Analyst, Research – Business Intelligence

Role Overview

• 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.

Tech Stack

• ETL
• Python
• SQL

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