About this role
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 possibly building new 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. This includes coordinating data migration efforts during EBS upgrades or cloud adoption initiatives and communicating clearly with non-technical stakeholders about data architecture
Other facts
About Stantec
Stantec provides professional design and consulting services in planning, engineering, architecture, interior design, landscape architecture, surveying, and project management. At Stantec, we offer integrated service delivery. We are one of the few industry leaders that can offer professional services throughout the entire infrastructure and facility life cycle: plan, design, build, monitor, assess, restore, and decommission. Continually striving to balance economic, environmental, and social responsibilities, we are recognized as a world-class leader and innovator in the delivery of sustainable solutions. Stantec supports the delivery of a continuous learning program focused on the principles of sustainable design, for the benefit of personnel, clients, and our community, following through on our goal to make our world a better place. A commitment to continuous learning and the understanding of sustainable design practices is key to Stantec's promise of environmental, social and economic sustainability. Stantec is registered with, and carries out projects funded by all the major International Funding Institutions. Projects are also carried out for private sector clients including utility and large multi-national companies. In 1954, Dr. Don Stanley, an environmental engineer, founded Stanley Associates Engineering Ltd. in Western Canada. Sixty years later, Stantec Consulting Ltd. has grown to encompass over 200 offices in North America and worldwide. The Stantec team of over 15,000 employees has completed more than 60,000 projects for over 6,000 clients in over 100 countries around the world. Our staff have successfully completed projects on six continents from Australia to Zambia for public and private sector clients. Stantec began working internationally in 1967 on a sewerage system in Kuala Lumpur, Malaysia, and has continued to do so for last 45 years. Stantec Consulting International Ltd. (SCIL) provides the specialized professional consulting services of Stantec to international funding agencies and clients in the government, institutional, industrial and commercial sectors. Corporate headquarters are located in the Stantec Centre in Edmonton, Alberta, Canada. Additional international offices are located in Barbados; Puerto Rico; Qatar; the Kingdom of Saudi Arabia, the United Arab Emirates; the United Kingdom; and India. Project offices are located around the world specific to on-going projects.
What you'll do
- The Senior Data Architect will develop and drive the overall data architecture strategy for the PM2PA application, ensuring it meets enterprise standards. This includes overseeing data integration workflows and collaborating with cross-functional teams to align data solutions with business objectives.
Ready to join Stantec?
Take the next step in your career journey