Lead Data Engineer

Job Title- Lead Data Engineer

Position type- Full Time

Work Location- Bangalore/ NCR

Working style- Hybrid

Cab Facility- Yes

Shift Time -10 AM to 7 PM

People Manager role: No

Required education and certifications critical for the role- Btech or Master's degree in computer science

Required years of experience -

9- 14 years of relevant experience

Aon is in the business of better decisions

At Aon, we shape decisions for the better to protect and enrich the lives of people around the world. As an organization, we are united through trust as one inclusive, diverse team, and we are passionate about helping our colleagues and clients succeed.

Responsibilities:

• Collaborate with teams of experienced actuaries, developers and business experts to deliver projects
• Design and propose end-to-end data pipelines ((ingestion to storage to consumption) for data projects as well as databases to support web-based applications
• Design and implement data warehouses and data marts to serve data consumers
• Execute implementation of the designs and bring it from design stages to implementation followed by operationalization to maintenance
• Database design and modelling. To be able to organize data at both macro and micro level and provide logical data models for the consumers
• Database performance tuning and data lifecycle management
• Assist in support and enhancements of existing data pipelines and databases

Requirements:

• 9+ years of total experience working with data integration teams.
• 3+ years of in-depth experience developing data pipelines within an Apache Spark environment (preferably Databricks).
• 2+ years of active hands-on work with Databricks, demonstrating in-depth experience.
• Good experience in building data pipelines that ingests various types of data sources into a database or data lake and populating a structured warehouse or data mart that fuels the data consumer.
• Fluent in both complex SQL query performance tuning and database performance tuning
• Highly knowledgeable in ETL/ELT processes, both design and implementation via SSIS or some other ELT/ETL tool.
• Good knowledge of data modelling, database technologies, data warehousing.
• Have experience in building and designing data warehouses/data marts
• Understand the importance of performance and able to implement best practices in ensuring performance and maintainability for data-centric projects
• This person is required to be dynamic and be a quick eager learner as knowledge about new technologies will need to be acquired on the spot
• Experience with BI and analytics tools like Power BI or Tableau.

Nice to haves:

• Experience integrating AI into data engineering.
• Certifications in Databricks, cloud computing or database management.
• Experience developing data solutions using native IaaS and PaaS solutions on AWS (RDS, S3).
• Experience in any object-oriented programming language.

HOW WE SUPPORT OUR COLLEAGUES

In addition to our comprehensive benefits package, we are proud to be an equal opportunity workforce. At Aon, we believe a diverse workforce is an innovative workforce. Our agile, inclusive environment allows colleagues to manage their wellbeing and work/life balance while empowering you to be your authentic self.

Furthermore, all colleagues enjoy two Global Wellbeing Days each year, encouraging them to take time to focus on themselves. We offer a variety of workstyle options through our Smart Working model, but we also recognize that flexibility goes beyond just the place of work... and we are all for it!

Our continuous learning culture inspires and equips colleagues to learn, share and grow, helping them achieve their fullest potential. As a result, Aon colleagues are more connected, more relevant and more valued.

COMMITMENT TO SUSTAINABILITY

Aon is dedicated to integrating sustainability into our core business practices. We strive to minimize our environmental impact through innovative solutions and responsible stewardship, ensuring a sustainable future for our clients and communities

#LI-SN1