Sr Engineer, Data Integrations & Analytics at AKKODIS
Irvine, CA 92614
About the Job
JOB TITLE Sr Engineer, Data Integrations & Analytics
EMPLOYMENT TYPE: Direct Hire
COMPENSATION: 107k-170k plus a 10% bonus paid out quarterly.
LOCATION DETAILS: Irvine, CA
Instructions: Remote
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.The Sr Engineer, Data Integrations & Analytics should have a positive attitude and excellent communication skills and be committed to achieving predetermined goals and deadlines while working within the policies of the Accounting Department.
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).
Work with customers to ensure that specifications are appropriately detailed to allow proper workflow design.
Develop and document the design of the automated workflow.
Help maintain quality and organization of platform code and data.
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.
Participate in meetings as required.
Other duties as assigned.
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.
Strong understanding of technology and architecture concepts.
Self-motivated, reliable individual capable of working independently as well as part of a team.
Benefits
Medical, dental, and vision insurance
Paid time off
Tuition Reimbursement
401K
Paid time to volunteer in your local community
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.The Sr Engineer, Data Integrations & Analytics should have a positive attitude and excellent communication skills and be committed to achieving predetermined goals and deadlines while working within the policies of the Accounting Department.
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).
Work with customers to ensure that specifications are appropriately detailed to allow proper workflow design.
Develop and document the design of the automated workflow.
Help maintain quality and organization of platform code and data.
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.
Participate in meetings as required.
Other duties as assigned.
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.
Strong understanding of technology and architecture concepts.
Self-motivated, reliable individual capable of working independently as well as part of a team.
Benefits
Medical, dental, and vision insurance
Paid time off
Tuition Reimbursement
401K
Paid time to volunteer in your local community
$107,088.00-$170,000.00 / Annually
Pay Details: $107,000.00 to $170,000.00 per year
Equal Opportunity Employer/Veterans/Disabled
To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to https://www.akkodis.com/en/us/candidate-privacy-policy
The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:
- The California Fair Chance Act
- Los Angeles City Fair Chance Ordinance
- Los Angeles County Fair Chance Ordinance for Employers
- San Francisco Fair Chance Ordinance