Senior Data Warehouse Operations Engineer
Govcio LLC, Fairfax, VA, United States
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.
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.