Senior Data Architect

Stantec · Tucson, AZ · 5 mo ago

Engineering$134k–$201k/yrFull-time

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

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. Experience applying frameworks like TOGAF for designing large-scale systems, or involvement in establishing data governance councils or standards in an organization, will be an advantage.
ERP Migration/Upgrade Experience: Hands-on experience in enterprise ERP migration or upgrade projects. Preference will be given to candidates who have been involved in migrating EBS to Oracle Cloud or upgrading from older EBS versions to R12.2+ in a cloud or hybrid environment, as well as those who have managed large data migration activities (for example, moving historical data to a cloud data warehouse or implementing Oracle Cloud SaaS alongside EBS).
Additional Domain Knowledge: Experience with integration platforms (e.g., MuleSoft, Dell Boomi) is an added advantage, as it shows versatility in integrating Oracle EBS within a wider IT landscape. Likewise, knowledge of Master Data Management (MDM) practices and tools, or data quality management systems is a plus – ensuring the Senior Data Architect can help drive unified, accurate data across the organization.

Pay & Benefits

Pay Range: $134,100.00 - $201,200.00 Annually
Locations in MN, OH, VT, & Various CA, NY Areas
Pay Range: $147,500.00 - $221,300.00 Annually
Locations in CO, HI, IL, MD & Various CA, NJ Areas
Pay Transparency: In compliance with pay transparency laws, pay ranges are provided for positions in locations where required. Please note, the final agreed upon compensation is based on individual education, qualifications, experience, and work location.

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.