Senior Data Warehouse Modernization Developer

Govcio LLC • Fairfax, VA

5d • Onsite

About The Position

GovCIO is currently hiring for a Senior Data Warehouse Modernization Developer with an active Secret clearance to modernize data warehouse pipeline architecture by gradually reducing reliance on SSIS and SQL-only patterns, introducing Python‑based ETL, improving modularity, and setting the groundwork for a future move into PySpark, distributed compute, and eventually Databricks or similar cloud platforms. Candidates should have an in-depth understanding of the Kimball model and experience incrementally replacing or re‑platforming components. This position will be located in Merrifield, VA and will be a fully onsite position.

Requirements

• High School with 10+ years application development (or commensurate experience)
• Active Secret with the ability to obtain and hold DEA suitability
• Solid SQL and understanding of Kimball dimensional modeling.
• Strong Python: Pandas, SQLAlchemy, packaging, module structure, unit testing.
• Experience with PySpark or Spark (or willingness to ramp quickly).
• Familiarity with cloud data platforms (Azure, AWS, etc.).
• Ability to read, interpret, and redesign SSIS/SQL-based ETL logic.
• Understanding of data ingestion, transformation, and structured warehouse design.
• Experience with Git, CI/CD pipelines, and modern development practices.

Nice To Haves

• Experience in modernizing legacy ETL systems is a major plus.

Responsibilities

• Learn and understand the existing Kimball-modeled SQL Server structure over time.
• Reverse-engineer SSIS packages and convert them into Python-based modular ETL pipelines.
• Build reusable Python frameworks for extraction, transformation, and loading.
• Begin introducing PySpark for scalable transformation patterns.
• Contribute to planning a future transition path (Databricks, Azure Synapse, Snowflake, etc.).
• Improve orchestration, dependency management, and data quality practices.
• Identify technical debt and modernize aging ETL components.
• Collaborate with EDW SMEs to understand business logic and lineage.
• Build documentation and repeatable processes for modernization.

What This Job Offers

• Career Level: Senior
• Education Level: High school or GED
• Number of Employees: 501-1,000 employees