Data Analytics Specialist - Internal Audit

As a Specialist for Data Analytics, supporting the Internal Audit Department, you will be responsible for building the continuous monitoring as well as working with the relevant internal audit team members to define and generate the analytics best needed for the planned audits. You will also present and support analytics results and conclusions to audit clients when needed.

You will be reporting to the engagement in-charge on assigned engagements with a direct reporting line to the Vice President - Internal Audit.

Your responsibilities include:

• Review the current data analytics, dashboards, and key performance indicators (KPIs) to map out our existing technical capabilities.
• Identify gaps and develop a future-state vision for Internal Audit s continuous monitoring program, recommending specific data analytics platforms, visualization tools, and data infrastructure improvements.
• Work with the audit team and business leaders to translate their requirements into technical specifications for new reports and automated alerts.
• Partner closely with IT, business, risk, and compliance teams to gain access to data sources and create a unified, cross-functional monitoring process.
• Lead the adoption and technical configuration of internal audit s primary data analytics tool, ensuring it is optimized for performance and usability.
• Provide technical training and hands-on support to the audit team, empowering them to leverage data tools and interpret analytical outputs effectively.
• Develop a clear roadmap for building and enhancing the continuous monitoring program, presenting the business case for technology and resource investments.
• Work closely with the IA team and key stakeholders and define key exception reports and continuous monitoring methods to ensure real time reporting for key risk indicators.
• Work closely with first and second lines of defence in the business to ensure that exception and continuous monitoring reports are aligned and establish combined assurance process.
• Data extraction and preparation for internal audit.
• Establish a framework for data extraction for the audit team in an autonomous
• Write and execute complex SQL queries and Python scripts to extract large, diverse datasets from primary sources, including ERPs (SAP, Oracle), cloud platforms (AWS, Azure), and on-premise databases.
• Design, build, and maintain automated ETL (Extract, Transform, Load) pipelines to ensure the timely and reliable flow of data from source systems into our analytics environment.
• Utilize Python libraries (Pandas, NumPy) to perform critical data preparation tasks.
• Handle missing values, correcting data types, and removing duplicates.
• Standardize formats across different data sources.
• Join, merge, and aggregate disparate datasets to create unified views for analysis.
• Implement data validation checks and quality assurance scripts to guarantee the accuracy and reliability of the data used for monitoring.
• Apply analytical techniques to the prepared data to develop key risk indicators, exception reports, and dashboards that provide real-time insights.