Senior Consulting Data Engineer - Snowflake

CO1003 CDW Technologies, LLC; Illinois; Hybrid; USD 105,000 - 150,000; Full time

Benefits offered by this job

Annual bonus

Benefits overview

Geographic pay differences

Job summary

CDW is seeking a Senior Consulting Data Engineer to design, ingest, transform, validate, and document analytics data solutions, including medallion-style data marts, for reporting and business insights. The role requires strong proficiency with Snowflake, DBT, AWS, and SQL, plus experience in regulated environments and governance.

The successful candidate will lead data ingestion projects, collaborate across teams, ensure on-time delivery, and maintain high-quality data pipelines while

Qualifications

• Bachelor’s degree and 5+ years’ experience in relational data models, ingestion, transformation, and analytics delivery
• Or 9+ years’ experience in the same areas
• Strong experience with Snowflake, DBT, AWS, and SQL including data transformation and quality
• Experience building datasets for ad-hoc analytics, reporting, and stakeholder insight
• Experience in regulated industries with governance and data privacy requirements

Responsibilities

• Manage time and budget per the Statement of Work and escalate budget issues early
• Collaborate with cross-functional teams to ingest and deliver analytics data
• Develop and maintain data ingestion and transformation processes using Snowflake, DBT, AWS, and SQL
• Monitor pipelines and automated jobs to ensure timely, accurate delivery
• Validate data transformations to ensure high-quality outputs
• Document data processes and governance compliance
• Communicate project status to leadership and clients

Skills

Snowflake

DBT

AWS

SQL

Data pipelines

Education

Bachelor's degree in IT / data engineering or related field

Tools

Snowflake

DBT

AWS

SQL

Job description

The Senior Consulting Data Engineer is responsible for providing value to the business by ensuring solutions are implemented as designed to the customer’s satisfaction and approval. This role works in a quality, professional manner to complete project responsibilities on time and on budget, resulting in high customer satisfaction. Gain a clear understanding of client environment, identify client needs, and effectively communicate solutions. This role also supports data engineering delivery by designing, ingesting, transforming, validating, and documenting analytics data solutions, including medallion-style data marts that combine multiple data sources into trusted models for reporting and actionable business insights.

Responsibilities

What you will do Manage time and expense to meet or exceed expectations defined in the Statement of Work, proactively escalating potential budget issues as soon as they are known Collaborate with cross-functional teams to ingest, maintain, and deliver analytics data that supports reporting, ad‑hoc analysis, and business decision‑making. Develop and maintain data ingestion and transformation processes using Snowflake, SQL, DBT, and related cloud data technologies. Monitor data pipelines and automated jobs to ensure data is captured, processed, and delivered accurately and on time. Perform validation and testing of data transformations to ensure high‑quality, reliable data outputs. Ensure data processes are efficient, repeatable, well documented, and aligned with required governance and data privacy expectations. Work independently on multiple projects in diverse customer environments, ensure that appropriate management is apprised of project status, bring projects to completion and follow up with customers regarding results. Troubleshoot, maintain, upgrade, and provide solutions to complex technology problems. Conduct analysis, problem solving, and planning. Identify and communicate potential opportunities for cross‑selling to the sales team. Collaborate with team members in the development of best practices within team Demonstrable passion for technology while using problem solving capabilities to deliver solutions utilizing a top end engineering approach with an enthusiasm for learning Focused on delivering value to the business with relentless efforts to improve process Flexible in thinking; able to evolve a solution when additional information or ideas are presented making tactical vs. strategic tradeoffs where needed

Qualifications

