Senior Data Engineer - AI

We are seeking a talented individual to join our Mercer Team at Marsh. This role will be based in Noida/Gurgaon/Mumbai. This is a hybrid role that has a requirement of working at least three days a week in the office.

Senior Principal Engineer - Data Engineering

We will count on you to:

As a Data Engineer, you will be responsible for designing and implementing scalable data pipelines and AI Based solution using Databricks. You will handle end-to-end ETL/ELT processes, manage large datasets, and work with tools like Python, PySpark, and AWS S3 to ensure data is transformed and optimized for analytical use.

Youll work on cutting-edge cloud and hybrid data projects, transforming raw data into meaningful insights and AI Analytics. Youll be hands-on from day one, collaborating closely with architects and business stakeholders.

What you need to have:

• Develop and maintain data pipelines using Databricks and the Medallion Architecture (Bronze, Silver, Gold layers).
• Design AI Based Solution using Databricks Genie and E2E integration.
• Knowledge of exposing/consuming Databricks features via API using cloud-native tools or other application.
• Write data transformation scripts using Python and PySpark.
• Store and manage real time data in AWS S3 and integrate with other cloud-based services.
• Use SQL to query, clean, and manipulate large datasets.
• Collaborate with cross-functional teams to ensure data is accessible for business intelligence and analytics.
• Monitor and troubleshoot data pipelines for performance and reliability.
• Document data processes and follow best practices for scalability and maintainability.
• Ingest and process structured and unstructured data across batch and streaming sources.

What makes you stand out?

• Experience with Databricks components like : Pipeline, scheduled / event based job , Genie , Unity Catalog and Datawarehouse.
• Proficiency in Python, PySpark, and SQL for data processing and transformation using AWS S3 data.
• Experience in Data Governance , data access security , and information of configuring Job compute for different Jobs in Databricks.
• Familiarity with version control using Git.
• Understanding of Databricks API and its integration with different Tools and application.
• Bulk data and real time data streaming understanding.
• Experience with Delta Lake and other Databricks technologies. Knowledge of additional AWS services (e.g., Athena, Glue, Lambda, S3, DMS ).

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.