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:
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.
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 Tata's pre-eminent leadership position in India and AIA's 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.

Skills Required