Senior Data Engineer
Remote - EST hours
6 months to 1 year contract
CDW is seeking a Senior Data Engineer contractor to support building a marketing data mart. This hands-on role will ingest, transform, and model data from 10+ sources into a trusted analytics foundation for marketing insights and reporting.
Responsibilities
Develop and maintain Snowflake data ingestion and SQL-based transformation processes using DBT and AWS.
Build medallion-style data models that unify 10+ sources into a marketing data mart.
Deliver analytics-ready datasets for ad-hoc analysis, recurring reporting, and business insights.
Monitor, validate, test, and document pipelines, transformation logic, and automated jobs.
Partner with technical, marketing, analytics, and business stakeholders while balancing competing priorities.
Maintain accuracy, governance, data privacy, and regulated-industry standards.
Required Qualifications
5+ years of experience with relational data models, databases, and analytics-focused data solutions.
Strong hands-on experience with Snowflake, DBT, AWS, and advanced SQL.
Experience with data ingestion, cleansing, preparation, transformation, and data modeling.
Marketing, campaign, customer, or commercial analytics experience.
Experience designing and documenting pipelines, processes, transformation logic, and validation procedures.
Ability to provide trusted datasets to analytics teams for reporting and ad-hoc analysis.
Experience in a highly regulated industry, including governance and data privacy requirements.
Strong cross-functional collaboration and prioritization skills.
Preferred Qualifications
Bachelor's degree in Information Technology, Software Engineering, Computer Science, Data Engineering, or a related field.
Healthcare data experience.
Experience building data marts or analytics layers with medallion-style architecture.
Familiarity with data quality testing, lineage, documentation, and reusable transformation frameworks.
Apply to help build a reliable marketing analytics foundation that turns complex, multi-source data into actionable insights.