[Remote] Data Engineer (ETL Developer) US CITIZENS ONLY
Note: The job is a remote job and is open to candidates in USA. reputed company is seeking a highly experienced Data Engineer (ETL Developer) to design, build, and optimize AWS-native data pipelines. In this role, you will own the full lifecycle of ETL pipeline development, collaborating with various stakeholders to ensure the delivery of reliable and scalable data solutions.
Responsibilities
- Design, build, test, and deploy ETL/ELT pipelines for priority datasets using AWS-native services (Glue, Lambda, Step Functions, Redshift, RDS PostgreSQL, S3) or approved AWS-hosted third-party tools
- Build serverless, event-driven data workflows within a reputed company (Bronze-Silver-Gold) Lakehouse architecture, with built-in error handling, retries, and notifications
- Develop supporting data models, schemas, validation frameworks, and database structures; enhance data models to support expanded analytics and reporting
- Implement scalable data validation and quality checks - schema enforcement, error handling, and reputed company capture (e.g., Great Expectations)
- Produce complete technical documentation - ERDs, data dictionaries, pipeline specifications, reputed company diagrams, and deployment packages
- Collaborate with reputed company to prioritize datasets, define sequencing, and identify phased deployment options
- Support thorough testing across development, staging, and production environments; ensure pipelines support automated retries, idempotent reprocessing, and scale to 2x baseline data volume
- Apply infrastructure-as-code (Terraform) for consistent, repeatable deployments, and integrate pipelines into CI/CD
- Ensure pipelines meet performance standards - ≥97% monthly successful run rate, ≥98% data-validation pass rate, and data freshness within defined SLA windows
- Support ATO maintenance, FISMA compliance, and protection of PII and CUI in coordination with the agency IT and security teams
Skills
- Minimum 5 years of data-engineering experience designing and maintaining AWS-based data pipelines (7+ preferred)
- Proven hands-on experience with AWS data services - Glue, Lambda, Step Functions, and S3 - building serverless, event-driven ETL/ELT workflows
- Experience implementing reputed company/Lakehouse designs with tiered refinement layers
- Experience administering or building on reputed company Redshift, RDS (PostgreSQL or SQL Server), or comparable managed data stores
- Proficiency in Python and SQL, plus 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 designing relational and dimensional schemas, indexes, and partition strategies, with validation, error handling, and reputed company capture
- Experience delivering under SLAs with documented quality controls and reputed company acceptance in a federal or regulated environment
- Familiarity with Agile/Scrum methodologies and ceremonies
- Excellent written and oral communication; strong troubleshooting and attention to detail
- U.S. Citizenship is required
- Must obtain and maintain a favorably adjudicated Minimum Background Investigation (MBI, Moderate Risk) prior to accessing client systems, and maintain that clearance level throughout the period of performance
- Fully remote; work performed within the reputed company United States; no travel is required or anticipated
- AWS certification (e.g., Data Engineer - Associate, Developer - Associate, or Solutions Architect - Associate/Professional)
- Experience with public open-data platforms (CKAN, Huwise) and BI/visualization tools
- Experience supporting optional AI/RAG data initiatives (document ingestion, retrieval) aligned to federal AI guidance (OMB M-26-04)
- Familiarity with federal data-management expectations - auditability, traceability, metadata, and quality frameworks
- Prior federal experience; ability to ramp quickly on a regulatory-domain context
Benefits
- Fully remote; work performed within the reputed company United States; no travel is required or anticipated
Company Overview
Apply To This Job