Senior Data Architect

About the role

The Senior Data Architect position is part of a project team designing new workflows and business processes to optimize collaboration between Stantec Project Managers and Project Accountants (PM2PA). This involves enhancing and integrating several existing applications with a focus on the on-premises Oracle E-Business Suite (EBS) database and potentially integrating with Oracle Cloud services.

Responsibilities

• Data Architecture Strategy: 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.
• Oracle EBS & Cloud Integration: Lead the future integration of PM2PA business processes and workflows with Oracle Fusion Cloud. This includes architecting solutions for data exchange between EBS and Oracle Cloud Infrastructure (OCI) or Oracle Cloud applications, using tools like Oracle Integration Cloud (OIC) or Oracle SOA Suite to ensure seamless end-to-end business processes.
• System Performance & Maintenance: Oversee the performance optimization, scalability and reliability of the PM2PA data flows. This may involve tuning Oracle databases or other key data sources, optimizing application performance and planning capacity for growth.
• Security and Compliance: Ensure robust data security measures and compliance protocols are implemented across PM2PA, Oracle EBS and integrated cloud environments.
• Cross-Functional Collaboration: 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. Act as the bridge between technical teams and business stakeholders for all matters related to PM2PA data, ensuring that technical solutions align with business requirements and timelines.
• Technical Leadership & Mentoring: Provide technical leadership and mentorship to database administrators, database developers, and integration specialists on the PM2PA team.

Qualifications

• Education: 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).
• Experience: 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.
• Oracle EBS Expertise: In-depth knowledge of Oracle E-Business Suite (EBS) R12 modules, database and architecture. The ideal candidate has worked with multiple EBS functional areas and understands their underlying data structures and interdependencies.
• Data Modelling: Strong data modelling skills, both relational (3NF) and dimensional (star schema) design. Able to design entity-relationship models for complex enterprise data and use data modelling tools to document and communicate these designs.
• Integration & Middleware: Experience with Oracle integration technologies. This may include Oracle Integration Cloud (OIC) for cloud-based integrations, Oracle SOA Suite and Oracle Service Bus for service-oriented architecture, Oracle Data Integrator (ODI) for ETL tasks, and Oracle REST/SOAP APIs.
• Data Management & Governance: Familiarity with enterprise data management tools and practices. Knowledge of data integration techniques, data cleansing, and Master Data Management (MDM) solutions to maintain a single source of truth across systems. Experience establishing data standards, dictionaries, and governance policies for an ERP environment.
• Analytics & Reporting Tools: Experience with reporting and analytics tools that complement Oracle EBS. For example, ability to work with Oracle Business Intelligence (OBIEE), Oracle Discoverer (legacy), or Oracle Analytics Cloud to design and deliver reports/dashboards using EBS data.
• Operating Systems & Scripting: Proficiency in operating the Oracle EBS tech stack on Linux platforms. Able to script and automate tasks (using shell scripting, Python, etc.) for routine maintenance, data file movement, or monitoring.
• Architecture & Standards: Knowledge of architecture best practices and design patterns, especially in the context of enterprise applications. Familiarity with microservices, API-led architecture, or event-driven architecture is a plus to modernize integration approach. Understanding of TOGAF or similar framework to ensure the architecture aligns with wider enterprise architecture standards is desirable.
• Leadership & Communication: Excellent leadership, communication, and stakeholder management skills. The role requires the ability to liaise with both technical and non-technical stakeholders – translating business requirements into technical solutions and articulating complex architectural concepts in plain language. A collaborative mindset and the ability to influence and drive consensus are critical.

Skills

• Deep technical expertise and strong leadership to guide the enterprise through complex data integration and optimization initiatives.
• Strong data modelling skills, both relational (3NF) and dimensional (star schema) design.
• Familiarity with data warehouse architecture and modelling (e.g., facts/dimensions for BI reporting).
• Experience with Oracle integration technologies.
• Familiarity with building data interfaces (using XML, RESTful services, etc.) and synchronizing data between EBS and other applications in real-time or batch mode.
• Working knowledge of OCI services and architecture.
• Understanding of cloud networking (VPN, FastConnect) for connecting on-premises EBS to Oracle Cloud, and exposure to OCI security and identity management concepts.
• 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.

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, and paid time off.

Temporary/casual employees will have access to group registered retirement savings plan, employee stock purchase program, and group tax-free savings account.