Data Mart Data Warehousing Specialist (EDW Data Mart Specialist)

Quantum Sky•Aurora, CO

6d•$112,000 - $125,000•Onsite

About The Position

Quantum Sky is hiring a Data Warehousing Specialist 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 for the DHA E-Commerce Data Warehouse, an integrated repository that 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 Database Management System. The specialist helps ensure reliable processing and data integrity across daily, monthly, and year-end batch cycles. The position develops and supports Informatica PowerCenter ETL workflows, administers and monitors batch schedules with BMC Control-M, writes Linux shell scripts and Oracle SQL, and helps optimize warehouse performance. It also supports production operations, including troubleshooting failed jobs and data discrepancies, database and ETL tuning, and scheduled financial close processing. The role contributes to secure environment management across development, test, pre-production, and production tiers, including code migrations, security remediation, and continuity and disaster recovery exercises. The position is located in Aurora, Colorado. It has a standard 40-hour work week with rotational on-call requirements and flexible scheduling to balance additional hours during critical financial close periods. The stated salary range is $112,000–$125,000, with actual compensation depending on candidate-specific factors.

Requirements

Must be a U.S. citizen.
Must possess or obtain a DoD 8140.03 / DoDD 8570.01-M IAT Level II cybersecurity certification, such as CompTIA Security+ CE, CCNA Security, or CySA+, within 90 days (three months) of hire.
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.
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

Prior experience supporting DHA, the Military Health System, TRICARE, or DoD financial/accounting enterprise systems.
Experience with healthcare claim data structures, including TEDS, HIPAA, and pharmacy records.
Experience implementing data archiving strategies for Stage and Archive Stage databases.
Working knowledge of AWS GovCloud services, S3, EC2, and the MedCOI Application Virtualization Hosting Environment (AVHE).
Experience using GitLab and change-management tooling such as Micro Focus SBM and Quality Center / ALM.
Scripting capability in Perl, Python, or advanced Linux shell scripting.

Responsibilities

Design, develop, test, debug, and maintain Informatica PowerCenter ETL mappings, mapplets, sessions, and workflows that integrate healthcare, financial, and procurement datasets.
Administer, schedule, and monitor production batch workflows with BMC Control-M, including data movement through landing zones, Staging, Archive Stage, and downstream reporting Data Marts.
Develop and maintain shell/bash scripts on Linux.
Assist with Informatica PowerCenter administration, including repository backups, user privileges and roles, and service monitoring.
Write, debug, and tune Oracle SQL queries, triggers, and views; analyze execution plans and SQL traces and optimize indexes and partitioning schemes.
Collaborate with Data Architects and DBAs on physical and logical data modeling, dimensional modeling, and data warehouse design.
Support processing of high-volume healthcare transactions, including TEDS claims, pharmacy rebate reconciliation, and financial ledger data.
Monitor and execute operational batch schedules in accordance with the DHA ECS Operational Schedule, including nightly processing and designated weekend maintenance windows.
Diagnose and correct failed ETL jobs, data discrepancies, and processing errors within contract service-level agreements and restoration limits.
Perform routine database and ETL tuning, identify bottlenecks, and optimize workflow load partitioning.
Support off-hours, weekend, and holiday maintenance, including month-end, quarter-end, and fiscal-year-end accounting processing.
Follow IEEE 1074-compliant SDLC practices across development, system test, QA/pre-production, and production environments.
Conduct code migrations and version control through enterprise repositories in coordination with 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.