Jobs.ca
Jobs.ca
Language
Stantec logo

EPM Developer

Stantec1 day ago
Verified
Toronto, ON
Senior Level
Full-time

Top Benefits

Health plans
Dental plans
Vision plans

About the role

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.

Additional Duties

  • Contribute to the establishment of standards for cube maintenance and reporting infrastructure.
  • Design and document backup and recovery procedures.
  • Support database maintenance and security.
  • Identify opportunities for framework improvements and participate in code reviews.

Your Capabilities and Credentials

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

Education and Experience

Minimum of five years of related work experience; or an equivalent combination of education and related experience.

This description is not a comprehensive listing of activities, duties or responsibilities that may be required of the employee and other duties, responsibilities and activities may be assigned or may be changed at any time with or without notice.

Stantec is a place where the best and brightest come to build on each other’s talents, do exciting work, and make an impact on the world around us. Join us and redefine your personal best.

About Stantec

Design Services
10,000+

Stantec empowers clients, people, and communities to rise to the world’s greatest challenges at a time when the world faces more unprecedented concerns than ever before.

We are a global leader in sustainable engineering, architecture, and environmental consulting. Our professionals deliver the expertise, technology, and innovation communities need to manage aging infrastructure, demographic and population changes, the energy transition, and more.

Today’s communities transcend geographic borders. At Stantec, community means everyone with an interest in the work that we do—from our project teams and industry colleagues to our clients and the people our work impacts. The diverse perspectives of our partners and interested parties drive us to think beyond what’s previously been done on critical issues like climate change, digital transformation, and future-proofing our cities and infrastructure.

We are designers, engineers, scientists, project managers, and strategic advisors. We innovate at the intersection of community, creativity, and client relationships to advance communities everywhere, so that together we can redefine what’s possible.

Stantec trades on the TSX and the NYSE under the symbol STN.