Data Warehouse Modernization Developer

GovCIO
Merrifield, VA, United States
2 days ago
Apply on dejobs.org
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Compensation
$185,000
Working hours
Regular working hours
Job source

Tech stack

Amazon Web Services Business Logic Unit Testing Microsoft Azure Biometrics Extract Transform Load (ETL) Data Warehousing Dimensional Modeling Python (Programming Language) Microsoft SQL Server Cloud Services Reverse Engineering
+13 more
SQL Databases SQL Server Integration Services SQLAlchemy Web Application Frameworks Data Ingestion Snowflake Apache Spark Technical Debt Git Pandas Pyspark Azure Synapse Analytics Databricks

Job description

  • 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., * A valid photo ID must be presented during each interview
  • During the Hiring Process
  • Enhanced Biometrics ID verification screening
  • Background check, to include:
  • Criminal history (past 7 years)
  • Verification of your highest level of education
  • Verification of your employment history (past 7 years), based on information provided in your application

Benefits & conditions

At GovCIO, we consistently hear that meaningful work and a collaborative team environment are two of the top reasons our employees enjoy working here. In addition, our employees have access to a range of perks and benefits to support their personal and professional well-being, beyond the standard company offered health benefits, including:

  • 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

Our employees’ unique talents and contributions are the driving force behind our success in supporting our customers, which ultimately fuels the success of our company. Join us and be a part of a culture that invests in its people and prioritizes continuous enhancement of the employee experience.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, disability, or status as a protected veteran. EOE, including disability/vets.

Posted Pay Range

The posted pay range, if referenced, reflects the range expected for this position at the commencement of employment, however, base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, education, experience, and internal equity. The total compensation package for this position may also include other compensation elements, to be discussed during the hiring process. If hired, employee will be in an β€œat-will position” and the GovCIO reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, GovCIO or individual department/team performance, and market factors.

About the company

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., GovCIO is a team of transformers–people who are passionate about transforming government IT. Every day, we make a positive impact by delivering innovative IT services and solutions that improve how government agencies operate and serve our citizens.

But we can’t do it alone. We need great people to help us do great things - for our customers, our culture, and our ability to attract other great people. We are changing the face of government IT and building a workforce that fuels this mission. Are you ready to be a transformer?

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on dejobs.org
Prepare application

Good distractions

Loading talks and stories from around this role…