Job Description

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.

foundit