What are the responsibilities and job description for the Senior Data Engineer (Snowflake and DBT) position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, CMK Resources Inc., is seeking the following. Apply via Dice today!
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
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.
- 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.
- 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.