Enterprise Architect- Data Infrastructure ETL

Description

Due to the client contract, you will be assigned, this position requires you to be a U.S. citizen

The Enterprise Architect provides expertise on the design and participates in building of data infrastructure to optimize data processing from a variety of data sources. They Independently design and implement data governance policies and procedures for data handling to manage data consistency, integrity, accuracy, and reliability. Provides expertise on and participates in the design and implementation of rigorous data validation and integrity checks, proactively mitigating data quality issues that could impact data pipeline and model performance.

This role will also leverage advanced knowledge of Extract, Transform, and Load (ETL) processes to design, develop, and optimize automated, scalable, and efficient data pipeline architectures to build reusable data products.

Work independently and collaboratively in an agile development environment with other engineers to develop, maintain, and debug advanced data solutions that are scalable, efficient, cost effective, and reliable

Leads interface testing and integration validation for complex Oracle Health implementations. This role owns the coordination of multiple concurrent interface workstreams—including schedules, status, dependencies, risks, issues, and escalations—to ensure integration deliverables are tested, ready, and aligned with deployment timelines.

As a client-facing leader, the architect facilitates meetings, communicates clearly with VA stakeholders and technical teams, drives decisions and follow-up actions, and serves as a trusted advisor throughout the testing lifecycle. The ideal candidate understands electronic health record workflows, HL7 messaging, and healthcare data exchange across clinical, ancillary, and external systems.

Requirements:

• 8+ years of experience in data engineering, integration architecture, or related technical roles , with advanced expertise designing, building, and optimizing scalable data infrastructure, ETL pipelines, data flows, and reusable data products across diverse data sources.
• Strong expertise in data quality and governance , including designing and implementing data validation, integrity checks, governance policies, data handling standards, and automated controls to ensure data accuracy, consistency, reliability, and compliance.
• Demonstrated experience with healthcare systems integration and interface testing , including knowledge of electronic health record (EHR) workflows, HL7 messaging, healthcare data exchange, and integration across clinical, ancillary, and external systems; Oracle Health implementation experience preferred.
• Due to the client contract, you will be assigned, this position requires you to be a U.S. citizen
• Proven ability to lead complex integration and testing workstreams , managing concurrent schedules, dependencies, risks, issues, escalations, SLAs, and deployment

Responsibilities

Data Processing & Pipelining – Data Requirements, Collection, and Infrastructure:

• Provides expertise on the design and participates in building of data infrastructure to optimize data processing from a variety of data sources.
• Independently analyzes, designs, and troubleshoots data flows based on business needs.
• Participates and designs architecture, performance, and security reviews of the technical solution.
• Adjusts data collection processes that involve indexing and query optimizations for optimal performance.
• Builds Extract, Transform, and Load (ETL) pipelines to support efficient and scalable data collection and extraction.
• Engages with and holds the upstream and downstream teams accountable for the predefined service level agreements (SLAs).

Data Processing & Pipelining – Data Validation & Quality Assurance:

• Provides expertise on and participates in the design and implementation of rigorous data validation and integrity checks, proactively mitigating data quality issues that could impact data pipeline and model performance.
• Mentors less experienced team members to define data annotation and labeling processes to ensure data quality.
• Identifies opportunities for automation of data validation and governance, and implements them.

Data Pipeline and Solutions Engineering – Pipeline Design:

• Leverages advanced knowledge of ETL processes to design, develop, and optimize automated, scalable, and efficient data pipeline architectures to build reusable data products.
• Implements advanced data storage solutions to store the processed data to be used in a scalable, optimized, and efficient way for access and analysis.

Problem Solving:

• Identifies and addresses moderately complex issues by analyzing a wide range of data and/or information to identify solutions in accordance with standard practices.
• Proactively escalates unresolved or critical issues with a thorough assessment and suggests potential solutions.
• Reviews, contributes to, and documents problem solving strategies.

#LI-DJ1

Qualifications

Disclaimer:

Certain U.S. based or U.S. customer or client-facing roles may be required to comply with applicable requirements, such as immunization/occupational health mandates, and/or drug testing requirements.

Range and benefit information provided in this posting are specific to the stated locations only

US: Hiring Range in USD from: $95,000 to $209,500 per annum. May be eligible for bonus and equity.

Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle's differing products, industries and lines of business.

Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.

Oracle US offers a comprehensive benefits package which includes the following:

• Medical, dental, and vision insurance, including expert medical opinion
• Short term disability and long term disability
• Life insurance and AD&D
• Supplemental life insurance (Employee/Spouse/Child)
• Health care and dependent care Flexible Spending Accounts
• Pre-tax commuter and parking benefits
• 401(k) Savings and Investment Plan with company match
• Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.
• 11 paid holidays
• Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.
• Paid parental leave
• Adoption assistance
• Employee Stock Purchase Plan
• Financial planning and group legal
• Voluntary benefits including auto, homeowner and pet insurance

The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted. Career Level - IC4