Senior Data Architect

Salary: £63,000 - 103,000 per year

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.
• Track record of leading complex integration projects or ERP data initiatives in large organizations.
• In-depth knowledge of Oracle E-Business Suite (EBS) R12 modules, database, and architecture.
• Experience working with multiple EBS functional areas, such as Oracle Financials (GL, AP, AR), Project Billing and Costing, and Human Capital Management.
• Strong understanding of EBS schema, concurrent processing, and EBS configuration from a data perspective.
• Strong data modelling skills, including relational (3NF) and dimensional (star schema) design.
• Experience designing entity-relationship models for complex enterprise data and using data modelling tools to document and communicate designs.
• Knowledge of data warehouse architecture and modelling for BI reporting.
• Experience with Oracle integration technologies such as Oracle Integration Cloud (OIC), Oracle SOA Suite, Oracle Service Bus, Oracle Data Integrator (ODI), and Oracle REST/SOAP APIs.
• Familiarity with building data interfaces using XML, RESTful services, and synchronizing data between EBS and other applications in real-time or batch mode.
• Working knowledge of OCI services and architecture.
• Experience deploying or managing applications on OCI and using cloud services such as Oracle Autonomous Data Warehouse (ADW) or Oracle Cloud databases with EBS.
• Understanding of cloud networking, including VPN and FastConnect, for connecting on-premises EBS to Oracle Cloud.
• Exposure to OCI security and identity management concepts.
• Familiarity with enterprise data management tools and practices, including data integration, data cleansing, and Master Data Management (MDM).
• Experience establishing data standards, dictionaries, and governance policies for an ERP environment.
• Experience with reporting and analytics tools such as Oracle Business Intelligence (OBIEE), Oracle Discoverer, or Oracle Analytics Cloud.
• Understanding of how to extract and transform EBS data for BI platforms and use SQL reporting tools or ad-hoc query tools.
• Proficiency operating the Oracle EBS tech stack on Linux platforms.
• Ability to script and automate tasks using shell scripting, Python, or similar tools.
• Familiarity with AutoConfig, concurrent managers, and other EBS administrative utilities.
• Knowledge of architecture best practices and design patterns, including microservices, API-led architecture, or event-driven architecture.
• Understanding of TOGAF or similar architecture frameworks.
• Excellent leadership, communication, and stakeholder management skills.
• Ability to liaise with both technical and non-technical stakeholders and translate business requirements into technical solutions.
• Collaborative mindset with the ability to influence and drive consensus.
• Relevant certifications such as Oracle Certified Professional (OCP), Oracle Certified Master (OCM), OCI Architect certifications, Oracle EBS specialization certificates, IT service management certifications, or architecture framework certifications are highly valued.
• Familiarity with enterprise architecture methodologies and tools.
• Experience applying frameworks like TOGAF for designing large-scale systems.
• Experience establishing data governance councils or standards.
• Hands-on experience in enterprise ERP migration or upgrade projects.
• Experience migrating EBS to Oracle Cloud or upgrading older EBS versions to R12.2+ in a cloud or hybrid environment.
• Experience managing large data migration activities, such as moving historical data to a cloud data warehouse or implementing Oracle Cloud SaaS alongside EBS.
• Experience with integration platforms such as MuleSoft or Dell Boomi.
• Knowledge of Master Data Management (MDM) practices and tools, or data quality management systems.

Responsibilities:

• Develop and drive the overall data architecture strategy for PM2PA.
• Design scalable data models, data integration workflows, and data governance frameworks that meet enterprise standards.
• Ensure the architecture supports current and future business needs with an emphasis on data quality, consistency, and governance.
• Lead the future integration of PM2PA business processes and workflows with Oracle Fusion Cloud.
• Architect data exchange solutions between EBS and Oracle Cloud Infrastructure (OCI) or Oracle Cloud applications using tools such as Oracle Integration Cloud (OIC) or Oracle SOA Suite.
• Oversee the performance optimization, scalability, and reliability of PM2PA data flows.
• Tune Oracle databases or other key data sources, optimize application performance, and plan capacity for growth.
• Ensure that data storage, indexing, and retrieval mechanisms are efficient.
• Ensure that disaster recovery and high-availability solutions are in place.
• Implement robust data security measures and compliance protocols across PM2PA, Oracle EBS, and integrated cloud environments.
• Collaborate closely with IT Infrastructure & Operations, Oracle Database Administrators, Software Solutions developers, Business Analysts, and Project Management.
• Act as the bridge between technical teams and business stakeholders for all matters related to PM2PA data.
• Ensure technical solutions align with business requirements and timelines.
• Coordinate data migration efforts during EBS upgrades or cloud adoption initiatives.
• Communicate clearly with non-technical stakeholders about data architecture.

Technologies:

• API
• Architect
• Business Intelligence
• Cloud
• Data Warehouse
• ERP
• Linux
• Marketing
• MuleSoft
• ODI
• Oracle
• Python
• REST
• SOAP
• SQL
• Security
• TOGAF
• VPN
• XML
• microservices
• ETL

More:

At Stantec, we have leading professionals across finance, procurement, human resources, information technology, marketing, corporate development, HSSE, real estate, legal, and practice services. We foster a caring culture where everyone can thrive and build a stronger, more resilient organization through teamwork and collaboration. We are seeking a Senior Data Architect to join a project team focused on designing new workflows and business processes to improve collaboration between Stantec Project Managers and Project Accountants (PM2PA). This role is based in Canada, with primary location in Edmonton and other locations including Markham. The position is regular, full time, and offers a pay range of $105,400.00 to $164,600.00 annually depending on location, education, qualifications, experience, and work location. Eligible employees have access to a comprehensive benefits package that may include health, dental, and vision plans, wellness programs, retirement and savings plans, insurance coverage, tuition reimbursement, professional membership fee coverage, and paid time off.

last updated 36 week of 2026