Remote Senior Oracle Data Engineer & Systems Architect

Alignment Healthcare USA, LLC in; Orange (CA); Remote; USD 130,000 - 195,000; Full time

Job summary

Alignment Health seeks a Senior Engineer, Oracle Finance Systems Integration & Data Architect (remote) to design, build, and maintain high-volume data pipelines connecting Oracle Cloud Financials to the Enterprise Data Lake and downstream analytics platforms.

You will collaborate with Finance stakeholders and the DTS Data Engineering team to ensure data integrity and secure data flow for executive reporting, CMS compliance, and strategic decision-making.

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 data to the enterprise model.
• Engineer and Support Application Integrations: develop synchronous and asynchronous integrations between Oracle Cloud Financials and enterprise systems (Workday, third-party platforms) using OIC, REST/SOAP APIs, FBDI, and ADFdi; implement robust error-handling and alerting.
• Ensure Financial Data Compliance and Security: apply security protocols for HIPAA/SOX data, manage identity and access (Okta SSO, OAuth 2.0, SFTP) to protect data and maintain audit trails.
• Build and Sustain Reporting Infrastructure: configure Oracle BI Publisher reporting, optimize OTBI queries, and ensure reporting workloads do not impact transactional processing.
• Serve as Tier 3/4 Escalation Expert for Integration Incidents: drive root-cause analysis and preventive controls to improve reliability.
• Support Implementation and Continuous Improvement: contribute to Oracle Cloud Financials implementation, lead integration workstream, automate workflows, and raise standards with Python/Java and DevOps practices.

Job description

Alignment Health seeks a Senior Engineer, Oracle Finance Systems Integration & Data Architect (remote) to design, build, and maintain high-volume data pipelines connecting Oracle Cloud Financials to the Enterprise Data Lake and downstream analytics platforms.

You will collaborate with Finance stakeholders and the DTS Data Engineering team to ensure data integrity and secure data flow for executive reporting, CMS compliance, and strategic decision-making.