Oracle ERP Data Architect

Apex Clearing Corporation; United States; On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Comprehensive Medical Insurance (PPO)

Health Savings Account (HSA)

Dental Insurance

Vision Insurance

Employer-Paid Life Insurance

Remote Work

Travel Incentive

Job summary

Apex IT is seeking an Oracle ERP Data Architect to design and govern enterprise data architecture across Oracle Cloud applications, with a focus on ERP, SCM, and CX. You will lead data modeling, migration, and integration efforts ensuring data accuracy and scalability.

The ideal candidate brings deep Oracle Cloud data knowledge, experience with large-scale data conversion programs, and the ability to align data strategies with business objectives across finance, supply chain, and customer

Qualifications

• 7+ years of experience in data architecture, data modeling, and data management focusing on Oracle ERP environments.
• Experience leading large-scale data migration and conversion projects for Oracle ERP environments.
• Ability to design data models and governance frameworks across ERP, SCM, CX.

Responsibilities

• Design and maintain enterprise-wide data architecture strategies across Oracle ERP, SCM, and CX applications.
• Lead data migration, mapping, and transformation initiatives between legacy systems and Oracle Cloud.
• Architect and oversee integrations between Oracle ERP, CX, HCM, and third‑party applications.

Skills

Oracle ERP

Data architecture

Data migration

Data integration

Data governance

Education

Bachelor’s or Master’s in Computer Science / Information Systems

Tools

Oracle Integration Cloud (OIC)

ETL technologies

Job description

Apex IT is a global consulting firm that provides award-winning services to transform the customer, employee, and student experiences. Since 1997, Apex IT our Salesforce and Oracle experts have provided a full range of enterprise solutions including CRM and related applications that support sales, marketing, and service; financial reporting; HR; and Business Intelligence. As a remote company, we have top talent all over the United States and India and are continuously growing. We provide our team with a flexible work-life balance in addition to the traditional benefits.

About Apex IT

Apex IT is a global consulting firm that provides award-winning services to transform customer, employee, and student experiences. Our Salesforce and Oracle experts understand the transformative power of Salesforce and Oracle platforms in driving business growth and success. We guide businesses through the entire Salesforce implementation process, from planning and configuration to customization and integration. We provide end-to-end consulting, implementation, and migration services for Oracle Cloud applications. Whether it's Oracle ERP Cloud, HCM Cloud, or CX Cloud, our experts help businesses leverage the power of the cloud to enhance agility, scalability, and cost-efficiency. With our headquarters in the US and a strong business unit in India, we are excited to begin expanding into Colombia. This expansion will allow us to leverage Colombia's growing tech talent pool, strengthening our global capabilities and positioning us for an even greater impact on the global stage.

Job Title: Oracle ERP Data Architect

Classification: Exempt under the Fair Labor Standards Act (FLSA)

Reports to: President

Work Location/Travel: Work is remote or on-site at client location. Percentage of travel to client sites, where the travel occurs, such as locally or in specific countries or states, and whether the travel is overnight, varies.

Job Summary

The Oracle ERP Data Architect is responsible for designing, governing, and optimizing enterprise data architecture across Oracle Cloud applications, with a primary focus on ERP, Supply Chain Management (SCM), and Customer Experience (CX) platforms. This role provides strategic leadership for data modeling, migration, integration, and governance initiatives, ensuring data accuracy, scalability, and alignment with business objectives. The ideal candidate brings deep expertise in Oracle Cloud data structures, large-scale data conversion programs, and enterprise integrations, enabling seamless end-to-end business processes across finance, supply chain, customer, and service operations. Experience with Oracle Field Service is a plus.

Essential Functions

• Design and maintain enterprise-wide data architecture strategies across Oracle ERP, SCM, and CX applications.
• Develop scalable, secure, and efficient data models that support end-to-end business processes.
• Establish architectural standards, data modeling best practices, and design patterns to ensure consistency across the Oracle ecosystem.

Data Migration, Conversion & Transformation

• Lead large-scale data migration and conversion initiatives for Oracle Cloud implementations, upgrades, and acquisitions.
• Define data mapping, transformation, cleansing, and validation strategies between legacy and Oracle Cloud systems.
• Ensure data accuracy, completeness, and integrity throughout the migration lifecycle.
• Architect and oversee integrations between Oracle ERP, SCM, CX, HCM, and third‑party applications.
• Design data exchange frameworks utilizing Oracle Integration Cloud (OIC), APIs, middleware, and ETL technologies.
• Ensure seamless movement of master and transactional data across enterprise platforms.

Data Governance & Quality Management

• Define and implement enterprise data governance frameworks, policies, and standards.
• Establish processes for data quality monitoring, stewardship, security, and compliance.
• Develop validation, reconciliation, and auditing procedures to maintain trusted business data.

Stakeholder Collaboration & Solution Design

• Partner with business leaders, functional consultants, project teams, and technical resources to define data requirements and solutions.
• Translate business objectives into scalable data architecture designs that support operational and strategic goals.
• Provide subject matter expertise related to Oracle data models, integrations, and migration strategies.
• Lead data architecture workstreams during implementations and digital transformation initiatives.
• Mentor project teams and provide guidance on data architecture best practices.
• Identify opportunities for automation, process optimization, and improved data management capabilities.
• Stay current on Oracle Cloud product enhancements and emerging data technologies.

Duties/Responsibilities

• Maintain and pursue continuing education opportunities, such as training and certification exams.
• Participate on internal projects.
• Provide expertise and help to others, as needed, on projects.
• Performs other duties as assigned.

Competency

• Strong expertise in Oracle ERP, SCM, and CX data models and architecture.
• Experience with enterprise data migration, conversion, and integration.
• Familiarity with Oracle Field Service data structures and integrations is a plus.
• Understanding of end-to-end business processes across Finance, Supply Chain, Customer Experience, and Service Operations.

Supervisory Responsibilities

• May assist with training members of the technical staff.
• May conduct interviews.
• Assigns duties and responsibilities and oversees workflow of project staff.
• May conduct project performance evaluations that are timely and constructive.

The work environment is remote or on-site at a client location. While remote, employees are expected to provide office space for themselves with a professional background (including virtual backgrounds) and noise level. A reliable and consistent internet connection is required.

Physical Requirements

• Prolonged periods sitting or standing at a desk and working on a computer.
• Bending, sitting lifting, driving.

Position Type and expected hours of work

• Full time work during Apex IT business hours and, at times, outside of business hours, if required.

Required Education and Experience

• Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field.
• 7+ years of experience in data architecture, data modeling, and data management, with a focus on Oracle ERP applications.
• Proven experience leading large-scale data migration and conversion projects for Oracle ERP environments

Other Duties

This job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required. Duties, responsibilities, and activities may change, or new ones may be assigned at any time, with or without notice.

Comprehensive Medical Insurance (Preferred Provider Organization (PPO) High Deductible or Copay plans) with Wellness Program and Teledoc

Health Savings Account (HSA)

Medical Flexible Spending Accounts (FSA) – Full and Limited Purpose

Dental Insurance Options

Vision Insurance Options

Critical Illness Insurance

Hospital Indemnity Insurance

Profit-Sharing Program

Travel Incentive

Employer-Paid Life and Accidental Death & Dismemberment Insurance

Employer-Paid Short-Term Disability

Employer-Paid Long-Term Disability

Dependent Care Flexible Spending Account (FSA)

Bi-Weekly Pay via Direct Deposit

Employee Discount Marketplace

Voluntary Benefits

Life Insurance

Pet Insurance

Work-Life Balance

Flexible Scheduling

Remote Work

Learning and Development Activities

Employee Assistance Program