Strategic BI Analyst: Data Dashboards for City Ops

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

Job summary

City of Edmonton seeks a Strategy Systems Analyst to bridge field operations and enterprise IT. You will design, build, and maintain automated ETL data pipelines, custom mobile field apps, and interactive dashboards to translate operational data into actionable data stories and KPI frameworks.

You will partner with frontline crews and leadership to drive data-informed decisions, governance, and continuous improvement within Mobility Infrastructure Services.

Qualifications

• University degree in Computer Science, Computer Engineering, Software Engineering, Statistics, or a related field
• Minimum of five (5) years of experience in business software development, BI analysis, statistics, or software project management

Responsibilities

• Design, deploy, and maintain interactive dashboards using Tableau, Power BI, and Looker Studio aligned with MIS reporting framework
• Support MIS Performance Management Framework and build enterprise performance measures
• Maintain KPI registries, analyze system data, and define baselines against KPIs and service levels
• Design integrations for data pipelines and store data in City of Edmonton databases
• Develop and configure operational tools, web interfaces, and mobile data collection apps using AppSheet, Google Apps Script, ESRI Field Maps, ArcGIS QuickCapture
• Use corporate software to address operational demands and collaborate with SIP and DSS teams when needed
• Respond to routine and ad hoc information requests from stakeholders
• Turn operational data into insights and automate reporting processes
• Provide technical support for analytics and tools used by MIS and MIO teams

Skills

AppsScript

Python

JavaScript

C++

SQL

GCP

ERP integration

Tableau

Power BI

Looker Studio

AppSheet

Google Sheets

Data modelling

Data cleansing

Statistics

Narratives

Stakeholder mgmt

Troubleshooting

ArcGIS

Field Maps

QuickCapture

Education

CS/CE/SE degree

Tools

ArcGIS

ArcGIS Online/Pro

Job description

City of Edmonton seeks a Strategy Systems Analyst to bridge field operations and enterprise IT. You will design, build, and maintain automated ETL data pipelines, custom mobile field apps, and interactive dashboards to translate operational data into actionable data stories and KPI frameworks.

You will partner with frontline crews and leadership to drive data-informed decisions, governance, and continuous improvement within Mobility Infrastructure Services.