Capital Rx
Affordable Pharmacy Benefits, Powered by Modern Infrastructure.
Data Engineer II
Location
United States
Posted
6 days ago
Salary
$90K - $120K / year
Bachelor Degree1 yr expEnglishAirflowAmazon RedshiftETLJavaPythonSQLTerraform
Job Description
• 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.
Job 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.