What we expect of you Bachelor’s degree and 5+ years’ professional experience with relational data models, databases, data engineering, ingestion, transformation, and analytics delivery OR 9+ years’ professional experience with relational data models, databases, data engineering, ingestion, transformation, and analytics delivery Strong experience with Snowflake, DBT, AWS, and SQL, including data transformation, cleansing, preparation, and performance‑minded development. Experience developing datasets that support ad‑hoc analytical needs, reporting, and marketing or business stakeholder insight generation. Experience working in highly regulated industries and complying with internal governance, data privacy, and data quality requirements. Preferred experience includes healthcare data, marketing data, and a bachelor’s degree in IT, software engineering, data engineering, or a related field. Implements, maintains, upgrades, and troubleshoots S&S solutions; transferring technical skills and knowledge to client through work logs. Performs overall solution Quality Assurance (QA) tasks for all projects delivered against assigned project deliverables while ensuring they are in alignment with the project scope and SOW (Statement of Work). Provides implementation/migration planning to client, knowing and meeting client timetable, coordinating vendor installations, etc. Facilitates communication between product team members. Strong written and verbal communication skills with the ability to effectively interact with leadership stakeholders and clients. Proven ability to maintain and create technical documentation for assigned project work. Demonstrated attention to detail, especially client and project changes, with solid analytical skills to identify potential risks. History of balancing competing priorities with the ability to adapt to the changing needs of the business while meeting deadlines. Demonstrated experience applying lessons learned to unique problems. History of reskilling on new technologies with understanding of difference with past technologies. Ability and willingness to travel as needed to other CDW locations or client sites.

Compensation

Pay range: $105,000 - $150,000 depending on experience and skill set Annual bonus target of 10% subject to terms and conditions of plan

Benefits

Benefits overview: https://cdw.benefit-info.com/ Salary ranges may be subject to geographic differentials

Values & Culture

CDW is committed to being an AI‑fluent organization We’re looking for people who bring curiosity, a learner’s mindset, and a willingness to engage with ever‑evolving technology and tools. We value adopting AI as a partner, openness to experimentation, and a shared interest in learning together on AI. Our goal is to create a culture where AI enhances—not replaces—human creativity and decision‑making. You don’t need to be an expert today; what matters is your readiness to explore, adapt, and grow with us as we integrate AI responsibly and effectively into our work. Additionally, CDW is committed to fostering an equitable, transparent, and respectful hiring process for all applicants. During our application process, our goal is to understand your experience, strengths, skills, and qualifications. As an AI forward company, we see AI not just as a tool, but as a catalyst for new ways of thinking, creating, and communicating. We encourage candidates to embrace an AI mindset, one that’s curious, adaptive, and ready to explore what’s possible. We welcome thoughtful use of AI to expand your perspective and elevate how you share your story, while ensuring your application remains rooted in your own background, judgment, and voice.

Diversity & Inclusion

CDW is an equal opportunity employer. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status or any other basis prohibited by state and local law.

About CDW

CDW is a Fortune 500 technology solutions provider that helps businesses, government, education, and healthcare organizations achieve what’s possible through technology. What makes CDW different isn’t just what we do—it’s how we do it. At CDW we act as one—building trust, speaking candidly, and working together to achieve more. We play to win—focusing on what matters most and delivering for our customers. And we think forward—staying curious, moving fast, and continuously learning. We believe meaningful work happens when people feel supported, heard, and empowered to contribute. That’s why we think of ourselves as coworkers, not just employees—working together to solve complex challenges and deliver real impact for our customers and communities. As a full‑stack, full‑lifecycle technology partner, CDW brings deep expertise, strong relationships, and broad industry knowledge to help turn ideas into outcomes. When you join CDW, you become part of a collaborative environment where your work matters, your growth is supported, and your contributions help shape what’s next. Together, we deliver the full promise of what technology can do. Together, we Make Amazing Happen. CDW is an equal opportunity employer. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status or any other basis prohibited by state and local law. At CDW, we make technology work so people do great things. We are a leading multi‑brand technology solutions provider to business, government, education and healthcare customers in the United States, the United Kingdom and Canada. Our coworkers across the globe are working together to bring technology to life for our customers by solving complicated IT business challenges, providing outstanding service, and orchestrating the technology landscape to optimize our customers’ performance.