Advanced Analytics Engineer

We are seeking an  Advanced Analytics Engineer to join our Data Analytics team at Mercer, playing a key role in building Oliver Wyman’s new hub in Lisbon.

This is a hybrid role that has a requirement of working at least three days a week in the office.

The Advanced Analytics Engineer will design and build scalable data solutions that support advanced analytics, machine learning, and AI initiatives. You will be joining us in building Oliver Wyman’s new hub in Lisbon.

This role focuses on developing data pipelines and workflows for structured and unstructured data using Databricks, Python, and PySpark. The ideal candidate is passionate about modern data platforms, distributed computing, API integrations, and enabling data-driven innovation across the organization.

We will count on you to**:**

• Design, develop, and optimize scalable data pipelines using PySpark and Databricks

• Build workflows to ingest, process, and transform structured and unstructured data

• Develop data models and reusable datasets for analytics and AI use cases

• Integrate external systems and enterprise platforms through APIs and modern data interfaces

• Collaborate with AI engineers and platform teams to support MCP (Model Context Protocol) integrations and AI-driven workflows

• Collaborate with data scientists, AI engineers, and business stakeholders to support advanced analytics initiatives

• Implement data quality, governance, monitoring, and observability best practices

• Optimize performance and scalability of distributed data processing environments

• Support batch and real-time data processing architectures

• Contribute to CI/CD pipelines and DataOps best practices

• Document technical solutions, workflows, and operational procedures

What makes you stand out?

• 2+ years of experience in Data Engineering, Analytics Engineering, or related roles

• Strong hands-on experience with Python, PySpark, Databricks, and SQL

• Experience designing and developing scalable ETL/ELT pipelines and distributed data processing solutions

• Experience working with structured, semi-structured, and unstructured data