JobHabor

Senior Engineer & Data Architect, Financial Systems

Alignment Health

Location
Anywhere in the U.S.
Workplace
Remote
Employment
Full Time
Salary
USD 130,332–195,498/yr
Apply on the employer’s site

Posted 1mo ago

The employer’s full description could not be read from their board. This is a summary of the posting — follow the apply link for the original.

Responsibilities

  • Design, build, and optimize automated data extraction pipelines from Oracle Cloud Financials into the Enterprise Data Lake
  • Maintain a comprehensive data dictionary mapping Oracle's data model across GL, AP, AR, and Fixed Assets
  • Develop and sustain integrations between Oracle Cloud Financials and enterprise systems using Oracle Integration Cloud (OIC), REST/SOAP APIs, FBDI, and ADFdi
  • Build robust error-handling frameworks including automated alerting and dead-letter queue management
  • Apply and maintain security protocols for sensitive financial data including HIPAA-compliant handling and SOX-aligned data lineage controls
  • Manage identity and access controls including Okta SSO, OAuth 2.0, and SFTP key management
  • Configure and maintain Oracle BI Publisher report bursting to deliver financial data to downstream systems
  • Optimize SQL-based data extracts and OTBI queries to ensure reporting workloads do not degrade Oracle transaction processing
  • Act as final technical escalation point for complex incidents involving Oracle Financials data pipelines
  • Drive root-cause analysis, document resolution steps, and implement preventive controls
  • Contribute hands-on technical expertise during Oracle Cloud Financials implementation, leading the integration workstream
  • Proactively identify opportunities to automate data workflows and improve pipeline performance using scripting tools and DevOps principles
  • Participate in on-call rotation for critical integration failures and financial close incidents

Requirements

  • 8+ years of progressive IT experience with a minimum of 5 years in Oracle Cloud ERP or Oracle EBS technical integration and data architecture
  • Demonstrated experience building enterprise-grade data pipelines from Oracle Cloud Financials to a cloud-based Enterprise Data Lake (Azure, Snowflake, AWS S3, or equivalent)
  • Hands-on experience with Oracle Integration Cloud (OIC), FBDI, ADFdi, Oracle BICC, and REST/SOAP API development in a production Oracle Financials environment
  • Proven ability to navigate Oracle's data model across GL, AP, AR, and Fixed Assets modules
  • Experience with data privacy and financial compliance requirements (HIPAA, SOX, GDPR/CCPA) as they apply to moving sensitive financial data out of an ERP
  • Experience in a regulated healthcare, insurance, or financial services environment
  • Bachelor's degree in Computer Science, Software Engineering, Data Analytics, or a related technical field
  • Working proficiency with Oracle Integration Cloud and Azure data engineering tools
  • Working knowledge of data governance principles and their application to financial systems integration
  • SQL, PL/SQL, and Oracle Data Model Navigation
  • Scripting and automation using Python or Java
  • Oracle BI Publisher, OTBI, and reporting infrastructure
  • Identity and access security including Okta SSO, OAuth 2.0, Azure Key Vault, and Oracle Vault

Preferred

  • Prior experience in a Medicare Advantage, managed care, or health insurance organization
  • Experience integrating Oracle Cloud Financials with Workday (HCM/Payroll) in a multi-system enterprise environment
  • Familiarity with Oracle EPM Cloud data pipelines (FDMEE, EPM Integration Agent)
  • Master's degree in Computer Science, Data Engineering, or Information Systems
  • Oracle Cloud Platform Application Integration Specialist certification
  • Oracle Data Management certification
  • Microsoft Azure Data Engineer Associate certification
  • Azure Microsoft Fabric Data Engineer or Azure Databricks Data Engineer certification (strongly preferred)

Skills

  • Oracle Cloud Financials
  • Oracle EBS
  • Oracle Integration Cloud
  • FBDI
  • ADFdi
  • Oracle BICC
  • REST
  • SOAP
  • Azure Data Factory
  • Azure Data Lake
  • Snowflake
  • AWS S3
  • SQL
  • PL/SQL
  • Oracle BI Publisher
  • OTBI
  • Workday
  • Okta SSO
  • OAuth 2.0
  • Azure Key Vault
  • Oracle Vault
  • SFTP
  • Python
  • Java
  • EPM Automate
  • HIPAA
  • SOX
  • GDPR
  • CCPA
  • Oracle EPM Cloud
  • FDMEE
  • EPM Integration Agent
  • Azure Databricks
  • Microsoft Fabric

Similar roles