Job 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:
xc2xb7 Run queries on TALIC data for ad-hoc reporting
xc2xb7 Create & maintain validation rules in SQL server using SSIS package
xc2xb7 Automate manual reporting via innovative solutions using SQL, Python or R Platform
xc2xb7 Conversant in data modeling techniques
xc2xb7 Do Slice & dice on monthly new business to identify & highlight new risk across channels
xc2xb7 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
xc2xb7 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
xc2xb7 The resource should be able to provide innovative solutions to automate daily reports, build tools for ad-hoc reporting
Maintain department Database
xc2xb7 The resource should be able to assist in managing department database used for daily, weekly & monthly reporting
Dashboards & PPT
xc2xb7 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
xc2xb7 Comfortable with large data,
xc2xb7 Knowledge of excel, access, My SQL, Python & R
xc2xb7 Knowledge of operating data visualization tools like Power BI/Tableau/Qlik view etc
xc2xb7 Basic PPT Skills required
xc2xb7 Insurance background is non-mandatory
xc2xb7 Communication skill
Behavioral (Refer Appendix for details)
Level 1
(rarely / not required)
Level 2
(required frequently)
Level 3
(essential for position)
Interpersonal skills
xefx83xbc
Communication skills
xefx83xbc
Creative thinking skills
xefx83xbc
Supervising/Leadership skills
xefx83xbc
Teamwork Skills
xefx83xbc
Influencing skills
xefx83xbc
Relationship Building skills
xefx83xbc
Decision making skills
xefx83xbc
Incumbent Characteristics
Essential
Qualification
Graduate
Experience
At least 1-4 years relevant experience.
About Company:
Tata AIA Life Insurance Company Limited (Tata AIA Life) is a joint venture company, formed by Tata Sons Pvt. Ltd. and AIA Group Ltd. (AIA). Tata AIA Life combines Tatas pre-eminent leadership position in India and AIAs presence as the largest, independent listed pan-Asian life insurance group in the world spanning 18 markets in the Asia Pacific region. Tata AIA Life has written retail new business weighted premium of Rs. 2,692 crore for the financial year 2019-20. For the same period, the 13th month persistency of the company was at 89.10% and, the individual death claims settlement ratio was 99.06%. One of the fastest growing companies in the Life Insurance sector, Tata AIA Life is now ranked at no. 5, based on individual weighted new business premium.