Analyst - Data Engineering

Company:Marsh McLennan AgencyDescription:

Marsh McLennan is seeking candidates for the following position based in the Pune/Mumbai office.

SeniorPrincipal Engineer/Manager  – Data Engineer

What can you expect?

As a Data Engineer, you will be responsible for designing and implementing scalable data pipelines using Databricks and the Medallion Architecture. 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. Additionally, knowledge on Informatica, Unix, and Oracle database is also a good to have.

What is in it for you?

• Holidays (As Per the location)
• Medical & Insurance benefits (As Per the location)
• Shared Transport (Provided the address falls in service zone)
• Hybrid way of working
• Diversify your experience and learn new skills
• Opportunity to work with stakeholders globally to learn and grow

We will count on you to:

• Develop and maintain data pipelines using Databricks and the Medallion Architecture (Bronze, Silver, Gold layers).
• Design and optimize ETL/ELT workflows to ensure data quality and efficiency.
• Write data transformation scripts using Python and PySpark.
• Store and manage 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 the data using AWS DMS from disparate sources.

What you need to have: 

• Experience with Databricks and the Medallion Architecture.
• Proficiency in Python, PySpark, and SQL for data processing and transformation.
• Solid experience with ETL/ELT pipelines and cloud-based data solutions, specifically AWS S3.
• Familiarity with version control using Git.
• Understanding of modern data architecture principles and best practices.
• Preferred Qualifications:
• Experience with Delta Lake and other Databricks technologies. Knowledge of additional AWS services (e.g., Redshift, Glue, Lambda, S3, DMS ).

Marsh McLennan (NYSE: MMC) is the world's leading professional services firm in the areas of risk, strategy and people. The Company's more than 85,000 colleagues advise clients in over 130 countries.  With annual revenue of $23 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 serves as a critical strategic, economic and brand advisor to private sector and governmental clients. For more information, visit , or follow us on LinkedIn and X.

Marsh McLennan is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people regardless of their sex/gender, marital or parental status, ethnic origin, nationality, age, background, disability, sexual orientation, caste, gender identity 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.

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 , or follow on LinkedIn and X.Marsh McLennan is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, caste, disability, ethnic origin, family duties, gender orientation or expression, gender reassignment, 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.

---