EPM Developer

Description

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

Requirements

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

Benefits

Training + Development

Interview process

Visa Sponsorship

Security clearance