Assistant Manager - Field Investigation Unit

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 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.