Data Operations Engineer II
McKinsey & Company
Operations
San Jose, CA, USA
Posted on Apr 3, 2025
Data Operations Engineer II
Job ID: 96559
Do 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 Impact
As a Cloud Infrastructure Engineer II at McKinsey, you will play a pivotal role in ensuring the seamless operation and optimization of our data infrastructure.
You will manage and maintain data pipelines and refresh processes to ensure the timely and accurate availability of data for critical business needs.
In this capacity, you will investigate and resolve pipeline failures by conducting root cause analyses and implementing effective remediations.
Your expertise will be instrumental in optimizing and maintaining data pipelines to support robust data integration and transformation efforts.
You will design and build processes that facilitate efficient data ingestion, transformation, qualitative analysis, and dependency management.
Collaborating closely with data provider teams, you will address pipeline issues that impact data freshness and accuracy. When discrepancies arise that cannot be resolved by feeder teams, you will take the lead in raising and implementing data fixes to ensure the integrity of data in reporting layers.
In addition to operational responsibilities, you will spearhead the evaluation, implementation, and deployment of tools and processes that enhance the efficiency and effectiveness of our workflows.
You will identify opportunities for process improvement, automate repetitive tasks, and enhance the sustainability of existing data pipelines. Ensuring compliance with data governance and security policies will be a key aspect of your role.
Collaboration will be central to your success, as you will work closely with cross-functional teams, including data translators, data scientists, and data visualization engineers, to deliver exceptional client service.
Furthermore, you will manage and support infrastructure platform configurations, resource provisioning, and cloud and data services to maintain a high-performing and reliable infrastructure environment. Your contributions will enable McKinsey to deliver innovative, data-driven solutions to our clients.
Your Growth
Secure Foundation Cloud Services is an entity within McKinsey's global IT organization that provides IT support services to McKinsey Firm members and clients.
The team is responsible for managing the Firm’s global IT infrastructure and applications. Secure Foundation Cloud Services provides “Data Operation and Engineering” services for McKinsey’s business operations.
This group is responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams.
It is a team of skilled engineers supporting our software developers, data analysts and data scientists, with initiatives to ensure optimal data delivery architecture and consistency during engagements.
Beyond technology skills, our data operations engineers bring skills essential to client service, including Problem Solving, Critical Thinking, Process Orientation and Business savvy. Team members are currently distributed globally across three time zones (India, USA, Costa Rica).
Your qualifications and skills
- Degree in Engineering or related field. Data engineering or analytics certifications are a plus.
- 3+ years of experience managing data products and pipelines (data ingestion & transformation) on cloud platforms, with expertise in identifying inefficiencies and implementing automation solutions
- Proficient in complex SQL for data validation, troubleshooting, and root cause analysis, along with scripting (Python) for automation, pipeline enhancement, and workflow optimization
- Skilled in handling data issues, collaborating with feeder teams, and resolving discrepancies using tools like Apache Airflow, AWS Glue, DBT, or similar ETL frameworks
- Strong understanding of cloud databases (e.g., Snowflake, AWS RDS, Aurora, SQL Server), recovery models, and public cloud platforms (AWS or Azure)
- Working knowledge of CI/CD tools (e.g., GitHub Actions, JFrog, SonarQube) and visualization tools (e.g., Tableau, Power BI)
- Experienced in collaborating with cross-functional teams (Data Engineers, BI, Infra) to resolve issues, improve processes, and drive operational enhancements through automation
- Adaptable to ambiguity and rapid changes, with a proactive mindset for optimizing processes and solving business problems using data-driven solutions
- Fluency in English in business contexts
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.
share this job
Job Skill Group - CSSA
Job Skill Code - SSTE - Cloud Infrastructure Engineer II
Function - Technology
Industry - High Tech
Post to LinkedIn - Yes
Posted to LinkedIn Date - Wed Mar 26 00:00:00 GMT 2025
LinkedIn Posting City - San Jose
LinkedIn Posting State/Province -
LinkedIn Posting Country - Costa Rica
LinkedIn Job Title - Data Operations Engineer II
LinkedIn Function - Information Technology
LinkedIn Industry - Information Technology and Services
LinkedIn Seniority Level - Mid-Senior level
Job Skill Code - SSTE - Cloud Infrastructure Engineer II
Function - Technology
Industry - High Tech
Post to LinkedIn - Yes
Posted to LinkedIn Date - Wed Mar 26 00:00:00 GMT 2025
LinkedIn Posting City - San Jose
LinkedIn Posting State/Province -
LinkedIn Posting Country - Costa Rica
LinkedIn Job Title - Data Operations Engineer II
LinkedIn Function - Information Technology
LinkedIn Industry - Information Technology and Services
LinkedIn Seniority Level - Mid-Senior level