DHA-EOSS Data Mart Data Warehousing Specialist (EDW Data Mart Specialist)
About The Position
Quantum Sky is seeking a Data Warehousing Specialist (ETL Data Warehouse Specialist - Journeyman) to support the Defense Health Agency (DHA) E-Commerce Operational Systems Support (EOSS) program. The role maintains, enhances, and monitors large-scale enterprise ETL pipelines. The DHA E-Commerce Data Warehouse consolidates healthcare claims, TRICARE Encounter Data System (TEDS) feeds, Oracle Federal Financials data, PRISM contracting data, and pharmacy and rebate metrics. The environment is hosted in MedCOI AWS GovCloud East and runs Red Hat Enterprise Linux and Oracle DBMS. The specialist helps ensure reliable processing and data integrity across daily, monthly, and year-end batch cycles. The role covers ETL development and administration, production batch operations, database and workflow tuning, modernization and integration work, technical documentation, environment management, and security compliance. Work includes standard 40-hour weeks with rotational on-call requirements, scheduled off-hours and weekend maintenance, and flexible scheduling to balance extra hours during critical financial close periods. The position is located in Aurora, Colorado.
Requirements
- Must be a U.S. citizen.
- Must possess or obtain a DoD 8140.03 / DoDD 8570.01-M IAT Level II certification, such as CompTIA Security+ CE, CCNA Security, or CySA+, within 90 days (three months) of hire.
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related discipline, or 15 years of equivalent documented professional experience in lieu of a degree.
- Three to five years of hands-on experience in ETL development, data warehousing, and Informatica administration or development for enterprise applications.
- Operational experience with BMC Control-M job scheduling and automation.
- Proficiency in Oracle SQL and PL/SQL and experience working with Oracle databases in a hosting environment.
- Must possess 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).
Nice To Haves
- Experience supporting the DHA, Military Health System, TRICARE, or DoD financial/accounting enterprise systems.
- Experience with healthcare claim data structures such as TEDS, HIPAA 837/835 EDI transactions, or pharmacy NCPDP records.
- Familiarity with federal accounting datasets, SFIS, and Treasury reporting interfaces such as CARS and G-Invoicing.
- Working knowledge of AWS GovCloud services, S3, EC2, and the MedCOI Application Virtualization Hosting Environment (AVHE).
- Experience with Git/GitHub and change-management tools such as Micro Focus SBM and Quality Center / ALM.
Responsibilities
- Design, develop, test, debug, and maintain Informatica PowerCenter ETL mappings, mapplets, sessions, and workflows integrating healthcare, financial, and procurement datasets.
- Administer, schedule, and monitor production batch workflows using BMC Control-M, covering data pipelines from landing zones through Staging, Archive Stage, and downstream reporting Data Marts.
- Develop and maintain Perl and Bash shell scripts and PL/SQL stored procedures for file ingestion, transformation, validation, and file-transfer management.
- Support processing of TEDS claims, pharmacy rebate reconciliation, and financial ledger data.
- Monitor and execute operational batch schedules, including nightly processing and designated weekend maintenance windows.
- Diagnose and correct failed ETL jobs, data discrepancies, and processing errors within contract SLAs, including restoration limits during financial close periods.
- Tune databases and ETL workflows, optimize SQL queries, identify bottlenecks, and partition workflow loads to improve throughput.
- Support off-hours, weekend, and holiday maintenance for month-end, quarter-end, and fiscal year-end accounting processing.
- Implement data archiving strategies for Stage and Arc Stage databases.
- Support ingestion and ETL reconciliation of CARS Transactional Data Extract files and Treasury G-Invoicing data.
- Update ETL logic for annual SFIS and SLOA data standards.
- Prepare and validate ETL test data feeds for biennial CRMSIT end-to-end administrative payment testing with TEDS and Oracle Federal Financials.
- Collaborate with Data Architects, DBAs, and Business Analysts to produce technical documentation, Solution Design Documents (CDRL 0010), and Requirements Traceability Matrices.
- Follow IEEE 1074-compliant SDLC practices across Dev, System Test, QA/Pre-Prod, and Production tiers in the MedCOI AWS GovCloud environment.
- Coordinate code migrations and version control through Git/GitHub repositories and the Configuration Management Board.
- Assist DBAs and Systems Administrators with remediation of STIGs, IAVAs, and ACAS findings on ETL platforms.
- Participate in annual DHA ECS Continuity of Operations and Disaster Recovery exercises.
Benefits
- Health, dental, and vision coverage
- 401(k) match
- Paid Time Off
- Short-term and long-term disability insurance
- Life insurance
- Referral bonuses
- Professional development reimbursement
- Parental leave
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
