EPM Developer at Stantec

Edmonton, Alberta, Canada -

Full Time

Start Date

Immediate

Expiry Date

16 May, 26

Salary

0.0

Posted On

15 Feb, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

EPM Systems, Essbase, Budgeting, Forecasting, Financial Analysis, ETL Pipelines, Data Governance, Security Policies, Cube Design, Data Engineering, Maxl Scripting, Data Analysis, Business Analysis, Troubleshooting, Attention To Detail, Stakeholder Management

Industry

Industrial Machinery Manufacturing

Description

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. Pay Transparency: In compliance with pay transparency laws, pay ranges are provided for positions in locations where required. Please note, the final agreed upon compensation is based on individual education, qualifications, experience, and work location. At Stantec certain roles are bonus eligible. Actual compensation for part-time roles will be pro-rated based on the agreed number of working hours per week. Benefits Summary: 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.

Responsibilities

The EPM Developer will design, develop, deploy, configure, and maintain enterprise performance management applications, including planning models and Essbase cubes for budgeting and forecasting. Key duties involve building ETL pipelines, ensuring data accuracy, enforcing data governance, and providing technical input for architecture planning.