onsite
Data Engineer Senior / Mid-Level - ETL / Cloud / AWS - Visual Soft, Inc
Data Engineer
Experienced Data Engineer skilled in building scalable ETL pipelines on AWS, designing data models, and scripting with Python and SQL to support federal agency analytics and reporting.
About the role
Key Responsibilities
- Design, develop, and maintain robust ETL pipelines on AWS services (e.g., Glue, Lambda, S3, Redshift).
- Implement data modeling and schema design to support analytical workloads and reporting.
- Write efficient Python and SQL code for data extraction, transformation, and loading.
- Collaborate with cross‑functional teams to gather requirements, ensure data quality, and optimize performance.
- Monitor, troubleshoot, and tune data workflows to meet SLA and security standards.
Requirements
- 5+ years (mid‑level) or 8+ years (senior) of hands‑on data engineering experience.
- Proficiency with AWS data services (Glue, Redshift, S3, Lambda) and cloud‑based ETL tools.
- Strong programming skills in Python and advanced SQL for data manipulation.
- Experience designing relational and dimensional data models for large datasets.
- Active Top Secret clearance and U.S. citizenship.