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 Technology OR successful 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

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.