data analyst Ottawa
Job description
Please note we only accept applications through our website: www.fcm.ca career page section.
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 client-facing 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 GMF-funded initiatives. Creates visual representations of program data and results (e.g., graphs, charts, maps, etc.).
- Develops, updates, and maintains data collection and analysis tools.
- Supports the implementation of existing reporting tools and creates new tools as needed.
- Key contributor towards optimization of various reporting and data processes for presentation to multiple levels of stakeholders.
Knowledge, Experience and Skills
- University degree in a related field (engineering, computer science or business administration, economics, etc).
- A minimum of five years of progressively responsible experience in monitoring, data analysis, project management, communications, and/or managing program activities, including experience in planning and reporting processes.
- Experience in impact measurement and evaluation using a broad range of both quantitative and qualitative tools and methods, including results-based management approaches, reporting procedures and principles.
- Previous exposure to knowledge management and activities (e.g., researching existing knowledge tools, organizing resources, identifying gaps in existing knowledge tools, mobilizing tools and resources and developing guides).
- Demonstrated experience in managing data with data/information management techniques and the use of databases is required. GMF uses multiple tools including Excel, PowerBI, Microsoft CRM, etc.
- Experience with data visualization is required.
- Strong knowledge of continuous improvement methodologies such as Lean is an asset.
- Excellent interpersonal and collaboration skills with a focus on working across internal teams, and with external stakeholders.
- Excellent judgment, problem solving, analytical, research and decision-making skills.
- Exceptional customer service skills.
- Strong attention to detail and accuracy.
- Proficiency with database languages such as SQL.
- Experience producing reports for government-funded projects is an asset.
- Knowledge of the Canadian municipal sector and experience working with elected officials and/or a Board of Directors are definite assets.
Language Requirements
- The ability to work in both official languages is an asset.
The benefits to joining the FCM team include summer hours (Fridays off between July 1st and Labour Day); office facilities located in the ByWard Market, FCM’s commitment to employee development and a competitive range of employee benefits and services. FCM encourages flexible work arrangements to support the wellbeing and productivity of employees.
The Federation of Canadian Municipalities is 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.
FCM welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the recruitment and selection process.
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 in and be authorized to work in Canada. They are also required to be able to work from home/remotely, from within Canada.
For additional information on this posting, or for further information on FCM, access our website at www.fcm.ca. Visit the careers section of our website to apply. The deadline for applications is June 18, 2023.
We thank all candidates for their interest; however, we will only contact those selected for an interview. All the applications will be kept on file for six months following the hiring.
Job Types: Full-time, Fixed term contract
Contract length: 6 months
Salary: $75,800.00-$95,650.00 per year
Flexible Language Requirement:
- French not required
Schedule:
- Monday to Friday
Work Location: Hybrid remote in Ottawa, ON K1N 5P3
Application deadline: 2023-06-18
About Federation of Canadian Municipalities
CEO: Carole Saab
Revenue: $5 to $25 million (USD)
Size: 51 to 200 Employees
Type: Non-profit Organisation
Website: www.fcm.ca
