Data Engineer

Job Title - Data Engineer

Position type- Full Time

Work Location- Bangalore

Working style- Hybrid

Cab Facility- Yes

Shift Time - 12:00 PM - 9:00 PM IST time

People Manager role: No

Required education and certifications critical for the role- Any Graduate or Post-Graduate (full time)

Required years of experience - 7years 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 committed as one firm to our purpose, united through trust as one inclusive, diverse team and we are passionate about helping our colleagues and clients succeed.

GENERAL DESCRIPTION OF ROLE:

Aon has transitioned to a product-oriented model and is investing in capabilities like never before. This role will give the chosen candidate a unique opportunity to shape the product and data delivery model for our Commercial Risk Ecosystem to drive significant revenue and efficiency opportunities across all countries where Aon operates.

JOB RESPONSIBILITIES:

This role will provide the candidate an opportunity to deliver enterprise-scale data workloads following a data lakehouse architecture on a modern cloud-based data stack for our new Commercial Risk Solutions Ecosystem. These data workloads represent strategic feeds to support our BI/Analytics solutions that are essential to the value proposition of our ecosystem. Responsibilities of this role include:

1. Cross-functional Team: Work within a cross-functional Agile team alongside Product Owner, Data Architect and Data Analysts to deliver on release goals for a global program
2. Data Workload Design: Design scalable and efficient data workloads architectures that integrate our transactional systems with a new lakehouse data model.
3. Data Integration: Develop, test and maintain data pipelines (ETL) for integrating diverse data sources into a unified format embedding best practices and standards.
4. Data Management: Manage and optimize data to ensure efficient data storage, retrieval, and processing.
5. Data Quality Management: Implement automated data quality checks and ensure data integrity throughout the migration process.
6. Documentation: Create and maintain comprehensive documentation for data processes, ensuring knowledge transfer, observability and supportability.
7. Performance Monitoring: Monitor and optimize data performance to meet defined service-level agreements.
8. Troubleshooting: Identify and resolve data-related issues in a timely manner, collaborating with relevant teams.

SKILLS/COMPETENCIES REQUIRED:

• Advanced Technical Skills:
  • In-depth knowledge in programming languages such as Python incl. Spark/Scala.
  • Experience with ETL tools and lakehouse architectures (3+years) through Databricks, Apache SparkSql and similar
  • Strong SQL skills for data manipulation and querying
  • Pipeline efficiency optimization skills
• Hands on experience with Agile technical practices, source versioning and Agile project management tools (Azure Repos, GitLab, Azure DevOps, Jira, Confluence, other)
• Database Knowledge: Familiarity with relational and non-relational databases (Oracle, MSSQLServer).
• Agile planning skills - Kanban and Scrum release/sprint planning.
• Problem-Solving: Proven ability to solve complex data engineering challenges and optimize system performance.
• Good communication and interpersonal skills to collaborate effectively with team members and stakeholders
• College degree in STEM-related discipline.

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.

#LI-RK2