Job Req ID: 49010

- Location: Pune, Maharashtra, IN

- Function: Other

- About:

- Vodafone Idea Limited is an Aditya Birla Group and Vodafone Group partnership. It is India’s leading telecom service provider. The Company provides pan India Voice and Data services across 2G, 3G and 4G platform. With the large spectrum portfolio to support the growing demand for data and voice, the company is committed to deliver delightful customer experiences and contribute towards creating a truly ‘Digital India’ by enabling millions of citizens to connect and build a better tomorrow. The Company is developing infrastructure to introduce newer and smarter technologies, making both retail and enterprise customers future ready with innovative offerings, conveniently accessible through an ecosystem of digital channels as well as extensive on-ground presence. The Company is listed on National Stock Exchange (NSE) and Bombay Stock Exchange (BSE) in India.

We're proud to be an equal opportunity employer. At VIL, we know that diversity makes us stronger. We are committed to a collaborative, inclusive environment that encourages authenticity and fosters a sense of belonging. We strive for everyone to feel valued, connected and empowered to reach their potential and contribute their best.

VIL's goal is to build and maintain a workforce that is diverse in experience and background but uniform in reflecting our Values of Passion, Boldness, Trust, Speed and Digital. Consequently, our recruiting efforts are directed towards attracting and retaining best and brightest talents. Our endeavour is to be First Choice for prospective employees.

VIL is an equal opportunity employer committed to diversifying its workforce.

Role

Team Member Internal Audit

Job Level/ Designation

M2/ Assistant General Manager

Function / Department





Internal Audit - Data Analytics & Automation

Location

Hinjewadi Pune, Corporate office

Job Purpose

To build and deliver data analytics test cases for internal audit function which would help to increase audit function’s effectiveness and efficiency, help provide to internal audit team for smooth completion of multiple ongoing audits.

Key Result Areas/Accountabilities

Audit analytics - planning - In depth consultation and discussion with Internal Audit team to understand the objective of the audit test scenarios and define the implementation road map for achievement.

- Involvement in multiple ongoing audits to ensure fulfillment and completions of auditor’s requirements.
- Actively participate in all audit commencement discussions; to identify the key focus areas and prepare audit analytics plan and work program

Audit analytics - execution - Ensuring required data availability & accessibility through the data lake or various source systems to evaluate audit test scenarios.

- Ensure that sufficient information is identified, analysed, evaluated and recorded to achieve the audit objectives as per engagement plan.
- Development of various audit(s) analytics test scenarios (transactions & controls) through complex SQL scripting (Database Technologies i.e. DB2, Oracle, Hive etc.), output data validation,



highlighting data quality issues and ensuring accuracy in result accepted by auditors and business users.
- Need to connect, explore, collect, evaluate, analyze and data points from multiple source system. Able to perform cross functional data analysis.
- Maintain DA SQL script banks for further reuse purpose to internal audit team and various business stakeholders.

Audit analytics - quarterly control monitoring - Effectively perform executions of identified controls (SQL Scripts) at agreed frequency, output analysis, comparison with previous audit result and publishing artifacts post consultation with internal audit team.

- Effectively maintain the track of the SQL Scripts which are required for execution and prepare the result sheet as observations
- Participate into the discussion with business on observations
- Discuss on business queries and resolve it

Audit analytics - through visualization - Need a strong competency in design, develop and publish dashboards through visualization tools like - Congnos or Power BI or Tableau etc.

- Represent the analysis with visualization for effectively business consumption and adoption.
- Schedule the dashboard at defined frequency

Audit analytics - through Automation - Automation of SQL Scripts, UNIX scripts.

- Well understanding of Unix scripting for file handlingShell scripting for connecting with different servers for extracting required information for further analysis.
- Must have - Core Competencies, Knowledge and Experience

Must have hands-on knowledge in Data Analytics area with the preferable Telecom functional understanding.

He / She must have technical expertise in -

- Positive understanding of Data warehouse, BI, Data Lake, ETL concepts, Big-data & hive
- Good hands on experience in Alteryx Workflow development.
-

📌 Agm-team Member Internal Audit (Pune)
🏢 Vodafone Idea
📍 Pune