Senior Snowflake Data Engineer — Consulting & AI-Driven Data

CDW; United States; On-site; USD 105,000 - 150,000; Full time

Benefits offered by this job

Annual bonus

Job summary

CDW is seeking a Senior Consulting Data Engineer to design, ingest, transform, validate, and document analytics data solutions. You will work on medallion-style data marts combining multiple sources to deliver trusted models for reporting and insights.

You will lead data ingestion, transformation, and QA across client environments, ensuring on-time delivery within a defined SOW and budget while communicating progress to stakeholders and exploring opportunities for value-enhancing cross-sell.

Qualifications

• Bachelor's degree or higher in IT, software engineering, data engineering, or related field.
• 5+ years' professional experience with relational data models, databases, data engineering, ingestion, transformation, and analytics delivery OR 9+ years' experience.
• Strong experience with Snowflake, DBT, AWS, and SQL, including data transformation, cleansing, preparation, and performance-minded development.
• Experience developing datasets supporting ad-hoc analytical needs, reporting, and stakeholder insight generation.
• Experience in regulated industries with governance and data privacy requirements.

Responsibilities

• Manage time and expense to meet or exceed SOW expectations; escalate budget issues.
• Collaborate with cross-functional teams to ingest, maintain, and deliver analytics data for reporting and decision-making.
• Develop and maintain data ingestion and transformation processes using Snowflake, SQL, DBT, and related cloud data technologies.
• Monitor data pipelines to ensure data is captured, processed, and delivered on time.
• Validate and test data transformations to ensure high-quality outputs.
• Ensure data processes are efficient, repeatable, and well documented with governance in mind.
• Work independently on multiple projects across diverse client environments and report status to management.
• Troubleshoot and upgrade technology problems; conduct analysis and planning.
• Identify opportunities for cross-selling and share with sales team.
• Develop best practices and maintain technical documentation for projects.

Skills

Snowflake

DBT

SQL

AWS

Data ingestion

Data transformation

Data governance

QA

Cross-functional collaboration

Communication

Education

Bachelor's degree in IT / Computer Science

Job description

CDW is seeking a Senior Consulting Data Engineer to design, ingest, transform, validate, and document analytics data solutions. You will work on medallion-style data marts combining multiple sources to deliver trusted models for reporting and insights.

You will lead data ingestion, transformation, and QA across client environments, ensuring on-time delivery within a defined SOW and budget while communicating progress to stakeholders and exploring opportunities for value-enhancing cross-sell.