Data Engineer II

McKinsey & Company
parental leave, paid time off
United States, Georgia, Atlanta
Mar 31, 2025
Technology & Digital Data Engineer II Job ID: 96657 As a Data Engineer II, you will be based in Atlanta (US), Gurgaon (IN), or San Jose (CR) as part of our Learning and Development Solutions Team. This team is responsible for technically managing learning platforms that empower our colleagues' growth and development. 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 You will be a leading contributor in the creation and maintenance of data pipelines and database views to represent required information sets. You will build and test more sophisticated end-to-end data transformation pipelines solving for specific challenges of different kinds of data sources and types of data (e.g., master, transaction, reference, and metadata). You will be technically hands-on and comfortable writing code to cater to business requirements. You will design solutions and use SQL, Python, PySpark, or other programming tools to consume, transform, and write data according to processing requirements for the data. You will follow and help to enforce coding and data best practices with the team. You will develop, promote, and use reusable patterns for consuming, transforming, and storing different kinds of data from diverse sources. You will always use a quality and security-first mindset and ensure principles are met through leading by example. You will keep aware of the newest technologies and trends and provide meaningful investigations into their potential. You will act as thought leader in the team to assess the technical feasibility of developing solutions around a conceptual idea. You will consistently be seen as an enabler to working with distributed development teams. 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 Undergraduate degree; Advanced graduate degree (e.g., MBA, PhD, etc.) or equivalent work experience preferred 5+ years of corporate and/or professional services experience Excellent organization capabilities, including the ability to initiate tasks independently and see them through to completion Strong communication skills, both verbal and written, in English and local office language(s), with the ability to adjust your style to suit different perspectives and seniority levels Proficient in rational decision-making based on data, facts, and logical reasoning Must have technical skills with hands-on experience * AWS - Glue, S3 Snowflake (SQL, data sharing, Snowpark, views, functions/stored procedures, Snowpipe) Python, PySpark, Pandas Git/GitHub, GitHub Actions Terraform Designing and implementing ETL pipelines with an understanding of common transformations Nice to have technical skills AWS - RDS, DynamoDB, Lambda, API-GW, EC2, Sagemaker Airflow Databricks Kafka Iceberg, Flink Snowflake Cortex Warehousing Data lakes/lake houses Data modeling Please review the additional requirements regarding essential job functions of McKinsey colleagues. Apply Now Apply Later 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. 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 $116,600 - $119,600 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. Job Skill Group - CSSA Job Skill Code - FSDA - Data Engineer II Function - Technology Industry - High Tech Post to LinkedIn - #LI-DNI Posted to LinkedIn Date - LinkedIn Posting City - LinkedIn Posting State/Province - LinkedIn Posting Country - LinkedIn Job Title - Data Engineer II LinkedIn Function - LinkedIn Industry - LinkedIn Seniority Level -