IT - Data Analyst

Job Title:IT - Data Analyst

ARL-7.1

Position type-Full Time

Work Location-Bangalore, Whitefield

Working style-Hybrid

Cab Facility-Yes

Shift Time - 12:00 pm IST to 9:00 PM IST

People Manager role:No

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

Required years of experience - 3-4 year's 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:

We are seeking for a highly experienced IT Data Analyst to join our team, bringing expertise in data analysis with proven track of record working on large data related projects. Successful candidate will collaborate with project lead, business stakeholders and multi-functional team of data analysts & data engineers responsible for delivering Data Migration initiatives leveraging a modern lakehouse architecture for our new Commercial Risk Solutions Ecosystem.

Job responsibilities:

• Lead data analysis, collaborate with cross-functional team, business stakeholders and SME's to understand data delivery requirements and business context of the data
• Actively assist team with data analysis activities at each stage of data delivery process.
• Analyze source systems and underlying database, develop source to target data mappings
• Develop and document data extraction and transformation scripts/queries to support ETL processes to migrate data between systems
• Support development of data quality testing framework by defining data quality rules, perform source to target data reconciliation to validate accuracy & integrity of migrated data
• Coordinate with Project and Delivery Lead to address technical challenges, solve issues to ensure seamless execution of the roadmap
• Contribute to development of the data analyst playbook, embedding best practices and standards
• Participate in agile ceremonies, providing regular updates on technical progress and addressing potential risks
• Perform data validation and comparison to ensure the accuracy of migrated data.
• Develop and implement advanced reporting solutions utilizing Power BI to deliver insightful data visualizations and support strategic decision-making.

Skills/competencies required:

• Bachelor's or Master's Degree or equivalent experience in Computer Science, Information Technology or related fields
• Proven experience (5+ years) as a Data Analyst or similar role in data related projects, working in insurance/finance industry in large multinational environment would be an asset
• In-depth knowledge of data migration concepts, ETL processes and database management systems
• Proficiency in SQL(advanced joins, aggregations, functions, query optimization), Python and PySpark for complex data extraction and transformation
• Experience with data visualization tools (eg. Power BI) incl. strong skills in DAX, Power Query and effective visualization techniques
• Hands on experience with agile practices and agile project management tools (eg. Jira, Confluence, Azure DevOps Boards)
• Engage cross-functionally with ETL, Data Engineering, and business stakeholders to ensure insight driven solution delivery.
• Knowledge on data management principles, data profiling and quality management, compliance standards
• Deep understanding of the commercial environment related to the data, detail oriented, excellent problem solving skills
• Excellent communication and interpersonal skills to collaborate effectively with team members and stakeholders
• Ability to work in fast-paced environment and adapt to changing project requirements
• Fluency in English (written & spoken) is required
• Understanding of insurance context would be an asset.

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-cs1