AWS Data Engineer – ETL & Data Platform for Federal Gov

Synectics for Management Decisions, Inc; Washington (District of Columbia); Hybrid; USD 120,000 - 130,000; Full time

Job summary

Synectics for Management Decisions, Inc. is seeking a Data Engineer to design, build, and optimize ETL pipelines on an AWS-based data platform for a federal client. The role emphasizes serverless, event-driven workflows and Medallion/Lakehouse architectures.

The position requires 3–7 years of experience with AWS services, Python/SQL/PySpark, and data validation/metadata tools. A hybrid work setup in the Washington, DC area is available.

Qualifications

• 3–7 years designing and maintaining AWS-based data pipelines (Glue, Lambda, Step Functions, S3).
• Experience building serverless, event-driven ETL/ELT workflows and Medallion/Lakehouse designs.
• Proficiency in Python, SQL, PySpark, Pandas, or similar data processing frameworks.
• Experience with data validation tools (e.g., Great Expectations), data catalogs (AWS Glue, Lake Formation), CI/CD, and infrastructure-as-code (Terraform).
• Experience producing technical documentation (ERDs, data dictionaries, lineage diagrams) for government or regulated stakeholders.

Responsibilities

• Design, build, test, and deploy ETL pipelines using AWS-native services or approved third-party tools hosted on AWS on AWS.
• Develop supporting data models, schemas, validation frameworks, and database structures; enhance models to support expanded analytics and reporting.
• Implement scalable data validation and quality checks, including error handling and lineage capture.
• Produce complete technical documentation including ERDs, data dictionaries, and pipeline specifications.
• Collaborate with stakeholders to prioritize datasets, define sequencing, and identify phased deployment options.
• Support thorough testing across development, staging, and production environments.
• Meet defined performance standards for pipeline reliability, data-validation pass rates, and data freshness.

Skills

AWS-based data pipelines

Serverless ETL/ELT workflows

Python/SQL/PySpark

Technical documentation

Data validation/quality checks

Tools

AWS Glue

AWS Lake Formation

Terraform

CI/CD

S3

Lambda

Step Functions

Job description

Synectics for Management Decisions, Inc. is seeking a Data Engineer to design, build, and optimize ETL pipelines on an AWS-based data platform for a federal client. The role emphasizes serverless, event-driven workflows and Medallion/Lakehouse architectures.

The position requires 3–7 years of experience with AWS services, Python/SQL/PySpark, and data validation/metadata tools. A hybrid work setup in the Washington, DC area is available.