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:
Qualifications
Skills and Experience:
Posted Salary Range
USD $185,000.00 - USD $185,000.00 /Yr.
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.