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.