Our salaries generally range from $73,000 - $82,500, and are based on qualifications and experience

At GMF, we empower our people to create change where it has the most impact – municipalities. GMF is a $1.6 billion permanent endowment from the Government of Canada, managed at arm's length, making it nimble and available for higher-risk, higher-impact initiatives. A further $530M investment into GMF to support the National Adaptation Strategy was announced in November 2022.  Our team is committed to helping local governments switch to sustainable practices faster. GMF is the cornerstone program of the Federation of Canadian Municipalities (FCM).

Our unique mix of funding, resources, and training gives municipalities the tools they need to build resiliency — and create better lives for Canadians. Through GMF, municipalities have reduced carbon emissions; built better transportation assets; constructed efficient and resilient buildings; diverted waste from landfill; made previously unusable land available for development; and improved soil and water quality.

You in this role

• Lead business processes related to the programs databases as per the established data architecture and in the transformation into a LLCA program-wide dashboards.
• Ensure that the programs databases meet the needs of the programs, including that it contains accurate, complete and up-to-date information. Work closely with team members to ensure a high standard of quality control and identifying data inconsistencies or errors for continuous and final program reporting.
• Lead coordination with the Information Services (IS) department to develop and implement a plan to transfer program data, information and knowledge products to other FCM programs and locations such as the SharePoint and the Data Warehouse.
• Liaise with IS, and provides support on data platform upgrades, migrations, new product implementation and training initiatives.
• Using PowerBI, lead the design and development of program overview dashboards showcasing project and program results.
• Manage data management processes in the improvement of overall management processes and during data migration initiatives
• Lead coordination between LLCA teams and matrixed units to create and produce program dashboard and reports, using Power BI, CRM and GLMS, that support better program delivery, monitoring and evaluation.
• Lead the integration of program result analysis, including  climate adaptation data analysis and results presentation.
• Lead the design of the data architecture for the programs, including ensuring the alignment with GMF processes, data integration, data flow and data integrity.
• Liaise with LLCA reporting teams and other GMF units.
• Lead coordination with the programs funding teams to create and produce financial tracking tools, reconciliations, and reports using Power BI and GMF’s Customer Relationship Management (CRM) software. 
• Perform initial quantitative and qualitative analysis of program data and data collected from program-funded initiatives. Create visual representations of program data and results (e.g., graphs, charts, maps, etc.). 
• Develop, update, and maintain data collection and analysis tools. 
• Use SQL or similar software to run queries. 
• Lead the development of program products, including presentations and project profiles.  
• 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. Example: automation of manual reporting practices and development of dashboards. 
• Create and continuously improve programs dashboards and reports.

Continuous Improvement

• In collaboration with key internal stakeholders, identifies, develops, optimizes and implements best practices and business processes within data management and reporting with the objective of achieving operational excellence. Example: automation of manual reporting practices and development of dashboards.
• Gathers and analyzes data, investigate, and analyze bottlenecks and inefficiencies to seek data driven solutions.
• Identifies and analyzes needs, trends and opportunities to continually improve the overall effectiveness of reporting initiatives.
• Creates and continuously improves LLCA Dashboards and Reports.

Your skills make us better 

You bring:   

• Post-secondary education in a related field (public or business administration, economics, applied science, project management, etc.).
• 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.
• Strong attention to detail and accuracy.
• Excellent research and project coordination skills.
• Strong verbal and written communications skills.
• Exceptional organization skills, ability to work independently with good initiative and judgement, ability to adapt to changing priorities and manage multiple tasks, and work towards deadlines.
• Experience with program closure processes is considered an asset.
• Proven experience as a Data Architect, Reporting Architect, or a similar role with strong understanding of data modeling, data integration, data warehousing, machine learning and reporting concepts.
• 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.
• Demonstrated experience with strong storytelling and visualization techniques using multiple tools including Excel, PowerBI, Microsoft CRM, etc. is required.
• Strong knowledge of continuous improvement methodologies such as Lean is an asset. 

We prioritize work-life balance with our flexible model:

• When we say flexible work model, we mean that in collaboration with your manager and based on what your team needs, you have the flexibility to determine when you work so that you can enjoy a healthy balance between work and personal demands.
• While you do need to live in Canada for this role, you can primarily work from home. Travel may be required to Head Office in Ottawa periodically.  The majority of the GMF team operates from the National Capital Region.
• We do like to visit the areas we are impacting and it allows us to see unique and wonderful parts of our country. You may find yourself traveling nationally 10-15% of the time. 

We don’t just talk about employee wellness, we live it:

• Summer hours between July 1 and Labour Day:
  • 7-hour workdays rather than 7.5
  • Every Friday off in the summer
• Flexible work arrangements to support productivity and well-being
• Commitment to employee development
• Competitive range of employee benefits and services
• Office facilities located in the Byward Market and Ottawa’s 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, 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.