Data Modelling & Analytics Coordinator - City of Saskatoon

AI Summary

The City of Saskatoon is seeking an Information Management Coordinator for Data Modelling and Analytics in Saskatoon, SK. This role focuses on leading the design, development, and governance of corporate data models and analytics frameworks. Key responsibilities include consulting with divisions to identify business needs and integrating data systems for strategic decision-making. Top requirements include a relevant degree and seven to nine years of experience in information services, data modelling, and analytics, including three years in a systems analyst or data architecture role.

About the Role

This permanent full-time Information Management Coordinator position within the City of Saskatoon's Digital Technology Department is crucial for advancing the organisation's data capabilities. The successful candidate will be instrumental in leading the design, development, and robust governance of corporate data models and comprehensive analytics frameworks. This role involves significant consultation across various City divisions, assessing their unique business needs and recommending data-driven solutions that align with strategic objectives. A core aspect of this position is ensuring the seamless integration of diverse data systems and enhancing analytics capabilities to support informed decision-making throughout the City. The focus on effective information management is paramount, contributing directly to the City's transformation strategy. This role offers an exciting opportunity to shape the future of data utilisation within a dynamic public sector environment, applying expertise in data modelling and advanced analytics to real-world challenges.

Key Responsibilities and Expertise

The Information Management Coordinator will actively work with City divisions to thoroughly assess corporate data and analytics requirements, advising on available IT services and data solutions that effectively support business objectives. A primary duty involves leading the meticulous design and documentation of data models, including precise data definitions, critical business rules, relationships, and data flows. This role is also responsible for establishing and maintaining master data management standards and frameworks, collaborating closely with City Clerks to operationalise governance for the Corporate Reporting Process, including intake, prioritisation, progress tracking, and resource allocation. Further collaboration with Data Architects and Data Engineers will focus on data ingestions, ETL processes, and modern platforms like MS Fabric. The position supports advanced analytics initiatives, including predictive modelling and the development of business intelligence dashboards, and is involved in executing the full lifecycle of data-related projects. This includes everything from initial business case development through to planning, execution, and ongoing monitoring. The role also encompasses preparing short- and long-term forecasts for data and analytics initiatives, recruiting, directing, supervising, training, and evaluating assigned staff, fostering a culture of continuous improvement and innovation in data practices, and maintaining current knowledge of emerging technologies and trends in data modelling and analytics. The coordinator will lead the development of policies and procedures specific to data modelling and analytics for the organisation, ensuring alignment with Corporate Data program strategies and goals.

Required Qualifications and Skills

Candidates for this Information Management Coordinator role must possess a degree in computer science, commerce, business administration, or a related discipline. A minimum of seven to nine years of experience in information services, data modelling, and analytics is essential, including at least three years in a systems analyst or data architecture role. The required experience also extends to master data management, analytics concepts, and solutions, alongside practical experience with SQL, ETL tools, and data visualisation platforms such as Power BI or Tableau. Demonstrated experience managing projects and directing resources, preparing and conducting presentations, and leading teams on complex projects independently is also critical. Applicants should exhibit a strong understanding of various data modelling techniques, including conceptual, logical, and physical models. Knowledge of cloud data platforms like Azure, AWS, or GCP, and modern data architectures, including Microsoft Fabric, is highly valued. Furthermore, a solid grasp of organisational management principles and project management methodologies is necessary. Strong communication skills, both oral and written, are required for effectively conveying complex technical information to both technical and non-technical audiences. A security check, including an acceptable current Criminal Record Check, is a condition of employment.