Data Engineer II

Location: Remote (For Non-Local) or Hybrid (Local to NYC area or Denver, CO)

Position Summary:

We are seeking a highly motivated and talented Data Engineer to join our team and play a critical role in shaping the future of healthcare data management. This individual will be a key contributor in building robust, scalable, and accurate data systems that empower operational and analytics teams to make informed decisions and drive positive outcomes.

Position Responsibilities:

• Lead relationship 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
• Identify, recommend, and implement process improvement initiatives.
• Proactively identify and resolve data-related issues, ensuring system reliability and data integrity
• Lead moderately complex projects.
• 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.

Required Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field
• 2+ experience working with Airflow, dbt, and Snowflake
• Expertise in data warehousing architecture techniques and familiarity with Kimball methodology
• Minimum 3+ years experience with a proven track record as a Data Engineer, displaying the ability to design, implement, and maintain complex data pipelines
• 1+ year experience in Python, SQL
• 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

Preferred Qualifications:

• 1-3 years of experience as a Data Engineer, ideally in the healthcare or PBM sector
• Advanced proficiency with Airflow, dbt, and Snowflake, coupled with 3+ years of SQL development and Python experience

This range represents the low and high end of the anticipated base salary range for the NY-based position. The actual base salary will depend on several factors such as experience, knowledge, and skills, and if the location of the job changes.

This position description is designed to be flexible, allowing management the opportunity to assign or reassign duties and responsibilities as needed to best meet organizational goals.