Planning and Data Analyst

City of Edmonton•Edmonton, AB

1d•CA$90,926 - CA$114,898•Hybrid

About The Position

The Affordable Housing and Homelessness Section at the City of Edmonton is seeking a skilled, collaborative, and analytical Planning and Data Analyst. This role will contribute to addressing housing needs and coordinating the City's response to homelessness by analyzing complex data sets, conducting research, and establishing evaluation frameworks. The position involves turning data into actionable insights, creating public-facing tools and reports, and supporting evidence-based decision-making to evaluate program effectiveness. The role reports to the Program Manager of Policy and Planning and works closely with social planners, data and policy specialists, and City-funded organizations.

Requirements

Undergraduate Degree in Public Policy, Economics, Public Administration, Statistics, Urban Planning, or a related field
A minimum of five years of progressively responsible experience combining strategic and operational business planning, performance measures, business case development and data analytics
Proficient at identifying trends within distinct data points and simplifying complex data models into a visual or narrative format for diverse audiences
Experienced in navigating the sensitivities of government
Experience responding to high-pressure, time-sensitive inquiries
Highly skilled at translating raw data outputs into practical policy recommendations and expressing complex ideas persuasively in writing and presentations
Advanced knowledge of primary and secondary research methodologies, including data collection, trend analysis, and results presentation
Strong relationship-building skills with the ability to utilize influence, mediation, and collaboration to resolve issues and navigate workplace culture
Alignment to the City of Edmonton’s Cultural Commitments and Leadership Competencies
Embracing a culture of equity, diversity, reconciliation, and inclusion

Nice To Haves

A Master's degree in a related field is preferred
Experience with project management or leadership within a public sector environment
Three years of experience specializing in professional data analysis
Familiarity with application layer technologies and programming languages such as Google Workspace, Tableau, AppScript, AppSheet and Looker/Data Studio

Responsibilities

Support the development and/or monitoring of evaluation frameworks for major strategic initiatives, such as the Updated Affordable Housing Strategy and the Homelessness and Housing Services Plan
Design and provide customized, easy-to-implement data tracking solutions to build data solutions
Create public-facing dashboards, visual tools, and reports to transparently communicate the City's progress on housing initiatives to Council and the public
Monitor and update the City’s affordable housing inventory as required, including outreach to external partners
Evaluate Affordable Housing and Homelessness initiatives and programs and make recommendations.
Conduct environmental scans, jurisdictional reviews, and independent research to inform policy recommendations and assess legislative impacts
Lead independent projects including management of project scoping, timelines, and milestones for strategic housing initiatives
Contribute to updating strategic housing initiatives such as the City's Housing Needs Assessment through quantitative data analysis and qualitative engagement with housing organizations
Prepare and contribute to Council Reports, briefing notes, memorandums, presentations, evaluation summaries, and other relevant documents required to both internal and external parties
Support the implementation of strategic housing initiatives, manage timelines and ensure milestones are met