Job Information
AON IND Intern - Data Analytics & BI in Bengaluru, India
Job Title- Intern: Data Analytics & BI
Work Location- Bangalore, Whitefield
Working style- In Office
Cab Facility- Yes
Shift Time - 12.30 p.m. to 9.30 p.m.
People Manager role: No
Required education and certifications critical for the role-
Any Graduate or Post-Graduate (full time)
Required years of experience –
0-6 months 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.
INFORMATION ABOUT THE BUSINESS
Global Spend Management-Analytics specializes in Data Warehousing and managing large data sets across multiple systems. Based on variety of data the team provides detailed analysis and visibility on Aon’s spend with 3rd Party, Real Estate, Travel, Expense, P2P MIS etc and also support globally on CBA, RFP, Pricing Models and evaluation of suppliers.
GENERAL DESCRIPTION OF ROLE:
Incumbent would be responsible for managing on data ingestion, warehousing, and management. Any failures in data transmission must be addressed in a timely manner and ensure data is updated. To complete end-end activity the candidate must have knowledge on visualization tools lime Power Bi/Tableau.
JOB RESPONSIBILITIES :
Develop/Work with Engineering team on creating codes for daily data upload activity.
Evaluate completeness of data from all sources
Ensure daily and monthly tasks on data Management and Data Enrichment is carried out on time. Validate data accuracy and process
Work with internal teams to understand business goals, existing BI reports, KPIs, raw data sources and clarify visualization requirements
Identify key business metrics measurements and develop ways to represent data in support of measurements
Collaborate on requirement gathering and documentation of key reporting metrics
Develop Tableau dashboards as per business requirement and ensure updates are carried out in a timely manner
Research and reconcile data issues in reporting and provide recommendations to support the rationalization of current reporting inventory and establish future state reporting
Create high quality analytics/reports and translate them into value added decisions
SKILLS/COMPETENCIES REQUIRED
Extremely good to have knowledge on Python, Cloudera Data Sciences Workbench and R to enable Prescriptive Analysis and Forecasting
Must have strong experience in Reporting & Analytics
Must be strong in developing user friendly and interactive dashboards on Tableau, Microsites and Power Bi
Good Knowledge of Trifecta for data wrangling
Good Knowledge of Tableau Prep
Good knowledge on Procure 2 Pay process
Good knowledge of Ariba, Coupa (Data Structure, building reports) integration with other systems
Knowledge of ERP systems like Workday, PeopleSoft and Oracle
Advanced proficiency in Microsoft Office applications including, Word, Excel, PowerPoint and other tools that facilitate the requirements gathering
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.
2546234
Job Title- Intern: Data Analytics & BI
Work Location- Bangalore, Whitefield
Working style- In Office
Cab Facility- Yes
Shift Time - 12.30 p.m. to 9.30 p.m.
People Manager role: No
Required education and certifications critical for the role-
Any Graduate or Post-Graduate (full time)
Required years of experience –
0-6 months 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.
INFORMATION ABOUT THE BUSINESS
Global Spend Management-Analytics specializes in Data Warehousing and managing large data sets across multiple systems. Based on variety of data the team provides detailed analysis and visibility on Aon’s spend with 3rd Party, Real Estate, Travel, Expense, P2P MIS etc and also support globally on CBA, RFP, Pricing Models and evaluation of suppliers.
GENERAL DESCRIPTION OF ROLE:
Incumbent would be responsible for managing on data ingestion, warehousing, and management. Any failures in data transmission must be addressed in a timely manner and ensure data is updated. To complete end-end activity the candidate must have knowledge on visualization tools lime Power Bi/Tableau.
JOB RESPONSIBILITIES :
Develop/Work with Engineering team on creating codes for daily data upload activity.
Evaluate completeness of data from all sources
Ensure daily and monthly tasks on data Management and Data Enrichment is carried out on time. Validate data accuracy and process
Work with internal teams to understand business goals, existing BI reports, KPIs, raw data sources and clarify visualization requirements
Identify key business metrics measurements and develop ways to represent data in support of measurements
Collaborate on requirement gathering and documentation of key reporting metrics
Develop Tableau dashboards as per business requirement and ensure updates are carried out in a timely manner
Research and reconcile data issues in reporting and provide recommendations to support the rationalization of current reporting inventory and establish future state reporting
Create high quality analytics/reports and translate them into value added decisions
SKILLS/COMPETENCIES REQUIRED
Extremely good to have knowledge on Python, Cloudera Data Sciences Workbench and R to enable Prescriptive Analysis and Forecasting
Must have strong experience in Reporting & Analytics
Must be strong in developing user friendly and interactive dashboards on Tableau, Microsites and Power Bi
Good Knowledge of Trifecta for data wrangling
Good Knowledge of Tableau Prep
Good knowledge on Procure 2 Pay process
Good knowledge of Ariba, Coupa (Data Structure, building reports) integration with other systems
Knowledge of ERP systems like Workday, PeopleSoft and Oracle
Advanced proficiency in Microsoft Office applications including, Word, Excel, PowerPoint and other tools that facilitate the requirements gathering
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.
