Lead Data Architect

We are seeking a Lead Data Architect to join our Applications Development team at Mercer. This role will be based in Mexico City. This is a hybrid role that has a requirement of working at least three days a week in the office. As a Lead Data Architect at Marsh, your role serves as the lead data architect for the Corporate Data Engineering team and will align with the Enterprise Corporate line of business. The Lead Data Architect is expected to make an immediate impact on the assigned projects.

We will count on you to:

Conceptualize and implement a comprehensive, thoughtful, and best-in-class data ingestion and processing capabilities to support this line of business.Provide technical leadership, leading the team to build reusable and scalable data pipelines and new API integrations to support continuing increases in data volume and complexityWork in tandem with source system and application teams to integrate and establish data pipelines using Databricks, S3 and other AWS services.Understand data landscape i.e., tooling, tech stack, source systems etc. and work closely with extended platform teams to improve data collection, quality, reporting and analytics capabilitiesCollaborate 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 organizationParticipate in all aspects of the software development lifecycle for AWS solutions, including planning, requirements, development, testing, and quality assurance

What you need to have:

Bachelor’s degree (or equivalent) in computer science, information technology, or mathematics3+ years of relevant Databricks, Data Ingestion/ETL/ELT, Big Data, and Data Visualizations experience.Strong Python development and SQL experienceExperience with schema design and dimensional data modelling.Experience working on AWS and related services (not limited to) such as Glue, Athena, S3.Excellent written and verbal communication skills in English

What makes you stand out:

Strong AWS experience.Prior experience working in HR technology and services.Experience in DatabricksExperience in Informatica data quality and governance tools.

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.

Marsh McLennan (NYSE: MMC) is a global leader in risk, strategy and people, advising clients in 130 countries across four businesses: Marsh, Guy Carpenter, Mercer and Oliver Wyman. With annual revenue of $24 billion and more than 90,000 colleagues, Marsh McLennan helps build the confidence to thrive through the power of perspective. For more information, visit marshmclennan.com, or follow on LinkedIn and X.

Marsh McLennan 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 McLennan 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 McLennan 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.