Integration analyst Jobs in Edmonton, AB

Job Description

Financial Analyst – Junior

Government of Alberta – Public Safety and Emergency Services (PSES)

Position Details

Position Overview

The Government of Alberta is seeking a Junior Financial Analyst to support the Public Safety and Emergency Services (PSES) team with full-cycle accounting, financial reporting, financial analysis, reconciliations, month-end processes, and other financial operations.

The successful candidate will apply accounting and financial analysis skills to ensure the accuracy, completeness, and reliability of financial information. The resource will support month-end activities, reporting, budgeting and forecasting, variance analysis, account reconciliations, AP/AR activities, and process improvements.

The role requires a resource who is comfortable working with financial data, Microsoft Excel, accounting processes, and business stakeholders in an onsite Government of Alberta environment.

Key Responsibilities

The Financial Analyst – Junior will be responsible for, but not limited to:

Accounting & Month-End

• Prepare and process journal entries.
  
• Assist with month-end close and reporting activities.
  
• Review and analyze accruals and trial balance accounts.
  
• Perform account reconciliations and investigate discrepancies.
  
• Perform bank reconciliations.
  
• Ensure financial transactions are accurate, complete, and properly recorded.
  
• Assist with maintaining accurate financial records.
  

Financial Reporting & Analysis

• Assist in preparing financial reports, dashboards, and internal/external reporting.
  
• Analyze and interpret financial information.
  
• Support financial analysis and reporting activities using Microsoft Excel.
  
• Perform variance analysis and investigate unusual or abnormal financial results.
  
• Identify errors, inconsistencies, and discrepancies in financial data.
  
• Provide accurate financial information to business partners and stakeholders.
  

Accounts Payable & Receivable

• Assist with Accounts Payable (AP) activities.
  
• Assist with Accounts Receivable (AR) activities.
  
• Support invoice processing and financial transaction activities.
  
• Assist with identifying and resolving AP/AR discrepancies.
  
• Support customer collections activities as required.
  

Financial Operations

• Assist with business partner maintenance.
  
• Assist with capital asset maintenance.
  
• Support diverse financial operations and accounting activities.
  
• Gather financial information from business entities.
  
• Disseminate financial information to appropriate stakeholders.
  
• Support budgeting and forecasting activities.
  

Process Improvement

• Identify opportunities to improve financial and accounting processes.
  
• Assist with implementing process improvements.
  
• Help improve the accuracy, efficiency, and reliability of financial processes.
  
• Perform other financial/accounting duties as required.
  

Requirements

Mandatory Qualifications

Candidates must meet the following requirements:

1. Education

Bachelor's degree or diploma in one of the following, or equivalent experience:

• Accounting
  
• Finance
  
• Business
  
• Supply Chain
  
• Information Technology
  
• Computer Science
  
• Related discipline
  

2. Accounting Knowledge

Demonstrated knowledge of:

• Accounting principles
  
• Financial transactions
  
• Financial data accuracy and reliability
  
• Canadian public-sector accounting standards, or equivalent knowledge
  

3. Advanced Microsoft Excel – Minimum 1 Year

At least 1 year of experience creating and using advanced Excel functions, including:

• PivotTables
  
• VLOOKUP
  
• XLOOKUP
  
• Financial data analysis
  
• Data manipulation
  
• Reporting and reconciliation
  

Candidates should be able to demonstrate how Excel was used in a specific job/project, rather than simply listing Excel as a skill.

4. Financial Reporting – Minimum 2 Years

At least 2 years of experience with financial reporting and financial transactions, including:

• Preparing financial reports
  
• Analyzing financial data
  
• Ensuring accuracy and reliability of financial information
  
• Reconciliations
  
• Financial analysis
  
• Microsoft Excel-based reporting
  

Nice-to-Have Qualifications

CPA

• Currently pursuing a CPA designation.
  

Financial Audit / Controls / Reconciliation – 2+ Years

At least 2 years of experience applying one or more of the following:

• Financial audit principles
  
• Financial controls
  
• Financial reconciliation
  
• Financial systems governance
  
• Financial data validation
  

Experience supporting these activities within large-scale data migration, data conversion, or ERP implementation projects is an advantage.

AP / AR / Reconciliation – 2+ Years

At least 2 years of experience with:

• Accounts Payable
  
• Accounts Receivable
  
• Account reconciliation
  
• Identifying and correcting financial errors
  
• Investigating discrepancies
  

SAP Finance (FI) – 1+ Year

At least 1 year of experience with SAP Finance (FI), including:

• Financial postings
  
• Invoice processing
  
• Financial transactions
  
• SAP FI processes
  
• Integration points with procurement
  
• Integration points with supply chain
  

Financial Operations – 2+ Years

At least 2 years of experience supporting diverse financial operations, including working with business stakeholders and supporting day-to-day accounting and financial activities.

Requirements
Mandatory Qualifications Candidates must meet the following requirements: 1. Education Bachelor's degree or diploma in one of the following, or equivalent experience: Accounting Finance Business Supply Chain Information Technology Computer Science Related discipline 2. Accounting Knowledge Demonstrated knowledge of: Accounting principles Financial transactions Financial data accuracy and reliability Canadian public-sector accounting standards, or equivalent knowledge 3. Advanced Microsoft Excel – Minimum 1 Year At least 1 year of experience creating and using advanced Excel functions, including: PivotTables VLOOKUP XLOOKUP Financial data analysis Data manipulation Reporting and reconciliation Candidates should be able to demonstrate how Excel was used in a specific job/project, rather than simply listing Excel as a skill. 4. Financial Reporting – Minimum 2 Years At least 2 years of experience with financial reporting and financial transactions, including: Preparing financial reports Analyzing financial data Ensuring accuracy and reliability of financial information Reconciliations Financial analysis Microsoft Excel-based reporting Nice-to-Have Qualifications CPA Currently pursuing a CPA designation. Financial Audit / Controls / Reconciliation – 2+ Years At least 2 years of experience applying one or more of the following: Financial audit principles Financial controls Financial reconciliation Financial systems governance Financial data validation Experience supporting these activities within large-scale data migration, data conversion, or ERP implementation projects is an advantage. AP / AR / Reconciliation – 2+ Years At least 2 years of experience with: Accounts Payable Accounts Receivable Account reconciliation Identifying and correcting financial errors Investigating discrepancies SAP Finance (FI) – 1+ Year At least 1 year of experience with SAP Finance (FI), including: Financial postings Invoice processing Financial transactions SAP FI processes Integration points with procurement Integration points with supply chain Financial Operations – 2+ Years At least 2 years of experience supporting diverse financial operations, including working with business stakeholders and supporting day-to-day accounting and financial activities.