Assistant Manager - Field Investigation Unit
- SSIS
- SQL
- Python
- Data Modeling
- Data Visualization
- Excel
- Power BI
- Tableau
- Qlik
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. |
Assistant Manager - Field Investigation Unit · Tata AIA Life Insurance