[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 dedicated to improving drug price visibility and patient outcomes. They are seeking a Data Engineer I to help build and scale their analytics foundation, focusing on developing high-quality datasets and a metrics layer for reporting and operational insights.

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

Company H1B Sponsorship