Data Warehouse Modernization Developer
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.
- Merrifield, Virginia, United States
- Full-time
- On-site
- $185K–$185K per year
- Posted Nov 18, 2026
INDUSTRYSoftware & InternetSaaS & Enterprise SoftwareData & Analytics
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
Requirements
- Bachelor's
- Experience in a Data Warehousing
Nice to have: Experience modernizing legacy ETL systems
Skills
More jobs nearby
Full description
Company details are for members
Sign up for a free job alert to see Govcio LLC's profile, website and LinkedIn, and the same for every employer on Referso Jobs.