Senior Engineer & Data Architect, Financial Systems

Alignment Health•Remote CA Outside Bay Area, CA

107d•$130,332 - $195,498•Remote

About The Position

Alignment Health is seeking a Senior Engineer, Oracle Finance Systems Integration & Data Architect to be the hands-on technical owner responsible for designing, building, and maintaining high-volume data pipelines. This role connects Oracle Cloud Financials to the enterprise data ecosystem, including the Enterprise Data Lake, downstream analytics platforms, and key third-party integrations. The engineer will work closely with the Senior Director of Enterprise Financial Systems, Finance stakeholders, and the DTS Data Engineering team to ensure accurate and secure financial data flow for executive reporting, CMS regulatory compliance, and strategic decision-making. This role is crucial for operational performance and compliance in a Medicare Advantage organization, particularly concerning risk adjustment financial reconciliation, Stars ratings cost reporting, CMS bid submissions, and encounter data accuracy.

Requirements

8+ years of progressive IT experience, with a minimum of 5 years dedicated to 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 to locate, extract, and map financial data.
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; equivalent professional experience may be considered.
Demonstrated working proficiency with Oracle Integration Cloud and Azure data engineering tools through formal implementation or project experience.
Working knowledge of data governance principles and their application to financial systems integration.

Nice To Haves

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) in addition to core ERP integrations.
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).

Responsibilities

Architect and Maintain Financial Data Pipelines: Design, build, and optimize automated data extraction pipelines from Oracle Cloud Financials into the Enterprise Data Lake using Oracle BICC, Azure Data Factory, and cloud-native storage platforms (Azure Data Lake, Snowflake). Maintain a comprehensive data dictionary mapping Oracle's data model (GL, AP, AR, Fixed Assets) to the enterprise canonical data model.
Engineer and Support Application Integrations: Develop and sustain synchronous and asynchronous integrations between Oracle Cloud Financials and enterprise systems (Workday, third-party financial platforms, banking systems) using Oracle Integration Cloud (OIC), REST/SOAP APIs, FBDI, and ADFdi. Build robust error-handling frameworks with automated alerting and dead-letter queue management.
Ensure Financial Data Compliance and Security: Apply and maintain security protocols for sensitive financial data, including HIPAA-compliant data handling, SOX-aligned data lineage controls, and field-level encryption using Azure Key Vault and Oracle Vault. Manage identity and access controls (Okta SSO, OAuth 2.0, SFTP key management).
Build and Sustain Reporting Infrastructure: Configure and maintain Oracle BI Publisher report bursting for scheduled delivery of financial data. Optimize SQL-based data extracts and OTBI queries to prevent degradation of Oracle transaction processing performance.
Serve as Tier 3/4 Escalation Expert for Integration Incidents: Act as the final technical escalation point for complex incidents involving Oracle Financials data pipelines, integration failures, or data discrepancies. Drive root-cause analysis, document resolutions, and implement preventive controls.
Support Implementation and Continuous Improvement: Provide technical expertise during Oracle Cloud Financials implementation, leading the integration workstream. Post go-live, identify opportunities to automate data workflows, reduce manual data handling, and improve pipeline performance using scripting tools (Python, Java) and DevOps principles.