Senior Data Engineer - Periscope

Consulting Senior Data Engineer - Periscope

Job ID: 108653

• Atlanta
• Boston
• Dallas
• New Jersey

Apply NowApply Later Do you want to do work that matters, alongside supportive leaders who will help you grow faster than you ever thought possible? Are you a creative problem-solver who is energized by challenges? You've come to the right place. YOUR IMPACT 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. In this role you will design, develop, and maintain scalable data pipelines and systems using Databricks on Azure (among other environments). You will implement and optimize ETL processes with a focus on performance, cost-efficiency, and reliability. You will utilize advanced Databricks technologies (DLT, Unity Catalog, Delta Sharing, SQL Warehouse) to enhance data management and sharing capabilities. You will be leading and executing data engineering projects from inception to completion, ensuring timely delivery and high quality while you continuously monitor, troubleshoot, and improve data pipelines and workflows to ensure optimal performance and cost-effectiveness. You will 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. You will also work with client facing teams to help solve and deploy client specific solutions that integrate into the client's internal systems. Periscope is the asset-based arm of McKinsey's Marketing & Sales practice and is at the leading edge of the new ways we serve clients. This integrated model of serving clients, i.e. combining our generalist consulting approaches with the solutions, is a proof of the firm's commitment to continued innovation in the spirit of bringing the best of the firm to our clients. Periscope By McKinsey enables better commercial decisions by uncovering actionable insights. The Periscope platform combines world leading intellectual property, prescriptive analytics, and cloud-based tools to provide more than 25 solutions focused on insights and marketing, with expert support and training. It is a unique combination that drives revenue growth both now and in the future. Customer experience, performance, pricing, category, and sales optimization are powered by the Periscope platform. Periscope has a presence in 26 locations across 16 countries with a team of 600+ business and IT professionals and a network of 300+ experts. To learn more about how Periscope's solutions and experts are helping businesses continually drive better performance, visit their site. 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, all while upholding our unwavering commitment to ethics and integrity. 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 to enable holistic well-being for you and your family.

YOUR QUALIFICATIONS AND SKILLS

• 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

Please review the additional requirements regarding essential job functions of McKinsey colleagues.
Our
unwavering commitment to integrity drives everything we do, guiding us to always act in the best interests of our clients, our people, and the communities we serve. Industries Capabilities Apply NowApply Later

FOR U.S. APPLICANTS: McKinsey & Company is an Equal Opportunity/Affirmative Action 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.

Certain US jurisdictions require McKinsey & Company to include a reasonable estimate of the salary for this role.
For new joiners for this role in the United States, including all office locations where the job may be performed, a reasonable estimated range
is $195,300 - $199,200 USD -to help you understand what you can expect. This reflects our best estimate of the lowest to highest
[salary/hourly wages] for this role at the time of this posting, ensuring you have a clear picture right from the start, though it's important
to remember that actual salaries may vary. Factors like your office location, your unique blend of experience and skills, start date and our current
organizational needs all play a part in determining the final figure. Certain roles are also eligible for bonuses, subject to McKinsey's discretion
and based on factors such as individual and/or organizational performance.

Additionally, we provide a comprehensive benefits package that reflects our commitment to the wellness of our colleagues and their families.
This includes medical, mental health, dental and vision coverage, telemedicine services, life, accident and disability insurance, parental leave and family planning benefits, caregiving resources, a generous retirement contributions program, financial guidance,
and paid time off.

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