Reporting to the Manager, Research and Business Intelligence you will play an integral role in the business requirements gathering and BI project execution stages of the various BI projects within Human Services.
You will be responsible for requirements gathering, interpreting, and analyzing information to provide recommendations for improvements to projects, processes, or performance management tools, frameworks, and methodologies.
Evaluate, analyze and identify issues regarding current thinking, technologies, business practices, and programs as it related to Human Services (HS) programs
Process Analysis (understand how current processes work and define the problem)
Develop BI recommendations for process changes and improvements
Conduct Gap Analysis (compare current state versus future state)
Analyze information and provides recommendations to support HS improvements
Determine user requirements and develops a customized solution utilizing advanced BI methodologies
Develop designs for the business tools and processes required in HS
Respond to information requests on behalf of the team
Support team goals and objectives by providing advice, training and/or guidance to staff
Promote and model the Regional Values and principles of the Common Purpose
Build relationships with internal and external stakeholders

Requirements

A satisfactory Level 1 Criminal Record Check obtained directly from a police station (third-party background checks will not be accepted).
College diploma or university degree, with a focus on computer science, statistics, business and/or equivalent experience
A minimum of three years work experience in analytics and BI, Microsoft Power Platform (Power BI, Power Apps, Power Automate), SQL, Python/R.
Knowledge of ETL and data management practices.
Proficiency in all MS Office applications (Visio, Word, Excel, PowerPoint)

Benefits

Comprehensive Health, Dental, Vision benefit plan including psychological health (effective start date)
Automatic enrolment into OMERS pension plan (where applicable)
Accrue Vacation on a monthly basis (where applicable) up to 3 weeks per annum
3 Paid personal days and floating holidays
Flexible hours supporting your wellness and wellbeing
Annual performance review and merit increases based on performance (where applicable)
Supportive leadership and a culture of respect and inclusion
Access to tuition reimbursement (where applicable) and learning and development resources

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

business intelligencerequirements gatheringprocess analysisgap analysisdata managementETLSQLPythonRMicrosoft Power Platform

Soft Skills

communicationrelationship buildingteam supportadvicetrainingguidance

Certifications

Level 1 Criminal Record Check