[Remote] Data Engineer I

Note: The job is a remote job and is open to candidates in USA. Capital Rx is a full-service pharmacy benefit manager (PBM) and pharmacy benefit administrator (PBA), focused on improving drug price visibility and patient outcomes. They are seeking a highly motivated Data Engineer I to help build and scale their analytics foundation by developing high-quality, analytics-ready datasets and collaborating with various stakeholders to translate business needs into data products.ResponsibilitiesPartner closely with operational and analytics teams to translate business needs into analytics-ready data models, curated data marts, and reusable datasetsBuild and maintain dbt projects (staging → intermediate → marts), including model layering, macros, exposures, packages, and source freshness to accelerate delivery and improve reliabilityDesign and evolve dimensional models (facts/dimensions, grain, SCD patterns) and analytics patterns aligned with key business domainsOwn 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 teamsImplement robust data quality practices (dbt tests, constraints, anomaly checks/monitoring) to ensure reliable downstream reporting and decision-makingProduce clear documentation and enablement assets (dbt docs, lineage, data dictionaries, metric definitions, onboarding guides) to support self-service analyticsOptimize warehouse performance and cost in Snowflake through SQL tuning, incremental models, appropriate materializations, and efficient data designUse disciplined software engineering practices (Git-based workflows, peer review, CI checks, versioning, environment promotion) to deploy changes safely and repeatablyProactively identify and resolve data-related issues, ensuring system reliability and data integrityProvide ongoing support for critical analytics data products and participate in an on-call rotation as neededResponsible for adherence to the Capital Rx Code of Conduct including reporting of noncomplianceSkillsBachelor'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 time1+ 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 skillsA self-motivated, detail-oriented individual with the ability to tackle and solve intricate technical challenges and deliver high-quality workExperience in healthcare, PBM, insurance, or other regulated data environmentsDeep 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 toolsExperience with CI/CD for analytics (automated tests, PR checks, environment promotion) and data observability/monitoring practicesWorking knowledge of Python for data tooling or analytics enablement (e.g., automation, validation checks), and comfort collaborating with orchestration/workflow tools when neededCompany OverviewCapital 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 SponsorshipCapital 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.



Apply To This Job