Senior Data Warehouse Operations Engineer

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).