Strategy Systems Analyst (Strategic Planning Analyst II)

City Of Edmonton; Edmonton; On-site; CAD 91,000 - 115,000; Full time

Job summary

The City of Edmonton is seeking a Strategic Systems Analyst to join the Mobility Infrastructure Services (MIS) and help translate field operations data into actionable insights. You will build ETL pipelines, mobile data collection apps, and interactive dashboards to support frontline crews and leadership.

You will design and maintain KPI registries, align metrics with enterprise goals, and collaborate with IT governance and data governance teams to ensure scalable solutions.

Qualifications

• University degree in Computer Science, Computer Engineering, Software Engineering, Statistics, or a related Engineering/CS field.
• Minimum of five (5) years of experience in business software development, business intelligence analysis, statistics, or software project management.
• Experience with ETL design, data governance, and dashboards.

Responsibilities

• Design, deploy, and maintain interactive dashboards using Tableau, Power BI, and Looker Studio.
• Support the MIS Performance Management Framework and KPI registries.
• Design data pipelines and integrations for diverse data sources.
• Develop mobile data collection apps and web interfaces (AppSheet, ArcGIS).
• Respond to information requests from stakeholders and produce data stories.

Skills

AppsScript

Python

JavaScript

SQL

BigQuery

ERP integration (SAP)

Education

University degree in Computer Science/Engineering/Statistics

Tools

Tableau

Power BI

Google Looker Studio

Google AppSheet

ArcGIS Pro/Online

Job description

Job Number: 55941Are you a tech-savvy data professional who thrives on translating complex operational data into actionable insights? The Mobility Infrastructure Services (MIS) section within the Parks and Roads Services branch is seeking a collaborative Strategic Systems Analyst to join our Business Performance and Analytics (BPA) Team.Reporting to the Supervisor, Business Performance and Analytics, the Strategic Systems Analyst serves as an embedded technical and analytical partner supporting the Mobility Infrastructure Operations (MIO) unit—including Snow and Ice Control, Spring Sweep, and Reactive Sanitation programs—with additional support across Mobility Infrastructure Services (MIS) priorities as directed.In this dynamic role, you will bridge the gap between complex field operations and enterprise IT systems. You will design, build, and maintain automated ETL data pipelines, custom mobile field applications, and interactive visual dashboards in Tableau. By working directly alongside frontline crews and section leadership, you will translate raw operational data into clear, actionable "Data Stories" and robust KPI frameworks that drive data-informed decision-making across the City.If you are passionate about business intelligence, data governance, data visualization, continuous improvement, and helping the team thrive, we encourage you to apply!What will you do?Design, deploy, and maintain interactive, responsive dashboards using Tableau, Power BI, and Google Looker Studio aligned with the MIS Reporting FrameworkSupport the implementation of the MIS Performance Management Framework and build Enterprise Performance Measures aligned with corporate, branch, and section goalsMaintain KPI registries for the assigned MIO portfolio, analyze system data, and define operational baselines against unit KPIs and service levelsDesign integrations for data pipelines, ensuring that the data sourced from an array of databases or systems is efficiently gathered and stored within the City of Edmonton's agreed databaseDevelop and configure custom operational tools, web interfaces, and mobile data collection apps using AppSheet, Google Apps Script, ESRI Field Maps, and ArcGIS QuickCaptureUse existing, corporate-approved software to address operational demands and may need to work collaboratively with the Service Innovation and Performance (SIP) team or the Department Strategy Section (DSS) to build solutions that assist in the collection, storage, evaluation, and reporting of informationRespond to routine and ad hoc requests for information from a variety of stakeholdersTurn operational data into clear insights and establish reliable, automated reporting processesAct as a technical support, addressing and rectifying issues related to the analytical and operational software/programming tools designed by the Business Performance and Analytics team and used by the Mobility Infrastructure Operations unitQualifications:University degree in Computer Science, Computer Engineering, Software Engineering, Statistics, or a related Engineering/Computer Science fieldMinimum of five (5) years of experience in business software development, business intelligence analysis, statistics, or software project managementAssets:Supporting education or professional training in software development, IT systems, process improvement, or business analyticsProject Management Professional (PMP) designation and/or Change Management certificationSkills required for success:Scripting & Database Engineering: Strong proficiency in AppsScript, Python, JavaScript, C++, SQL, FME, GCP (BigQuery), and ERP integration concepts (e.g., SAP / SAP S/4 HANA)BI & Dashboard Development: Expert-level mastery of Tableau, Power BI, Google Looker Studio, Google AppSheet, and Google SheetsAnalytics & Data Storytelling: Advanced ability in complex data modeling, data cleansing, statistical analysis, and translating data into audience-tailored narrativesBusiness Analysis & IT Governance: Solid expertise in business process modeling, IT architectural standards, data governance, and emerging technology evaluationInterpersonal & Communication Skills: Exceptional ability to build relationships, engage diverse stakeholders (from frontline staff to executive leaders), and balance competing priorities in a public sector environmentTroubleshooting: Ability to troubleshoot systems, conduct solution maintenance, and ensure compliance with IT architectural and security standardsGeospatial & Field Mobility Systems: Working knowledge of ArcGIS Online/Pro, ESRI Field Maps, ArcGIS QuickCapture, and JSON integrations with geodatabasesAlignment to our Cultural Commitments and Leadership Competencies (https://bit.ly/4brRrXm)Embracing a culture of equity, diversity, reconciliation and inclusionWork Environment:Occasional visits to field locations, yards, or operational locations across the city to connect directly with operational teams and field staffThe City of Edmonton values applicants with a diverse range of skills, experiences and competencies, and encourages you to apply. We strive to provide reasonable access and accommodations throughout the recruitment process. To request an accommodation, please contact [e-mail]. Learn more about our benefits https://bit.ly/COEbenefitsUp to 1 temporary full-time for up to 11 monthsHours of Work: 33.75 hours per weekSalary Range: $51.611 - $65.218 (Hourly) $90,925.680 - $114,897.810 (Annually)Recruitment Consultant: AG/SOEdmonton rests in the heart of Treaty Six territory in Alberta and the homelands of the Metis NationClassification Title: Strategic Planning Analyst IIPosting Date: Aug 26, 2026Closing Date: Sept 09, 2026 11:59:00 PM (MDT)Number of Openings (up to): 1 - Temporary Full-timeUnion : CSU 52Department: Parks and RoadsWork Location(s):Central Maintenance Yard - Pavement Office, 10517 - 95 Street Edmonton T5H 2C2