Job Summary:
Stantec is a company comprising leading professionals dedicated to enhancing business efficiency. They are seeking a Senior Data Architect to design and implement data architecture strategies for the PM2PA application, focusing on optimizing collaboration between project managers and accountants through data integration and application enhancement.
Responsibilities:
• Develop and drive the overall data architecture strategy for PM2PA, including designing scalable data models, data integration workflows, and data governance frameworks that meet enterprise standards.
• Lead the future 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.
• Collaborate closely with other teams – including IT Infrastructure & Operations, Oracle Database Administrators, Software Solutions developers, Business Analysts, and Project Management – to plan and execute PM2PA data-related projects.
• Provide technical leadership and mentorship to database administrators, database developers, and integration specialists on the PM2PA team.
Qualifications:
Required:
• Bachelor’s degree or diploma in computer science, Information Systems, or a related field is required (an equivalent combination of education and experience will be considered).
• 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.
• Working knowledge of OCI services and architecture.
• 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.
• Knowledge of architecture best practices and design patterns, especially in the context of enterprise applications.
• Excellent leadership, communication, and stakeholder management skills.
Preferred:
• Relevant certifications are highly valued. Examples include Oracle Certified Professional (OCP) or Oracle Certified Master (OCM) in Oracle Database or E-Business Suite administration, Oracle Cloud Infrastructure Architect certifications, or Oracle EBS specialization certificates.
• Familiarity with enterprise architecture methodologies and tools.
• Hands-on experience in enterprise ERP migration or upgrade projects.
• Experience with integration platforms (e.g., MuleSoft, Dell Boomi).
Company:
Stantec is a professional services company that provides engineering, architecture, design, and consulting services. Founded in 1954, the company is headquartered in Edmonton, CAN, with a team of 10001+ employees. The company is currently Late Stage.