EPM Developer

Overview

Design, develop, and support Essbase-based budgeting and planning applications

Key Responsibilities

• etl pipelines
• cube design
• data governance
• reporting models
• database maintenance
• planning models

Tasks

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

Requirements

• debugging
• business analysis
• essbase
• pbcs
• bachelor’s
• data analysis

What You Bring

-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

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