[Hiring] EPM Developer @Stantec

Role Description

Stantec is seeking a detail-oriented and collaborative EPM Developer to support our Financial Budgeting and Planning department. In this role, you will work closely with the BI Financial team and other stakeholders to enhance and maintain our enterprise performance management (EPM) systems. You will contribute to the development, administration, and support of planning and budgeting applications, including the Essbase reporting cube.

As a key contributor to the team, the EPM Developer will help design, develop, deploy, configure, and maintain applications and data integrations that support financial planning and reporting. This includes building software interfaces and managing databases that automate processes or meet the informational needs of the business. You will apply sound judgment, proactively solve problems, and deliver scalable solutions that support financial planning and reporting.

Key Responsibilities

• DevOps
  • Serve as a core member of the Stantec EPM team.
  • Design and develop planning models and cubes for budgeting, forecasting, and financial analysis requirements.
  • Build and maintain ETL pipelines from EBS and other data sources with minimal supervision.
  • Effectively communicate on development and operational support of work status and priority setting.
  • Ensure compliance with data governance and security policies while handling sensitive financial data.
• Architecture
  • Provide subject matter expertise and participate or lead in the creation of all deliverable content.
  • Define, design, document and implement required customizations to business rules that impact the model calculations before making any changes to the cubes.
  • Participate in architecture analysis and planning sessions, contributing subject matter expertise and technical input.
  • Ensure integration of cube and reporting components with overall enterprise architecture.
  • Provide hands-on guidance, support, and review for the creation of all technical components.
  • Advise on planning, coordination, and communications activities.
• Data Engineering
  • Develop data designs and scripts for new projects of varying complexity.
  • Ensure data accuracy by thoroughly testing business uses cases for new or changed ETL processes to extract data from EBS.
  • Utilize cube design skills to create effective models for efficient and robust historical and real-time reporting.
  • Develop summarization and reporting processes from detailed data in the reporting cubes.
• Collaboration and Stakeholder Management
  • Partner with Finance and cross-functional teams to gather requirements and enhance cube functionality.
  • Troubleshoot issues collaboratively, ensuring timely resolution and clear communication.
  • Manage stakeholder expectations and guide them on optimal use of reporting tools.
• Security and Data Governance
  • Enforce data governance policies, ensuring compliance with data privacy regulations and implementing application roles or OID groups to control access to the application.

Benefits

• Regular full-time and part-time employees (working at least 20 hours per week) will have access to health, dental, and vision plans, a wellness program, health care spending account, wellness spending account, group registered retirement savings plan, employee stock purchase program, group tax-free savings account, life and accidental death & dismemberment (AD&D) insurance, short-term/long-term disability plans, emergency travel benefits, tuition reimbursement, professional membership fee coverage, and paid time off.
• Temporary/casual employees will have access to group registered retirement savings plan, employee stock purchase program, and group tax-free savings account.
• The benefits information listed above may not apply to union positions because benefits for such positions are governed by applicable collective bargaining agreements.