Senior Data Warehouse Operations Engineer
US-VA-Fairfax
Careers (External)
Req #: 7895
Type: Full-Time
|
|
||||||||||
|
|||||||||||
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).
Share this job:
