Senior Data Engineer

Senior Analytics Engineer (Snowflake / dbt / SQL) Contract through 2026; potential extensions 100% remoteCDW 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.ResponsibilitiesDesign 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 Qualifications5+ 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 QualificationsExperience 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 ProfilePrimary 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.