Senior Analyst - Data & Analytics

Marsh Agency; United States; Hybrid; MXN 700,000 - 1,000,000; Full time

Job summary

Marsh Agency is seeking a Data & Analytics Senior Analyst in Mexico to design and maintain scalable data pipelines on Databricks, build lakehouse data models, and enable AI-driven analytics. The role emphasizes collaboration with business and technical teams to translate requirements into robust data products and dashboards.

The candidate will drive data quality, performance optimization, and validation while exploring Gen AI capabilities to enhance enterprise data interactions.

Qualifications

• Bachelor’s degree in a quantitative field (Data Science, CS, Engineering, etc.).
• 4+ years in Data Analytics, Data Engineering, BI, or related roles.
• Advanced SQL skills.
• Python for data processing and automation.
• Experience developing ETL/ELT pipelines.
• Strong relational databases, data modeling, and data warehousing.
• Experience with Databricks or similar cloud data platforms.
• Understanding of Medallion Architecture or modern lakehouse architectures.
• Strong analytical and problem-solving skills.
• Ability to communicate with business and technical stakeholders.
• Professional working proficiency in English.

Responsibilities

• Design, develop, and maintain scalable data pipelines using Databricks.
• Build data models following Medallion Architecture.
• Data transformation, cleansing, standardization, and validation using SQL and Python.
• Design reusable datasets to support analytics and AI use cases.
• Troubleshoot data pipelines and data quality issues.
• Collaborate with stakeholders to translate requirements.
• Support analytics projects from requirements to production deployment and support.
• Communicate technical concepts clearly to stakeholders.

Skills

Advanced SQL

Python for data processing

ETL/ELT pipelines

Medallion Architecture

Data warehousing concepts

English communication

Education

Bachelor's degree in a quantitative field

Tools

Databricks

Job description

About The Role

We are looking for a Data & Analytics Senior Analyst to join our team and contribute to the development of scalable data and AI-driven analytics solutions.

This role is designed for a senior-level technical professional who combines strong data engineering capabilities with experience or interest in Generative AI, conversational analytics, and modern data platforms. As part of a data delivery team, this role is responsible for ensuring ETL code quality by testing the data correctness, completeness and accuracy between sources and destinations.

Key Responsibilities

Data Engineering & Architecture

• Design, develop, and maintain scalable data pipelines using Databricks.
• Build and maintain data models following Medallion Architecture principles (Bronze, Silver and Gold layers).
• Perform data transformation, cleansing, standardization, and validation using tools like SQL and Python.
• Design reusable and scalable datasets to support analytics, reporting, and AI use cases.
• Troubleshoot data pipelines, data quality issues, and performance problems.

AI & Conversational Analytics

• Participate in the design, development, and continuous improvement of Databricks Genie Spaces and AI-enabled analytics solutions.
• Translate business questions and analytical requirements into semantic models that AI tools can understand and query effectively.
• Design and execute benchmark questions and validation frameworks to evaluate the accuracy of AI-generated answers.
• Explore new Generative AI capabilities that can improve how users interact with enterprise data.

Analytics & Business Collaboration

• Work closely with business stakeholders, analysts, data engineers, and subject matter experts to translate business requirements into technical solutions.
• Perform data analysis and validation to ensure consistency between source systems, analytical datasets, and business expectations.
• Support the delivery of analytics projects from requirements gathering through production deployment and ongoing support.
• Communicate technical concepts and project progress clearly to both technical and non-technical stakeholders.

Required Qualifications

• Bachelor’s degree in Data Science, Computer Science, Engineering, Actuarial Science, Mathematics, Information Technology, or a related quantitative field.
• Approximately 4+ years of experience in Data Analytics, Data Engineering, Business Intelligence, or related roles.
• Advanced SQL skills.
• Experience with Python for data processing and automation.
• Experience developing ETL/ELT pipelines.
• Strong understanding of relational databases, data modeling, and data warehousing concepts.
• Experience working with Databricks or comparable cloud data platforms.
• Understanding of Medallion Architecture or modern lakehouse architectures.
• Strong analytical and problem-solving skills.
• Ability to communicate effectively with both business and technical stakeholders.
• Professional working proficiency in English.

Preferred Qualifications

• Experience with Databricks Genie.
• Experience building semantic layers for analytics or AI applications.
• Exposure to Generative AI, LLMs, RAG, conversational BI, or natural-language-to-SQL solutions.
• Experience with Microsoft Fabric, Qliksense, Power BI, or similar analytics ecosystems.
• Experience working in Agile environments and managing multiple analytics initiatives simultaneously.

What We Are Looking For

We are looking for someone who is technically strong but also curious and business-oriented. The ideal candidate does not simply build pipelines based on predefined specifications; they understand why the data is needed, how it will be consumed, and how to design reliable data products that can support both traditional analytics and emerging AI use cases.

The successful candidate should be comfortable investigating complex problems, challenging assumptions, learning new technologies, and collaborating across technical and business teams.

Marsh

Marsh (NYSE: MRSH) is 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 marsh.com, or follow us on LinkedIn and X.

Marsh is committed to providing an inclusive work environment. We aim to attract and retain the best, most qualified people and value colleagues of all backgrounds, without regard to 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.