What are the responsibilities and job description for the Senior Data Engineer (Snowflake + DBT required) position at CMK Resources, Inc.?
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
Eligibility: US Citizen or Green Card only
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.
Salary : $50 - $60