Senior Data Engineer (Snowflake and DBT)

CMK Resources is seeking a Senior Data Engineer (Snowflake + DBT required) for a client based in Michigan. This role supports analytics and data-platform initiatives that enable better health outcomes and efficient benefit management that our client seeks to improve for in-home healthcare providers and members.

Location: Detroit metro preferred (Troy, MI) — hybrid onsite Thursdays; remote possible if needed but candidate must meet most requirements

Key responsibilities

• Design, develop, and maintain scalable data pipelines using Snowflake and dbt.
• Build and optimize data models in Snowflake to support BI, reporting, and analytics.
• Implement ETL/ELT workflows with dbt to transform raw data into analytics-ready datasets.
• Tune Snowflake queries, storage/compute usage, and dbt models for performance and cost efficiency.
• Integrate Snowflake with diverse internal systems and third-party data sources.
• Implement data quality checks, monitoring, and validation processes.
• Collaborate with data analysts, data scientists, engineers, and business stakeholders to translate requirements into solutions.
• Produce and maintain clear documentation for data models, transformations, and pipeline designs.

Required skills & qualifications

• 5+ years hands-on data engineering experience.
• Expert SQL skills — writing, optimizing, and debugging complex queries.
• Proven hands-on Snowflake experience (data modeling, query tuning, architecture/integration).
• In-depth dbt experience (models, macros, tests, CI/CD/workflow orchestration).
• Solid understanding of cloud data warehousing concepts and best practices.
• Experience with ETL/ELT patterns, data quality frameworks, and observability/monitoring.
• Strong analytical, problem-solving, and communication skills; able to work cross-functionally.

Nice-to-haves

• Experience with orchestration tools (Airflow, Prefect, Dagster).
• Familiarity with BI tools (Looker, Tableau, Power BI) and analytics consumption patterns.
• Python or another scripting language for data engineering tasks.
• Prior experience in healthcare, claims, or DMEPOS/benefits environments.