Audit Data Analytical Specialist

Job Title: Audit Data Analytical Specialist

Client: Metrolinx

Location: Toronto, Ontario

Work Model: Up to 3 days onsite (subject to HM's discretion)

Duration: 6 Months

Submission Deadline: July 15, 2026, 12pm

Must Haves

• 5 years experience - Proficiency in Excel, SQL, and Python for querying, manipulating, validating, and analyzing data.
• 5 years experience and skill with preparing analyses, summaries, memos, and reports using computer applications including Power-BI, Databricks, and MS suite.
• 5 years experience - Analyze large and complex datasets to identify trends, anomalies, and potential control gaps.

Description / Responsibilities / Skills

Description

• This role conducts independent, objective, and constructive assessments of the adequacy and effectiveness of management's processes to identify and mitigate significant risks across Metrolinx in accordance.
• Follows the standards of the Institute of Internal Auditors (IIA), the internal audit profession's industry best practices, and the Internal Audit Charter.
• Responsible for leading the Audit Analytics function within the Audit Regulatory Compliance and Control (ARCC) department to organize, review, and present insights on available datasets within the internal audit framework.
• The role will support the establishment of repeatable analytical models and approaches for audit engagement in coordination with audit managers.
• This role will also work with existing client groups within Metrolinx to leverage these audit analytics into control monitoring and improvements.

What will I be doing?

• Support the technical design and execution of data analytics to enhance audit scoping, testing, monitoring and reporting.
• Apply automation, AI, and data analytics to enhance audit processes to improve efficiency, assess risks and controls, and provide better audit insights.
• Present complex data findings in a clear and compelling manner using data visualization tools and dashboards.
• Continuously develop and maintain scalable and reusable analytics that enhance fraud detection and control testing.
• Analyze large and complex datasets to identify trends, anomalies, and potential control gaps.
• Review source data for quality issues, inconsistencies, and anomalies, and work with audit teams and business leads to resolve gaps or limitations.

What Skills and Qualifications Do I Need?

• Completion of a degree in Mathematics and Statistics, Business Administration, Accounting, Information Technology, or a related discipline.
• Demonstrated progressive experience conducting internal audits or data analysis, or a comparable combination of progressive experience in internal and external risk management or audit.
• Continuing Education in auditing, project management, technology and / or construction is required.
• Experience and skill with preparing analyses, summaries, memos, and reports using computer applications including PowerBI, Databricks, or SAS is a requirement.
• Proficiency in SQL and Python for querying, manipulating, validating, and analyzing data.

Must Haves

• 5 years experience - Proficiency in Excel, SQL, and Python for querying, manipulating, validating, and analyzing data.
• 5 years experience and skill with preparing analyses, summaries, memos, and reports using computer applications including Power-BI, Databricks, and MS suite.
• 5 years experience - Analyze large and complex datasets to identify trends, anomalies, and potential control gaps.

Experience & Skill Set Requirements

Must Haves

• 5 years experience - Proficiency in Excel, SQL, and Python for querying, manipulating, validating, and analyzing data.
• 5 years experience and skill with preparing analyses, summaries, memos, and reports using computer applications including Power-BI, Databricks, and MS suite.
• 5 years experience - Analyze large and complex datasets to identify trends, anomalies, and potential control gaps.

What Skills and Qualifications Do I Need?

• Completion of a degree in Mathematics and Statistics, Business Administration, Accounting, Information Technology, or a related discipline
• Demonstrated progressive experience conducting internal audits or data analysis, or a comparable combination of progressive experience
• Continuing Education in auditing, project management, technology and / or construction is required
• Relevant designations are expected with priority given to auditing designations
• Experience and skill with preparing analyses, summaries, memos, and reports using computer applications including PowerBI, Databricks, or SAS is a requirement.
• Proficiency in SQL and Python for querying, manipulating, validating, and analyzing data.