Senior Data Engineer

Senior Analytics Engineer (Snowflake / dbt / SQL) Contract through 2026; potential extensions 100% remote CDW is seeking a Senior Analytics Engineer to design and build a marketing-focused data mart that consolidates data from multiple sources into a scalable analytics platform. This role is centered on dimensional data modeling, analytics engineering, and business-facing data solutions, enabling marketing teams to generate actionable insights. Important: We are looking for candidates whose primary expertise is building dimensional data models and analytics-ready datasets using dbt and Snowflake, versus a background primarily focused on data pipeline development, ingestion frameworks, or ETL engineering. Responsibilities • Design and implement dimensional data models, including fact and dimension tables, to support marketing reporting and analytics. • Build and maintain dbt models and SQL transformations within Snowflake. • Develop a unified marketing data mart by integrating data from multiple source systems. • Partner with marketing and analytics stakeholders to translate business requirements into scalable data models. • Create analytics-ready datasets that support dashboards, reporting, segmentation, campaign measurement, and ad hoc analysis. • Ensure data quality through testing, validation, and documentation of transformation logic. • Support governance, privacy, and compliance requirements. Required Qualifications • 5+ years of experience in analytics engineering, data warehousing, or business intelligence. • Strong expertise with SQL, dbt, and Snowflake. • Hands-on experience designing dimensional data models using Kimball methodologies, star schemas, fact tables, and dimension tables. • Experience developing data marts and curated analytics layers for business users. • Demonstrated experience supporting marketing analytics, customer analytics, campaign analytics, or similar business functions. • Strong communication skills and the ability to collaborate directly with business stakeholders. Preferred Qualifications • Experience building analytics solutions in AWS environments. • Experience working with regulated industries. • Healthcare industry experience is a plus. • Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field. Ideal Candidate Profile • Primary experience is in analytics engineering and dimensional modeling, not data pipeline engineering. • Deep experience building and maintaining dbt models that power analytics and reporting. • Strong understanding of marketing data domains and KPI-driven analytics. • Comfortable translating business questions into well-designed fact and dimension models. • Experience delivering business value through data marts, semantic layers, and analytics-ready datasets.