• Create and maintain EPM governance, service level agreements, administration/procedural policies, and guideline documentation based on business needs, SOX controls, and security requirements.
• Responsible for requirements gathering, design, and solution architecture, as well as configuring EPM application components in line with business, functional, and performance requirements. This includes optimal dimension configuration, business rule/calc script customization, web forms/task list definition, Financial Reporting Web Studio reports, SmartView templates and other tools.
• Develop and maintain processes to ensure data quality, including data mapping, validation, and translation.
• Coordinate monthly EPM application patching activities, including impact analysis and regression testing
• Support the financial close and reporting process, including financial consolidation for external and legal entity reporting, tax filings, statutory disclosures, creation and maintenance of reports in the Narrative Reporting module, and management dashboards.
• Support the financial planning and analysis process, providing expert advice on design/architecture incorporating leading practices, including business and finance strategy, target setting, profit & loss, balance sheet, cash flow forecasting, key performance metrics, financial analytics, driver-based planning, and rolling forecast.
• Provide support for software implementation, including overseeing testing, training and revised system documentation. This may include managing external consultants.
• Identify and resolve performance and functional issues through robust processes to diagnose root causes and implement solutions.
• Participate in system audits & internal control reviews.
• Participate in EPM disaster recovery planning.
• Provide leadership and support to the team in day-to-day operations and initiatives.

• 6+ years of experience in consolidation and planning software with at least 2 years using Oracle cloud EPM (EPBCS, PCMCS, FCC, ARCS, Tax reporting, and Data Management)
• Bachelor's Degree in Business Management, Business Administration, Computer Information Technology, or a designated CPA.
• Advanced understanding of financial statements, currency translations, inter-company eliminations, consolidation accounting, and closing processes under various GAAPs.
• Advanced understanding of FP&A processes, including strategic planning, bottoms-up and driver-based budgeting, scenario modelling and analysis, and multidimensional financial reporting.
• Experience designing and developing financial reports, including statutory and management reports using SmartView and narrative report writing skills, e.g. HS-GetValue.
• Demonstrated experience managing databases and multi-hierarchy reporting cubes.
• Experience with EPM process automation through EPM Automate, REST API, and PowerShell scripting and integrating cloud and on-premises applications to EPM using Data Management, data maps, and Groovy scripting.
• Proven ability to design and maintain robust data integration workflows using Oracle Data Integration (ODI) or equivalent export, transform and load (ETL) solutions.
• Advanced proficiency with Groovy scripting, SQL, Essbase calculations, advanced business rule development, and optimization techniques for ASO and BSO (or Hybrid) cubes.
• Workforce planning experience, including building models for headcount, compensation, and detailed financial scenarios.
• Demonstrated excellence in simplifying and fine-tuning calculations, reducing runtime, designing for scalability, and improving user experience.
• Strong troubleshooting and problem-solving skills with a proven ability to deliver complex, time-sensitive projects and resolve system issues under pressure.
• Effective verbal and written communication skills.
• Authorized to work in Canada and must work onsite 4 days a week in the downtown Vancouver office.

If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.

If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion on your career.