Senior Data Warehouse Operations Engineer

• Posted 1 day ago • Updated 2 hours ago
Full Time
USD $160,000.00 - 190,000.00 per year
Company Branding Image
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.

About_Company_One
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Fairfax, Virginia

Today

Full-time

Compensation information provided in the description

Fairfax, Virginia

2d ago

Full-time

Compensation information provided in the description

No location provided

Today

Full-time

USD 160,000.00 - 190,000.00 per year

Fairfax, Virginia

Today

Full-time

Compensation information provided in the description

Search all similar jobs