Division: Strategy and Transformation

Department: Digital Technology

Term: 2 Permanent Full Time positions available.

Closing Date: 03/18/2026

Labour Group: CUPE 59

Posting: 4932

Job Summary

This position designs, develops, and supports the City’s data and analytics environment to ensure reliable, high-quality data for enterprise reporting and decision-making. The role translates business requirements into data models, integration processes, and analytics solutions while supporting corporate data governance and standards.

Duties & Responsibilities

• Ensures the stability, reliability, and quality of organizational data through proactive data platform monitoring, database support, and lifecycle management.
• Works with business units to understand key performance indicators (KPIs) and translates requirements into data structures, metrics, and semantic models that support accurate and consistent performance measurement.
• Profiles and analyzes data sources to determine integration requirements and assess suitability for enterprise analytics and reporting.
• Designs, develops, and maintains dimensional and semantic data models, including star schemas, semantic layers, and Microsoft Fabric models.
• Develops, maintains, and supports Extract, Transform, Load/Extract, Load, Transform (ETL/ELT) data integration processes for both on-premises and cloud platforms.
• Supports and enhances the City’s analytics ecosystem, including Microsoft Fabric (Lakehouse, Warehouse, OneLake, Data Pipelines, Semantic Models), Azure Data Factory, and Microsoft Power BI.
• Prepares test data and validates new or modified systems, data pipelines, jobs, and analytics processes to ensure accuracy and completeness.
• Prepares and updates system, data model, program, and operational documentation in accordance with corporate standards.
• Responds to and resolves issues related to analytics systems, data pipelines, and production failures.
• Participates in assigned data, analytics, and technology projects, contributing technical expertise in modelling, integration, and analytics.
• Maintains current knowledge of analytics technologies, modelling practices, standards, and IT trends.
• Provides training, advice, and technical guidance to staff on data modelling, analytics tools, and reporting solutions.
• Contributes to the development and application of corporate data management practices, modelling standards, metadata management, and data governance initiatives.
• Performs other related duties as assigned.

Qualifications

Education, Training and Experience Requirements

• Degree in computer science plus four years' progressively responsible experience in Information TechnologyORsuccessful completion of a two-year, post-secondary computer technology or business systems program or Data Analyst designation from an institution plus six years' progressively responsible experience in Information Technology.

• Educational and experience equivalences will be considered.

• Possession of a valid Saskatchewan Class 5 Driver's Licence.

• Current driver’s abstract from SGI demonstrating a safe driving record.

Knowledge, Abilities and Skills

• Experience with dimensional modelling, semantic modelling, and enterprise data model design.
• Experience developing datasets, semantic models, and reports/dashboards in Microsoft Fabric and Power BI.
• Experience working with data lakes and lakehouses, including ingestion patterns, folder structures, and governance practices.
• Experience with SQL, DAX, Power Query (M), and modern data transformation tools.
• ETL/ELT development experience.
• Experience with Office 365, Azure data services, and cloud-based analytics platforms.
• Ability to establish and maintain effective working relationships.
• Strong oral and written communication skills, including presentation skills.
• Strong customer service skills and the ability to interact tactfully with stakeholders.
• Skill in critical thinking and problem solving.

Requires Security Check

Acceptable current Criminal Record Check (CRC) upon offer of employment.

Additional Requirements

Evening work and call-backs may be involved.
Stand-by is mandatory for designated employees when required. The employee must report to work immediately and be fit for duty.

**Weekly Hours:**36.67

Salary Range:$85,754.16 to $89,817.84 CADper annum(2026 rates)

Diversity, Equity and Inclusion

The City of Saskatoon offers an inclusive workplace that embraces diverse backgrounds. As an equity partner with the Saskatchewan Human Rights Commission (SHRC), the City commits to diversity, equity and inclusion in our workplaces. By having our workforce reflect the community we serve, we support the realization of miyo-pimatisiwin, (me-o-pi-ma-ti-si-win) “the good life”, for all residents. To learn more about Diversity, Equity and Inclusion at the City, please visit Saskatoon.ca/diversity

Accommodation

The City of Saskatoon strives to provide an accessible and inclusive workplace for all, including throughout the application and selection process through reasonable access and accommodations. Should you require accommodation through any stage of the recruitment process, please email talentacquisition@saskatoon.ca.

While we appreciate all applications we receive, only candidates under consideration will be contacted.

Our Recruitment Process: Application > Posting Closes > Resume Review > Pre-screen/Interview > Offer > Pre-Employment Conditions > Welcome to the City