At a Glance
- Tasks: Lead data architecture strategy and optimise workflows for project management.
- Company: Join Stantec, a collaborative company with a passion for innovation.
- Benefits: Enjoy health plans, retirement savings, tuition reimbursement, and more.
- Other info: Great career growth opportunities in a supportive culture.
- Why this job: Make a real impact by enhancing data solutions in a dynamic environment.
- Qualifications: 10+ years in data architecture with Oracle EBS expertise required.
The predicted salary is between 72000 - 88000 £ per year.
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.
We are seeking a Senior Data Architect to join a project team that will be designing new workflows and business processes to optimize and simplify collaboration between Stantec Project Managers and Project Accountants (aka PM2PA). This will involve enhancing and integrating several existing applications and their databases with a focus on the on-premises Oracle E-Business Suite (EBS) database and potentially integration with Oracle Cloud services in the future.
In this senior-level role, you will drive the strategic data architecture for the PM2PA application. You will be responsible for the design, implementation, and maintenance of the PM2PA data environment – including integration points with our on-premises Oracle EBS system, multiple custom applications and various data sources (including the Stantec Data Store (SDS), a centralized data store with the ability to serve EBS data to consuming applications, and replicate updates back into EBS from those applications).
As a key technical leader, the Senior Data Architect will collaborate with a cross-functional team to align data solutions with PM2PA business objectives, and act as a strategic advisor on leveraging Oracle EBS, various data repositories (e.g., SDS) and potentially cloud technologies to meet the needs of this strategic project. This role requires both deep technical expertise and strong leadership to guide the enterprise through complex data integration and optimization initiatives.
Key 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. Ensure the architecture supports current and future business needs with an emphasis on data quality, consistency, and governance.
- 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. Ensure that data storage, indexing, and retrieval mechanisms are efficient and that disaster recovery and high-availability solutions are in place.
- 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.
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. This should include a track record of leading complex integration projects or ERP data initiatives in large organizations.
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 – for example, Oracle Financials (GL, AP, AR), Project Billing and Costing, Human Capital Management – 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.
Oracle Cloud Infrastructure (OCI): Working knowledge of OCI services and architecture. Experience deploying or managing applications on OCI (compute, storage, networking) and using cloud services such as Oracle Autonomous Data Warehouse (ADW) or Oracle Cloud databases in conjunction with EBS is a plus.
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.
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.
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.
Preferred Qualifications
- Professional Certifications: 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.
- Enterprise Architecture & Methodologies: Familiarity with enterprise architecture methodologies and tools.
- ERP Migration/Upgrade Experience: Hands-on experience in enterprise ERP migration or upgrade projects.
- Additional Domain Knowledge: Experience with integration platforms (e.g., MuleSoft, Dell Boomi) is an added advantage.
Pay Range: Locations Outside of Lower Mainland - BC & Various locations in Ontario-$105,400.00 - $158,100.00 Annually. Locations in Lower Mainland -- BC, GTA & Ottawa Ontario-$114,600.00 - $164,600.00 Annually.
Benefits Summary: 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.
The benefits information listed above may not apply to union positions because benefits for such positions are governed by applicable collective bargaining agreements.
Primary Location: Canada | AB | Edmonton
Other Locations: Canada | ON | Markham
Organization: 1374 IT Services-CA Corporate-Edmonton AB
Employee Status: Regular
Business Justification: New Position
Travel: No
Schedule: Full time
Job Posting: 04/02/2026 05:02:42
Req ID: 1003733
Senior Data Architect in London employer: Stantec
Stantec is an exceptional employer that empowers its employees to make a significant impact in the energy sector through innovative projects like hydropower and energy building design. With a strong focus on professional development, flexible working arrangements, and a collaborative work culture, Stantec fosters an environment where engineers can thrive and grow their careers while contributing to meaningful change in the industry.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Data Architect in London
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Stantec!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Senior Data Architect at Stantec.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Stantec.
✨Apply Directly through Our Website
When you find a suitable opening like Senior Data Architect at Stantec, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Senior Data Architect in London
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Stantec, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Stantec. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Stantec
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Stantec!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
