RQ00209 - Int. Data Analytical Specialist/Scientist

RQ00209 - Int. Data Analytical Specialist/Scientist 6-month contract (130 business days) - possible extension Up to 3 days onsite (subject to HM's discretion) - 20 Bay Street 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. Nice-to-have: Public Sector Experience Job Description: Metrolinx is connecting communities across the Greater Golden Horseshoe. Metrolinx operates GO Transit and UP Express, as well as the PRESTO fare payment system. We are also building new and improved rapid transit, including GO Expansion, Light Rail Transit routes, and major expansions to Toronto's subway system, to get people where they need to go, better, faster and easier. Metrolinx is an agency of the Government of Ontario. At Metrolinx, equity, diversity and inclusion are essential to living our values of serving with passion, thinking forward and playing as a team. 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. In addition, the role will support the establishment of repeatable analytical models and approaches for audit engagement in coordination with audit managers, work with other ARCC functions to further the use of data and analytics, and enhance the value of our analytics deliverables and the insights provided by our work. This role will also work with existing client groups within Metrolinx to leverage these audit analytics into control monitoring and improvements. Responbilities: 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. Support the documentation of analytics processes, logic, methodologies, assumptions, and data sources to ensure transparency, reproducibility, and auditability. Skills and Qualifications: Completion of a degree in Mathematics and Statistics,Business Administration, Accounting, Information Technology,or a related discipline– with a specific specialization in both the technical requirements for data analysis and processing, as well as the training to present these results in a way useful to both business and technical leaders in Metrolinx. Demonstrated progressive experience conducting internal audits or data analysis, or a comparable combination of progressive experience in internal and external risk management or audit (while obtaining relevant professional designation(s)) 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 withpreparing analyses, summaries, memos, and reports usingcomputer applications including PowerBI, Databricks, or SAS is a requirement. Proficiency in SQL and Python for querying, manipulating, validating, and analyzing data. AI Disclaimer: Source Code may use artificial intelligence (AI) tools to assist in certain aspects of its recruiting and business operations. Note: The higher end of the range is intended for absolutely exceptional candidates who meet all must-have requirements and most or all nice-to-have qualifications. The client will evaluate candidates based on both rate expectations and overall skill set when shortlisting. INCORPORATED RATE RANGE (7.25 billable hours per day) $61.60/hr - $66.00/hr Inc. T4 RATE RANGE (7.25 billable hours per day) $49.28/hr - $52.80/hr T4