Senior Data Management Strategist

City of Calgary; Calgary; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

The City of Calgary is seeking a Senior Data Management Strategist to lead data analysis, governance, and reporting for Calgary 9-1-1, Transit Public Safety, CEMA and EMS divisions. You will build pipelines, warehouses, models, dashboards and automation to support operational and strategic decision making.

You will translate complex data into clear insights for technical and non-technical audiences, partner with multiple units and external agencies, and deliver data strategy guidance while

Qualifications

• Degree in CS/Math/Stats or related field and 5+ years in data analysis and modeling.
• Experience with Power BI for reporting and dashboards.
• Proficiency in SQL and relational databases.
• Programming skills in Python or R, with basic ML and data manipulation.
• Experience defining KPIs and gathering business requirements.
• Knowledge of emergency management or public safety analytics is a plus.
• Experience developing data strategy and governance frameworks.
• Strong communication, research, analysis, and problem-solving skills.

Responsibilities

• Analyze data for Calgary 9-1-1, Transit Public Safety, CEMA, and EMS groups.
• Design data pipelines, data warehouses, and data models.
• Develop analytical reports and dashboards and automate reporting.
• Apply statistics and ML to forecast workload and resources.
• Ensure data governance, quality, security, metadata and access control.
• Collaborate with business units, IT, vendors and external agencies.
• Translate data into actionable insights for varied audiences.

Skills

Power BI

SQL

Python

R

Data visualization

KPIs & requirements gathering

Communication skills

Education

Bachelor's degree in Computer Science/Mathematics/Statistics or related field

Tools

Power BI Service

Power BI Desktop

DAX Studio

Power Query

SQL best practices

Machine learning basics

Job description

If you are committed to public service, enjoy collaborating with others, share our values and have a desire to learn and grow, join The City of Calgary. City employees deliver the services, run the programs and operate the facilities which make a difference in our community. We support work-life balance, promote physical and psychological safety, and offer competitive wages, pensions, and benefits. Together we make Calgary a great place to make a living, a great place to make a life.

The City is committed to fostering a respectful, inclusive and equitable workplace which is representative of the community we serve. We welcome those who have demonstrated a commitment to upholding the values of equity, diversity, inclusion, anti-racism and reconciliation. Applications are encouraged from members of groups that are historically disadvantaged and underrepresented. Accommodations are available during the hiring process, upon request.

As a Senior Data Management Strategist, you will be responsible for data analysis, performance measurement, and reporting for Calgary 9-1-1, Transit Public Safety (TPS), Calgary Emergency Management Agency (CEMA), and the various Bylaw peace officer groups within Emergency Management and Community Safety (EMCS). You will provide data to contribute to business and Council-led initiatives, support decision making, optimize internal resources, and enhance public safety services for Calgarians. You will collect, cleanse, analyze, interpret, and present data, while building and maintaining data pipelines, data warehouses, data models, dashboards, reports, and automation tools. You will also be responsible for data governance tasks including maintaining business data glossaries, improving data accuracy, classifying data and maintaining access controls. Primary duties include:

• Develop a deep business knowledge of an assigned division, and assume responsibility for enriching their data and reporting solutions.
• Design data pipelines that provide reliable access to information to support operational and strategic decision making.
• Design and maintain data warehouses, data models, and data integration solutions.
• Develop analytical reports and data visualizations to identify historical trends, provide insights, establish why trends occur, measure performance, and support evidence-based decision making.
• Apply statistical methods and machine learning to build predictive analytics to forecast future workload and resourcing requirements.
• Establish and oversee data governance, quality, security, metadata, stewardship, and compliance practices. Ensure adherence to corporate standards, legislation, and best practices for data management.
• Monitor, validate, and optimize data pipelines, reports, models, and analytical systems.
• Translate complex data into clear and actionable insights, recommendations, and presentations tailored to technical and non-technical audiences.
• Partner with business units, leadership, IT, vendors, external agencies and subject matter experts to define business needs and deliver innovative data solutions.
• Provide expert advice and strategic guidance on data strategy, analytics, reporting, solution design, and emerging technologies.

Qualifications

• A degree in Computer Science, Mathematics, Statistics or a related field and at least 5 years of experience in data analysis and modeling using tools such as Power BI.
• The following will be considered preferred assets:
• Proficiency with the Power BI Service including Power BI Desktop, Power BI Report Builder, DAX Studio, and Power Query along with managing the security, refresh schedules, and development cycles inside Workspaces.
• Proficiency in writing SQL queries and knowledge of best practices when dealing with relational databases.
• Proficiency in programming (Python, R, etc.), statistical analysis, data visualization, machine learning algorithms, and data manipulation.
• Experience gathering business requirements, including identifying Key Performance Indicators (KPIs).
• An understanding of emergency management and community safety with experience contributing to business planning, and strategic planning activities.
• Experience developing and supporting a Data Strategy and Data Governance framework.
• Strong communication, research, analysis, and problem-solving skills.

Pre-employment Requirements

• Applicants will be required to complete a written assessment.
• An Enhanced Security Clearance (ESC) will be conducted. The ESC requires applicants to have resided in North America for at least 3 years.
• Successful applicants must provide proof of qualifications.

Workstyle:

This position may be eligible to work from home for at least part of the time as one of several flexible work options available to City employees. These arrangements depend on the operational requirements of the role, employee suitability, and are subject to change based on operational needs and corporate direction.