Data Steward & Analytics Advisor (Hybrid)

Federation of Canadian Municipalities; Ottawa; Hybrid; CAD 76,000 - 85,000; Full time

Job summary

The Federation of Canadian Municipalities in Ottawa is seeking a Data Steward Advisor to lead the data lifecycle for the Growing Canada’s Community Canopies program. You will design data collection architecture, ensure data quality, and deliver real-time insights through automated dashboards.

You will work with the IS team, coordinate with program staff, and build Power BI reports and dashboards to support monitoring and evaluation.

Qualifications

• Post-secondary education in a related field such as public/admin, economics, data science or project management.
• Strong knowledge of Excel, Power BI, CRM software and database management.
• Experience with data collection for urban forestry initiatives and i-Tree tools.
• Experience launching programs and establishing new data collection systems.
• Excellent research, coordination and communication skills.
• Ability to manage multiple tasks and meet deadlines.

Responsibilities

• Lead and manage the design of the data architecture for programs, including data integration and data quality.
• Develop, implement and manage data collection processes to ensure data quality and integrity.
• Create Power BI dashboards and reports to visualize program results.
• Collaborate with IS, GMF teams and external consultants to automate reporting.
• Provide strategic data advisory support to managers and coordinators.
• Ensure compliance with data privacy obligations and reporting schedules.

Skills

Data governance

Data analysis

Communication

Project coordination

Attention to detail

Education

Post-secondary education in a related field

Tools

Power BI

CRM software

SQL

Python

Excel

Data warehousing

Job description

The Federation of Canadian Municipalities in Ottawa is seeking a Data Steward Advisor to lead the data lifecycle for the Growing Canada’s Community Canopies program. You will design data collection architecture, ensure data quality, and deliver real-time insights through automated dashboards.

You will work with the IS team, coordinate with program staff, and build Power BI reports and dashboards to support monitoring and evaluation.