Data Warehousing Specialist - Data Marts (EDW)

Quantum Sky; Aurora (CO); On-site; USD 115,000 - 155,000; Full time

Benefits offered by this job

Health/Dental/Vision

401(k) match

Paid Time Off

STD/LTD/Life Insurance

Referral Bonuses

Professional development reimbursement

Parental leave

Job summary

Quantum Sky seeks a detail-oriented Data Mart Data Warehousing Specialist to join the DHA EOSS contract in Aurora, Colorado. You will administer, enhance, and maintain DHA E-Commerce Data Warehouse reporting data marts (FRDM, ORDM, PRDM, CRDM) in a cloud-hosted MedCOI AWS GovCloud East environment, using OAS/OBIEE/BI Publisher.

Responsibilities include data mart administration, report development, user access management with CAC PKI, and ensuring Section 508 accessibility.

Qualifications

• Bachelor’s degree required; substitution allowed for 15 years of experience in data warehousing or BI.
• 3+ years BI reporting, data mart maintenance, and SQL development.
• Experience with Oracle BI tools and data governance.

Responsibilities

• Administer and sustain DHA ECS reporting data marts including FRDM, ORDM, PRDM, CRDM.
• Develop pixel-perfect reports and dashboards using BI Publisher and OAS.
• Manage user access, security filters, and CAC PKI authentication.
• Ensure Section 508/WCAG compliance for dashboards and reports.
• Support testing, UAT, and SLA targets for monthly closeouts.

Skills

BI reporting

SQL development

Data warehousing

OAS/OBIEE/BI Publisher

Education

Bachelor’s degree in Computer Science, Information Systems, Software Engineering, Mathematics, or related field

Tools

Oracle Analytics Server (OAS)

OBIEE

BI Publisher

Oracle WebLogic

Linux (RHEL)

Job description

Quantum Sky seeks a detail-oriented Data Mart Data Warehousing Specialist to join the DHA EOSS contract in Aurora, Colorado. You will administer, enhance, and maintain DHA E-Commerce Data Warehouse reporting data marts (FRDM, ORDM, PRDM, CRDM) in a cloud-hosted MedCOI AWS GovCloud East environment, using OAS/OBIEE/BI Publisher.

Responsibilities include data mart administration, report development, user access management with CAC PKI, and ensuring Section 508 accessibility.