Implement and maintain batch/streaming pipelines with Dagster, Databricks/Spark, and dbt
Build, test, and document Snowflake data models and business logic in dbt
Apply and improve data quality, testing, observability, and lineage standards
Collaborate with cross-functional partners to define data contracts and interfaces
Contribute to Capital Rx’s modular data platform and client-specific data configurations
Participate in design reviews; propose scalable, maintainable patterns
Monitor pipeline health, troubleshoot incidents, and drive root-cause fixes
Optimize cost and performance of jobs, storage, and queries with guidance
Write clear documentation and support knowledge sharing
Adhere to the Capital Rx Code of Conduct, including reporting of noncompliance

Requirements

5+ years in data engineering, software engineering, or related field
Strong SQL and Python; solid understanding of ETL/ELT and dimensional/data vault modeling
Hands-on dbt experience (models, tests, documentation, deployments)
Experience with orchestration (Dagster or Airflow) and scheduling best practices
Familiarity with Spark/Databricks and cloud data warehouses (Snowflake preferred)
CI/CD for data (Git-based workflows, environments), and basic IaC familiarity
Data observability and testing (dbt tests, Great Expectations/Soda, lineage tools)
Understanding of security, governance, and privacy for PII/PHI (HIPAA awareness)
Effective communication and collaboration with technical and non-technical stakeholders
Bonus if you have Exposure to healthcare data (claims, eligibility, provider directories)
Performance tuning in Snowflake (warehouse sizing, clustering, caching)
Knowledge of Elastic Search

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPythonETLELTdbtdata modelingdata observabilityperformance tuningdata testingdata governance

Soft Skills

effective communicationcollaborationproblem-solvingdocumentationknowledge sharing