Senior Data Engineer, Snowflake/dbt – Hybrid

Capital Rx; Denver (CO); Hybrid; USD 128,000 - 160,000; Full time

Job summary

Capital Rx is seeking a Senior Data Engineer (Analytics Engineer) to build robust Snowflake data models with dbt, ensuring data quality and observability. You will work with analysts, data scientists, and engineers to deliver trusted datasets powering analytics and products.

You will contribute to a modular data platform, improve data contracts, and optimize pipelines, storage, and queries while documenting work and collaborating across teams.

Qualifications

• 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, lineage tools).
• Understanding of security, governance, and privacy for PII/PHI (HIPAA awareness).
• Effective communication and collaboration with technical and non-technical stakeholders.

Responsibilities

• 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.

Skills

SQL

Python

dbt

Dagster/Airflow

Snowflake

Git

Data observability

HIPAA awareness

Communication

Education

Bachelor's degree in CS/Engineering/related

Tools

Dagster

Airflow

Snowflake

Spark/Databricks

Git-based workflows

Terraform (IaC)

Job description

Capital Rx is seeking a Senior Data Engineer (Analytics Engineer) to build robust Snowflake data models with dbt, ensuring data quality and observability. You will work with analysts, data scientists, and engineers to deliver trusted datasets powering analytics and products.

You will contribute to a modular data platform, improve data contracts, and optimize pipelines, storage, and queries while documenting work and collaborating across teams.