About this role
JOB 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.
Apply Now
Recommended
Get matched!
Upload your resume and see jobs that match your skills and experience.
Search with resume
Get notified for similar jobs
You'll receive updates once a week
Enter Email address (Required)
Activate
Manage alerts
Failure!
Ok
Profile recommendations
Show more
Show less
See next
See even more
No recommendations found
Similar Jobs
Data Engineer
Location
Rua António Pedro, no. 111, 1150-045 Lisbon, Portugal
Category
Finance
Job Id
R_346094
We are looking for a Data Engineer to join our Data & Analytics Team at Mercer. In this role, you will design and maintain scalable data pipelines, collaborate with cross-functional teams, and ensure data quality and integrity to support data-driven initiatives.
Analytics Application Engineer/Developer
Location
Rua António Pedro, no. 111, 1150-045 Lisbon, Portugal
Category
Finance
Job Id
R_365435
We are looking for a Full Stack Software Engineer to join our Data & Analytics Team at Mercer. This role involves building applications that enable users to interact with data, utilizing technologies like Python and React.
Data & Analytics Analyst - Lisbon
Location
Rua António Pedro, no. 111, 1150-045 Lisbon, Portugal
Category
Finance
Job Id
R_344801
We are looking for a Data and Analytics Analyst to create and maintain reporting artifacts connected to the operations of Oliver Wyman. The ideal candidate will leverage their problem-solving skills and creativity to deliver impactful analytics solutions.
Regional Lead – Revenue Operations & Project Lifecycle
Location
Rua António Pedro, no. 111, 1150-045 Lisbon, Portugal
Category
Finance
Job Id
R_362156
We are looking for a talented individual to join Oliver Wyman as a Regional Lead – Revenue Operations & Project Lifecycle. This hybrid role will focus on leading operational execution