Data Mart Data Warehousing Specialist

Job overview

The Data Mart Data Warehousing Specialist role is onsite in Aurora, CO, with a stated salary range of $112,000–$125,000 per year. The position supports the Defense Health Agency E-Commerce Operational Systems Support program in a secure, cloud-hosted data warehouse environment. The specialist maintains and improves enterprise ETL pipelines that consolidate healthcare claims, financial, procurement, and pharmacy data. The role supports reliable batch processing, reporting, and data availability while meeting operational and security requirements.

What you'll do

• Design, develop, test, debug, and maintain Informatica PowerCenter ETL mappings and workflows
• schedule and monitor batch processing with BMC Control-M
• maintain Linux shell scripts
• support Informatica administration
• write and tune Oracle SQL and PL/SQL
• collaborate on data modeling and warehouse design
• diagnose failed jobs and data discrepancies
• support off-hours, weekend, and holiday maintenance
• assist with security compliance and disaster recovery exercises.

What we're looking for

Skills & competencies

data warehousing specialist

etl

informatica powercenter

bmc control-m

oracle sql

aws govcloud

healthcare data

data marts

aurora co

quantum sky

salary $112,000–$125,000/year

rotational on-call

weekend maintenance

Work arrangement

• Weekend coverage required

Benefits & perks

• Health, dental and vision coverage, 401(k) match, paid time off, short- and long-term disability and life insurance, referral bonuses, professional development reimbursement, and parental leave.

Why this role

Supports DHA healthcare and financial data in AWS GovCloud; requires U.S. citizenship, a qualifying DoD cybersecurity certification at hire or within 90 days, and rotational on-call coverage.

About the employer

Quantum Sky is hiring for this role. Industry: Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services. Sector: 51.