Senior Data Engineer - Periscope

About the role

You will be a core member of Periscope’s technology team with responsibilities that range from developing and deploying our core enterprise products to ensuring that McKinsey’s craft and expertise remain on the leading edge of technology.

Responsibilities

• Design, develop, and maintain scalable data pipelines and systems using Databricks on Azure (among other environments).
• Implement and optimize ETL processes with a focus on performance, cost-efficiency, and reliability.
• Utilize advanced Databricks technologies (DLT, Unity Catalog, Delta Sharing, SQL Warehouse) to enhance data management and sharing capabilities.
• Lead and execute data engineering projects from inception to completion, ensuring timely delivery and high quality while continuously monitoring, troubleshooting, and improving data pipelines and workflows to ensure optimal performance and cost-effectiveness.
• Collaborate with cross-functional teams to understand data needs and deliver solutions that meet business requirements.
• Mentor and educate junior engineers on best practices, emerging technologies, and efficient data engineering techniques.
• Work with client facing teams to help solve and deploy client specific solutions that integrate into the client’s internal systems.

Requirements

• 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 (server and serverless)
• Experience in handling large data volumes and orchestrating automated ETL using Azure Data Factory, Airflow / data pipelines using CI/CD and Cloud Technologies
• Development efficiency leveraging AI framework technologies
• Demonstrated ability to optimize performance and cost in large-scale data environments
• Proven track record of leading projects independently and mentoring junior team members
• Experience with cloud platforms, particularly Azure, and a solid understanding of cloud-native architectures
• Experience adopting software development best practices (e.g., modularization, testing, refactoring, etc.)
• Experience with data governance, security, and compliance in a cloud environment
• Familiarity in understanding BI framework

Qualifications

• Master’s degree in computer science, engineering or a related field

Skills

• Advanced knowledge of Databricks on Azure, Spark, Python, and Spark SQL
• Experience with Delta Live Tables, Unity Catalog, Delta Sharing, and SQL Warehouse (server and serverless)
• Strong proficiency in cloud platforms, particularly Azure, and cloud-native architectures
• Experience with data governance, security, and compliance in a cloud environment
• Experience with AI framework technologies
• Experience with software development best practices (e.g., modularization, testing, refactoring, etc.)

Benefits

• 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.
• 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, all while upholding our unwavering commitment to ethics and integrity.
• 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.
• World-class benefits: On top of a competitive salary (based on your location, experience, and skills), we provide a comprehensive benefits package to enable holistic well-being for you and your family.

Pay

• Competitive salary based on your location, experience, and skills

Schedule

• Full-time