Data Engineer

Company:Mercer

Description:

We are seeking a Data Engineer to join our Data & Analytics Team at Mercer. You will be joining us 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.

Job Overview:

You will be responsible for designing, building, and maintaining scalable data pipelines and infrastructure to support our data-driven initiatives. You will collaborate closely with cross-functional teams to ensure the availability, reliability, and performance of our data systems and solutions. Strong experience with Databricks and solid coding skills in SQL and Python are essential to succeed in this role.

We will count on you to:

• Collaborates with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization

• Develop and maintain automated data pipelines for efficient data collection, transformation, and delivery adhering to business requirements.

• Implement systems and processes to monitor and ensure data quality and integrity across production data sources.

• Design data integrations and data quality frameworks while applying data governance principles.

• Partner with business units and engineering teams to define long-term data platform architecture strategies.

• Document technical designs, workflows, and best practices to support team knowledge sharing and system maintenance.

• Provide technical guidance and mentorship to peers and other stakeholders as needed.

What makes you stand out?

• Bachelors / MS in a quantitative discipline e.g., applied mathematics, statistics, computer science, information systems or related field

• 2+ years of experience in experience in data engineering, software development, or related roles.

• 2+ years of hands-on experience with Databricks and other ETL tools such as SSIS, Azure Data Factory, Alteryx, or Knime.

• 2+ years of SQL/PLSQL development experience

• Familiarity with cloud platforms and services (e.g., AWS, Azure, Google Cloud Platform, etc.).

• Experience with big data technologies and frameworks (e.g., Hadoop, Spark, Kafka, etc.).

• Proficiency with languages like Python or R

• Ability to create compelling and insightful visualizations using tools like Tableau, Power BI, or other visualization platforms

• Familiarity with relational and NoSQL databases, and experience with data warehousing concepts.

• Experience with multiple RMDB’s such as SQL Server, Oracle

Skills and Attributes:

• Excellent problem-solving and critical thinking skills required

• Ability to drive exploration and draw conclusions from multiple data sets

• Strong spirit of innovation, self-starter, independent, and with ability to come up with solutions to meet business problems

• Self-directed who can interpret data to understand trends and derive meaningful business insights for senior executives with little oversight

• Self-motivated with ability to work independently while also enjoying collaboration with cross-functional teams and other analysts

• Strong desire to learn new skills and pass knowledge acquired onto others

• Keen attention to detail with deep quantitative and analytical skills and demonstrated capacity to solve problems and enhance reporting

• Strong relationship building skills and ability to build alignment among customers and key stakeholders with demonstrated experience influencing without authority

• Ability to work effectively in a fast paced, deadline driven, highly dynamic atmosphere and react quickly to changes and shifting priorities.

• Effective communication skills and ability to translate numbers into a story

• You need to be curious by nature, understand how data is produced in our various underlying systems and how reporting and analytics content is compiled so that data can be turned into actionable business insights to support the firm’s strategy

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.