Back to jobs

Data Mart Data Warehousing Specialist (EDW Data Mart Specialist)

Pay
$112,000–125,000/yearAnnual period assumed — pay source
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:
Read the full posting
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: FULL_TIME
From the employer’s posting

What you’ll work on

Full posting
  • Design and maintain Informatica PowerCenter ETL mappings and workflows

  • Run and monitor production batch workflows in BMC Control-M

  • Diagnose and fix failed ETL jobs within 4-8 hour restoration limits

  • Tune Oracle SQL queries and load partitioning for throughput

  • Support weekend, holiday, and month-end or year-end processing

From the employer’s posting
Design, develop, test, debug, and maintain complex ETL mappings, mapplets, sessions, and workflows using Informatica PowerCenter
Administer, schedule, and monitor production batch processing workflows using BMC Control-M
Diagnose and perform corrective maintenance on failed ETL jobs, data discrepancies, and processing errors within strict contract service level agreements (SLAs)
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.

Before you apply

Work authorization
US citizens onlyMust be a US Citizen (mandatory for DoD IT-II privileged access)

What you’ll bring

All qualifications

Core 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.
  • Prior experience supporting the Defense Health Agency (DHA), Military Health System (MHS), TRICARE, or DoD financial/accounting enterprise systems.
  • Solid proficiency in Oracle SQL, PL/SQL, and working with Oracle databases in hosting environment.
  • 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.
  • Experience utilizing version control (Gitlab) and change management tooling (Micro Focus SBM, Quality Center / ALM).
Qualification wording
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.
Prior experience supporting the Defense Health Agency (DHA), Military Health System (MHS), TRICARE, or DoD financial/accounting enterprise systems.
Solid proficiency in Oracle SQL, PL/SQL, and working with Oracle databases in hosting environment.
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.
Experience utilizing version control (Gitlab) and change management tooling (Micro Focus SBM, Quality Center / ALM).
Education & alternatives
- 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.

Benefits in the posting

Full benefits wording
  • 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.

From the employer’s posting.

Apply at Quantum Sky

Posting record

Report an error

Actively hiringFirst seen by us 1 day ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20261 day ago
Recorded sightings
2
Last seen by us
Nov 19, 2026
Employer says posted
Nov 5, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

Lower than most similar jobs

$112K–$125K against $127K–$190K, the middle half of what similar US postings state.

From 2,396 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 1

Early. Similar jobs usually come down between day 6 and day 56.

From 14,503 similar postings that came down. Coming down is not always a hire.

Quantum Sky is hiring

6 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Bash
  • Perl
  • PL/SQL
  • Python
  • Shell
  • SQL
  • AWS
  • Control-M
  • Informatica
  • Oracle
  • S3
Where the posting names them
- 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.
- 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:
- 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:
- 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.
- 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.
- 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.
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:
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).
- 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).
- 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.
- 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.
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
- 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.

Your next step

Complete your application on careers-quantumsky.icims.com. The employer’s form will show what is required.

Applying through iCIMS

  • You start with your email. New applicants then create a login, and returning ones sign in.
  • Upload your resume before you fill anything in: iCIMS fills some profile fields from it.
  • Check your status on the employer’s iCIMS Dashboard, under Past Job Submittals.

Already applied? Track this application

Job description

View original posting ↗

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.

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 14% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 860, the most 1,353, and the latest week had 1,020.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
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:
Location & working pattern

Aurora, CO

Working pattern and location restrictions need checking in the full posting.

Work authorization
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.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.