*Field*
*Description*
Job Title
IND Team Member-BI
Line of Business
India Benefits/Ops & Quality BG
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%
· 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
· 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
Formal Education/Certification
Graduate in B.A/B.Com./BBA/BCA/B.Sc(IT)/ B.Tech
No MCA/BCA/B.E/ B.Ed
No Full Time MBA
Knowledge and Experience*
0-3 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.
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
**Title:** *IND Team Member-BI*
**Location:** *India-MH-Navi Mumbai-Navi Mumbai/Vishwaroop IT Park*
**Requisition ID:** *2412622*