Apply Now

Senior Data Warehouse Modernization Developer

Fairfax, VA, US • Posted 7 days ago • Updated 3 minutes ago

Full Time

On-site

Compensation information provided in the description

Fitment

Dice Job Match Score™

🛠️ Calibrating flux capacitors...

Job Details

Skills

Recruiting
Microsoft SQL Server
Reverse Engineering
Extraction
Databricks
Snow Flake Schema
Orchestration
Management
Data Quality
Collaboration
Data Warehouse
Documentation
Application Development
Security Clearance
Dimensional Modeling
Python
Pandas
Unit Testing
PySpark
Apache Spark
Cloud Computing
Microsoft Azure
Amazon Web Services
Microsoft SSIS
SQL
Extract
Transform
Load
Warehouse
Git
Continuous Integration
Continuous Delivery

Summary

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.

Posted Salary Range: USD $160,000.00 - USD $190,000.00 /Yr.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: appfeed
Position Id: 17468_7894
Posted 7 days ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Senior Data Engineer

Reston, Virginia

•

30+d ago

JD: Seeking an AWS Data Engineer to design, build, and maintain scalable data pipelines and ETL solutions using Python/Pyspark and AWS managed services to support analytics and data product needs. Key Responsibilities Build and maintain ETL pipelines using Python and PySpark on AWS Glue and other compute platformsOrchestrate workflows with AWS Step Functions and serverless components (Lambda)Implement messaging and event-driven patterns using AWS SNS and SQSDesign and optimize data storage and

Easy Apply

Full-time

$60,000 - $120,000

Senior Python Data Engineer

Chantilly, Virginia

•

Today

Job Number: R0235388 Python Data Engineer, Senior The Opportunity: As a back-end developer, you know that a good site or system needs the right combination of clean code, APIs, analytics, and infrastructure to develop a user-focused solution. We're looking for an experienced back-end developer with the software engineering skills it takes to identify potential risks, contribute to solution development, and create efficient and effective systems for our clients. As a back-end developer at Booz Al

Full-time

USD 86,800.00 - 198,000.00 per year

AWS Data Engineer

Reston, Virginia

•

30+d ago

Role: AWS Data Engineer Client Location: Reston, VA Salary Range: To be discussed. Work Mode: 5 days onsite (No remote/hybrid exceptions) Must Have Skills: Seeking an AWS Data Engineer to design, build, and maintain scalable data pipelines and ETL solutions using Python/Pyspark and AWS managed services to support analytics and data product needs. Key Responsibilities Build and maintain ETL pipelines using Python and PySpark on AWS Glue and other compute platformsOrchestrate workflows with AWS

Easy Apply

Full-time

$60,000 - $80,000

Senior Data Warehouse Operations Engineer

Fairfax, Virginia

•

Today

Overview: GovCIO is currently hiring for a Senior Data Warehouse Operations Engineer with an active Secret clearance to provide hands-on operational support for the existing 15-year-old Kimball-modeled Enterprise Data Warehouse, built on SQL Server and SSIS.This position will be located in Merrifield, VA and will be a fully onsite position. Responsibilities: This role provides hands-on operational support for the existing 15-year-old Kimball-modeled Enterprise Data Warehouse, built on SQL Serve

Full-time

Compensation information provided in the description

Search all similar jobs