Oliver Wyman - Data Engineer - Mexico City

Oliver Wyman; Mexico; Hybrid; PHP 1,642,000 - 2,555,000; Full time

Job summary

Oliver Wyman in Mexico City is seeking a data engineer to design, build, and maintain scalable data pipelines and infrastructure to support data-driven initiatives. You will work with cross-functional teams to ensure availability, reliability, and performance of data systems, with strong emphasis on Databricks, SQL, and Python.

This hybrid role requires collaboration across analytics teams and engineering, contributing to data governance, quality, and architecture strategies, while mentoring

Qualifications

• 2+ years in data engineering or related roles.
• 2+ years with Databricks and ETL tools.
• 2+ years of SQL/PLSQL development.
• Experience with cloud platforms (AWS/Azure/GCP).
• Experience with big data tech (Hadoop/Spark/Kafka).
• Proficiency in Python or R.
• Ability to visualize data with Tableau or Power BI.
• Experience with relational and NoSQL databases and data warehousing.
• Experience with multiple RDBMS such as SQL Server, Oracle.

Responsibilities

• Collaborates with analytics and business teams to improve data models that feed BI tools.
• Develop and maintain automated data pipelines for data collection, transformation, and delivery.
• Implement systems to monitor data quality and integrity across production data sources.
• Design data integrations and data quality frameworks with governance principles.
• Partner with business units and engineering to define long-term data platform architecture strategies.
• Document technical designs, workflows, and best practices for team knowledge sharing.
• Provide technical guidance and mentorship to peers and other stakeholders as needed.

Skills

Databricks

SQL/PLSQL

Python

Data modeling

Data governance

Cloud platforms

Big data tech

Visualization

Relational/NoSQL databases

Education

Bachelor's or MS in quantitative discipline

Tools

SSIS

Azure Data Factory

Alteryx

Knime

Job description

About Oliver Wyman Oliver Wyman, a Marsh (NYSE: MRSH) business, is a management consulting firm driven by deep industry insight, bold innovation, and a collaborative approach that cuts through complexity to help organizations navigate their most defining transformative moments.

About Oliver Wyman Oliver Wyman, a Marsh (NYSE: MRSH) business, is a management consulting firm driven by deep industry insight, bold innovation, and a collaborative approach that cuts through complexity to help organizations navigate their most defining transformative moments. For more information, visitoliverwyman.com, or follow us onLinkedInandX.

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. Also, please note that this is a hybrid role based in our Mexico City office.

Key Responsibilities

• 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.

Experience Required

• 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

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, visitoliverwyman.com, or follow us onLinkedInandX.

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.

R_360626