Description
At CDW, we make it happen, together. Trust, connection, and commitment are at the heart of how we work together to deliver for our customers. It's why we're coworkers, not just employees. Coworkers who genuinely believe in supporting our customers and one another. We collectively forge our path forward with a level of commitment that speaks to who we are and where we're headed. We're proud to share our story and Make Amazing Happen at CDW.
We are seeking a Senior / Lead Consultant - Data Engineering with 6- 10 years of experience to lead the design and delivery of modern cloud data solutions. The ideal candidate will combine strong architectural thinking with hands-on execution, guide engineering standards, mentor team members, and partner with business and technical stakeholders to deliver scalable, secure, and reliable data platforms.
Key Responsibility
- Lead the architecture, design, and optimization of enterprise-scale data pipelines and ETL/ELT solutions using Microsoft Fabric, Azure Data Factory (ADF), and PySpark.
- Drive modern data warehousing architecture, dimensional modeling, and end-to-end lifecycle management for analytics platforms.
- Apply advanced SQL engineering for complex transformations, performance tuning, query optimization, and scalable data processing.
- Own platform administration and operational excellence across Azure Portal and Azure data services, including monitoring, cost awareness, reliability, and security.
- Partner with business stakeholders, architects, and cross-functional teams to translate complex requirements into robust data models, integration patterns, and reporting-ready datasets.
- Establish and enforce data governance, security, quality, and metadata management standards aligned with enterprise best practices.
- Provide technical leadership for solution design reviews, implementation guidance, and engineering best practices across the data platform landscape.
- Lead root-cause analysis, resiliency improvements, and performance optimization for cloud-based data pipelines and distributed processing workloads.
- Drive continuous improvement through reusable frameworks, automation, and engineering practices that improve maintainability, supportability, and delivery efficiency.
Other Responsibilities
Provide proactive leadership updates on delivery progress, risks, dependencies, and mitigation plans to the appropriate Engineering Manager and stakeholder groups on a regular cadence.
Build strong stakeholder relationships through timely, clear, and professional communication, while influencing decisions, resolving blockers, and aligning teams on delivery priorities.
Education and/or Experience Qualifications
Bachelor's degree in Computer Science, Information Technology, or a related field.
Required Qualifications
- 6- 10 years of progressive experience in Data Engineering, including ownership of large-scale data platforms, solution design, and technical leadership.
- Deep expertise in advanced SQL, including complex query optimization, performance tuning, data transformations, stored procedures, and troubleshooting at scale.
- Strong hands-on experience with data warehousing architecture, dimensional modeling, partitioning, indexing strategies, and scalable analytical data design.
- Proven expertise in Microsoft Fabric, Azure Data Factory (ADF), and modern ETL/ELT orchestration patterns for enterprise-grade data integration.
- Strong operational knowledge of Azure Portal and Azure data services for environment management, monitoring, security, governance, and cost optimization.
- Hands-on experience with Python and PySpark for distributed data processing, transformation frameworks, and reusable engineering patterns.
- Ability to establish engineering standards, reusable patterns, and delivery best practices for modern data platform implementations.
- Broad experience with cloud data ecosystem components such as Azure Synapse, Azure SQL Database, Azure Storage, and related integration services.
- Strong experience in data modeling, data governance, metadata management, data quality frameworks, and security controls across enterprise environments.
- Strong analytical and decision-making skills, with the ability to navigate complex technical challenges and guide teams toward effective solutions.
Preferred Qualifications
- Relevant certifications in Azure Data Engineering (such as DP-203), Microsoft Fabric (such as DP-600 or DP-700), or other advanced cloud data platform certifications.
- Exposure to Power BI, DevOps/CI-CD practices, infrastructure-as-code, or data observability frameworks is an added advantage.
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.
About Us
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.
