Data Advisor
Federation of Canadian Municipalities · Ottawa · $75,577–$85,413 (stated in the posting)
Who we are at GMF:
At the Green Municipal Fund (GMF), we create change where it matters most—in Canada’s municipalities.
As the Federation of Canadian Municipalities’ flagship program and backed by a $2.4 billion endowment from the Government of Canada, GMF helps Canadian municipalities, big and small, invest in their future by supporting homegrown sustainability and resilience projects that work for Canadians by creating jobs, lowering costs, and strengthening local economies.
Through our unique mix of funding, resources and training, GMF is enhancing the quality of life for people in Canada by accelerating a transformation to sustainable and resilient communities.
Since 2000, GMF has invested over $1.6 billion in local projects helping communities avoid 2.9 million tonnes of greenhouse gas emissions, while also contributing $1.24 billion to the national GDP and creating more than 13,000 person-years of national employment.
About This Role:
The Data Advisor will be part of a small and effective cross-sectoral team within Green Municipal Fund (GMF) Programs. Our team provides support in the areas of program design, program performance management, and continuous improvement for several GMF funding offers. Our team works most closely with programs focused on transportation, circular economy, water, energy, land use, affordable housing, and sustainable finance.The Data Advisor will play a leading role on setting up and operating data systems to support monitoring and evaluation efforts of several GMF programs. They will also play a role in supporting other programs design and effectiveness initiatives, as needed.
Note that this role strongly benefits from fluency in French; by contributing to program materials, stakeholder engagement and other projects in French on an as needed basis.
What you'll be doing:
Key Responsibilities
Data Analytics, dashboards and data systems
- Liaise with other teams across GMF to produce program dashboard and reports, using Power BI, the customer relationship management database (CRM) and the grants and loans management system (GLMS), that support better program delivery, monitoring, and evaluation.
- Perform initial quantitative and qualitative analysis of program data. Create visual representations of program data and results (e.g., graphs, charts, maps, etc.).
- Develop, update, and maintain data collection and analysis tools.
- Manage and execute data extraction requests from CRM, GLMS, and related business systems, ensuring data is accurately retrieved, validated, and prepared in accordance with operational, reporting, and stakeholder requirements.
- In collaboration with key internal stakeholders, identify, develop, optimize, and implement best practices and business processes within data management and reporting with the objective of achieving operational excellence.
Evidence-based risk monitoring
- Support evidence based, data informed, risk monitoring and management approaches at a program and portfolio level.
Information Systems / Programs Liaison
- Support programs leadership and liaise with the Information Systems team to track and support Programs department Information Systems priorities, including providing a department-wide lens on system change requests and requirements processes – to inform and raise decision points to Programs Leadership Team.
- Support program design leads to understand and follow consistent processes for new program launches (Information Systems requirements) and system enhancement requests.
- Support Information Systems team and Program design leads to ensure smooth translation of business needs to technical requirements and ensure processes and standards are consistently implemented across programs.
Other Programs Support and Development Projects as assigned
- Lead continuous improvement initiatives.
- Conduct research and analysis related to program design, program performance management or program improvement.
- Provide support for initiatives such as planning and organizing working groups, information management, and coordinating with stakeholders, lead advisors and service providers.
- Support colleagues with development and/or production of French content related to program design and operations, as needed.
- Promote intra and inter-unit collaboration, information sharing and knowledge brokering activities.
- Support development, updating, and process improvements of funding offers to ensure that GMF funding supports sector needs and are well integrated with overall GMF operations (e.g., finance, risk management, outreach, client services, governance, capacity building).
- Undertake additional activities assigned such as, participating in working groups and designing workshops/consultations and/or other activities
Knowledge and Experience
Requirements :
- Post-secondary education in a related field (public or business administration, economics, data science, project management, etc.).
- Minimum of 3-5 years of experience in conducting research, data management and/or analysis, project management, performing quantitative and qualitative analysis, and developing written materials for a professional audience.
- Strong knowledge of business support processes and tools, particularly advanced data manipulation and visualization skills using Microsoft Excel and PowerBI computer business applications (MS Office suite, including Microsoft PowerPoint), customer-relationship management (CRM) software and database management.
- Demonstrated experience with strong storytelling and visualization techniques using multiple tools including Excel, PowerBI, Microsoft CRM, etc.
- A combination of professional, academic, and/or lived experience in at least one of the following areas: monitoring, evaluation, and organizational learning, funding program design and operations, program reporting and performance management
- Demonstrated ability to understand, communicate, and contribute to technical content. Technical experience in one or more of the following sectors an asset: transportation, energy, waste, water, land use, affordable housing, or municipal finance.
- Strong attention to detail and accuracy.
- Excellent research and project coordination skills.
- Strong verbal and written communications skills in English. French is a strong asset.
Assets :
- Experience in stakeholder engagement, applying equity principles, lean methodologies / continuous improvement, project management, design thinking.
- Experience leading meetings and delivering presentations/trainings to senior and professional audiences.
- Understanding of the structures and function of municipal government in Canada; and the interests of municipal governments related to sustainability and the environment.
- Familiarity with cloud platforms (e.g., AWS, Azure, Google Cloud) and distributed computing frameworks (e.g., Spark) for scalable machine learning.
- Proficiency with programming frameworks and languages such as SQL, Python, TextBlob, scikit-learn., DAX.
Language Requirements :
- The ability to communicate fluently in written and verbal format in English is required. French fluency is a strong asset.
Additional Information :
- This posting is for an existing role
Salary Range:
$75,577.00 - $85,413.00
What we offer:
We offer a flexible work model grounded in accountability, collaboration, and delivering results. It is designed to support both performance and well‑being. While work is primarily virtual, occasional travel to our Head Office in Ottawa is expected. The majority of the team is based in the National Capital Region.
Where applicable, you may also have opportunities to travel across Canada to engage with the communities we support and better understand the impact of our work.
Employee experience and supports:
We are committed to creating an environment where people can do their best work while maintaining a healthy balance including:
- Flexible work arrangements that support productivity and collaboration
- Summer schedule (July 1 to Labour Day):
- 7-hour workdays
- Fridays off, aligned with team and operational needs
- Ongoing commitment to employee development
- Comprehensive range of employee benefits and services designed to support employee wellbeing and development. Please note: details and eligibility may vary depending on the role
- Modern office space in Ottawa’s ByWard Market and downtown core
We’re committed to fostering an organizational culture that embraces equity, diversity, inclusion and belonging, where individuals from diverse racial and ethnic identities, ages, nationalities, social economic status, sexual orientation, gender identity/expression and physical and mental abilities can thrive and be fully engaged at their best level.
We welcome and encourage applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the recruitment and selection process.
The future of work at FCM includes a hybrid work model; therefore, this role will be a combination of virtual and on-site work. The successful candidate is required live within 80kms of downtown Ottawa, unless otherwise specified, and be authorized to work in Canada.
As part of our recruitment process, we use automated artificial intelligence tools to screen applicants. All AI-generated assessments are reviewed and validated by our People and Culture team.
In closing....
If this role speaks to you and the impact you want to make, we’d love to hear from you!
We thank all candidates for their interest; however, only those selected to proceed to the next stage of the recruitment process will be contacted by a member of our People and Culture Team.
More jobs at Federation of Canadian Municipalities · Other jobs in Ottawa