Role description

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 creative 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 new 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 (Surat)
🏢 Tata AIA Life
📍 Surat