Finance Systems Clerk

BC General Employees' Union (BCGEU); Burnaby; On-site; CAD 123,356,000 - 133,557,000; Full time

Job summary

BCGEU in Burnaby, BC is seeking a Finance Systems Clerk (L7) to support the finance department’s systems, databases, and reporting tools. You will troubleshoot issues, help with upgrades, and prepare financial reports and dashboards.

The role requires a 2-year diploma in finance or CIS, at least 3 years’ relevant experience, and strong Excel, Office, and database querying skills; knowledge of Power BI and Microsoft Dynamics GP is preferred.

Qualifications

• Completion of a 2-year diploma in finance, computer information systems, or related field from a recognized post-secondary institution.
• Experience providing technical and end-user support for financial or accounting systems.
• At least 3 years of relevant experience in a similar position.
• Proficiency in Microsoft Office, with advanced Excel skills.
• Proficiency in the use of database queries and building Power BI dashboards, and/or other similar reporting tools.
• Experience with Microsoft Dynamics GP (Great Plains) preferred, or a similar accounting software program.

Responsibilities

• Provide ongoing financial systems support to the finance department and other key stakeholders within the union in the form of daily troubleshooting, systems maintenance, development of training material, subject matter expertise, and financial database management.
• Investigate financial system issues, seek resolutions, and liaise with software vendors/consultants as required to assist with issue resolution.
• Help maintain a strong system of internal controls through the maintenance and updating of system access rights and user permissions in accordance with the policies of the union.
• Support system upgrades, integrations, and implementations.
• Maintain the Finance Department’s information databases and assist with the development and maintenance of financial reporting tools and dashboards.

Skills

Advanced Excel

Power BI dashboards

Database queries

Financial data analysis

Attention to detail

Education

2-year diploma in finance or CIS

Tools

Microsoft Dynamics GP

Microsoft Office

Power BI

Job description

Job Title: Finance Systems Clerk (L7) – Finance

Wage Rate: $43.05- $46.61 per hour

Location: 4126 Norland Ave, Burnaby, BC V5G 3S8

Job Summary:

Reporting to the Director and Associate Director of Finance, and working closely with the Senior Financial Systems Analyst, the Finance Systems Clerk will provide support to the department and be responsible for various finance systems-related tasks, including, but not limited to maintaining financial systems and databases, troubleshooting issues, generating financial data and reports, reconciling data, and assisting in the implementation of new systems.

Key Responsibilities:

Financial Systems Maintenance and Support

• Provide ongoing financial systems support to the finance department and other key stakeholders within the union in the form of daily troubleshooting, systems maintenance, development of training material, subject matter expertise, and financial database management.
• Investigate financial system issues, seek resolutions, and liaise with software vendors/consultants as required to assist with issue resolution.
• Help maintain a strong system of internal controls through the maintenance and updating of system access rights and user permissions in accordance with the policies of the union.
• Support system upgrades, integrations, and implementations.

Database Administration and Reporting

• Maintain the Finance Department’s information databases.
• Assist with the development and maintenance of financial reporting tools including, but not limited to, spreadsheets, business intelligence dashboards, and database queries.
• Perform data validation and reconciliations between financial systems, databases, and reporting tools to help ensure completeness and accuracy.
• Assist in the preparation of both routine and ad-hoc financial reports.

Process Improvements

• Assist with the continuous improvement of policies and procedures and upgrade of financial systems.
• Collaborate with cross-functional teams within the union to resolve issues and execute on project deliverables.

General Finance and Administrative Support

• Prepare process documentation for financial systems and provide training to users.
• Other related finance and administrative duties and responsibilities as required.
• Completion of a 2-year diploma in finance, computer information systems, or related field from a recognized post-secondary institution.
• Experience providing technical and end-user support for financial or accounting systems.
• At least 3 years of relevant experience in a similar position.
• Proficiency in Microsoft Office, with advanced Excel skills.
• Proficiency in the use of database queries and building Power BI dashboards, and/or other similar reporting tools.
• Experience with requirements gathering, process mapping, testing, and documentation.
• Experience with Microsoft Dynamics GP (Great Plains) preferred, or a similar accounting software program.

Knowledge, Skills, & Abilities:

• Good understanding of accounting concepts and principles.
• Ability to prioritize tasks and manage multiple responsibilities while adhering to deadlines and ensuring accuracy.
• Aptitude for organization and detail.
• Good analytical, troubleshooting, and problem-solving skills.
• Ability to review and validate financial data for completeness and accuracy.
• Excellent written and verbal communication skills, with the ability to collaborate effectively with both finance and non-finance staff.
• Ability to translate business requirements into technical/system requirements.
• Excellent keyboarding skills (40 - 50 wpm).

The BCGEU supports employment equity. Indigenous workers, workers of color, women, 2SLGBTQI+ workers, and workers with disabilities are encouraged to apply for positions with the BCGEU.