Senior Data Warehouse Modernization Developer
About The Position
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.
Requirements
- High School with 10+ years application development (or commensurate experience)
- Clearance Required: Active Secret with the ability to obtain and hold DEA suitability
- 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.
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.
Benefits
- Employee Assistance Program (EAP)
- Corporate Discounts
- Learning & Development platform, to include certification preparation content
- Training, Education and Certification Assistance
- Referral Bonus Program
- Internal Mobility Program
- Pet Insurance
- Flexible Work Environment
- Available to full-time employees
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
High school or GED
Number of Employees
501-1,000 employees
