COOP, Data Engineer

What you’ll do  

In a few words… 

Abarca is igniting a revolution in healthcare.  We built our company on the belief that with smarter technology we are redefining pharmacy benefits, but this is just the beginning…  

At Abarca’s company culture centers around embracing a growth mindset, theme of inspiring excellence, and encouraging all to bring their best each day! Our Interns/Coops work on real-world projects in collaboration with teams across Abarca Health, while having fun along the way. You'll be empowered to build community, explore your passions, and achieve your goals.  The Internship & Coop programs are designed to encourage bringing solutions and ideas to life while working on cutting-edge technology, while experiencing our culture of community. In this role you will be part of the Business Intelligence team where you will be immersed in the world of healthcare technology, which impact millions of lives.   

The fundamentals for the job… 

• Understand the data structure and meaning in both the source and the target Business Intelligence tools, Tableau and Snowflake 
• Apply business rules as transformations. 
• Adapt ELT processes to accommodate changes in source systems and new business user requirements. 
• Building and unit testing data transformation, source data transport, and population processes for environment 
• Assisting the Business Intelligence Team in delivering information and analytic solutions to the company’s key stakeholders, including members of the various business units, internal/external providers, and internal staff.
• Report/Query testing, development using dbt and Snowflake SQL. 

 What we expect of you  

The bold requirements…  

• Be an active student at least in third year and above enrolled in a bachelor’s or master’s degree in computer engineering, Computer Science, Software Engineering, or related field.
• Must have taken and enjoyed the database class. 
• You should have previous knowledge of SQL, Database Design, and Stored Procedures. 
• Knowledge of Business Intelligence designs and practices.
• Excellent oral and written communication skills. 

Physical requirements…  

• Must be able to access and navigate each department at the organization’s facilities.  
• Sedentary work that primarily involves sitting/standing.  

At Abarca we value and celebrate diversity. Diversity, equity, inclusion, and belonging are guiding principles of Abarca and ensure Abarca’s workforce reflects the communities it serves.  We are proud to provide equal employment opportunities to all employees and applicants for employment and prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, medical condition, genetic information, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. 

Abarca Health LLC is an equal employment opportunity employer and participates in E-Verify.  “Applicant must be a United States’ citizen. Abarca Health LLC does not sponsor employment visas at this time” 

The above description is not intended to limit the scope of the job or to exclude other duties not mentioned. It is not a final set of specifications for the position. It’s simply meant to give readers an idea of what the role entails. 

#LI-VP1 #LI-REMOTE