Integration Engineer

Rice University•United States,

4h•$120,000 - $130,000•Onsite

About The Position

Systems Integrations, a division of the Office of Information Technology (OIT), is dedicated to delivering and supporting the transfer and integration of data across enterprise systems. The Integration Engineer designs, develops, maintains, and supports solutions that integrate applications across the enterprise or its units/departments. The position evaluates existing components or systems to determine integration requirements and ensures final solutions meet organizational needs. The ideal candidate will demonstrate experience working on integration platforms with Oracle Cloud ERP, HCM, and EPM, leveraging Oracle’s Integration Cloud (OIC) solution. This position is mission-critical and requires a high level of flexibility, attention to detail, and ownership.

Requirements

Bachelor’s degree in computer science or a related field
In lieu of the education requirement, additional related experience beyond what is required may be substituted on an equivalent year-for-year basis
3+ years of related experience in application programming or development, with at least 3 years in SQL/PLSQL, Oracle Integration Cloud (OIC), or equivalent
In lieu of the experience requirement, additional related education beyond what is required may be substituted on an equivalent year-for-year basis
Expertise in designing, developing, testing, and deploying applications
Proficiency in application design and data modeling
Ability to define and solve logical problems for highly technical applications
Strong communication skills with both technical and non-technical clients
Ability to lead activities on structured team development projects
Ability to select, adapt, and effectively use a variety of integration methods
Knowledge of application domains

Nice To Haves

5 years of experience
Extensive experience in extracting, transforming, and loading data from heterogeneous source systems such as flat files, XML, JSON, Excel, Oracle/relational databases, and APIs; strong proficiency in SQL and PL/SQL development
Hands-on knowledge of HCM (technical), including the ability to write/update custom BI reports; understanding of HCM (Core HR, Payroll, Benefits) tables and ability to join them to write/fix reports
Implementation experience using OIC, PL/SQL, BI reports, and HDL
Hands-on knowledge of HDL processes and experience implementing integrations between HCM and various vendors
Strong knowledge of SQL (Oracle) and PL/SQL
Experience designing solutions

Responsibilities

Designs, develops, maintains, and supports solutions that integrate applications across the enterprise or its units/departments.
Evaluates existing components or systems to determine integration requirements and ensures final solutions meet organizational needs.
Ability to analyze, architect, design, develop, configure, support, and optimize robust integration solutions using Oracle Integration Cloud services.
Excellent client-facing skills, working closely with internal and external stakeholders to gather requirements and design complex business application and data integration solutions.
Translates business processes and requirements into technical integration requirements and design.
Provides production system support and issue resolution.
Serves as a project leader, as needed, for projects of moderate complexity.
Compares, evaluates, and implements new features and technologies, and integrates them into the computing environment.
Works on and partners with teams on key initiatives, including Oracle Analytics Cloud (OAC), Salesforce, and analytic reporting solutions.
Mentors lower-level engineers.
Designs and develops new integrations in support of application or functionality deployments in ERP, HCM, EPM, and Salesforce.
Evaluates and translates business requirements into technical specifications.
Regularly participates in solution development efforts.
Supports quality assurance activities, including unit and regression testing; develops and documents test scripts; and effectively interacts with our Jira-based requirement and test management suite.
Participates in code reviews and maintains source code quality and change control.
Conducts regular system reviews to identify opportunities and solutions that improve capabilities, eliminate technical debt, and deliver business value.
Constructs solutions that reuse shared or common services or establish reusable services (service-oriented approach).
Identifies project technology risks and communicates credible scenarios and feasibility issues to project and senior management.
Collaborates with enterprise teams to ensure technical deliverables meet client technology, security, and supportability standards, policies, frameworks, and controls.