Data Engineer II

Capitalrx; Charlotte (NC); Hybrid; USD 92,000 - 113,500; Full time

Job summary

Capitalrx is looking for a Data Engineer II to join their team in Charlotte, NC. This hybrid role involves building and maintaining data models within Snowflake, improving data quality, and collaborating with various partners. The ideal candidate will have solid experience in data engineering.

The position requires strong skills in SQL and Python, with hands-on experience in dbt and a good understanding of ETL/ELT processes. This is an opportunity to contribute to transforming pharmacy benefits and healthcare navigation.

Qualifications

• 3+ years in data engineering, software engineering, or related field.
• Hands‑on dbt experience (models, tests, documentation, deployments).
• Strong SQL and Python; solid understanding of ETL/ELT.

Responsibilities

• Build, test, and document Snowflake data models in dbt.
• Collaborate with cross‑functional partners to define data contracts.
• Monitor pipeline health, troubleshoot incidents, and drive fixes.

Skills

SQL

Python

Data Engineering

ETL/ELT

dbt

Spark/Databricks

Tools

Snowflake

Git

Dagster

Airflow

Job description

About Judi Health

Judi Health is an enterprise health technology company providing a comprehensive suite of solutions for employers and health plans, including:

• Capital Rx, a public benefit corporation delivering full-service pharmacy benefit management (PBM) solutions to self-insured employers,
• Judi Health™, which offers full-service health benefit management solutions to employers, TPAs, and health plans, and
• Judi®, the industry’s leading proprietary Enterprise Health Platform (EHP), which consolidates all claim administration-related workflows in one scalable, secure platform.

Together with our clients, we’re rebuilding trust in healthcare in the U.S. and deploying the infrastructure we need for the care we deserve.

Position Location: Hybrid 3 days (offices in NYC, Denver, CO and Charlotte, NC area)

Position Summary:

Join our mission to transform pharmacy benefits and healthcare navigation as a Data Engineer II (Analytics Engineer). You will build and maintain reliable data models within Snowflake with dbt, and improve data quality and observability. Partner with analysts, data scientists, and software engineers to deliver trusted, well-documented datasets that power analytics and products.

Position Responsibilities:

• Build, test, and document Snowflake data models and business logic in dbt
• Apply and improve data quality, testing, observability, and lineage standards
• Collaborate with cross‑functional partners to define data contracts and interfaces
• Contribute to Capital Rx’s modular data platform and client‑specific data configurations
• Participate in design reviews; propose scalable, maintainable patterns
• Monitor pipeline health, troubleshoot incidents, and drive root‑cause fixes
• Optimize cost and performance of jobs, storage, and queries with guidance
• Write clear documentation and support knowledge sharing
• Adhere to the Capital Rx Code of Conduct, including reporting of noncompliance

Preferred Qualifications:

• 3+ years in data engineering, software engineering, or related field
• Strong SQL and Python; solid understanding of ETL/ELT and dimensional/data vault modeling
• Hands‑on dbt experience (models, tests, documentation, deployments)
• Experience with orchestration (Dagster or Airflow) and scheduling best practices
• Familiarity with Spark/Databricks and cloud data warehouses (Snowflake preferred)
• CI/CD for data (Git‑based workflows, environments), and basic IaC familiarity
• Data observability and testing (dbt tests, lineage tools)
• Understanding of security, governance, and privacy for PII/PHI (HIPAA awareness)
• Effective communication and collaboration with technical and non‑technical stakeholders
• Bonus if you have Exposure to healthcare data (claims, eligibility, provider directories)
• Performance tuning in Snowflake (warehouse sizing, clustering, caching)

Nothing in this position description restricts management’s right to assign or reassign duties and responsibilities to this job at any time.

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

• New York, NY Salary Range: $108,800 – $136,000 USD
• Denver, CO Salary Range: $100,000 – $125,000 USD
• Charlotte, NC Salary Range: $92,000 – $113,500 USD