Stantec

Senior Data Architect

Stantec

full-time

Posted on:

Location Type: Hybrid

Location: Edmonton • Canada

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

CloudLinuxOracle

About the role

  • Design, implementation, and maintenance of the PM2PA data environment
  • Collaborate with a cross-functional team to align data solutions with PM2PA business objectives
  • Develop and drive the overall data architecture strategy for PM2PA
  • Lead the integration of PM2PA business processes and workflows with Oracle Fusion Cloud
  • Oversee the performance optimization, scalability and reliability of the PM2PA data flows
  • Ensure robust data security measures and compliance protocols are implemented across PM2PA, Oracle EBS and integrated cloud environments
  • Act as the bridge between technical teams and business stakeholders for all matters related to PM2PA data

Requirements

  • 10+ years of experience in data architecture, data analysis, or related IT roles, with significant hands-on experience designing and implementing solutions for Oracle E-Business Suite environments.
  • In-depth knowledge of Oracle E-Business Suite (EBS) R12 modules, database and architecture.
  • Strong data modelling skills, both relational (3NF) and dimensional (star schema) design.
  • Experience with Oracle integration technologies including Oracle Integration Cloud (OIC), Oracle SOA Suite, and Oracle Data Integrator (ODI).
  • Working knowledge of Oracle Cloud Infrastructure (OCI).
  • Familiarity with enterprise data management tools and practices.
  • Experience with reporting and analytics tools that complement Oracle EBS.
  • Proficiency in operating the Oracle EBS tech stack on Linux platforms and scripting.
Benefits
  • 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
  • paid time off
  • Temporary/casual employees will have access to
  • group registered retirement savings plan
  • employee stock purchase program
  • group tax-free savings account
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data architecturedata analysisdata modellingOracle E-Business SuiteOracle Integration CloudOracle SOA SuiteOracle Data IntegratorOracle Cloud Infrastructurereporting toolsanalytics tools
Soft Skills
collaborationleadershipcommunicationperformance optimizationscalabilityreliabilitydata securitycompliance