In this role, you will be a core member of Periscope's technology team, focusing on developing and deploying enterprise products while ensuring McKinsey's expertise remains at the forefront of technology. You will design, develop, and maintain scalable data pipelines and systems using Databricks on Azure. The position involves leading data engineering projects, collaborating with cross-functional teams, and mentoring junior engineers. Your work will contribute to delivering innovative solutions that meet business requirements and enhance data management capabilities.

• Bachelor's or master's degree in computer science, engineering, or a related field
• 6+ years of experience in data engineering, with a strong background in big data technologies
• Proficiency in Databricks on Azure, Spark, Python, and Spark SQL
• Extensive experience with Delta Live Tables, Unity Catalog, Delta Sharing, and SQL Warehouse
• Experience in handling large data volumes and orchestrating automated ETL using Azure Data Factory
• Demonstrated ability to optimize performance and cost in large-scale data environments
• Experience with cloud platforms, particularly Azure, and a solid understanding of cloud-native architectures
• Experience adopting software development best practices
• Experience with data governance, security, and compliance in a cloud environment

• Design, develop, and maintain scalable data pipelines and systems using Databricks on Azure
• Implement and optimize ETL processes with a focus on performance, cost-efficiency, and reliability
• Lead and execute data engineering projects from inception to completion
• Collaborate with cross-functional teams to understand data needs and deliver solutions
• Mentor and educate junior engineers on best practices and emerging technologies
• Work with client-facing teams to deploy client-specific solutions that integrate into internal systems

• Employees at McKinsey are often offered a comprehensive benefits package, including medical, dental, and vision coverage, prescription benefits, mental-health resources, expert medical opinions, and travel emergency protection. Financial benefits typically include retirement contributions and savings plans, life/accident/disability insurance, tax-advantaged accounts, and financial coaching. Many roles also feature generous paid time off (including volunteering days), flexible/hybrid work options, family care support (parental leave, fertility/adoption/surrogacy assistance, backup care), tuition reimbursement, transportation benefits, discounts, and matching gifts.