Business Intelligence Analyst II

Job Purpose Summary

The Business Intelligence Analyst II, Corporate Audit Services (CAS), is responsible for supporting the Internal Audit function by leveraging data analytics and continuous monitoring to enhance audit efficiency, identify risks, and provide actionable insights for process improvements across the organization’s global operations. This role reports functionally to the Business Intelligence Senior and involves extracting, analyzing, and interpreting data to help audit teams evaluate financial and operational controls worldwide. Common tasks include planning and executing data analytics projects within audits, independently preparing audit documentation (data analysis workpapers, supporting evidence) and draft reports, and effectively communicating findings to Internal Audit leadership with minimal supervision.

Key Responsibilities and Accountabilities

General

• Communicate effectively with internal audit staff, leadership, and IT management across global operations through clear presentations, concise written reports, and strong interpersonal skills.
• Apply a strong understanding of internal audit principles and risk-based audit methodologies in daily responsibilities.
• Translate complex data insights into clear, actionable information for non-technical stakeholders.
• Prepare audit planning documentation, workpapers, supporting evidence, and draft audit reports or memos with minimal supervision.
• Coordinate and lead internal meetings with auditees and global process owners throughout all phases of the audit engagement.
• Ability to work on multiple tasks and manage priorities and workload effectively as part of an agile team.

Analytics & Technical Responsibilities

• Design and implement data-driven audit analytics programs to support risk assessment, risk-based auditing, and continuous monitoring efforts.
• Develop data models, reports, and dashboards to meet audit and business objectives.
• Analyze complex datasets to identify trends, anomalies, and inefficiencies, providing actionable insights to audit teams and senior management (e.g., highlighting potential control gaps or process improvements).
• Build and maintain advanced, repeatable dashboards using modern data visualization tools (with a strong emphasis on Microsoft Power BI) to effectively communicate key audit findings and risk indicators.
• Leverage Power BI Service capabilities for enterprise analytics deployment: publish and refresh datasets, manage dashboards in collaborative workspaces, implement row-level security, and share insights securely with authorized users across the organization.
• Troubleshoot and resolve data or visualization issues (e.g., data anomalies, refresh errors) to ensure accuracy and performance of audit analytics.
• Perform data extraction, cleansing, validation, and transformation from various sources (e.g., ERP systems, databases) to prepare reliable datasets for analysis.
• Ensure data integrity and quality in all analytics activities and ensure compliance with relevant data governance policies and regulations (e.g., data privacy standards).
• Collaborate with Internal Audit teams to define data requirements and identify opportunities for process improvement and audit automation.
• Promote the use of self-service analytics tools among audit teams and contribute to a data-driven culture within Internal Audit.
• Conduct complex ad-hoc analyses and deliver strategic insights to stakeholders as needed.
• Stay current with industry trends and advancements in data analytics and audit technologies (e.g., AI-driven analytics, automation) to continuously enhance the Internal Audit analytics program.

• Maintain high ethical standards in handling sensitive data, while demonstrating strong attention to detail and a commitment to accuracy in analysis and reporting.

People Management & Development

• Adapt working style to meet changing circumstances and team needs.
• Regularly assess personal strengths and areas for growth to enhance contributions to the Internal Audit function.
• Set and pursue performance goals in collaboration with audit management.
• Provide timely, constructive feedback to team members and support their development (e.g., by sharing best practices in audit data analytics).
• Work effectively in a global team, collaborating across different cultures and time zones.
• Engage in professional development opportunities and promote diverse perspectives, demonstrating cultural sensitivity when working in multicultural teams.

Relationship Management

• Foster strong, collaborative relationships with colleagues across global Internal Audit teams, business process owners in multiple regions, and external partners.
• Contribute to a positive, team-oriented work environment by proactively removing barriers and enhancing departmental effectiveness.
• Demonstrate excellent written and verbal communication skills in all interactions.

Job Specifications & Competencies

Critical Competencies

• Build and Share Knowledge
• Communicate Clearly and Effectively
• Possess Business Acumen
• Possess Risk and Process Knowledge

• Critical Thinking

Relevant Areas of Knowledge

The following list of knowledge areas is a broad, representative overview of knowledge and technical skills relevant to this position. It is generally expected that the position would possess or demonstrate basic knowledge in some of the areas listed below.

• IIA International Professional Practices Framework and Code of Ethics
• Risk and control frameworks (e.g., COSO Internal Control, COSO ERM, COBIT, ISO 31000 Risk Management, ISO 27000 Information Security)
• IT infrastructure and operations
• Accounting principles, financial reporting, and related analytical skills
• Data analysis, visualization, and continuous monitoring tools (e.g., Power BI, Tableau)
• Standard business applications (e.g., Microsoft Office, project management tools)
• Artificial intelligence (AI) technologies and applications (e.g., robotic process automation, machine learning, natural language processing, GenAI/ChatGPT)

Specialty Skills/Knowledge

• SQL - Querying databases, joins, aggregations, filtering, subqueries.
• Python - for data transformation (pandas) and visualization (Matplotlib, PyPlot) - is a MUST
• Power BI - expertise in building interactive dashboards and Power BI Service operations (publishing datasets, scheduling refreshes, managing workspaces, and maintaining row-level security) is a MUST.
• Tableau - proficiency in data visualization and dashboard development.
• Statistical knowledge (descriptive, inferential, time series).
• Demonstrated analytical, technical, and auditing skills with exposure to IT and compliance audits.

Qualifications

• A minimum of a bachelor’s degree (BA/BS) in Data Science, Business Intelligence, Finance, Accounting, Computer Science, or a related field is required.
• 3-4 years of experience in executing data analytics programs, preferably including exposure to Internal Audit or risk management analytics.
• Intermediate English proficiency (written and spoken).

Preferred (Optional)

• Professional data analytics or audit/information security certifications (e.g., CIA, CPA, CISA, CISSP, GIAC) are a plus.
• Post-graduate degree (e.g., MBA) is a plus.
• Experience with recognized process improvement methodologies (e.g., Six Sigma, Lean, CMMI) is desirable.
• Experience in a BPO or similar outsourcing/services industry, or exposure to a multi-national corporate environment, is beneficial.