Senior Data Warehouse Operations Engineer

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). Company Overview: GovCIO is a team of transformers--people who are passionate about transforming government IT. Every day, we make a positive impact by delivering innovative IT services and solutions that improve how government agencies operate and serve our citizens.But we can't do it alone. We need great people to help us do great things - for our customers, our culture, and our ability to attract other great people. We are changing the face of government IT and building a workforce that fuels this mission. Are you ready to be a transformer? What You Can Expect Interview & Hiring ProcessIf you are selected to move forward through the process, here’s what you can expect:During the Interview ProcessVirtual video interview conducted via video with the hiring manager and/or teamCamera must be onA valid photo ID must be presented during each interviewDuring the Hiring ProcessEnhanced Biometrics ID verification screeningBackground check, to include:Criminal history (past 7 years)Verification of your highest level of educationVerification of your employment history (past 7 years), based on information provided in your applicationEmployee PerksAt GovCIO, we consistently hear that meaningful work and a collaborative team environment are two of the top reasons our employees enjoy working here. In addition, our employees have access to a range of perks and benefits to support their personal and professional well-being, beyond the standard company offered health benefits, including:Employee Assistance Program (EAP)Corporate DiscountsLearning & Development platform, to include certification preparation contentTraining, Education and Certification Assistance*Referral Bonus ProgramInternal Mobility ProgramPet InsuranceFlexible Work Environment*Available to full-time employees Our employees’ unique talents and contributions are the driving force behind our success in supporting our customers, which ultimately fuels the success of our company. Join us and be a part of a culture that invests in its people and prioritizes continuous enhancement of the employee experience. We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, disability, or status as a protected veteran. EOE, including disability/vets. Posted Pay RangeThe posted pay range, if referenced, reflects the range expected for this position at the commencement of employment, however, base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, education, experience, and internal equity. The total compensation package for this position may also include other compensation elements, to be discussed during the hiring process. If hired, employee will be in an “at-will position” and the GovCIO reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, GovCIO or individual department/team performance, and market factors. Posted Salary Range: USD $160,000.00 - USD $190,000.00 /Yr.

Created: 2026-04-01