Job Title- IND Consultant: Data Analytics & BI Position type- Full Time 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 – 3-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. 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 and overseeing consolidation and warehousing of large complex data from multiple sources and be required to carry out tasks related to data enrichment and validation. Working Near Real Time data and need to ensure all data transfers are successfully completed on a daily basis. JOB RESPONSIBILITIES: 3 Plus years hands-on experience in developing tableau dashboards using multiple data sources within the DASP data Lake or other similar data visualization tools Eg Power BI Good knowledge of Cloudera Data Sciences Workbench, Microsites and Bigdata Working knowledge of Advanced Excel (dynamic graphs, 3 axis charts, Waterfall chart, etc.) Knowledge on sound knowledge on Procure 2 Pay process and 3rd party spend at category level. Having knowledge of systems like Coupa, Ariba, Workday, PeopleSoft and Oracle will be a huge advantage Expert level knowledge on Tableau, Power BI, Trifecta, Cloudera Data Science Workbench and Excel. Additionally, having knowledge of Impala, Spark and Python will be advantageous. Develop/Work with Engineering team on creating Big Data and SQL codes for daily data upload activity. Ensure daily and monthly tasks of large and multiple data gathering from various sources is carried on a timely manner. Data sources cover PeopleSoft, Workday, Oracle, Ariba Coupa, Amex, Expense etc. Evaluate completeness of data from all sources Ensure data from all sources should be warehoused in Data Analytics Services Platform (DASP) and in SQL where appropriate 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 and stakeholders to understand business goals, existing BI reports, KPIs, raw data sources and clarify visualization requirements / goals 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 Provide support to projects that improve business, supplier spend and business performance. Use of JIRA for Project Management is essential Provide information to stakeholders to help address their business questions Create high quality analytics/reports and translate them into value added decisions Provide training to team members on use of data visualization and dashboard design best practices. Serve as a primary contact for all reporting and data related activities SKILLS/COMPETENCIES REQUIRED: Use of Bigdata, Hadoop, SQL and Sftp for data extraction and Warehousing 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. 2551198