2013-08-14

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

Show more