Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Mart Data Warehousing Specialist (EDW Data Mart Specialist)

$112k - $125k

Quantum Sky

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. Submit a Referral ( Software Powered by ICIMS Location US-CO-Aurora

ID 2026-2280

Category Information Technology Position Type Full-Time Quantum Sky

Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Data Mart Data Warehousing Specialist (EDW Data Mart Specialist) in Aurora, CO vacancy
  •  ...deadlineEstablish daily remote connections and controls for multiple Amazon AWS machinesMaintain and write new interfaces to custodians and other data systemsUpdate and maintain SQL, C# and PowerShell scripts and other tools to automate downloadsReconcile accounts and analyze data... 
    Suggested
    Work at office
    Remote work

    FinFolio

    Denver, CO
    15 hours ago
  • $45k - $55k

     ...professionals who lead medical practices. Since 1926, through data, people, insights, and advocacy, MGMA empowers medical group practices...  ...Group Management Association (MGMA) is looking for a Data Specialist to join our Denver team. The Data Specialist is responsible... 
    Suggested
    Temporary work
    Work experience placement
    Work at office
    Relocation package
    Flexible hours

    Medical Group Management Association

    Denver, CO
    1 day ago
  • $19.96 - $30.94 per hour

     ...Job Summary and Responsibilities As our Data Integrity Specialist, you will manage day-to-day operational functions within Revenue Management to ensure the highest standards of data accuracy. You will play a critical role in maintaining the enterprise master patient... 
    Suggested
    Work experience placement
    Work from home

    CommonSpirit Health

    Greenwood Village, CO
    3 days ago
  •  ...and preliminary interviews are being conducted to support timely hiring should authorization be granted. The Data Management Specialist is responsible for leading grants management data analysis and reporting tasks and serving as the primary data / system point... 
    Suggested
    Full time
    Contract work
    Work at office
    Local area
    Monday to Friday
    Night shift

    Guardians of Honor Future Work

    Denver, CO
    4 days ago
  • $105.4k - $207.8k

    Position Summary Cyber Data Protection Senior ConsultantAre you passionate about helping leading organizations reduce cyber risk, protect critical data, and build resilience in an increasingly complex digital world? If so, consider joining Deloitte & Touche LLP... 
    Suggested
    Local area

    Deloitte

    Denver, CO
    1 day ago
  •  ...timely hiring should authorization be granted. The successful candidate will have a proven track record of leading grants management data analysis and reporting tasks, as well as serving as the primary data / system point of contact between the functional and technical... 
    Full time
    Work at office
    Local area
    Monday to Friday
    Night shift

    Guardians of Honor, LLC

    Denver, CO
    1 day ago
  •  .../or Linux Administration.Position Comments: - Combined role - Senior Help desk mixed with Lab Facilities- Technical Lab Management- Data center setup - small scale (servers, desk top, laptop, etc.)Working with M&A technical install team to successfully onboard various... 
    Immediate start

    Artech

    Denver, CO
    3 days ago
  • $94.3k - $117.9k

    Description Senior Data & AI Analyst (Agent Specialist) Description We are committed to building a workplace where everyone feels heard and respected, and extending our culture of care so that every individual can reach their full potential. We want you to have a sense... 
    Temporary work
    Work at office
    Local area
    Flexible hours

    RES

    Denver, CO
    1 day ago
  • $120k - $125k

     ...across North America, EMEA and Asia Pacific, Vantage has evolved data center design in innovative ways to deliver dramatic gains in...  ...Vantage is seeking a mid-level Data Infrastructure and Systems Specialist to support the Utility Billing team within Business Operations.... 
    Temporary work
    Local area
    Flexible hours

    Vantage Data Centers

    Denver, CO
    1 day ago
  •  ...are curious, take initiative, and want to grow while helping shape the future of an industry. The Payroll Data Implementation Specialist owns the end-to-end payroll data implementation experience for assigned clients across payroll products sold and supported... 
    Work at office
    Local area

    Restaurant365

    Denver, CO
    3 days ago
  •  ...you fast! By applying to this job, you agree to receive periodic text messages from this employer and Homebase about your pending job application. Opt out anytime. Msg & data rates may apply. Powered by Homebase. Free employee scheduling, time clock and hiring tools.... 

    PrepFort

    Aurora, CO
    4 days ago
  •  ...or forklift equipment; Check, verify and audit merchandise to ensure accuracy and identify damaged or defective merchandise; Enter data into remote data terminal; Identify, separate, label, and palletize merchandise; Replenish pick areas; Fill merchandise orders; Load... 
    Part time
    Immediate start
    Remote work
    Shift work

    Dollar General

    Aurora, CO
    1 day ago
  • $21.25 per hour

     ...type.Safety First Culture: We are relentlessly focused on a safe work environment for all employees.Growth Opportunities: We value data-driven decisions and promote from within, offering clear paths for career advancement in operations, team leadership, and management... 
    Hourly pay
    Full time
    Shift work

    Wayfair

    Aurora, CO
    1 day ago
  • Field Representatives We are immediately hiring part time Field Representatives in your area! Are you a military spouse and looking for supplemental income? Make extra spending money to help with your car payment, social activities, and more! Benefits: A comprehensive...
    Extra income
    Part time
    Immediate start
    Flexible hours
    Shift work

    RD SOLUTIONS INC

    Denver, CO
    1 day ago
  • $18.15 - $25.4 per hour

     ...15-$25.40 HourlyColorado law requires the posting of the salary range for advertised jobs. This range is determined based on market data and internal pay practices to establish a minimum and maximum value for a job. Individual base pay is determined based on a variety... 
    For contractors
    Immediate start

    Whitecap

    Aurora, CO
    15 hours ago
  • $20.91 - $45.04 per hour

     ...productive, and connected future. Our broad range of connectivity and sensor solutions enable the distribution of power, signal and data to advance next-generation transportation, renewable energy, automated factories, data centers, medical technology and more. With more... 
    Remote job
    Work experience placement
    Summer work
    Internship
    Local area

    TE Connectivity

    Aurora, CO
    2 days ago
  • $19 - $21.45 per hour

     ...ESSENTIAL DUTIES AND RESPONSIBILITIES:Pick and pack orders per customer specification.Scan product as directed to capture required data.Sort, organize, repack, palletize, track, weight and break down various products to assist production as needed.Ship and receive product... 
    Minimum wage
    Full time
    Temporary work
    Work at office
    Shift work

    US Foods

    Aurora, CO
    1 day ago
  • $19 - $24.7 per hour

     ...applicable and relevant skills and abilities, market demand, Company budget, as well as internal equity and alignment with geographic market data. Living Spaces reserves the right to modify this page at any time. Compensation: $19.00 - $24.70 Overtime pay is available for... 
    Hourly pay
    Full time
    Part time
    For contractors
    Work experience placement
    Local area

    Living Spaces

    Aurora, CO
    4 days ago
  • $91k - $202.8k

     ...workplace culture where all of our employees feel respected, valued and have an opportunity to contribute to the company’s success. As a Data Expert within PNC's Data and Automation GenAI Governance organization, you will be based in Pittsburgh, Strongsville, Denver, Dallas... 
    Full time
    Temporary work
    Part time
    Work experience placement
    Work at office

    The PNC Financial Services Group

    Denver, CO
    7 hours ago
  • $19.29 - $20 per hour

     ...Warehouse Specialist And Forklift DriverCzarnowski is one of the four studios of the Czarnowski Collective. It combines operations, strategy...  ...based on internal equity, internal salary ranges, market data/ranges, applicant's skills and prior relevant experience.Colorado... 
    Monday to Friday

    Czarnowski

    Denver, CO
    1 day ago
  •  ...receive fair and impartial consideration without regard to race, sex, color, national origin, age, disability, veteran status, genetic data, gender identity, sexual orientation, religion or other legally protected status, or any other classification protected by federal,... 
    Local area

    GLS

    Aurora, CO
    4 days ago
  • $17 - $25 per hour

     ...such as pallet jacks, pickers, or scrubbersBasic computer skills to operate warehouse management systems, tools such as scanners, and data entry tasksBasic math skills to manage inventory counts and measurements (addition, subtraction, multiplication, division)Ability to... 
    Hourly pay
    Local area
    Flexible hours
    Night shift

    Brady Plus

    Aurora, CO
    2 days ago
  •  ...receive fair and impartial consideration without regard to race, sex, color, national origin, age, disability, veteran status, genetic data, gender identity, sexual orientation, religion or other legally protected status, or any other classification protected by federal,... 
    Seasonal work
    Local area

    GLS

    Aurora, CO
    1 day ago
  • $12 - $46 per hour

    As a Netflix Tagger , you’ll watch movies, TV shows, documentaries, and other original content on Netflix and assign relevant metadata and tags that help improve Netflix’s recommendation algorithm. Your insights help personalize what millions of viewers see when they...

    Netflix

    Aurora, CO
    3 days ago
  • $21.25 per hour

     ...Multi-Departmental Operations & Execution Inbound & Receiving: Unload, inspect, and scan incoming freight, checking carton-level data for quantity and condition. Order Picking & Fulfillment: Locate, pick, and stage furniture and home goods using handheld scanners... 
    Hourly pay
    Weekly pay
    Part time
    Flexible hours
    Shift work

    Wayfair

    Aurora, CO
    3 days ago
  • $21.25 per hour

     ...:1. Multi-Departmental Operations & ExecutionInbound & Receiving: Unload, inspect, and scan incoming freight, checking carton-level data for quantity and condition.Order Picking & Fulfillment: Locate, pick, and stage furniture and home goods using handheld scanners and... 
    Hourly pay
    Weekly pay
    Part time
    Flexible hours
    Shift work

    Wayfair

    Aurora, CO
    2 days ago
  • $110k - $125k

     ...Business Intelligence Analyst (FM/EDW Business Analyst) to support the...  ...Financials (OFF R12)—and the Enterprise Data Warehouse (EDW) business intelligence data marts. Your day-to-day focus will...  ...federal accounting flows. Data Warehousing & BI Understanding: Working familiarity... 
    Contract work
    For contractors
    Flexible hours
    Shift work

    ClearanceJobs

    Aurora, CO
    1 day ago
  • $24 per hour

    Job DescriptionJob DescriptionWhat you will be doing:Pull, cut, stripe/dye or twist materialFollow standard operating proceduresScrap materialBreakdown unusable reelsComplete rundowns after ordersComplete proper documentation as requiredMaintains cleanliness and organization...
    Temporary work
    Shift work

    Distributor Wire Cable

    Aurora, CO
    4 days ago
  •  ...specialized tracks: Track 1: Enterprise Data Warehouse (EDW) Track — Specializes in multi-terabyte analytical...  ...and reporting databases, complex data warehousing structures (Stage, Archive Stage, and multidimensional reporting marts), and bulk data ingestion pipelines.... 
    Contract work
    For contractors
    Night shift

    ClearanceJobs

    Aurora, CO
    1 day ago
  •  ...Job DescriptionJob DescriptionWarehouse Specialist - Bulk Apothecary Job Description:The Warehouse Specialist for Bulk Apothecary directly...  ...products from higher locations to pick locations below.Using warehousing transport devices like manual pallet jack, electric pallet... 
    Full time
    Casual work
    Day shift

    Natural Essentials

    Aurora, CO
    4 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Mart Data Warehousing Specialist (EDW Data Mart Specialist). Be the first to apply!