Advanced Analytics Engineer

AI in this role

databricks

Company:

Mercer

Description:

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
Experience building and integrating APIs and enterprise data services
Experience supporting advanced analytics, AI, or machine learning initiatives
Strong understanding of modern lakehouse and cloud-based data architectures
Experience with workflow orchestration, automation, and CI/CD pipelines
Familiarity with cloud platforms such as AWS, Azure, or GCP
Experience with streaming and real-time processing technologies is a plus
Knowledge of MCP integrations and AI-driven workflow architectures is a plus

Skills and Attributes:

Excellent problem-solving and analytical thinking skills with ability to solve complex data challenges
Strong ability to design scalable and efficient data solutions in fast-paced environments
Self-starter with strong ownership mindset and ability to work independently with minimal supervision
Strong curiosity and desire to learn emerging technologies and modern data/AI practices
Ability to interpret data trends and generate actionable insights for technical and business stakeholders
Strong collaboration skills with ability to work effectively across engineering, analytics, AI, and business teams
Effective communication skills with ability to explain technical concepts to non-technical audiences
Strong attention to detail with focus on data quality, reliability, and operational excellence
Ability to manage multiple priorities and adapt quickly to changing business needs
Strong relationship-building skills and ability to influence stakeholders across the organization
Passion for innovation, automation, and continuous improvement
Ability to thrive in highly dynamic and evolving technology environments

Why join our team:

We help you be your best through professional development opportunities, interesting work and supportive leaders.
We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have impact for colleagues, clients and communities.
Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well-being.
As of November 7, 2024, the Business Group Global Boilerplate Language, Country Specific Regulatory Language (Ex. US EEO Statement) OR Global Diversity Statement, and Global Hybrid Work Policy Statement have been automated except for:
Marsh McLennan Agency
Mercer Marsh Benefits

Oliver Wyman is a business of Marsh (NYSE: MRSH), a global leader in risk, reinsurance and capital, people and investments, and management consulting, advising clients in 130 countries. With annual revenue of over $27 billion and more than 95,000 colleagues, Marsh helps build the confidence to thrive through the power of perspective. For more information, visit oliverwyman.com, or follow us on LinkedIn and X. 

Marsh is committed to creating a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, disability, ethnic origin, family duties, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law.

Marsh is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one “anchor day” per week on which their full team will be together in person.

How we rate this

Advanced Analytics Engineer at Marsh McLennan rates 67 out of 100 for how much of the daily work is AI. That makes it Works on AI (AI Level 3 of 4). The level is about AI in the job, not seniority.

Classification

Works on AI. The daily work is on AI products, without building the model.

●●●● Builds AI80 to 100
●●●○ Works on AI60 to 79
●●○○ Uses AI40 to 59
●○○○ Little AI0 to 39

Levels come from how often the tools, models and workflows of the role are named in the posting itself. Open the description and count.

Prepare for this job

A free preview built only from this posting: what it asks for, what you could be asked in an interview, and how to adjust your resume.

Skills and AI tools this role asks for

Databricks

Questions you could be asked

What's a project where you used Databricks hands-on?
Describe a typical day in a role like this one: which parts run through AI directly?
If you removed AI from this role, what would be left, and how do you decide what still needs a human?

Adapt your resume

List these exact terms on your resume: Databricks. An applicant tracking system matches the wording, not the idea.
Attach one line of real, concrete experience to at least one of them — a tool named with nothing behind it rarely survives a human read.
Show where AI is part of your daily process, not a one-off project — this role expects it to be a running habit.

Want an expert to read your CV for this job?

Free. Send your CV and the role you want next. We reply by email within 2 to 4 business days.

Get a free CV review

Get new AI jobs (Works on AI ●●●○ or higher) by email

One email a week with the new AI jobs (Works on AI ●●●○ or higher), each rated for how much AI is in the work. No recruiter spam, unsubscribe in one click.

Also alert me for new jobs at Marsh McLennan

Free. One email a week. Unsubscribe in one click.