EPM Developer

Overview

Develop, maintain, and support Essbase/EPM budgeting and planning models.

Key Responsibilities

• cube design
• etl development
• data governance
• reporting processes
• backup recovery
• stakeholder management

Tasks

-Define, design, document and implement required customizations to business rules that impact the model calculations before making any changes to the cubes. -Utilize cube design skills to create effective models for efficient and robust historical and real-time reporting. -Advise on planning, coordination, and communications activities. -Participate in architecture analysis and planning sessions, contributing subject matter expertise and technical input. -Effectively communicate on development and operational support of work status and priority setting. -Provide hands-on guidance, support, and review for the creation of all technical components. -Design and document backup and recovery procedures. -Identify opportunities for framework improvements and participate in code reviews. -Manage stakeholder expectations and guide them on optimal use of reporting tools. -Develop data designs and scripts for new projects of varying complexity. -Ensure compliance with data governance and security policies while handling sensitive financial data. -Ensure integration of cube and reporting components with overall enterprise architecture. -Troubleshoot issues collaboratively, ensuring timely resolution and clear communication. -Contribute to the establishment of standards for cube maintenance and reporting infrastructure. -Serve as a core member of the Stantec EPM team. -Enforce data governance policies, ensuring compliance with data privacy regulations and implementing application roles or OID groups to control access to the application. -Develop summarization and reporting processes from detailed data in the reporting cubes. -Support database maintenance and security. -Provide subject matter expertise and participate or lead in the creation of all deliverable content. -Ensure data accuracy by thoroughly testing business uses cases for new or changed ETL processes to extract data from EBS. -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. -Partner with Finance and cross-functional teams to gather requirements and enhance cube functionality.

Requirements

• epm tools
• maxl
• bachelor's
• data analysis
• debugging
• business analysis

What You Bring

-Proven experience with EPM Tools and Maxl scripting (Essbase, PBCS, Planning) -Education/diploma - Bachelor’s Degree or equivalent -Proficiency in Data Analysis or Analytical mind with a problem-solving aptitude -Strong attention to detail -Ability to Debug/troubleshoot -Business Analysis

People Also Searched For

About Stantec

-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.

Sector Specialisms