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)
Well developed analytical, problem solving, research and data analysis skills
Familiarity with public sector issues and challenges
Understanding of Business Analysis industry best practices and applications
Experience with requirements gathering and documentation
Familiarity with business case development
Knowledge of project management principles, practices, techniques, and tools
Knowledge of Organizational Change Management principles
Written skills to prepare reports and information papers for a variety of audiences and verbal skills to exchange and provide information as necessary
Ability to provide specialized guidance and advice for the achievement of department’s goals and objectives
Experience with process analysis and documentation, tools and techniques
Strong communication, negotiation, consultation, facilitation, and conflict resolution skills
Interpersonal skills for effective liaison with other staff, divisions, departments, and the public
Effective time management skills, ability to work independently with minimal direction and the ability to meet strict deadlines
Committed customer service focus
Demonstrated critical thinking skills
Demonstrate a commitment to diversity, equity, and inclusion through continuous development, modeling inclusive behaviors, and proactively managing bias.

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 gatheringdata analysisSQLPythonRETLMicrosoft Power Platformprocess analysisgap analysis

Soft Skills

analytical skillsproblem solvingcommunication skillsinterpersonal skillstime managementcritical thinkingnegotiation skillsconsultation skillsfacilitation skillsconflict resolution

Certifications

Level 1 Criminal Record Check