user avatar

Data Warehouse Modernization Developer

GovCIO

Posted yesterday

Job Requirements

Fairfax, VA
Secret Polygraph Unspecified
Career Level not specified
$185,000 - $185,000

Job Description

GovCIO is currently hiring for a Data Warehouse Modernization Developer with an active Secret clearance to focus on modernizing 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. This position is located in Merrifield, VA and is an onsite position.

Responsibilities

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

  • Bachelor's with 12+ years (or commensurate experience)
  • Clearance Required: Active Secret with the ability to obtain and hold DEA suitability.

Skills and Experience:
  • In depth understanding of the Kimball model in place, and experience incrementally replacing or re-platforming components.
  • 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 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 $185,000.00 - USD $185,000.00 /Yr.
group id: 10384469

After the acquisition of Salient CRGT, we're excited to introduce the new GovCIO. As we evolve towards our next phase as a company, we’ve refreshed our brand to better position ourselves in the government marketplace.

job ad image
Find GovCIO on Social Media
Recruiters
user avatar
About Us
GovCIO was founded with a single purpose-To Transform Government IT. Our expert teams apply groundbreaking IT solutions to optimize government agencies’ daily operations so they can focus on serving our citizens. We want to make a difference, so we’ve built an inclusive work culture to fuel this mission. Various skills and perspectives make us better problem solvers and creators. We’re changing the face of IT-from our diverse staff to the end-products we develop and we want you on our team!
job ad2 image

GovCIO Jobs


Job Category
IT - Software
Clearance Level
Secret
Employer
GovCIO