Senior Data Architect

Senior Data Architect

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 decisions.

Technical Leadership & Mentoring:
Provide technical leadership and mentorship to database administrators, database developers, and integration specialists on the PM2PA team.

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. 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. You should be familiar with the EBS schema, concurrent processing, and EBS configuration from a data perspective.

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. Knowledge of data warehouse architecture and modelling (e.g., facts/dimensions for BI reporting) is important for EBS data extraction and analysis.

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. Familiarity with building data interfaces (using XML, RESTful services, etc.) and synchronizing data between EBS and other applications in real‑time or batch mode.

Oracle Cloud Infrastructure (OCI):
Working knowledge of OCI services and architecture. Experience deploying or…