Mid/Senior Data Engineer (Snowflake, dbt, Airflow)

C&F•Loveland, CO

5d•Hybrid

About The Position

C&F is a technology services company providing innovative solutions in Data Management, Big Data, Advanced Analytics and Compliance. With a highly integrated team of 400+ experts, for over 20 years C&F has been delivering superior engineering and premium operations to Fortune 500 companies, primarily in the Life Science industry. We are growing our data engineering and service delivery capability and are looking for an experienced Data Engineer to join us at Mid or Senior level.

Requirements

Proven commercial experience as a Data Engineer (Mid: approx. 3+ years; Senior: approx. 5+ years)
Hands-on experience with Snowflake, including data modeling, roles and access, and performance optimization
Strong experience with dbt (models, tests, macros, sources, incremental models, documentation)
Practical experience building and maintaining Airflow DAGs
Advanced SQL and solid understanding of data warehousing and dimensional modeling
Working knowledge of Python for data processing and automation
Experience with Flyway or other database schema migration tools
Experience using AI-assisted development tools in data engineering (e.g., GitHub Copilot or similar) for code generation, testing, documentation, or code analysis
Experience with Git-based workflows, PR reviews, and CI/CD (e.g., GitHub Actions)
Experience working with multiple environments and a structured release process
Experience working in a ticket-driven delivery model (e.g., Jira)
Very good command of English, both written and spoken
Strong communication skills with stakeholders: confident with technical audiences and able to explain things clearly to business audiences
A prioritization mindset and the ability to adapt quickly when priorities change, so the work stays relevant to the business
Proactiveness and a high level of independence, combined with the ability to work effectively in a larger team
Comfort working where standards and tooling are still evolving (especially important at Senior level)
Strong problem-solving, analytical, and documentation skills

Nice To Haves

Snowflake and/or dbt certifications
Experience in the human pharma or animal health domain, especially commercial, CRM, or customer data
Experience migrating or refactoring legacy dbt projects
Experience with code quality tools (e.g., SonarQube)
Exposure to data governance and metadata tools (e.g., Collibra)
Experience with data integration to CRM or customer data platforms
Understanding of ITIL fundamentals and service management processes

Responsibilities

Building and extending dbt models in Snowflake, following layered modeling conventions
Migrating and rebuilding legacy dbt models into the target architecture, including reverse-engineering complex, macro-heavy logic
Developing Airflow DAGs, including data quality gates that control pipeline flow
Ingesting seed and static files provided by business teams across environments, and clarifying naming, refresh cadence, and ownership
Implementing and maintaining data quality tests across all model layers
Triaging and fixing dbt test failures, pipeline failures, and bugs
Promoting code through environments via CI/CD, with PR review at each stage
Supporting Snowflake cost and performance optimization
Supporting incremental and CDC-based loads to downstream platforms
Maintaining documentation and metadata (column descriptions, data models, business terms)
Handling service requests, change requests, and incidents in a Jira-based delivery model
Communicating directly with client stakeholders, mainly technical but also business
Working closely with product owners, architects, and other teams to deliver prioritized work
Own design and migration decisions, such as mapping legacy models to target layers, orchestration and quality-gate patterns, and materialization strategy (Senior level)
Lead Snowflake cost and performance tuning (Senior level)
Review other engineers' code and guide technical standards (Senior level)
Represent the team in technical alignment with client and partner teams (Senior level)