Senior Data Warehouse Modernization Developer
US-VA-Fairfax
Careers (External)
Req #: 7894
Type: Full-Time
|
|
||||||||||
|
|||||||||||
Overview: 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: * 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.
Share this job:
