Manager - Internal Audit
- Axis Max Life
- 7 - 10 years
- Noida, Gurugram
- 4 days ago
- Email to a friend
- Report this job
Job Description
Job Summary:
- Be experienced in tools and systems on SQL Complex Queries, including Oracle, MS SQL Server, TSQL, ACL and Advance Excel using Complex Formula, Python, VBA Coding and BI Tools
- Understand business requirements to set functional and build data model.
- Identify, analyze, 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
- Quickly shape data into reporting and analytics solutions
- Work with management to prioritize business and information needs.
- Deliver on time with high quality.
- Troubleshooting and debugging skills for faster data defect fixing.
- Have knowledge of database fundamentals such as multidimensional database design, relational database design
Role & 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.
- Maintain dashboards and publish data to management
Revenue assurance model and automation in audits
- Preparation of 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
Preferred Candidate Profile:
- B. Tech/ BCA / MCA having more than 6+ years' experience working in Insurance / Finance Industry
- 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 Classification
Industry: InsuranceFunctional Area / Department: Finance & AccountingRole Category: Audit & ControlRole: Audit & Control - OtherEmployement Type: Full timeContact Details:
Company: Axis Max LifeLocation(s): Noida, Gurugram
Keyskills: Advanced Excel Query Power Bi Alteryx Advance Sql SQL Coding SQL Server Macros Power Query SQL VBA Complex Queries Tsql Queries Dashboards Python
Similar positions
Axis Max Life
Axis Max Life Insurance Limited, formerly known as Max Life Insurance Company Ltd., is a joint venture between Max Financial Services Limited (MFSL) and Axis Bank Limited. Axis Max Life Insurance offers comprehensive protection and long-term savings life insurance solutions through its multi-channel...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in