EPM Developer

Location: Edmonton, AB, Canada; Remote

At Stantec, we have some of the world’s leading professionals passionate about enabling our business to be its best. Our business teams include finance, procurement, human resources, information technology, marketing, corporate development, HSSE, real estate, legal, and practice services. We bring diverse backgrounds, skills, and expertise and create a caring culture where everyone can thrive. Through teamwork and collaboration, we’re building a stronger, more resilient Stantec every 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.

About the Organization