Data Advisor

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.

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:

• 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.
• Support evidence based, data informed, risk monitoring and management approaches at a program and portfolio level.
• Support programs leadership and liaise with the Information Systems team to track and support Programs department Information Systems priorities.
• Support program design leads to understand and follow consistent processes for new program launches (Information Systems requirements) and system enhancement requests.
• 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.
• 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.
• 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.
• We offer a flexible work model grounded in accountability, collaboration, and delivering results.
• While work is primarily virtual, occasional travel to our Head Office in Ottawa is expected.
• We are committed to creating an environment where people can do their best work while maintaining a healthy balance.
• Flexible work arrangements that support productivity and collaboration.
• Ongoing commitment to employee development.
• Comprehensive range of employee benefits and services designed to support employee wellbeing and development.
• 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.
• 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 to live within 80kms of downtown Ottawa, unless otherwise specified, and be authorized to work in Canada.

If this role speaks to you and the impact you want to make, we'd love to hear from you!