Data Analyst-gmf - Ottawa, Canada - Federation of Canadian Municipalities

Federation of Canadian Municipalities

Verified Company

Ottawa, Canada

1 week ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Background
The Federation of Canadian Municipalities (FCM) has been the national voice of municipal government since 1901.

FCM is dedicated to improving the quality of life in all communities by promoting strong, effective, and accountable municipal government.

FCM aspires to be an organization that is deeply respectful, collaborative, empowering and transparent in our work.

We have a commitment and passion for strengthening Canada by achieving results for our communities, our cities, and our workplace, and by sharing our knowledge and experience on the world stage, so that others may improve the quality of life in their communities.

The cornerstone FCM Program is the Green Municipal Fund (GMF), a $1 billion permanent endowment from the Government of Canada.

GMF helps local governments switch to sustainable practices faster.

Our unique mix of funding, resources and training gives municipalities the tools they need to build resiliency — and create better lives for Canadians.

As a leading catalyst for innovation, GMF offers funding (loans and grants) and knowledge for sustainable municipal initiatives designed to support communities to improve air, water, soil quality, and to protect the climate.

Through GMF, municipalities have 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 can find out more about how we're helping municipalities in this short videoor by taking a read of GMF's Annual Report.

Major Purpose
Reporting to the Manager

Client Support Services, the Data Analyst is responsible for providing operational and analytical support to the GMF Client and Funding Services team. The key functions of the role include analysis and remediation of data integrity and quality requirements related to GMF Client and Funding Services (CFS) activities, including identification of critical metrics, business process design mapping, auditing of critical data points, gap assessment of policies and procedures and associated remediation which includes the development of key standard operating procedures (for example, data management and maintenance).

The incumbent will work with the entire Client and Funding Services unit to coordinate best practices in data management and tracking of key metrics.

The Data Analyst supports the development and delivery of data visualizations and key performance indicators results through data mining and reconciliation, research of new opportunities and tools in data management, and review and analysis of unit reports with a focus on operational excellence and ensuring data quality and integrity for decision-making.

Key Responsibilities

Data mapping, auditing and remediation

Gap assessment of current policies and procedures related to data to ensure data management and integrity best practices are followed and maintained.
Drafting of key missing policies and procedures identified in gap assessment (for example, data management and maintenance) to ensure data management compliance to best practices.
With support from GMF stakeholders, leads the auditing of Client funding services related data in CRM to ensure quality and integrity in all systems.
Leads data quality and integrity activities for GMF's projects database, such as ensuring that clientfacing data is complete and accurate (for example, census data and project completion dates) and recommends corrective actions for data gaps and ensures processes are documented for issue resolution.
Develops data business process maps to define the flow of data during the client journey and recommends best practices for design development related to data integrity.
Analysis and remediation of data integrity and quality requirements related to GMF Client and Funding Services (CFS) activities (leads the execution and remediation of CSS's data mapping and auditing operational plan).
Implements changes to systems and procedures to streamline data management processes and improve data integrity.
Training of stakeholders on best practices related to data management and maintenance and audit requirements of process owners.

Reporting

Manages and analyses quantitative data to identify results and trends that can be used for the advancement of GMF programming through monthly, quarterly and annual reporting and management of dashboards.
Supports the team in the development of new reports and dashboards and the optimization of existing reporting.
Tracks and consolidates data and information provided by program staff, extracting relevant data from program databases, data warehouse, project files and documents.
Performs initial quantitative and qualitative analysis of program data and data collected from GMFfunded initiatives. Creates visual representations of program data and results (e.g., graphs, charts, maps, etc.).
Develops, updates,