Apply Now

Senior Data Warehouse Operations Engineer

• Posted 1 day ago • Updated 2 hours ago

Full Time

USD $160,000.00 - 190,000.00 per year

GovCIO

Fitment

Dice Job Match Score™

🧠 Analyzing your skills...

Job Details

Skills

Recruiting
Management
API
Root Cause Analysis
Incident Management
Reliability Engineering
Data Warehouse
Application Development
Security Clearance
Microsoft SQL Server
Microsoft SSIS
Extract
Transform
Load
Production Support
SFTP
FTP
Batch File
Workflow
SQL
CA Workload Automation AE
BMC Control-M

Summary

GovCIO is currently hiring for a Senior Data Warehouse Operations Engineer with an active Secret clearance to provide hands-on operational support for the existing 15-year-old Kimball-modeled Enterprise Data Warehouse, built on SQL Server and SSIS. This position will be located in Merrifield, VA and will be a fully onsite position.

Responsibilities

This role provides hands-on operational support for the existing 15-year-old Kimball-modeled Enterprise Data Warehouse, built on SQL Server and SSIS, and ensures stable operations; monitors daily ETL loads; handles job failures; supports file transfers; and serves as the first line of triage for data pipeline issues. This is an operational, reliability-focused position to reduce load on the current overwhelmed ops resource.

Key Responsibilities:

Monitor, troubleshoot, and support SSIS package execution and daily ETL workflows.
Manage file transfers (SFTP/FTP/API drops) and ensure ingestion processes run without interruption.
Perform root-cause analysis for job failures; escalate to developers when needed.
Maintain SQL Server jobs, schedules, alerts, and system health.
Support incident response and on-call rotation for EDW operations.
Document operational runbooks and improve system reliability.
Assist in minor SQL/data fixes or downstream adjustments (non-architectural).
Coordinate with EDW developers on enhancements or fixes.

Qualifications

High School with 10+ years of application development (or commensurate experience)
Clearance Required: Active Secret with the ability to obtain and hold DEA suitability

Skills / Experience Required:

Strong SQL and SQL Server experience.
Hands-on SSIS operations (execution, logging, troubleshooting).
ETL operations background (production support).
Experience with SFTP/FTP, batch file handling, and data ingestion workflows.
Familiar with job schedulers (SQL Agent, Autosys, Control-M, etc.).
Strong diagnostic and troubleshooting skillset.
Experience in operations/SRE for data systems (nice-to-have).

Posted Salary Range

USD $160,000.00 - USD $190,000.00 /Yr.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10443217
Position Id: 7895
Posted 1 day ago

Company Info

About GovCIO

GovCIO is a rapidly growing provider of advanced technology solutions and digital services for the federal government. Combining our extensive federal experience with the latest innovations in IT and disruptive approaches, our experts develop comprehensive solutions to meet the most pressing demands of today’s government agencies. From the U.S. military to Health and Human Services, we have an impressive track record of helping our customers optimize how they operate.

We’re transforming government IT, empowering our federal customers to meet the challenges of today while building the government of tomorrow.

Go to company profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Fairfax, Virginia

•

Today

Overview: GovCIO is currently hiring for a Senior Data Warehouse Operations Engineer with an active Secret clearance to provide hands-on operational support for the existing 15-year-old Kimball-modeled Enterprise Data Warehouse, built on SQL Server and SSIS.This position will be located in Merrifield, VA and will be a fully onsite position. Responsibilities: This role provides hands-on operational support for the existing 15-year-old Kimball-modeled Enterprise Data Warehouse, built on SQL Serve

Full-time

Compensation information provided in the description

Senior Data Warehouse Operations Engineer

Fairfax, Virginia

•

2d ago

Full-time

Compensation information provided in the description

Senior Data Warehouse Modernization Developer

No location provided

•

Today

GovCIO is currently hiring for a Senior Data Warehouse Modernization Developer with an active Secret clearance to modernize data warehouse pipeline architecture by gradually reducing reliance on SSIS and SQL-only patterns, introducing Python-based ETL, improving modularity, and setting the groundwork for a future move into PySpark, distributed compute, and eventually Databricks or similar cloud platforms. Candidates should have an in-depth understanding of the Kimball model and experience increm

Full-time

USD 160,000.00 - 190,000.00 per year

Senior Data Warehouse Modernization Developer

Fairfax, Virginia

•

Today

Overview: GovCIO is currently hiring for a Senior Data Warehouse Modernization Developer with an active Secret clearance to modernize data warehouse pipeline architecture by gradually reducing reliance on SSIS and SQL-only patterns, introducing Python?based ETL, improving modularity, and setting the groundwork for a future move into PySpark, distributed compute, and eventually Databricks or similar cloud platforms. Candidates should have an in-depth understanding of the Kimball model and experie

Full-time

Compensation information provided in the description

Search all similar jobs

Senior Data Warehouse Operations Engineer

GovCIO

Dice Job Match Score™

Job Details

Skills

Summary

Company Info

About GovCIO

Similar Jobs