Senior Analyst, Consolidated Financial Reporting

As the Senior Analyst, Consolidated Financial Reporting you will be accountable for the maintenance, operation, and issue resolution of the general ledger system from a finance-users perspective. This includes achieving the successful completion of technical accounting and reporting tasks and Oracle Financial Applications system related tasks. You would be responsible for preparing Quarter-End deliverables, which build the external reporting package, notably the consolidation schedule. Additionally, you would be responsible for preparing and maintaining the Finance Calendar, applying professional judgement when required.

• Facilitating and coordinating regulatory entries in Oracle, reviewing financial statements for consistency, and consolidating the regulatory set of books.
• Monitoring and resolving Journal Limit Approval and Oracle Posting Limit exceptions.
• Identifying and resolving technical or system issues in collaboration with BU Finance and IT support teams.
• Maintaining active GL segments, BU/legal rollups, and financial statement mapping.
• Managing requests, approvals, and Oracle set up for new GL segments from BU Finance teams.
• Performing accounting cycle steps per Finance Calendar deadlines and managing delays to meet deadlines.
• Rolling forward and completing the consolidation schedule to support external financial statements and Management Discussion & Analysis.
• Preparing quarterly workbooks and consolidated working papers using IFRS and professional judgement to support financial statements, budgets, and forecasts.
• Identifying and developing process improvements for financial reporting.
• Creating and updating financial reports for new segments or structural changes.
• Cross-training with Corporate Reporting Analyst to provide vacation coverage.
• Providing input to Manager on plans and maintaining effective relationships with other Business Unit (BU) positions.
• Supporting Oracle testing to facilitate new BUs, IT patches, and upgrades.
• Investigating Segregation of Duties reports and identifying CSOX control gaps.
• Generating Workday Adaptive Planning import for Actuals at month-end, verifying the import reconciles to Oracle, resolving issues with Centre of Excellence, and supporting GL segment setup and migrations.
• Generating and checking the close-out entries for retained earnings and AOCI using robotic process automation.
• Managing Oracle GL and ERP subledger operations (AR, Cost Management, Inventory, Projects) by scheduling interfaces, checking import reports, monitoring transactions, and guiding BU teams to resolve exceptions.
• Preparing revaluation analysis and consolidating the EPCOR CAD, EUSA, and EUSA IFRS ledgers into the EUI Consolidated General Ledger.
• Uploading audit materials to SharePoint and responding to auditor questions.

• An accredited accounting designation (CPA, CA, CMA and CGA).
• Ability to apply analytical and problem-solving skills in order to identify and recommend solutions.
• Understanding of how financial information flows from transaction initiation to reporting results.
• If you are considered for the position, clearance on all applicable background checks (which may include criminal, identity, educational, and/or credit) and professional reference checks is required. Some EPCOR positions require an enhanced level of background assessment, which is dictated by law. These positions require advanced criminal record checks that must also be conducted from time to time after commencement of employment.
• Understanding of and the ability to analyze and apply IFRS accounting standards.
• Strong Excel, Word and other MS Office applications skills.
• To meet the physical demands required of some positions, candidates must be in good physical condition and willing to work in all weather conditions. Clearance on pre-placement medical and drug and alcohol testing may be required.
• Demonstrating a high-performance, disciplined, safe, accountable, focused, innovative, and achievement-oriented work style.
• 4+ years of experience in a business setting with strong knowledge of the accounting cycle and financial systems.
• Prior infractions for unsafe driving behaviours will be evaluated and considered for non-selection regardless of current demerits on file.
• Knowledge of Workday Adaptive Planning software.
• 2+ years of hands-on Oracle Financial Applications (preferably including general ledger) experience.
• Skills with other software tools including data analysis would be a significant asset.
• Excellent oral and written communications skills including the ability to clearly present information to a variety of audiences in both formal and informal settings
• A requirement of working for EPCOR is that you are at least 18 years of age, successfully attained a high school diploma (GED, or equivalent level of secondary education) and legally entitled to work in Canada. (A copy of a valid work permit may be required.)
• Completion of a Degree in Business, Finance or Accounting (or a related field) from a recognized post-secondary educational institute.

Wage: Starting at $50.95 per hour