Data Engineer - Advanced Analytics, Madrid


  • Advanced degree in computer science, information systems, or closely related field
  • 1-5 years of hands-on experience in software engineering or IT infrastructure role
  • Advanced knowledge of Hadoop stack, with prior experience in Hive, Pig, HBase, Impala and Sqoop
  • Advanced knowledge of object oriented programming, distributed systems and software design principles
  • Advanced knowledge of database maintenance and administration using MS SQL Server
  • Strong programming experience in Java, Python and R
  • Hands-on experience in Microsoft Azure or Amazon EC2 cloud platform
  • Demonstrated ability to design and implement ETL workflows across both Windows and Linux environments
  • Should be a highly motivated individual with the ability to work effectively with people across all levels in an organization
  • Position requires ability to travel about 20%
  • Nice to have: programming experience in C++, SAS, and JavaScript
  • Experienced in RDBMS systems like Oracle Database, IBM DB2, or MySQL
  • Experienced in NoSQL systems like MongoDB, Redis, or Cassandra
  • Experienced in Apache Spark

Who You'll Work WithYou'll work with our Advanced Analytics group in Madrid. As a member of this team, you'll work with McKinsey consulting teams to carry out complex data analysis and modeling, creating a foundation for sound recommendations for client studies and internal projects.

What You'll DoYou will expand McKinsey's current analytics and machine learning capabilities, helping create new strategies and data tools within an innovative organization. You will help shape the future of what data-driven organizations look like, creating new lines of thinking within a diverse range of clients and situations. You will constantly engage with our clients and team members as they architect new systems and strategies for extracting, transforming and optimizing data flows from complex, sometimes disparate, data sources. You will work with our clients' entire data ecosystem to enable effective, highly scalable data analysis pipelines. This role will develop, implement and maintain distributed systems around all elements of data analysis with a constant eye toward continuous improvement.

Meet Some of McKinsey's Employees

Danielle B.


Danielle is one of the leaders of McKinsey’s business with retail and consumer clients. She oversees client projects and helps her teams and her clients utilize McKinsey’s resources.

Fope F.

Senior Associate

Fope helps lead a small team that works for McKinsey clients, helping them address business challenges and strategic questions. Though based in the NYC office, she travels frequently so she can be in-person with her clients.

Back to top