Platform

Platform overview

 

Platform overview
Hiring. Reimagined.

Agent

 

Archer
The always-on recruiting agent
HoD

 

On-demand
Hire world class contractors

Solutions

Resources

Save time and effort sourcing top tech talent
Start your free trial
Secure your dream job
Get started

Senior Data Warehouse Modernization Developer

Fairfax, US
Up to $190,000/ year
Data Engineer Data Warehouse Manager
Actively hiring

Senior Data Warehouse Modernization Developer

Govcio LLC
Fairfax, US
Up to $190,000/ year
Data Engineer Data Warehouse Manager
Govcio LLC
Actively hiring

hackajob is partnering with Govcio LLC to fill this position. Create a profile to be automatically considered for this role—and others that match your experience.

 

Overview:

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. 

Responsibilities:

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

Qualifications:

High School with 10+ years application development (or commensurate experience)
Clearance Required: Active Secret with the ability to obtain and hold DEA suitability

Skills / Experience Required:

  • 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.).
  • Experience in modernizing legacy ETL systems is a major plus.
  • 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.

Posted Salary Range: USD $160,000.00 - USD $190,000.00 /Yr.

hackajob is partnering with Govcio LLC to fill this position. Create a profile to be automatically considered for this role—and others that match your experience.

 

Upskill

Level up the hackajob way. Verify your skills, learn brand new ones and test your ability with Pathways, our learning and development platform.

Find out more

Ready to reach your potential?

Find out more