Job Requirements
Fairfax, VA
Secret Polygraph Unspecified
Career Level not specified
$160,000 - $190,000
Job Description
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:
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:
Posted Salary Range
USD $160,000.00 - USD $190,000.00 /Yr.
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.
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.
