Build and maintain dbt projects (staging → intermediate → marts), including model layering, macros, exposures, packages, and source freshness to accelerate delivery and improve reliability.
Design and evolve dimensional models (facts/dimensions, grain, SCD patterns) and analytics patterns aligned with key business domains.
Own metrics definitions end-to-end: establish KPI logic, naming standards, calculation rules, and governance; maintain a metrics/semantic layer so stakeholders use consistent definitions across tools and teams.
Implement robust data quality practices (dbt tests, constraints, anomaly checks/monitoring) to ensure reliable downstream reporting and decision-making.
Produce clear documentation and enablement assets (dbt docs, lineage, data dictionaries, metric definitions, onboarding guides) to support self-service analytics.
Optimize warehouse performance and cost in Snowflake through SQL tuning, incremental models, appropriate materializations, and efficient data design.
Proactively identify and resolve data-related issues, ensuring system reliability and data integrity.
Requirements
Judi® , the industry’s leading proprietary Enterprise Health Platform (EHP), which consolidates all claim administration-related workflows in one scalable, secure platform.
You will work heavily in dbt and Snowflake to design durable data models, define trusted business metrics, and ensure data quality through testing, documentation, and observability—partnering closely with operational, product, and analytics stakeholders to translate business questions into reusable data products that drive measurable outcomes. Position Responsibilities:
Use disciplined software engineering practices (Git-based workflows, peer review, CI checks, versioning, environment promotion) to deploy changes safely and repeatably.
Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent practical experience).
Strong SQL skills and
experience building analytics datasets in a modern cloud data warehouse (Snowflake preferred). Hands-on
experience with dbt core (model development, tests, documentation, macros, deployments).
experience delivering production-grade analytics models/marts or BI-ready datasets (internships/co-ops may be considered depending on leveling).
Ability to collaborate effectively with both technical and non-technical stakeholders; strong communication and documentation skills.
A self-motivated, detail-oriented individual with the ability to tackle and solve intricate technical challenges and deliver high-quality work. Preferred
Deep familiarity with Snowflake and
experience supporting multiple warehouses or databases as environments evolve (e.g., Redshift and/or Postgres).
Familiarity with semantic/metrics layer patterns and practices (e.g., consistent metric definitions, metric governance, semantic modeling approaches) and enabling KPI consumption across BI tools. ·
Experience with CI/CD for analytics (automated tests, PR checks, environment promotion) and data observability/monitoring practices.
Working knowledge of Python for data tooling or analytics enablement (e.g., automation, validation checks), and comfort collaborating with orchestration/workflow tools when needed.
As a Certified B Corp™, Capital Rx is executing its mission through the deployment of JUDI®, the company’s cloud-native enterprise health platform, and a Single-Ledger Model™, which increases visibility and reduces variability in drug prices.
Experience
Experience defining and managing metrics: translating business logic into consistent KPI definitions, documenting edge cases, and maintaining metric governance over time. 1+ years of
Benefits
Experience in healthcare, PBM, insurance, or other regulated data environments.
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.
Capital Rx is a full-service pharmacy benefit manager (PBM) and pharmacy benefit administrator (PBA), advancing our nation’s electronic healthcare infrastructure to improve drug price visibility and patient outcomes.
JUDI connects every aspect of the pharmacy ecosystem in one efficient, scalable platform, servicing millions of members for Medicare, Medicaid, and commercial plans.
This range represents the low and high end of the anticipated base salary range. The actual base salary will depend on several factors such as: experience, knowledge, skills, and location of the job.
Remote, US Salary Range $100,000 — $120,000 USD
Contact
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. To learn more, visit www.judi.health . Position Summary:
Additional details
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,
We are seeking a highly motivated and talented Data Engineer I (Analytics Engineering) to help build and scale Capital Rx’s analytics foundation.
This role focuses on developing high-quality, analytics-ready datasets and a consistent metrics/semantic layer that power reporting, self-service BI, and operational insights.
Partner closely with operational and analytics teams to translate business needs into analytics-ready data models, curated data marts, and reusable datasets.
Provide ongoing support for critical analytics data products and participate in an on-call rotation as needed.
Responsible for adherence to the Capital Rx Code of Conduct including reporting of noncompliance. Required
Solid foundation in data modeling (dimensional/Kimball concepts, facts/dimensions, grain, slowly changing dimensions). ·
Nothing in this position description restricts management’s right to assign or reassign duties and
responsibilities to this job at any time. About Capital Rx