Bachelor's degree with 12+ years of relevant experience or equivalent.
Active Secret clearance with the ability to obtain DEA suitability.
In-depth understanding of the Kimball model and experience with re-platforming.
Strong proficiency in Python, including libraries like Pandas and SQLAlchemy.
Familiarity with cloud data platforms such as Azure or AWS.
Responsibilities
Learn the existing Kimball-modeled SQL Server structure.
Reverse-engineer SSIS packages into Python-based ETL pipelines.
Build reusable Python frameworks for ETL processes.
Introduce PySpark for scalable data transformations.
Plan future transitions to platforms like Databricks or Snowflake.
Enhance orchestration and data quality practices.
Identify and modernize aging ETL components.
Benefits
Onsite position in Merrifield, VA.
Opportunity to work with cutting-edge technologies.
Engagement in a significant modernization project.
Collaboration with subject matter experts in enterprise data warehousing.
Full Job Description
Overview
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 onsiteposition.
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 replatforming 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.
GovCIO is a technology and consulting firm that provides IT solutions to government agencies. The company specializes in cloud computing, cybersecurity, and digital transformation. GovCIO's mission is to help government agencies improve their IT infrastructure and enhance their services to the public. The company was founded in 2015 and is headquartered in Washington, DC.