Note: The job is a remote job and is open to candidates in USA. Capital Rx is a full-service pharmacy benefit manager (PBM) focused on improving drug price visibility and patient outcomes. They are seeking a highly motivated Data Engineer I to build and scale their analytics foundation by developing analytics-ready datasets and ensuring data quality through collaboration with various stakeholders.
Responsibilities
- Partner closely with operational and analytics teams to translate business needs into analytics-ready data models, curated data marts, and reusable datasets
- 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
- Use disciplined software engineering practices (Git-based workflows, peer review, CI checks, versioning, environment promotion) to deploy changes safely and repeatably
- Proactively identify and resolve data-related issues, ensuring system reliability and data integrity
- 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
Skills
- 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)
- Solid foundation in data modeling (dimensional/Kimball concepts, facts/dimensions, grain, slowly changing dimensions)
- Experience defining and managing metrics: translating business logic into consistent KPI definitions, documenting edge cases, and maintaining metric governance over time
- 1+ years of 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
- Experience in healthcare, PBM, insurance, or other regulated data environments
- 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
Company Overview
Capital Rx is now Judi Health! Navigate to our new page here: https://www.linkedin.com/company/judi-health It was founded in 2017, and is headquartered in New York, NY, US, with a workforce of 501-1000 employees. Its website is https://www.judi.health/about/careers.Company H1B Sponsorship
Capital Rx has a track record of offering H1B sponsorships, with 3 in 2025, 2 in 2024, 1 in 2023, 1 in 2022, 5 in 2021. Please note that this does not guarantee sponsorship for this specific role.