Manager - Internal Audit

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.

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.