IND Consultant - Data Engineer

Job Title- IND Consultant – Data Engineer Arl- 7 Solution Line- Commercial Risk Position type- Full Time Work Location- Bangalore, Whitefield Working style- In Office Cab Facility- Yes People Manager role: No Required education and certifications critical for the role- Any Graduate or Post-Graduate (full time) Required years of experience – 3+ 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: The Data & Analytics Engineer is a key member of the AUM Insights (AUMI) team, responsible for designing, building and maintaining scalable data pipelines, transformation processes and analytical data assets that support AUM's reporting, analytics and decision-making requirements. The role focuses primarily on data engineering and data platform activities, ensuring data is ingested, transformed, validated and made available for reporting, analytics and operational use. Working across Databricks and related data platforms and technologies, the Data & Analytics Engineer develops and maintains reliable data pipelines, curated datasets and data products that enable business reporting and analytics, while also supporting the delivery of Power BI datasets and dashboards. The role is expected to develop a strong understanding of the AUM data landscape, reporting requirements and key business processes, building high-quality, scalable data solutions that support stakeholders across Underwriting, Operations, Finance and Leadership teams Job responsibilities: Design, develop and maintain scalable data pipelines and transformation processes using Databricks and related technologies. Build, manage and optimise Bronze, Silver and Gold layer datasets to support reporting, analytics and operational use cases. Develop reusable ETL/ELT frameworks, ingestion pipelines and transformation logic for structured and semi-structured data. Configure, schedule and monitor data workflows, ensuring reliable and timely delivery of data products. Implement incremental loading, data orchestration and performance optimisation techniques across data pipelines. Troubleshoot and resolve data pipeline failures, performance bottlenecks and data integrity issues. Contribute to the ongoing development and enhancement of AUM's data platform and engineering capabilities. Develop and maintain analytical data models that support reporting, analytics and business decision-making. Design and maintain curated, reporting-ready datasets for downstream consumption by Power BI and other analytical tools. Implement and maintain data quality controls, validations, reconciliations and exception handling processes. Build and maintain an understanding of data lineage, transformations and metric definitions across the data ecosystem. Support data governance initiatives and promote consistent use of business definitions and reporting standards 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