Oracle ERP Data Architect

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:

Enterprise Data Architecture

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

Integration Architecture

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

Leadership & Continuous Improvement

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

Work Environment:

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
• Accident insurance
• Hospital Indemnity Insurance

• Profit-Sharing Program
• 401(k) Program (available after eligibility period)
• 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

• Life Insurance
• Pre-Paid Legal
• Pet Insurance

• Paid Time Off, Paid Sick Leave, Paid Holidays
• Flexible Scheduling
• Remote Work
• Learning and Development Activities
• Employee Assistance Program