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 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 opportunitiesInnovate & 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 reportingMaintain department Database
. The resource should be able to assist in managing department database used for daily, weekly & monthly reportingDashboards & PPT
. Resource should be able to create dashboards using data visualization tools & make ppt which helps in clear identification of Risk & mitigation of the sameE 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 skillBehavioral (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.
Skills Required
Sql, Access, Ssis, Python, Excel