A Position Overview

Position Title

Senior Executive/Assistant Manager– Risk Control Unit

Department

Risk Control Unit

Level / Band

Senior Executive/Assistant Manager

Role Summary:

· Run queries on TALIC data for ad-hoc reporting

· Create & maintain validation rules in SQL server using SSIS package

· Automate manual reporting via innovative solutions using SQL, Python or R Platform

· Conversant in data modeling techniques

· Do Slice & dice on monthly new business to identify & highlight new risk across channels

· Assist in adding & implementing new risk dimensions

- Liaise with IT for current initiatives to mitigate risk
- Assists in identifying risk & create opportunities across departments in operations

B Organizational Relationships

Reports to Direct

Senior Manager (RCU)

Supervises

C Job Dimensions

Geographic Area Covered

PAN -India

Stakeholders Internal

Claims, UW, NB, FIU, IT & other operations department

External

D Key Result Areas

Analytics on new business data & other data sets

· The resource should be able to query data from SQL server, assess & analyze data to provide insights that help the organization in managing risk & identify new opportunities

Innovate & automate reports for process control & risk identification





· The resource should be able to provide innovative solutions to automate daily reports, build tools for ad-hoc reporting

Maintain department Database

· The resource should be able to assist in managing department database used for daily, weekly & monthly reporting

Dashboards & PPT

· Resource should be able to create dashboards using data visualization tools & make ppt which helps in clear identification of Risk & mitigation of the same

E Skills Required

Technical

· Comfortable with large data,

· Knowledge of excel, access, My SQL, Python & R

· Knowledge of operating data visualization tools like Power BI/Tableau/Qlik view etc

· Basic PPT Skills required

· Insurance background is non-mandatory

· Communication skill

Behavioral (Refer Appendix for details)

Level 1

(rarely / not required)

Level 2

(required frequently)

Level 3

(essential for position)

Interpersonal skills



Communication skills



Creative thinking skills



Supervising/Leadership skills



Teamwork Skills



Influencing skills



Relationship Building skills



Decision making skills



Incumbent Characteristics

Essential

Qualification

Graduate

Experience

At least 1-4 years relevant experience.

📌 Assistant Manager - Field Investigation Unit (Gurugram)
🏢 TATA AIA LIFE INSURANCE
📍 Gurugram