Associate 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.

As an Associate Data Engineer, you will be responsible for basic designs and the development and delivery of data solutions between operational systems and databases, Data Warehouse, downstream Data Marts as well as files. You will implement optimized designs to meet the operational performance requirements for our solutions and products, which may include the implementation of architecture, following development standards.

The fundamentals for the job.

• Actively participate in the design, development and delivery of solutions using modern technologies, which will be used to move and transform as needed, large amounts of data from multiple sources into multiple destinations.
• Perform peer code reviews and make recommendations.
• Challenge and express your opinion of existing solutions and find "Better Ways" that will result in quality, improved and scalable solutions.
• Serve as data engineering support, maintenance and escalation point for data exchange and data warehouse related services and incidents.
• Align with technical teams on suitable technical, application, or configuration solutions to incoming incidents and issues.
• Maintain frequent communication with peers and IT teams to maintain awareness of issues or changing processes.
• Understand the business implications of technical solutions and assist in defining and documenting technological solutions.
• Escalates and collaborates in major incidents with teams in:
  Technical Areas, Issue Management, Client Services, Operations, among others.
• Ensure ticket and work item documentation remains current, correct, and relevant including updates to users on status, user-provided input, investigation results, next steps, and estimated delivery time (ETAs) for resolutions.
• Maintain high operational and written standards throughout ticket documentation and management.
• Coordinate, and at times, lead meetings when needed for issue resolution.
• Identify repetitive open known issues for their centralization in a single work item and escalations to development cells for enhancements and bug fixes.

• Associate's or Bachelor's in Computer Engineering, Computer Science, Technology, or related field. (In lieu of a degree, equivalent relevant work experience may be considered. )
• 1+ years of hands-on expertise operating high volume repeatable ETL/ELT processes in a Large Data Volume environment with complex data transformations.
• 1+ years of experience in database development, data modeling, and query optimization.
• Experience working with any major RDMS such as MSSQL, Oracle, Postgres, MySQL, etc.
• Experience using customer service skills to deliver quality and satisfactory service to internal and external clients using tech platforms.
• Experience in using analytical skills and root cause analysis regarding technological solutions, issues, incidents, and problems.
• Excellent oral and written communication skills.
• We are proud to offer a flexible hybrid work model which will require certain on-site workdays (Puerto Rico Location Only).
• This position requires availability to work in a specified time zone or working schedule, accommodating the business needs of our clients and team members.
• This position may require availability for on-call hours, including evenings, weekends, and holidays, to promptly address emergent issues or provide necessary support as dictated by operational demands (if applicable).

• Experience with ETL and data tools such as:
  SSIS, dbt, Matillion, Azure Data Factory, Informatica, Talend, Hadoop, Pentaho and AWS Glue.
• Experience in the healthcare industry and familiarity with its terminology.

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