Lead Data Architect

Company:

Mercer

Description:

MMC is seeking candidates for the following position based in the Mexico City office and be onsite 3 days a week:   Lead Data Architect

What can you expect?

The Lead Data architect will play a technical lead role in a team of data engineers to deliver data and analytics projects for a line of business.

What is in it for you?

• A company with a strong Brand and strong results to match
• Culture of internal mobility, collaboration and valued partnership from the business.
• Employee Resource Groups which provide access to leaders, relevant volunteer and mentoring opportunities and interactions with counterparts in industry groups and client organizations.
• Entitled to vacation, floating holidays, time off to give back to your community, sick days, and national holidays (with early dismissal).

• Enjoy unlimited access to a vast range of courses and professional training through Udemy to continually enhance your skills and knowledge

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 complexity
• Work 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 capabilities
• Collaborate 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
• Participate in all aspects of the software development lifecycle for AWS solutions, including planning, requirements, development, testing, and quality assurance
• Troubleshoot incidents, identify root causes, fix, and document problems, and implement preventive measures
• Demonstrate exceptional problem-solving skills, with an ability to see and solve issues before they affect business productivity
• Actively contribute toward our culture of continuous learning by proactively identifying and evangelizing best practices globally.

What you need to have:

• Excellent written and verbal communication skills in English
• Bachelor’s degree (or equivalent) in computer science, information technology, or mathematics
• 3+ years of relevant Data Ingestion/ETL/ELT, Big Data and Data Visualizations experience in mission-critical platforms.
• Strong Python or Java development and SQL experience
• Experience with schema design and dimensional data modelling.
• Experience working on AWS and related services (not limited to) such as Glue, Athena, S3.
• Must have experience working in a fast-paced environment with rapidly changing expectations and requirements(Agile)

What makes you stand out?

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

If you are interested, please send your CV in English.

Interviews will be held in English.

Marsh McLennan (NYSE: MMC) is the world’s leading professional services firm in the areas of risk, strategy and people. The Company’s 85,000 colleagues advise clients in 130 countries.  With annual revenue of over $20 billion, Marsh McLennan helps clients navigate an increasingly dynamic and complex environment through four market-leading businesses. Marsh  provides data-driven risk advisory services and insurance solutions to commercial and consumer clients. Guy Carpenter  develops advanced risk, reinsurance and capital strategies that help clients grow profitably and pursue emerging opportunities. Mercer  delivers advice and technology-driven solutions that help organizations redefine the world of work, reshape retirement and investment outcomes, and unlock health and well being for a changing workforce. Oliver Wyman s  serves as a critical strategic, economic and brand advisor to private sector and governmental clients. For more information, visit marshmclennan.com, or follow us on LinkedIn and Twitter.

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 based teams will identify at least one “anchor day” per week on which their full team will be together in person. office or working onsite with clients at least three days per week.

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.