Finance Assistant

at  Federation of Canadian Municipalities

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

YOUR SKILLS MAKE US BETTER

You bring:

EDUCATION:

• Requires a post-secondary education in accounting and 2-3 years practical experience; (Asset)

EXPERIENCE:

• 1-2 years experience in Finance, accounting, or a other relevant field.
• Experienced in extracting and manipulating large data sets from relational databases and previous experience working in finance is considered an asset.

KNOWLEDGE:

• Strong Power BI skills allows a Finance Assistant to effectively contribute to data-driven decision-making and improve overall financial management within the organization.
• Requires experience with accounting practices and procedures, specifically, general ledger activities
• Knowledge of Microsoft Office, specifically Excel and PowerPoint, Power BI and experience with accounting software packages.

YOU IN THIS ROLE

Reporting to the Finance Manager, Programs, the Finance Assistant, Programs, will be responsible for providing financial reporting and support services for all programs.
A Finance Assistant with Power BI skills will include the responsibilities that blend financial tasks with data analysis and reporting. Having strong Power BI skills allows a Finance Assistant to effectively contribute to data-driven decision-making and improve overall financial management within the organization
The Finance Assistant will assist with the financial reporting duties related to all programs in compliance with their respective Funding and Contribution Agreements. (add about other responsibilities)
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 Finance Assistant works in a manner that embraces these values, the corporate culture and the passion for FCM’s mandate.

WHAT YOU’LL BE DOING

• Use Power BI to organize financial data and generate insightful reports for management and other stakeholders.
• Develop interactive dashboards that visualize financial metrics, trends, and KPIs.
• Review and reconcile financial databases in collaboration with IS team against the source, ensuring data integrity and accuracy
• Streamline reporting processes by automating data extraction and visualization using Power BI.
• Reviews expense claims, advances and credit card statements against project budgets and other established processing procedures, assessing accuracy and eligibility, following up on any missing information or discrepancies, and coding according to established guidelines and proper signing authority;
• Assists Finance Officers with monthly journal entries and reconciliations;
• Reviews supplier contracts and ensures proper signing authority; creates purchasing requisition for vendor contract;
• Provides support and assistance to Finance Manager with Power BI Reporting
• Provides support to the Finance Manager, Programs, for ad-hoc projects, e.g., assist in external organizational / project audits by collecting required information;
• Responsible for document retention (filing hardcopy and on the server) of financial documents
• Work with other departments to gather data and provide financial insights.