Data Engineer II

Data Engineer IIJoin our mission to transform pharmacy benefits and healthcare navigation as a Data Engineer II (Analytics Engineer). You will build and maintain reliable data models within Snowflake with dbt, and improve data quality and observability. Partner with analysts, data scientists, and software engineers to deliver trusted, well-documented datasets that power analytics and products.Position Responsibilities:Build, test, and document Snowflake data models and business logic in dbtApply and improve data quality, testing, observability, and lineage standardsCollaborate with cross-functional partners to define data contracts and interfacesContribute to Capital Rx's modular data platform and client-specific data configurationsParticipate in design reviews; propose scalable, maintainable patternsMonitor pipeline health, troubleshoot incidents, and drive root-cause fixesOptimize cost and performance of jobs, storage, and queries with guidanceWrite clear documentation and support knowledge sharingAdhere to the Capital Rx Code of Conduct, including reporting of noncompliancePreferred Qualifications:3+ years in data engineering, software engineering, or related fieldStrong SQL and Python; solid understanding of ETL/ELT and dimensional/data vault modelingHands-on dbt experience (models, tests, documentation, deployments)Experience with orchestration (Dagster or Airflow) and scheduling best practicesFamiliarity with Spark/Databricks and cloud data warehouses (Snowflake preferred)CI/CD for data (Git-based workflows, environments), and basic IaC familiarityData observability and testing (dbt tests, lineage tools)Understanding of security, governance, and privacy for PII/PHI (HIPAA awareness)Effective communication and collaboration with technical and non-technical stakeholdersBonus if you have Exposure to healthcare data (claims, eligibility, provider directories)Performance tuning in Snowflake (warehouse sizing, clustering, caching)Capital Rx values a diverse workplace and celebrates the diversity that each employee brings to the table. We are proud to provide equal employment opportunities to all employees and applicants for employment and prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, medical condition, genetic information, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.