Data Engineer

Aon Corporation; Bengaluru; On-site; INR 1,500,000 - 2,600,000; Full time

Benefits offered by this job

Global Wellbeing Days

Smart Working

Job summary

Aon is seeking a Data Engineer in Bangalore to join a hybrid-structured role focusing on data lakehouse architecture and modern cloud data stacks. You will work in a cross-functional Agile team to deliver scalable data workloads, build ETL pipelines, and optimize data performance for BI/Analytics across multiple regions.

The role requires 7+ years in data engineering, a STEM degree, and hands-on experience with Python, Spark/Scala, Databricks, and SQL.

Qualifications

• Bachelor’s or Master’s degree in a STEM field.
• 7+ years of relevant experience in data engineering.
• Experience with modern cloud-based data stacks.
• Strong SQL and data modeling capabilities.
• Hands-on with data lakehouse architectures and Databricks.

Responsibilities

• Deliver enterprise-scale data workloads in a lakehouse architecture.
• Build and maintain data pipelines (ETL) across diverse sources.
• Design scalable data workloads that meet performance targets.
• Ensure data quality and integrity throughout migration.
• Document data processes and support observability.

Skills

Python

Spark/Scala

SQL

ETL

Lakehouse

Databricks

Data pipelines

Education

Any Graduate or Post-Graduate (full time)

Tools

Azure Repos

GitLab

Azure DevOps

Jira

Confluence

Job description

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 – 7 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 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.