Stantec · 5 hours ago
Senior Data Architect
410 17th Street Suite 1400, Denver, CO, 80202, US
Full-time
Onsite
Senior Level, Lead/Staff
$148K/yr - $221K/yr
10+ years expStantec is a leading professional services company, and they are seeking a Senior Data Architect to enhance and integrate existing applications and databases, particularly focusing on the Oracle E-Business Suite. The role involves driving the strategic data architecture for the PM2PA application and collaborating with cross-functional teams to ensure data solutions align with business objectives.
ArchitectureConsultingInterior DesignProfessional Services
Responsibilities
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
Lead the future integration of PM2PA business processes and workflows with Oracle Fusion Cloud
Oversee the performance optimization, scalability and reliability of the PM2PA data flows
Ensure robust data security measures and compliance protocols are implemented across PM2PA, Oracle EBS and integrated cloud environments
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
Provide technical leadership and mentorship to database administrators, database developers, and integration specialists on the PM2PA team
Qualification
Required
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)
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
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. You should be familiar with the EBS schema, concurrent processing, and EBS configuration from a data perspective
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. Knowledge of data warehouse architecture and modelling (e.g., facts/dimensions for BI reporting) is important for EBS data extraction and analysis
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. 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. 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. 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. 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
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. Understanding how to extract and transform EBS data for use in BI platforms, and knowledge of SQL reporting tools or ad-hoc query tools for end-users
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. Familiar with tools like AutoConfig, concurrent managers, and other EBS administrative utilities is a plus (though the primary focus is on data, a broad understanding of the application tier helps in designing holistic solutions)
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
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
Preferred
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. Certifications in IT service management or architecture frameworks (e.g. TOGAF, Zachman) are also beneficial, indicating a strong grasp of best practices and frameworks
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
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). Such experience demonstrates the ability to handle complex transformations and change management
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
Benefits
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
Paid time off
Company
Stantec
Stantec is a professional services company that provides engineering, architecture, design, and consulting services.
10001+ employees
H1B Sponsorship
Stantec has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2021 (2)
2020 (1)
Funding
Current Stage
Public CompanyTotal Funding
$809.3M2025-05-30Post Ipo Debt· $309.3M
2023-11-20Post Ipo Equity· $250M
2023-06-20Post Ipo Debt· $250M
Leadership Team
Vito Culmone
EVP Finance & CFO
Dave Flynn
Senior Vice President, Health, Safety, Security & Environment
Recent News
Company data provided by crunchbase