Data Analyst

**Posting Number**:TC**-25-08**

**Job Type**:Temporary Full-time, Up to 2 Years, Union**

**Salary Range**:$69,050.80 to $82,755.40 per year**

**Location**:Barrie, ON - Hybrid**(see below for more details)

**Posted**:Tuesday, January 28, 2025**

**Application Deadline**:**Tuesday, February 11, 2025 at 11:59 pm**

**The Opportunity**

Reporting to the Supervisor of Data & Analytics, the Data Analyst position is responsible for the design and implementation of internal reporting structures (dashboards, reports, metrics, toolkits, templates, solutions, etc) to measure progress and enable key program areas to achieve strategic outcomes. This position owns the methodology and dashboard process to effectively identify, monitor, and report on critical metrics to evaluate these initiatives. Overall, this position plays an integral role in determining data requirements, appropriate analytic methods for use of data and reporting to support information sharing for decision making and funding allocation.

**Our Culture and Qualifications of the Job**

**Corporate Culture**:Your workplace values align with our corporate values of **_Strive, Share and Care_** and you want to join us in providing exceptional services and programs to build a prosperous, growing and sustainable community.
- Equally important to what we do is _how_ we do it - your actions reflect our core accountabilities of **_Personal Awareness, Teamwork and Collaboration, Respect and Inclusion, Innovation, _**and **_Service Excellence, _**which define how we work together to succeed.

**Education**(degree/diploma/certifications)
- Four (4) year University Degree in Data Science and/or Data Analytics or a related discipline
- Position Equivalency Code: F

**Experience**
- Five (5) years of experience performing duties related to the major responsibilities of the position
- Demonstrated experience in a data analytics environment, supporting and managing data solutions/data warehouses/lakes and business systems using visualization tools and related technologies
- Demonstrated experience managing vendor relationships and achieving desired performance outcomes while maintaining a positive working relationship
- Demonstrated experience with Data Visualization tools such as Power BI, Power BI Service, Microsoft Business Intelligence platform (SSIS,SSAS) or equivalent

**Knowledge/Skill/Ability**
- Working knowledge of Data Visualization, Business Intelligence practices, data modelling, analyzing and reporting techniques
- Demonstrated ability to:

- perform in a manner which is consistent with corporate goals, vision, mission, and values
- align branch programs/services with departmental and corporate goals and objectives
- think and act strategically, identify complex problems, develop and evaluate options, and implement solutions utilizing reason, judgment, and prescribed resources
- motivate and build staff teams and collaborative working relationships with both internal and external groups
- Intermediate skills include: Analytical; Facilitation; Interpersonal; Presentation; Problem Solving; Project Management; Time Management; Troubleshooting; Verbal and Written Communication
- Basic computer literacy using Microsoft Office software products associated with word processing, spreadsheets, and presentations
- Intermediate computer literacy using Power BI, Database software including Microsoft SQL and related components (SQL Management Studio, Analysis Services, Reporting Services, Azure, Microsoft Fabric), Transact-SQL (T-SQL), Microsoft Visual Studio
- Availability on a rotational basis to assist with after-hours questions, concerns, or emergencies; to attend evening/weekend meetings or special events; or to work outside of designated normal hours per week

**Conditions of Employment**
- Satisfactory Criminal Record Check*
- Please note that this is a requirement for any new employees to the City of Barrie in accordance with the **Police Record Check Policy**. Existing employees who have met this criteria will be exempt from this requirement.

**Other Important Information**

**Location**: City Hall, 70 Collier Street, Barrie, Ontario*
- Please note that the City has a **Hybrid Work Program Procedure** that may allow a hybrid work arrangement for employees who meet the eligibility requirements.

**Hours**: The normal hours of work are 35 hours per week in accordance with the Collective Agreement.

**Wage**: This position is within the CUPE Local 2380 Bargaining Unit with the following pay level and 2025 pay range:
- Pay Level: Level 7
- Yearly Salary: $69,050.80 to $82,755.40
- Hourly Pay Rate: $37.94 to $45.47

**What We Offer**: This position includes extended health and dental benefits, optional enrollment in the OMERS Primary pension plan, prorated paid sick time based on the expected duration of employment, and prorated vacation time based on calendar year and in accordance with the Employment Standards Act, access to the Employee and Family Assistanc