Data Warehousing Specialist

Quantum Sky; Aurora (CO); On-site; USD 120,000 - 150,000; Full time

Job summary

Quantum Sky is seeking a Data Warehousing Specialist (ETL/PowerCenter Journeyman) to maintain and enhance large-scale ETL pipelines within the DHA EOSS program. You will work on EDW data consolidation, batch processing, and data mart delivery in a AWS GovCloud/RHEL environment.

Responsibilities include design, development, and administration of complex ETL mappings, batch automation, and Oracle SQL tuning. Required DoD eligibility, IAT II certification within 90 days, and a bachelor’s degree or

Qualifications

• Citizenship: Must be a U.S. Citizen (mandatory for DoD IT-II privileged access).
• Cybersecurity Certification: DoD 8140.03 / DoDD 8570.01-M IAT Level II within 90 days (e.g., Security+ CE, CCNA Security, CySA+).
• Education & Experience: Bachelor’s degree or 15 years equivalent experience.
• 3–5 years hands-on ETL development, data warehousing, and Informatica administration/development.
• Operational experience with BMC Control-M job scheduling and automation.
• Proficiency in Oracle SQL/PLSQL in hosting environment.
• Experience with DHA, MHS, TRICARE, or DoD financial/accounting systems.
• Healthcare data experience: TEDS, HIPAA, pharmacy records.
• Warehouse Archival & Purge: archiving for Stage and Arc Stage databases.
• AWS GovCloud, S3, EC2, AVHE familiarity.
• Gitlab version control & SBM/ALM change management use.
• Scripting: Perl, Python, or advanced Linux shell scripting.

Responsibilities

• Design, develop, test, and maintain complex ETL mappings, sessions, and workflows using Informatica PowerCenter.
• Administer, schedule, and monitor production batch workflows with BMC Control-M.
• Develop and maintain robust Linux shell/bash scripts.

Skills

ETL development

Data warehousing

Oracle SQL

PL/SQL

Bash scripting

Shell scripting

Linux

Performance tuning

Batch processing

Education

Bachelor's degree in CS/IS/Engineering or 15 years experience

Tools

Informatica PowerCenter

BMC Control-M

GitLab

SBM/ALM

Oracle Database

AWS GovCloud

Linux shell scripts

Job description

Quantum 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 robust shell/bash scripts on Linux.
• Assist with Informatica PowerCenter administration, such as repository backups, user-privileges/roles, and service monitoring.
• Write, debug and fine-tune complex SQL queries, triggers, and views in Oracle Database environments
• Analyze execution plans (EXPLAIN PLAN), SQL Traces indexes and partitioning schemes to eliminate bottlenecks and optimize batch/real-time loads.
• Collaborate with Data Architects and DBAs on physical and logical data modeling, dimensional modeling (Star and Snowflake schemas), and data warehouse design.
• 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. 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 (Gitlab) 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.

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 in hosting environment.
• 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, and pharmacy records).
• Experience with Warehouse Archival & Purge: Implement data archiving strategies for Stage and Arc Stage databases.
• Working knowledge of AWS GovCloud services, S3, EC2, and MedCOI Application Virtualization Hosting Environment (AVHE).
• Experience utilizing version control (Gitlab) and change management tooling (Micro Focus SBM, Quality Center / ALM).
• Scripting capability in Perl, Python, or advanced Linux shell scripting.

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:

• Aurora, CO

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).