Integration Engineer

Rice University is ranked among the nation’s top 20 universities and is seeking an Integration Engineer to support the transfer and integration of data across enterprise systems. The role involves designing, developing, and maintaining integration solutions while ensuring they meet organizational needs and working closely with stakeholders to gather requirements.

Responsibilities:

• 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
• Performs all other duties as assigned
• 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

Requirements:

• Bachelor's degree in computer science or a related field
• 3+ years of related experience in application programming or development, with at least 3 years in SQL/PLSQL, Oracle Integration Cloud (OIC), or equivalent
• 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
• 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