Title: IND Team Member-BI
Location: IND-Haryana-Noida-Noida
Other Locations:
Field
Description
Job Title
IND Team Member-BI
Line of Business
India Benefits/Ops & Quality BG
Level(s)
8
Job Code
005035
Last updated date
Oct 2012
People Management (yes or no)
no
Revenue Scope
N/A
Annual Budget Responsibility
N/A
Overview/High-Level Responsibility Areas
The Team Member BI is responsible to generate ongoing reports which are timely and accurate. The Team member utilizes tools like Excel, Access to process raw data into meaningful information. The Team Member reports to the Manager- BI and keeps his Manager informed on any issues encountered with the data and works to understand the various data sources and their relevance. TM applies that knowledge to deliver reports as per the needs of the stakeholders and follows all guidelines for data sanctity and security.
KRA
• Ongoing Report generation Ensure service accuracy through compliance (TAT)
• Developing Scorecard and Metric calculations.
• High level Automation of reporting initiatives.
• Compliance to Time Entry & MIS
• Maintain documentation of SOPs/Operating Instructions
PRINCIPAL DUTIES AND RESPONSIBILITIES: Please describe the five to seven major duties and responsibilities of your job. Provide as much detail as necessary to give an accurate, complete picture of the job. When duties consume less than 5% of your time, please group them into larger categories instead of listing them individually. Next to each duty or responsibility, indicate the approximate percentage of time you spend performing the duty. Total percentage of time should equal 100%.
Ongoing Report Generation – 60%
Update SOP's – 5%
Team Meetings/ Client Calls – 10%
Data validation/Posting/Business emails – 10%
Work on Projects – 10%
Automations /Audits – 5%
Aon Leadership Model (ALM): Deliver Distinctive Client Value
Deliver measurable impact by leveraging relationships, client/industry knowledge and the Best of Aon” to provide distinctive solutions e.g., Consulting Skills, Selling Skills, Client Knowledge, Client Service
· Ensures work is delivered within the SLA
· Communicate effectively with all other team members
· Understand data sources and systems for Reporting
· Meets TAT defined as per SOP and also maintains the accuracy of work assigned
ALM: Develop Unmatched Teams
Develop and retain unmatched talent and high-performing teams through continuous learning, honest feedback, and rigorous development and disciplined talent management e.g., Adaptability and Flexibility, Coaching and Recognition, Cross-cultural Competence and Collaboration, Developing Self and Others
· Is able to adapt to multiple shifts, urgent requests and manage priorities as per business needs
· Accepts feedback and improves own performance
· Work with Metrics Analyst & communicates effectively both verbal/non verbal keeping cross culture diversity while communicating
· Develop SOP
· Assist Business Analyst - BI in training of new team members
ALM: Build Differentiated Capability Through Innovation
Build sustainable, differentiated capabilities through proven solutions, deep content expertise and focused innovation e.g., Expertise, Capability, Influence
· Understand domain in the area of reporting and understanding of metrics
· Builds domain/technical skills to Identify & support operational improvements
· Communicates appropriately at all levels and follows email etiquettes
ALM: Deliver Business Results With Excellence
Deliver consistent, positive operational results with the best balance of investment and efficiency e.g., Quality Management, Business Acumen, Systems and Processes, Project Management
· Audits own work and follows SOP's
· Understand subject matter
· Understand technical architecture of reporting solutions
· Assesses own proficiency level and time to manage tasks effectively and ensures prompt communication of task completion
ALM: Live Our Values
Act with integrity and work every day in a way that positively impacts our clients, colleagues and communities e.g., Excellence, People, Integrity, Community
· Ensures all reports meet TAT, Accuracy as per SLA
· Treats everyone with respect and dignity; embraces diversity
· Lives by the Aon Code of Conduct
· Contributes to community service
Domain Expertise / Specialization Requirements
Experience into Analytical/Report generation/MIS/Data Analysis domains
Formal Education/Certification
Must Have:
Non computer science graduates with Diploma in computers applications / PGDCA /GNIIT
Good to Have:
BCA, Bsc ( Comp ), Bachelors in Information Technology
Knowledge and Experience*
0-2 years Overall experience both for internal & external applicants
Technical Skills
Must Have
· Excel intermediate, Access ( Intermediate), VBA Basic
Good to Have
·
· Excel Adv , Access ( Adv ), VBA Intermediate, SQL language basic
Good to have experience in
· VBA
· Knowledge of DAO/ADO connectivity from Excel to Access or SQL.
· Should be able to run Insert/Update/Delete commands in Access/SQL data base from Excel interface.
· Should be able to use Access/SQL queries/store procedures from Excel.
· Should be aware of most of the Visual basic components/Controls available in Excel.
· Access/SQL
· Well conversant with how to create tables/queries/Store procedures/Forms/Reports/modules/Macros in Access.
· Should be able to create Excel based reports from Access/SQL server.
· Should be aware of Import/Export utilities in Access/SQL
Work Conditions
· As per business requirements - Working with global and off-shore resources may require flexible work hours.
· Mobility between India locations basis team alignment/meetings
· Participation in training sessions, business management routines in office/offsite