Title: Sr Engineer, Data Integrations & Analytics
Location: Remote (Irvine, CA)
Project: Oracle cloud finance apps is a focus of this role-Epm reconciliation enterprise data management, and rpa machine learning and AI-and this is a brand new role with in team they will manage integration work.
Oracle integration cloud (OIC) 70 processes that span from banking data to 3rd party financing solutions from workday to epic and employee health record into oracle.
Enterprise wide project with data warehouse out of oracle into edw into snowflake someone who can come in and understand integration work. All contracted out wants someone in house.
Not familiar enough with the product to make changes himself. Needs Oracle specific experience to understand that work. 200 applications in tech stack and they have interplay and they can transfer data and tap into them build and design and maintain it moving forward. 1 of not direct reports. Architecting the developer roles into Daniel. Oracle, snowflake would be ideal-data governance would be good. Could help partner with data analytics team. Banded 160-170k 20% bonus wish list.-fronted the first quarters. Total comp for role. Remote position fully dealing with general ledger, procurement etc. and proposals to management
Prescreen Questions
ERP financial application experience?
Development and integration and middle ware experience?
Experience building analytics dashboards?
Architecture
Flexible degree
The Sr. Engineer will support all run/maintain efforts, enhancement and management of all integrations between systems (Oracle - OIC, EPIC, Alteryx, UiPath, Snowflake, Anaplan, Dentira, etc.) for ongoing operations. This role will be accountable for the completeness and accuracy of the data from system to system including the build out of accounting operations KPI metrics and dashboard analytics from EDW (Snowflake).
The primary role of the Sr Engineer, Data Integrations & Analytics, is to work within our Accounting & Finance team to develop and support technical aspects of Oracle Fusion Cloud (ERP/EPM/EDM) such as OIC Integrations, ESS Jobs, Configurations, Rest & Soap calls, API's, FBDI Loads, BIP reports, and BICC. You'll be responsible for all aspects of designing technical solutions, debugging and resolving data issues as well as developing solutions based on specifications. This position will monitor and tune performance of interfaces between Oracle Fusion Cloud and external applications (Workday, Epic, Concur, etc.). You will help provide production support for Fusion Cloud (ERP/EPM/EDM) and responsible for ensuring SDLC procedures are followed when making changes to the system. You will work directly with business users to support and design solutions involving writing technical specifications and requirements for integrations, enhancements, and creating custom reports.
Responsibilities
- Design, build, and maintain our ETL (Extract, Transform, Load) processes.
- Manage the end to end process of implementing automation solutions using Oracle Integration Cloud (OIC).
- Develop and document the design of the automated workflow.
- Participating in functional testing working with the business to document changes to current business practices and assist in process re-engineering and change management planning efforts.
Qualifications
- 5+ years technical experience with Oracle Cloud Fusion ERP & EPM products.
- 5+ years technical experience with API, FBDI loads, BIP, BICC, ESS job configuration.
- 3+ years experience designing and developing integrations in OIC to Oracle ERP Cloud including making REST and SOAP calls, FBDI File Uploads, and extracting ERP Cloud data using BIP reports.
- 3+ years' experience performing integrations between OIC and 3rd party applications both inbound and outbound - File based, web service and XML based.
- Extensive experience in SQL/PLSQL, Logical SQL Queries and Performance Tuning.
- Solid exposure to varied cloud databases such as Snowflake, Oracle Autonomous DW (ADW), etc.
- Education: Bachelor's Degree in Computer Science, Computer Engineering, MIS or related field.
Preferred
- Experience working with ERP systems data such as Oracle EBS/Fusion (Purchasing, Order Management, and/or Financials modules)
- Experience in a multi-regional healthcare, retail, or dental company.
Knowledge/Skills/Abilities
- Knowledge in XSD, WSDL, SOAP, XSLT and REST.
- Experience with Python scripting, Groovy Scripting, SQL, PL/SQL, Java, XML, JDeveloper, Oracle BI Publisher, APEX, Visual Builder Cloud Service, OIC, FBDI, ADFDi, Cloud Framework native to Oracle Fusion Application.
- Expertise in data integration, data quality, and performance optimization will be essential in supporting our organization's data-driven decision-making efforts.
- Advanced skills in analyzing, designing, developing, implementing and maintaining application code in a variety of contexts.
- Demonstrated experience in application development, complex code development, application testing and component design.
- Extensive experience working with process owners and business analysts to analyze, standardize and optimize business processes, translate requirements into functional/technical designs, and build robust technical solutions.