Data Engineer I

• · 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. • 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. • Nothing in this position description restricts management’s right to assign or reassign duties and responsibilities to this job at any time. • 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. 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. JUDI connects every aspect of the pharmacy ecosystem in one efficient, scalable platform, servicing millions of members for Medicare, Medicaid, and commercial plans. Together with its clients, Capital Rx is reimagining the administration of pharmacy benefits and rebuilding trust in healthcare.