Manager - Internal Audit
- Axis Max Life
- 7 - 10 years
- Noida, Gurugram
- 5 months 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+ View Contact
Keyskills: Advanced Excel Query Power Bi Alteryx Advance Sql SQL Coding SQL Server Macros Power Query SQL VBA Complex Queries Tsql Queries Dashboards Python
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in