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.
Posted Salary Range
USD $185,000.00 - USD $185,000.00 /Yr.
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.
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.