EPM Developer
Stantec
Develop and maintain Essbase/EPM budgeting and forecasting models, ETL pipelines, and reporting.
16 days ago ago
Intermediate (4-7 years), Expert & Leadership (13+ years), Experienced (8-12 years)
Full Time
Edmonton
Office Full-Time
Company Size
32,000 Employees
Service Specialisms
Planning
Engineering
Architecture
Interior Design
Landscape Architecture
Surveying
Environmental Sciences
Project Management
Sector Specialisms
Industrial
Energy
Infrastructure
Buildings
Residential
Commercial
Water Resources
Heavy Civil
Role
What you would be doing
etl pipelines
cube design
data modeling
reporting
data governance
backup recovery
- Effectively communicate on development and operational support of work status and priority setting.
- Partner with Finance and crossfunctional teams to gather requirements and enhance cube functionality.
- Contribute to the establishment of standards for cube maintenance and reporting infrastructure.
- Ensure data accuracy by thoroughly testing business uses cases for new or changed ETL processes to extract data from EBS.
- Ensure compliance with data governance and security policies while handling sensitive financial data.
- Build and maintain ETL pipelines from EBS and other data sources with minimal supervision.
- Develop data designs and scripts for new projects of varying complexity.
- Support database maintenance and security.
- Utilize cube design skills to create effective models for efficient and robust historical and realtime reporting.
- Participate in architecture analysis and planning sessions, contributing subject matter expertise and technical input.
- Design and develop planning models and cubes for budgeting, forecasting, and financial analysis requirements.
- Enforce data governance policies, ensuring compliance with data privacy regulations and implementing application roles or OID groups to control access to the application.
- Ensure integration of cube and reporting components with overall enterprise architecture.
- Develop summarization and reporting processes from detailed data in the reporting cubes.
- Design and document backup and recovery procedures.
- Manage stakeholder expectations and guide them on optimal use of reporting tools.
- Identify opportunities for framework improvements and participate in code reviews.
- Troubleshoot issues collaboratively, ensuring timely resolution and clear communication.
- Define, design, document and implement required customizations to business rules that impact the model calculations before making any changes to the cubes.
- Serve as a core member of the Stantec EPM team.
- Provide handson guidance, support, and review for the creation of all technical components.
- Provide subject matter expertise and participate or lead in the creation of all deliverable content.
- Advise on planning, coordination, and communications activities.
What you bring
debugging
business analysis
epm tools
bachelor's
detail-oriented
data analysis
- Ability to Debug/troubleshoot
- Business Analysis
- Proven experience with EPM Tools and Maxl scripting (Essbase, PBCS, Planning)
- Education/diploma Bachelor’s Degree or equivalent
- Strong attention to detail
- Proficiency in Data Analysis or Analytical mind with a problemsolving aptitude
Information not given or found
Training + DevelopmentInformation not given or found
Interview process
Information not given or found
Visa SponsorshipInformation not given or found
Security clearanceInformation not given or found
People also searched
Data Engineer Jobs in Edmonton CanadaBusiness Analytics Jobs in Edmonton CanadaBusiness Analyst Jobs in Edmonton CanadaSoftware Engineer Jobs in Edmonton CanadaBI Developer Jobs in Edmonton CanadaBusiness Transformation Jobs in Edmonton CanadaSolutions Architect Jobs in Edmonton CanadaIT Consultant Jobs in Edmonton Canada
Company
Overview
Founded in 1954
Year Established
The company was established as a one-person environmental engineering practice in 1954.
MWH Global in 2016
Acquisition Year
Completed the acquisition of MWH Global to enhance expertise in water and natural resources.
450+ Offices
Global Presence
Operates across more than 450 offices on six continents, showcasing extensive global reach.
6 Continents
Geographic Reach
Maintains a strong presence on six continents through strategic expansion.
- Began as a one-person environmental engineering practice and has grown through strategic geographic and service expansion.
- Publicly listed on the NYSE and TSX, Stantec has completed major acquisitions to bolster expertise and strengthen global infrastructure portfolio.
- Headquartered in the iconic Stantec Tower in Edmonton, the company has delivered landmark projects like the Panama Canal Expansion and high-profile community developments.
- Leverages interdisciplinary teams of designers, engineers, scientists, and project managers.
- Typical projects span urban planning, civil infrastructure, water management, environmental assessment, energy delivery, and architectural design, serving public and private sectors.
- Blends technical prowess with visionary design in bold ventures such as designing its own mixed-use tower and leading multi-nation infrastructure projects.
- We Put People First
- We Do What is Right
- We Are Better Together
- We Are Driven to Achieve
2025
Carbon Neutrality Target
The company plans to achieve carbon neutrality in its operations by the end of the fiscal year 2025.
32,000
Employees in Sustainable Projects
Over 32,000 employees are working on climate-resilient infrastructure and future-proofing cities.
- Commitment to environmental, social and governance excellence across operations and client projects
- Issued Sustainability‑Linked Loan, tying financing to ESG metrics including Bloomberg GEI and environmental targets
- Publicly reported environmental performance in annual Sustainability Report (e.g., GRI‑aligned metrics)
43% women
Female Representation in Leadership
43% of board and C‑Suite positions are held by women in 2023.
18% pay gap
Global Gender Pay Gap
The global mean unadjusted gender pay gap is 18%.
3% compa-ratio
Gender Pay Gap Improvement
North America base pay compa-ratio gender pay gap improved by 3% in 2023 compared to the prior year.
7% score improvement
Gender-Equality Index
Score improved by 7% in 2023 in the Bloomberg Gender-Equality Index, which has been achieved for the fourth consecutive year.
- Named to Bloomberg Gender-Equality Index fourth consecutive year
- Female representation: more than 50% of entry-level staff are women
- 36 Women@Stantec regional employee resource groups active globally
- First globally to link senior credit facility pricing to Bloomberg Gender-Equality Index score
Kablio AIIf you're someone who helps build and power the world (or dreams to), Kablio AI is your pocket-sized recruiter that gets you hired.
Copyright © 2025 Kablio