RQ00209 Int. Data Analytical SpecialistScientist

RQ00209 - Int. Data Analytical Specialist/Scientist

6-month contract (130 business days) - possible extension

Up to 3 days onsite (subject to HMs 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 Torontos 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 managements processes to identify and mitigate significant risks across Metrolinx in accordance. Follows the standards of the Institute of Internal Auditors (IIA) the internal audit professions 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 StatisticsBusiness Administration Accounting Information Technologyor 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

Employment Type : Full Time
Experience: years
Vacancy: 1