• Be experienced in tools and systems on SQL Complex Queries, including Oracle, MS Sql Server and TSQL, ACL, MS Excel
using complex formula, Python, VBA Coding and BI Tools
• Understand business requirements to set functional and build data model.
• Identify, analyse, and interpret trends or patterns in complex data sets.
• Develop operational reports and dashboards
• Build automated reports and dashboards with the help of Power BI and other reporting tools
• Be able to quickly shape data into reporting and analytics solutions
• Work with management to prioritize business and information needs.
• Deliver on time with high quality.
• Trouble Shooting and debugging skills for faster data defect fixing.
• Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more
Key Responsibilities
Internal Audit Plan
Develop the automated tools and queries based on annual audit plan and conduct Adhoc reviews based on request from Management / Audit Committee members in a timely manner
Perform data analysis to identify and interpret the trends and patterns in
Collaborate with the teams / stakeholder for better understanding of the business
Create and maintain user friendly documentation of developed queries/automated tool / tests.
Maintenance the Dashboard data and publish to dashboard data to management
Revenue assurance model and automation in audits
Preparation of a comprehensive product and revenue assurance model and ensure quality of reviews, effective reporting of observations and its timely completion and implementation.
Prepare plan for concurrent audit of different types of payouts, functionalities through automation.
Drive automation in selected areas of audit which are of recurring nature and increasing the level of accuracy while reducing the processing timelines.
Active participation and contribute towards assurance reviews as per the requirement of Senior Management and Audit Committee.
Stakeholder Management
Provide timely and periodical update to Senior Leadership Team
Measures of Success
Report exceptions noted during analysis performed on complex data set and provide exception report in a timely manner.
Identify RCA for exceptions noted and highlighted to the management
Ensure quality of output and results of other external audits is in consistent with the automated queries with minimum material differences
Perform automated query for areas identified under Project CARE and Fraudnet analytics
Key Relationships (Internal /External)
Senior Management (Functional leaders / SLTs) including CRO / CCO
Cross functional teams
Process Owners
Team members including specialized staff (3-4 team members)
Key competencies/skills required
Collaboration and Stakeholder Management
Strategic and Analytical mindset
Problem solving ability
Willing to take multiple priorities (multi-tasking)
Growth Mindset
Domain knowledge of Insurance Industry
Negotiation skill
Desired qualification and experience
B. Tech/BCA/ MCA having more than 5-10 years of rich experience working
Insurance/Financial Industry experience
Ability to effectively communicate with external stakeholders and senior management
Technically proficient in handle database sql queries
Experience of participating in cross functional projects and contributing for overall success of project.
Job Description
Position
Manager
Incumbent
Department
Internal Audit
Function
Internal Audit
Reporting to
Chief Manager – Internal Audit
Band
4
Location
Gurgaon
Team size (D/I)
Job Summary
• Be experienced in tools and systems on SQL Complex Queries, including Oracle, MS Sql Server and TSQL, ACL, MS Excel
using complex formula, Python, VBA Coding and BI Tools
• Understand business requirements to set functional and build data model.
• Identify, analyse, and interpret trends or patterns in complex data sets.
• Develop operational reports and dashboards
• Build automated reports and dashboards with the help of Power BI and other reporting tools
• Be able to quickly shape data into reporting and analytics solutions
• Work with management to prioritize business and information needs.
• Deliver on time with high quality.
• Trouble Shooting and debugging skills for faster data defect fixing.
• Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more
Key Responsibilities
Internal Audit Plan
Develop the automated tools and queries based on annual audit plan and conduct Adhoc reviews based on request from Management / Audit Committee members in a timely manner
Perform data analysis to identify and interpret the trends and patterns in
Collaborate with the teams / stakeholder for better understanding of the business
Create and maintain user friendly documentation of developed queries/automated tool / tests.
Maintenance the Dashboard data and publish to dashboard data to management
Revenue assurance model and automation in audits
Preparation of a comprehensive product and revenue assurance model and ensure quality of reviews, effective reporting of observations and its timely completion and implementation.
Prepare plan for concurrent audit of different types of payouts, functionalities through automation.
Drive automation in selected areas of audit which are of recurring nature and increasing the level of accuracy while reducing the processing timelines.
Active participation and contribute towards assurance reviews as per the requirement of Senior Management and Audit Committee.
Stakeholder Management
Provide timely and periodical update to Senior Leadership Team
Measures of Success
Report exceptions noted during analysis performed on complex data set and provide exception report in a timely manner.
Identify RCA for exceptions noted and highlighted to the management
Ensure quality of output and results of other external audits is in consistent with the automated queries with minimum material differences
Perform automated query for areas identified under Project CARE and Fraudnet analytics
Key Relationships (Internal /External)
Senior Management (Functional leaders / SLTs) including CRO / CCO
Cross functional teams
Process Owners
Team members including specialized staff (3-4 team members)
Key competencies/skills required
Collaboration and Stakeholder Management
Strategic and Analytical mindset
Problem solving ability
Willing to take multiple priorities (multi-tasking)
Growth Mindset
Domain knowledge of Insurance Industry
Negotiation skill
Desired qualification and experience
B. Tech/BCA/ MCA having more than 5-10 years of rich experience working
Insurance/Financial Industry experience
Ability to effectively communicate with external stakeholders and senior management
Technically proficient in handle database sql queries
Experience of participating in cross functional projects and contributing for overall success of project.
