DescriptionQuantum Sky is searching for a Data Warehousing Specialist (ETL Data Warehouse Specialist - Journeyman) supporting the Defense Health Agency (DHA) E-Commerce Operational Systems Support (EOSS) program, you will maintain, enhance, and monitor large-scale enterprise data extraction, transformation, and loading (ETL) pipelines.
The DHA E-Commerce Data Warehouse (EDW) is an integrated, non-volatile, time-variant, subject-oriented repository consolidating private-sector healthcare claims, TRICARE Encounter Data System (TEDS) feeds, Oracle Federal Financials (OFF) data, PRISM contracting data, and pharmacy/rebate metrics. Operating in a MedCOI-hosted Amazon Web Services (AWS) GovCloud East environment running Red Hat Enterprise Linux (RHEL) and Oracle DBMS, you will ensure high reliability, zero data loss, and seamless execution of daily, monthly, and year-end batch processing cycles.
Responsibilities:
1. ETL Development, Administration & Workflow Automation
- Design, develop, test, debug, and maintain complex ETL mappings, mapplets, sessions, and workflows using Informatica PowerCenter to integrate disparate healthcare, financial, and procurement datasets.
- Administer, schedule, and monitor production batch processing workflows using BMC Control-M, ensuring timely end-to-end data pipelines from landing zones into Staging, Archive Stage (Arc Stage), and downstream reporting Data Marts (FRDM, ORDM, PRDM, CRDM).
- Develop and maintain automated shell scripts (Perl, Bash) and database stored procedures (PL/SQL) for file ingestion, data transformation, validation, and file transfer management.
- Support data processing for high-volume healthcare transactions, including TRICARE Encounter Data System (TEDS) claims, pharmacy rebate reconciliation, and financial ledger data.
2. Sustainment & Production Operations
- Monitor and execute operational batch schedules in accordance with the DHA ECS Operational Schedule (nightly execution between 6:00 PM – 6:00 AM MT and designated weekend maintenance windows).
- Diagnose and perform corrective maintenance on failed ETL jobs, data discrepancies, and processing errors within strict contract service level agreements (SLAs), adhering to required 4-hour to 8-hour restoration limits during financial closing periods.
- Perform routine database and ETL tuning, optimizing SQL queries, bottleneck identification, and workflow load partitioning to achieve peak system throughput.
- Support scheduled off-hours, weekend, and holiday maintenance, including Month-End, Quarter-End, and Fiscal Year-End accounting processing.
3. Enhancement & Modernization Projects
- Contribute to key PWS modernization milestones, including:
- Warehouse Archival & Purge: Implement data archiving strategies for Stage and Arc Stage databases.
- CARS & G-Invoicing Integration: Support the ingestion and ETL reconciliation of Central Accounting Reporting System (CARS) Transactional Data Extract (CTDE) files and Treasury G-Invoicing data.
- BEA SFIS & SLOA Compliance: Update ETL logic to reflect annual Standard Financial Information Structure (SFIS) and Standard Line of Accounting (SLOA) data standards.
- CRM System Integration Test (CRMSIT): Prepare and validate ETL test data feeds for biennial end-to-end administrative payment testing with TEDS and Oracle Federal Financials.
- Collaborate with Data Architects, Database Administrators (DBAs), and Business Analysts to produce technical documentation, Solution Design Documents (CDRL 0010), and Requirements Traceability Matrices (RTM).
4. Environment Management & Security Compliance
- Adhere to IEEE 1074-compliant Software Development Life Cycle (SDLC) best practices across Dev, System Test, QA/Pre-Prod, and Production tiers within the MedCOI AWS GovCloud environment.
- Conduct all code migrations and version control using enterprise repositories (Git / GitHub) in coordination with the Configuration Management Board (CMB).
- Assist DBAs and Systems Administrators in remediating Security Technical Implementation Guides (STIGs), Information Assurance Vulnerability Alerts (IAVAs), and Assured Compliance Assessment Solution (ACAS) findings on ETL platforms.
- Participate in annual DHA ECS Continuity of Operations (COOP) and Disaster Recovery exercises.
Qualifications
Required:
- Citizenship: Must be a U.S. Citizen (mandatory for DoD IT-II privileged access).
- Cybersecurity Certification: Must possess or obtain a DoD 8140.03 / DoDD 8570.01-M IAT Level II certification (e.g., CompTIA Security+ CE, CCNA Security, CySA+) within 90 days (3) months of hire.
- Education & Experience:
- Bachelor’s degree from an accredited university in Computer Science, Information Systems, Engineering, or a related discipline, or 15 years of equivalent documented professional experience in lieu of a degree.
- Minimum of 3 to 5 years of hands-on experience in ETL development, data warehousing, and Informatica administration/development for enterprise applications.
- Demonstrated operational experience with BMC Control-M job scheduling and automation.
- Solid proficiency in Oracle SQL, PL/SQL, and working with Oracle databases inhosting environment.
Desired:
- Prior experience supporting the Defense Health Agency (DHA), Military Health System (MHS), TRICARE, or DoD financial/accounting enterprise systems.
- Experience handling healthcare claim data structures (e.g., TEDS, HIPAA 837/835 EDI transactions, pharmacy NCPDP records).
- Familiarity with federal accounting datasets, Standard Financial Information Structure (SFIS), and Treasury reporting interfaces (CARS, G-Invoicing).
- Working knowledge of AWS GovCloud services, S3, EC2, and MedCOI Application Virtualization Hosting Environment (AVHE).
- Experience utilizing version control (Git / GitHub) and change management tooling (Micro Focus SBM, Quality Center / ALM).
Clearance:
- Must possess an active Tier 3 (T3) NACLC / Secret eligibility or favorable Public Trust IT-II adjudication. Must be capable of obtaining and maintaining a DoD Common Access Card (CAC).
Location:
Shift:
- Standard 40-hour work week with rotational on-call requirements. Flexible scheduling is supported to balance extra hours worked during critical financial close periods (End of Month / End of Fiscal Year).
Compensation:
- Compensation is unique to each candidate and relative to the skills and experience they bring to the position. The salary range for this position is typically between $119,000-$125,500. This does not guarantee a specific salary as compensation is based upon multiple factors such as education, experience, certifications, and other requirements, and may fall outside of the above-stated range.
Benefits:
- Highlights of our benefits include Health/Dental/Vision, 401(k) match, Paid Time Off, STD/LTD/Life Insurance, Referral Bonuses, professional development reimbursement, and parental leave.
