Partner closely with operational and analytics teams to translate business needs into effective data solutions
Architect and implement ETL workflows leveraging CapitalRx platforms and technologies such as Python, dbt, SQLAlchemy, Terraform, Airflow, Snowflake, and Redshift
Conduct rigorous testing to ensure the flawless execution of data pipelines before production deployment
Proactively identify and resolve data-related issues, ensuring system reliability and data integrity
Provide ongoing maintenance and support for critical data infrastructure, including 24x7 on-call availability
Responsible for adherence to the Capital Rx Code of Conduct including reporting of noncompliance.

Requirements

Bachelor's degree in Computer Science, Information Technology, or a related field
Demonstrated proficiency in Python (or Java), SQL, JSON, and XML
Expertise in data warehousing architecture techniques and familiarity with Kimball methodology
Minimum 1+ years experience with a proven track record as a Data Engineer, displaying the ability to design, implement, and maintain complex data pipelines
Capacity to analyze the company's broader data landscape and architect scalable data solutions that support growth
Excellent communication skills to collaborate effectively with both technical and non-technical stakeholders
A self-motivated and detail-oriented individual with the ability to tackle and solve intricate technical challenges
1+ years of experience as a Data Engineer, ideally in the healthcare or PBM sector
Proficiency with Airflow, dbt, and Snowflake, coupled with 3+ years of SQL development and Python experience.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PythonSQLJSONXMLETLdata warehousingdata pipelinesdbtAirflowSnowflake

Soft Skills

communicationself-motivateddetail-orientedproblem-solvingcollaboration

Certifications

Bachelor's degree in Computer ScienceBachelor's degree in Information Technology