Manager - Internal Audit
- Gurgaon, Haryana
- Permanent
- Full-time
- Be experienced in tools and systems on SQL Complex Queries, including Oracle, MS Sql Server and TSQL, ACL, MS Excel
- 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
- 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
- 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.
- Provide timely and periodical update to Senior Leadership Team
- 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
- Senior Management (Functional leaders / SLTs) including CRO / CCO
- Cross functional teams
- Process Owners
- Team members including specialized staff (3-4 team members)
- 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
- 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.
- Be experienced in tools and systems on SQL Complex Queries, including Oracle, MS Sql Server and TSQL, ACL, MS Excel
- 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
- 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
- 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.
- Provide timely and periodical update to Senior Leadership Team
- 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
- Senior Management (Functional leaders / SLTs) including CRO / CCO
- Cross functional teams
- Process Owners
- Team members including specialized staff (3-4 team members)
- 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
- 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.