Data Officer, Performance Measurement and Reporting

Data Officer, Performance Measurement and Reporting

The Federation of Canadian Municipalities (FCM) is the national voice of municipal governments, representing the interests of cities and communities with the federal government.

Position Data Officer, Performance Measurement and Reporting Department Growth & Development - Green Municipal Fund- PGP Classification Level 4 Salary

Our salaries generally range from $66,000 - $74,000, and are based on qualifications and experience

Languages Bilingual English required, French is an asset Term Permanent Full-Time Location Hybrid (Ottawa)

Why GMF is the place for you

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

Reporting to the (GMF) Manager, Performance Measurement and Reporting, the Data Coordinator is responsible for maintaining and improving GMF data management,





conducting research using data, and ensuring continuity of up-to-date, relevant information for both internal staff and external audiences. The Data Coordinator supports GMF performance measurement and reporting by aggregating and analysing program and fund-level data using databases containing information on project applications and GMF funded plans, studies, pilot projects, and capital projects. The data is managed within FCM’s Client Relations Management (CRM) system and is the foundation for monitoring performance and reporting results.







Key duties for the Data Coordinator include entering project information directly into the database; managing and updating business processes related to data management; auditing and quality control; producing research using data; working to expand the scope of the database to enhance value; and establishing links to relevant knowledge.

The work at FCM includes FCM becoming an even more member-driven organization that balances the realization of its goals with a people-centered approach. The incumbent embodies FCM’s commitment to being a healthy, diverse, inclusive, and anti-racist organization. As a member of the team, the officer works in a manner that embraces these values, the corporate culture and the passion for FCM’s mandate.

What you’ll be doing

Data Management

- Provides programming, research, analytical, administrative and logistical support to GMF.
- Ensures that databases contain accurate, complete, and up to-date information.






- Ensures that databases meet the needs of the programs, including accessibility of accurate, complete, and up-to-date information.
- Ensures a high standard of quality control and identifying data inconsistencies or errors.
- Collaborates with colleagues as part of an internal Data Management Working Group.
- Liaises with IS, and provides support on data platform upgrades, migrations, new product implementation, and training initiatives.
- Liaises with program delivery teams to create and produce program dashboard and reports, using Power BI, CRM, and GLMS (Grants and Loans Management System), that support better program delivery, monitoring and evaluation.






- Manages and analyzes quantitative and qualitative data from the final reports of GMF projects to identify project results and trends that can be used for the advancement of GMF programming.
- Supports the development of program products, including presentations and project profiles.

Database Improvement

- Contributes to database architecture improvement initiatives to ensure that data collection and reporting is consistent across users.
- Consults with Monitoring and Evaluation, Program delivery, and Communications staff to discuss opportunities to expand the scope and functionality of databases.
- Proactively researches, identifies, and recommends opportunities to improve business processes and user experience.

Research

- Supports the development and implementation of research projects related to GMF program enhancement,





via best practice scans, information and data management, program impact evaluations, trend analysis, and literature reviews. This includes designing and conducting research, and writing reports; developing work plans, and budgets; developing terms of reference and technical requirements; managing consultants as needed.
- Works with the GMF Engagement Analyst to plan and deliver stakeholder consultations, focus groups, and surveys engaging with clients and conducting market research to ensure that GMF is aligned with the interests of the municipal sector.
- Analyzes the results from research activities and develops recommendations regarding strategic issues.

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 gained through demonstrated experience of business support processes and tools, particularly advanced data manipulation, visualization and storytelling 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 and familiarity with Quality Assurance/Quality Control methodologies to validate datasets.
- 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.
- Critical thinking skills combined with a proven capacity for hands-on database work.
- 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
- Knowledge of continuous improvement methodologies such as Lean is an asset.

Why working here rocks

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.

How To Apply

If this role speaks to you and the impact you want to make, we’d love to hear from you! Apply today.

The deadline to apply is November 4th, 2024.

The future of work here 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 in and be authorized to work in Canada. They are also required to be able to work from home/remotely, from within Canada. All in-office work and in-person meetings for work that take place inside and/or outside of the offices located in Ottawa will be subject to FCM’s Safe Workplace Vaccination Policy, as well as its health and safety procedures.

For additional information on this posting, or for further information on FCM, access our website at www.fcm.ca. Learn more about the Green Municipal Fund at https://greenmunicipalfund.ca/