Senior Data Warehouse Operations Engineer
About The Position
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.
Requirements
- High School with 10+ years of application development (or commensurate experience)
- Clearance Required: Active Secret with the ability to obtain and hold DEA suitability
- 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.
Nice To Haves
- Experience in operations/SRE for data systems (nice-to-have).
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.
Benefits
- Employee Assistance Program (EAP)
- Corporate Discounts
- Learning & Development platform, to include certification preparation content
- Training, Education and Certification Assistance
- Referral Bonus Program
- Internal Mobility Program
- Pet Insurance
- Flexible Work Environment
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
High school or GED
Number of Employees
501-1,000 employees
