Sr Engineer, Data Integrations and Analytics

$107,088 - $180,169/Yr

Pacific Dental Services - Irvine, CA

Full-time - Mid Level

Irvine, CA

Ambulatory Health Care Services

About the position

Now is the time to join Pacific Dental Services. You will have opportunities to learn new skills from our team of experienced professionals. If you're ready to take your career to the next level and gain valuable experience, today! 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.
• Participate 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.

Requirements

• 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.
• Bachelor's Degree in Computer Science, Computer Engineering, MIS or related field.

Nice-to-haves

• 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.

Benefits

• Medical, dental, and vision insurance
• Paid time off
• Tuition Reimbursement
• 401K
• Paid time to volunteer in your local community