Integration & 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 CX, HCM, ERP, SCM, or EPM, our experts help businesses leverage the power of the cloud to enhance agility, scalability, and cost-efficiency.

In addition to consulting, our digital marketing agency, Apex Theorem, focuses on driving digital transformation. Our Marketing Acceleration Advisors create proprietary, results-driven solutions that increase lead conversion, enhance customer engagement, and drive revenue growth.

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 capabilities and positioning us for an even greater impact.

Job Title:Integration & Data Architect

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

Reports to:President

Work Location/Travel: Work is remote or on-site. Percentage of travel, where the travel occurs, such as locally or in specific countries or states, and whether the travel is overnight, varies. This resource must be willing and able to travel as required by the customer project. This is generally negotiable, but not always, and could be as high as 75%.

Job Summary:

This client-facing role designs and delivers integration and data solutions across enterprise systems. It focuses on system connectivity, data movement, and ensuring data is accurate, consistent, and usable across applications.

Essential Functions:

• Define end-to-end integration and data architecture across Oracle Fusion Cloud and enterprise applications
• Design scalable, secure solutions for system interoperability and data exchange across Oracle CX and related platforms
• Establish architecture standards, patterns, and best practices aligned with Oracle integration and data frameworks
• Design and oversee implementation of integrations using Oracle Integration Cloud (OIC), APIs, and event-based architectures
• Define integration patterns (real-time, batch, event-driven) based on business and technical requirements
• Lead integration solution delivery using OIC, including orchestration design, connectivity, and error handling
• Ensure integrations are performant, resilient, and aligned with Oracle Fusion Cloud best practices
• Design enterprise data models aligned with Oracle application structures and lead data migration and conversion efforts from legacy systems
• Define data mapping, transformation rules, and validation strategies to ensure data integrity and consistency across Oracle platforms
• Establish and enforce data governance standards and data quality frameworks within Oracle environments
• Partner with stakeholders to align on data definitions, ownership, and usage across systems
• Collaborate with cross-functional teams to translate business requirements into Oracle-based technical solutions and provide architectural guidance
• Define testing strategies and continuously optimize integration and data solutions for performance and scalability

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:

·Thorough understanding of information technology procedures and practices.

·Flexible to changing needs.

·Organized with attention to detail, and good at follow-up

·Willingness to get hands on with the product.

·Works well with a team

·Excellent verbal and written communication skills

·Excellent analytical, logical thinking, and problem-solving skills.

·Proficient with, or able to quickly become proficient with, a range of general and specialized applications, software, and hardware used in the organization and the industry.

·Proficient with Microsoft Office Suite or related software.

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, and/or 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 degree in Computer Science, Information Systems, or related field (or equivalent experience)

·8+ years of experience in integration, data architecture, or related roles

·Strong experience designing and delivering integrations using Oracle Integration Cloud (OIC)

·Proven experience with enterprise system integrations, including API design, web services (REST/SOAP), and middleware solutions

·Experience leading data migration and conversion efforts, including ETL processes and data mapping from legacy systems

·Strong understanding of relational databases and SQL

·Experience working on Oracle Fusion Cloud implementations (CX, ERP, HCM, or similar)

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.