EPM Developer

Stantec; Edmonton; On-site; CAD 80,000 - 100,000; Full time

Job summary

A global consulting company is seeking a detail-oriented EPM Developer for its Financial Budgeting and Planning department. The successful candidate will be responsible for enhancing and maintaining enterprise performance management systems, developing planning models, and supporting financial reporting processes. Strong skills in ETL processes and stakeholder management are key for this role. Join a diverse team driving operational excellence in a collaborative environment.

Qualifications

• Detail-oriented with strong collaborative skills.
• Experience in enterprise performance management systems.
• Knowledge in ETL processes and data integration.

Responsibilities

• Support financial budgeting and planning department as an EPM Developer.
• Design, develop, and maintain planning models and ETL pipelines.
• Collaborate with Finance and cross-functional teams for effective cube functionality.

Job description

At Stantec, we have some of the world’sleading professionals passionate aboutenabling ourbusinessto beitsbest.Ourbusinessteams include finance, procurement, human resources,information technology, marketing, corporate development, HSSE,real estate,legal, and practice services. Webring diverse backgrounds, skills, and expertiseandcreate acaringculturewhere everyone can thrive.Through teamworkand collaboration, we’re buildinga stronger, more resilientStantecevery day.

Grow with the best. Join a smart, creative, and inspired team that accomplishes operational excellence. Bringing individuals with diverse backgrounds, talents, and expertise, our 31,000 team members in over 400 locations worldwide are vital to making our Company stronger.

Your Opportunity

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.