Job Description

:A Position OverviewPosition TitleSenior Executive/Assistant Managerxe2x80x93 Risk Control UnitDepartmentRisk Control UnitLevel / BandSenior Executive/Assistant ManagerRole Summary:xc2xb7 Run queries on TALIC data for ad-hoc reportingxc2xb7 Create & maintain validation rules in SQL server using SSIS packagexc2xb7 Automate manual reporting via innovative solutions using SQL, Python or R Platformxc2xb7 Conversant in data modeling techniquesxc2xb7 Do Slice & dice on monthly new business to identify & highlight new risk across channelsxc2xb7 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 RelationshipsReports to DirectSenior Manager (RCU)SupervisesC Job DimensionsGeographic Area CoveredPAN -IndiaStakeholders InternalClaims, UW, NB, FIU, IT & other operations departmentExternalD Key Result AreasAnalytics on new business data & other data setsxc2xb7 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 identificationxc2xb7 The resource should be able to provide innovative solutions to automate daily reports, build tools for ad-hoc reportingMaintain department Databasexc2xb7 The resource should be able to assist in managing department database used for daily, weekly & monthly reportingDashboards & PPTxc2xb7 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 RequiredTechnicalxc2xb7 Comfortable with large data,xc2xb7 Knowledge of excel, access, My SQL, Python & Rxc2xb7 Knowledge of operating data visualization tools like Power BI/Tableau/Qlik view etcxc2xb7 Basic PPT Skills requiredxc2xb7 Insurance background is non-mandatoryxc2xb7 Communication skillBehavioral (Refer Appendix for details)Level 1(rarely / not required)Level 2(required frequently)Level 3(essential for position)Interpersonal skillsxefx83xbcCommunication skillsxefx83xbcCreative thinking skillsxefx83xbcSupervising/Leadership skillsxefx83xbcTeamwork Skillsxefx83xbcInfluencing skillsxefx83xbcRelationship Building skillsxefx83xbcDecision making skillsxefx83xbcIncumbent CharacteristicsEssentialQualificationGraduateExperienceAt 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 Tataxe2x80x99s pre-eminent leadership position in India and AIAxe2x80x99s 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.

Tata AIA Life Insurance