Transformation & Turnaround
Senior Data Engineer - I McKinsey Transformatics Job ID: 96879Do you want to work on complex and pressing challenges-the kind that bring together curious, ambitious, and determined leaders who strive to become better every day?
If this sounds like you, you've come to the right place. Your ImpactYou will also be part of an effort to build next-generation data platforms on the cloud to enable our business stakeholders to have rapid data access and incubate emerging technologies. Additionally, you will mentor junior engineers, and implement data governance practices to ensure security, compliance, and lifecycle management.
In this role, you will design and build data products. You will develop and maintain scalable, reusable data products that serve as foundational assets for analytics, reporting, and machine learning pipelines.
You will be architecting and optimizing data pipelines You will lead the design, develop, and enhance ETL/ELT workflows using AWS Lambda, AWS Glue, Snowflake, and Databricks You will ensure high-performance, scalable, and cost-efficient data processing solutions.
You will manage and scale data infrastructure. You will oversee cloud-based data environments, configure optimized storage solutions (S3, Snowflake, Delta Lake), and manage compute resources for efficient data processing.
You will perform tuning and optimization. You will implement advanced query tuning, indexing strategies, partitioning techniques, and caching to maximize efficiency in Snowflake and Databricks.
You will check cross-functional collaboration. You will partner with data scientists, engineers, and business teams to deliver well-structured, analytics-ready datasets that drive insights and machine learning initiatives.
You will govern data, compliance and security. You will establish and enforce best practices for access control, data lineage tracking, encryption, and compliance with industry standards (SOC 2, GDPR).
You will automate and observe: build resilient, automated data workflows leveraging tools such as Step Functions and Databricks Workflows. You will implement proactive monitoring, logging, and alerting to ensure system reliability and data quality.
You will drive innovation and best practices. You will be responsible to mentor junior engineers, stay ahead of emerging technologies, participate in hackathons, contribute to internal knowledge sharing at team and company levels, and champion continuous improvement in data engineering methodologies.
You will work in our McKinsey Client Capabilities Network in EMEA and will be part of our Wave Transformatics team.
Wave is a McKinsey SaaS product that equips clients to successfully manage improvement programs and transformations. Focused on business impact, Wave allows clients to track the impact of individual initiatives and understand how they affect longer term goals. It is a mix of an intuitive interface and McKinsey business expertise that gives clients a simple and insightful picture of what can otherwise be a complex process by allowing them to track the progress and performance of initiatives against business goals, budget and time frames.
Our Transformatics team builds data and AI products to provide analytics insights to clients and McKinsey teams involved in transformation programs across the globe. The current team is composed of data engineers, data scientists and project managers who are spread across several geographies. The team covers a variety of industries, functions, analytics methodologies and platforms - e.g. Cloud data engineering, advanced statistics, machine learning, predictive analytics, MLOps and generative AI.
As a member of the team, you will be responsible for designing, building, and optimizing scalable data solutions that power analytics, reporting, and machine learning. Working alongside a team of data engineers across global hubs, you will lead the development of robust data ingestion pipelines, procuring data from APIs and integrating it into cloud-based storage layers while ensuring data quality through rigorous cleaning and standardization.
Your Growth Driving lasting impact and building long-term capabilities with our clients is not easy work. You are the kind of person who thrives in a high performance/high reward culture - doing hard things, picking yourself up when you stumble, and having the resilience to try another way forward.
In return for your drive, determination, and curiosity, we'll provide the resources, mentorship, and opportunities you need to become a stronger leader faster than you ever thought possible. Your colleagues-at all levels-will invest deeply in your development, just as much as they invest in delivering exceptional results for clients. Every day, you'll receive apprenticeship, coaching, and exposure that will accelerate your growth in ways you won't find anywhere else.
When you join us, you will have:
- Continuous learning: Our learning and apprenticeship culture, backed by structured programs, is all about helping you grow while creating an environment where feedback is clear, actionable, and focused on your development. The real magic happens when you take the input from others to heart and embrace the fast-paced learning experience, owning your journey.
- A voice that matters: From day one, we value your ideas and contributions. You'll make a tangible impact by offering innovative ideas and practical solutions. We not only encourage diverse perspectives, but they are critical in driving us toward the best possible outcomes.
- Global community: With colleagues across 65+ countries and over 100 different nationalities, our firm's diversity fuels creativity and helps us come up with the best solutions for our clients. Plus, you'll have the opportunity to learn from exceptional colleagues with diverse backgrounds and experiences.
- World-class benefits: On top of a competitive salary (based on your location, experience, and skills), we provide a comprehensive benefits package, which includes medical, dental, mental health, and vision coverage for you, your spouse/partner, and children.
Your qualifications and skills- Bachelor's or Master's degree in Computer Science, Engineering, or a related technical field
- 5+ years of hands-on experience in data engineering, ETL/ELT development, cloud-based data solutions, or building data products that serve analytics, automation, or machine learning needs
- Deep expertise in AWS cloud services, including S3, Lambda, Glue, Snowflake, and designing scalable, cost-efficient data architectures
- Proficiency in Python, including modularization, writing optimized, production-ready code for data transformations, automation, and workflow orchestration
- Expert-level SQL skills, including query optimization, performance tuning, stored procedures, and database design best practices
- Proven experience in designing and implementing scalable data pipelines using AWS Glue, Step Functions, and SQL-based transformations (using stored procedures)
- Strong knowledge of data modeling, data warehousing concepts, schema design, and partitioning strategies
- Hands-on experience with Tableau or other BI tools for data visualization and dashboard development
- Hands-on experience with DevOps and CI/CD, including infrastructure-as-code, version control (Git) and automated deployment strategies
- Strong problem-solving skills, with a focus on troubleshooting and optimizing complex data workflows for performance, reliability, and scalability
- Excellent communication and collaboration skills, with the ability to work effectively in agile, cross-functional teams and mentor junior engineers
- Experience with Databricks for scalable data processing, PySpark for distributed data transformations, and Delta Lake for data versioning (Preferred)
Please review the additional requirements regarding essential job functions of McKinsey colleagues.
FOR U.S. APPLICANTS: McKinsey & Company is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by applicable law.
FOR NON-U.S. APPLICANTS: McKinsey & Company is an Equal Opportunity employer. For additional details regarding our global EEO policy and diversity initiatives, please visit our McKinsey Careers and Diversity & Inclusion sites.
