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 ArchitectClassification:Exempt under the Fair Labor Standards Act (FLSA)Reports to:PresidentWork 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 applicationsDesign scalable, secure solutions for system interoperability and data exchange across Oracle CX and related platformsEstablish architecture standards, patterns, and best practices aligned with Oracle integration and data frameworksDesign and oversee implementation of integrations using Oracle Integration Cloud (OIC), APIs, and event-based architecturesDefine integration patterns (real-time, batch, event-driven) based on business and technical requirementsLead integration solution delivery using OIC, including orchestration design, connectivity, and error handlingEnsure integrations are performant, resilient, and aligned with Oracle Fusion Cloud best practicesDesign enterprise data models aligned with Oracle application structures and lead data migration and conversion efforts from legacy systemsDefine data mapping, transformation rules, and validation strategies to ensure data integrity and consistency across Oracle platformsEstablish and enforce data governance standards and data quality frameworks within Oracle environmentsPartner with stakeholders to align on data definitions, ownership, and usage across systemsCollaborate with cross-functional teams to translate business requirements into Oracle-based technical solutions and provide architectural guidanceDefine testing strategies and continuously optimize integration and data solutions for performance and scalabilityDuties/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