Senior Data Engineer - DBT Cloud

Senior Data Engineer – Marketing Analytics (DBT Cloud) Remote, working CST hours Contract with CDW through end of 2025, Likely extension CDW is seeking a Senior Data Engineer to lead the development of a Medallion-style data mart that unifies data from 10+ diverse sources into a single, holistic model. This data platform will empower our marketing teams to derive actionable insights and drive strategy. In this role, you’ll own the design and implementation of scalable data ingestion and transformation pipelines using Snowflake, DBT, and AWS, ensuring high data quality, compliance, and usability across the organization. Key Responsibilities • Ingest and transform data from multiple sources into a unified data mart following the medallion architecture. • Collaborate with cross-functional teams (Marketing, Product, IT) to gather requirements and deliver analytical data solutions. • Design, build, and maintain robust ETL/ELT pipelines in Snowflake using SQL and DBT. • Develop and manage datasets to support ad-hoc analysis and regular reporting needs. • Monitor and troubleshoot data pipelines to ensure data integrity and timely delivery. • Document data processes, transformations, and metadata to support governance and reproducibility. • Perform data validation and testing for quality assurance. • Handle ad-hoc data requests and custom data processing. • Ensure compliance with internal data governance policies and external data privacy regulations. Minimum Qualifications • 5+ years of experience working with relational databases and data modeling. • Expertise with DBT Cloud (not just DBT Core), including environment management, job orchestration, and deployment best practices. • Strong hands-on experience with Snowflake and AWS. • Advanced proficiency in SQL, especially for data transformation, cleansing, and preparation. • Proven ability to document and maintain scalable, repeatable data workflows. • Excellent collaboration and communication skills. • Ability to manage multiple priorities in a fast-paced environment. • Experience working in highly regulated industries (e.g., healthcare, finance, etc.). Preferred Qualifications • Bachelor’s degree in Computer Science, IT, Engineering, or related field. • Experience working with healthcare or marketing data. • Familiarity with marketing platforms, customer journey data, or campaign performance metrics. Why Join Us You’ll play a critical role in transforming how our marketing teams leverage data to make strategic decisions. This is a high-impact opportunity to build something from the ground up, influence data architecture, and shape the future of analytics within the organization.