The Ash Group
Sr. Technical Recruiter at The Ash Group
*** W2 Contract Only – No C2C – No 3rd Parties ***
Summary The Ash Group is hiring a new
Programmer Analyst Principal (Data Engineer)
for our client, a global leader providing advanced systems and support in defense, aerospace, and security, based in
Falls Church, VA .
In this role, you'll design, implement, and optimize large-scale data systems and ETL pipelines, focusing on Amazon Redshift and AWS services to ensure data quality and integrity for complex defense programs.
Compensation, Benefits, and Role Info
Competitive pay rate of
$65
per hour.
Medical, dental, vision, direct primary care benefits, and after six months, a 4% matched 401(k) with immediate 100% vesting.
Type: 12‑month contract with potential extension or conversion.
Location: On‑site in Falls Church, VA.
What You’ll Be Doing
Design and implement large‑scale ETL data pipelines using AWS Glue and Python/PySpark to ingest, transform, and load data from various sources.
Build and maintain robust data warehouses, focusing on Amazon Redshift, including data modeling and governance.
Write and optimize complex, highly performant SQL queries across large datasets (Redshift, Oracle, SQL Server).
Collaborate with cross‑functional teams (data scientists, analysts) to understand requirements and deliver end‑to‑end data solutions.
Troubleshoot, optimize performance, and resolve data‑related issues such as pipeline failures and data quality bottlenecks.
What We’re Looking For
8+ years of hands‑on experience in data engineering, focusing on designing and implementing large‑scale data systems.
5+ years of experience building production‑level ETL pipelines using AWS Glue and Python/PySpark.
Deep proficiency in SQL, including query optimization, indexing, and performance tuning across data warehouses like Amazon Redshift.
Strong understanding of database design principles, data modeling (star/snowflake schemas), and data governance.
Experience with data processing/orchestration frameworks such as Apache Airflow, Apache Kafka, or Fivetran.
If you're a seasoned data engineering professional passionate about building scalable data solutions and driving innovation in cloud‑based environments, we want to hear from you. This is an exciting opportunity to work on cutting‑edge technologies, collaborate with cross‑functional teams, and make a meaningful impact on data‑driven decision‑making. Apply now to be part of a forward‑thinking organization where your expertise will shape the future of our data infrastructure.
Seniority level
Mid‑Senior level
Employment type
Contract
Job function
Information Technology
Industries
Defense and Space Manufacturing
#J-18808-Ljbffr
Summary The Ash Group is hiring a new
Programmer Analyst Principal (Data Engineer)
for our client, a global leader providing advanced systems and support in defense, aerospace, and security, based in
Falls Church, VA .
In this role, you'll design, implement, and optimize large-scale data systems and ETL pipelines, focusing on Amazon Redshift and AWS services to ensure data quality and integrity for complex defense programs.
Compensation, Benefits, and Role Info
Competitive pay rate of
$65
per hour.
Medical, dental, vision, direct primary care benefits, and after six months, a 4% matched 401(k) with immediate 100% vesting.
Type: 12‑month contract with potential extension or conversion.
Location: On‑site in Falls Church, VA.
What You’ll Be Doing
Design and implement large‑scale ETL data pipelines using AWS Glue and Python/PySpark to ingest, transform, and load data from various sources.
Build and maintain robust data warehouses, focusing on Amazon Redshift, including data modeling and governance.
Write and optimize complex, highly performant SQL queries across large datasets (Redshift, Oracle, SQL Server).
Collaborate with cross‑functional teams (data scientists, analysts) to understand requirements and deliver end‑to‑end data solutions.
Troubleshoot, optimize performance, and resolve data‑related issues such as pipeline failures and data quality bottlenecks.
What We’re Looking For
8+ years of hands‑on experience in data engineering, focusing on designing and implementing large‑scale data systems.
5+ years of experience building production‑level ETL pipelines using AWS Glue and Python/PySpark.
Deep proficiency in SQL, including query optimization, indexing, and performance tuning across data warehouses like Amazon Redshift.
Strong understanding of database design principles, data modeling (star/snowflake schemas), and data governance.
Experience with data processing/orchestration frameworks such as Apache Airflow, Apache Kafka, or Fivetran.
If you're a seasoned data engineering professional passionate about building scalable data solutions and driving innovation in cloud‑based environments, we want to hear from you. This is an exciting opportunity to work on cutting‑edge technologies, collaborate with cross‑functional teams, and make a meaningful impact on data‑driven decision‑making. Apply now to be part of a forward‑thinking organization where your expertise will shape the future of our data infrastructure.
Seniority level
Mid‑Senior level
Employment type
Contract
Job function
Information Technology
Industries
Defense and Space Manufacturing
#J-18808-Ljbffr