Senior Data Warehouse Operations Engineer

Fairfax, VA, US • Posted 8 days ago • Updated 1 hour ago
Full Time
On-site
Compensation information provided in the description
Fitment

Dice Job Match Score™

🛠️ Calibrating flux capacitors...

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

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 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: appfeed
  • Position Id: 17468_7895
  • Posted 8 days ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Fairfax, Virginia

2d ago

Full-time

Compensation information provided in the description

Fairfax, Virginia

Today

Full-time

Compensation information provided in the description

Reston, Virginia

Today

Full-time

USD 125,100.00 - 225,200.00 per year

Chantilly, Virginia

Today

Full-time

USD 86,800.00 - 198,000.00 per year

Search all similar jobs