Data Mart Data Warehousing Specialist (EDW Data Mart Specialist)

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.

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 in hosting 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, 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).

About Quantum Sky

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 $112,000-$125,000. 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.

The world the mission operates in is going post-quantum, contested, and machine-speed. Quantum Sky engineers the advantage across cyber, networks, software, and quantum because the mission demands dominance, not parity. We don't follow the map. We draw it.

At Quantum Sky, we believe that success starts with our people. We foster a collaborative, innovative, and mission-driven environment where every team member plays a critical role in shaping the future of technology. Are you ready to join #TeamQuantumSky?

Quantum Sky Engineering LLC is an Equal Opportunity Employer; all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, [sexual orientation, gender identity,] national origin, disability, status as a protected veteran, or any characteristic protected by applicable law.