Data Warehouse Modernization Developer
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+13 more
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., * 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.
Requirements
- 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.
Benefits & conditions
USD $185,000.00 - USD $185,000.00 /Yr.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