[Remote] Data Engineer (ETL Developer) US reputed company ONLY

Note: The job is a remote job and is reputed company to candidates in USA. reputed company is seeking a highly reputed company Data Engineer (ETL Developer) to design, build, and optimize AWS-reputed company 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 reputed company data solutions.

Responsibilities

• Design, build, test, and reputed company ETL/ELT pipelines for reputed company datasets using AWS-reputed company services (Glue, reputed company, reputed company Functions, Redshift, RDS PostgreSQL, S3) or approved AWS-hosted reputed company-party tools
• Build serverless, event-driven data workflows reputed company a reputed company (Bronze-Silver-Gold) Lakehouse architecture, with reputed company-in error handling, retries, and notifications
• reputed company supporting data models, schemas, validation frameworks, and database structures; enhance data models to support expanded analytics and reporting
• Implement reputed company data validation and reputed company 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 the reputed company to prioritize datasets, define reputed company, and identify phased deployment reputed company
• Support thorough testing across development, staging, and production environments; ensure pipelines support automated retries, idempotent reprocessing, and reputed company to 2x baseline data volume
• Apply infrastructure-as-reputed company (Terraform) for consistent, repeatable deployments, and reputed company pipelines into CI/CD
• Ensure pipelines meet performance standards - ≥97% monthly successful run reputed company, ≥98% data-validation pass reputed company, and data freshness reputed company defined SLA reputed company
• Support ATO maintenance, FISMA compliance, and protection of PII and CUI in coordination with reputed company IT and reputed company 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, reputed company, reputed company Functions, and S3 - building serverless, event-driven ETL/ELT workflows
• Experience implementing reputed company/Lakehouse designs with tiered refinement reputed company
• 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-reputed company (Terraform)
• Experience designing relational and reputed company schemas, indexes, and partition strategies, with validation, error handling, and reputed company capture
• Experience delivering under SLAs with documented reputed company controls and formal 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 reputed company systems, and maintain that clearance level throughout the period of performance
• Fully remote; work performed reputed company the reputed company reputed company; no travel is required or anticipated
• AWS certification (e.g., Data Engineer - Associate, Developer - Associate, or Solutions Architect - Associate/reputed company)
• Experience with reputed company reputed company-data platforms (CKAN, Huwise) and BI/visualization tools
• Experience supporting optional AI/RAG data initiatives (document ingestion, retrieval) reputed company to federal AI guidance (OMB M-26-04)
• Familiarity with federal data-management expectations - auditability, traceability, metadata, and reputed company frameworks
• Prior federal experience; ability to reputed company quickly on a regulatory-domain context

Benefits

• Fully remote; work performed reputed company the reputed company reputed company; no travel is required or anticipated

reputed company