Amazon Data Engineer Analytics & Engineering 

United States, Virginia 

190043351

Amazon Web Services (AWS), Worldwide Public Sector (WWPS), MVP Analytics & Data Engineering Team (MADE) is seeking a Data Engineer who will be responsible for developing and managing big data systems. The ideal candidate will possess a deep understanding of data engineering fundamentals and best practices, with the skills and experience to develop autonomous, scalable programs. Familiarity and exposure to data warehousing and cloud-based service offerings are also requirements to raise the bar in this role.This position requires that the candidate selected be a US Citizen and must currently possess and maintain an active TS/SCI security clearance with polygraph.Key job responsibilities
Analyze existing databases and warehouse structures to determine the most efficient and scalable methods for consolidating and aggregating data.Create and propose technical design documentation, including:Current and future ETL functionality
Affected database objects
Specifications, data flows, and diagrams detailing the proposed implementation
About the team
About AWS
AWS values diverse experiences. Even if you do not meet all of the preferred qualifications and skills listed in the job description, we encourage candidates to apply. If your career is just starting, hasn’t followed a traditional path, or includes alternative experiences, don’t let it stop you from applying.Mentorship & Career Growth We’re continuously raising our performance bar as we strive to become Earth’s Best Employer. That’s why you’ll find endless knowledge-sharing, mentorship and other career-advancing resources here to help you develop into a better-rounded professional.

- Bachelor’s degree in Computer Science, Engineering, Mathematics, or a related field, plus 5+ years of industry experience.
- 4+ years of developing and operating large-scale ETL/ELT processes, database technologies, and data modeling
- Working with at least one relational database technology (e.g., Redshift, Oracle, Postgres, SQL Server)
- Experience building and operating highly available, distributed systems for data extraction, ingestion, and processing of large datasets.
- 4+ years of coding experience with a modern programming or scripting language (e.g., Python, Scala, Java, C#, PowerShell).
- Advanced SQL skills with expertise in query performance tuning.
- Experience with at least one massively parallel processing data technology (e.g., Redshift, Spark, or Hadoop-based big data solutions).
- Experience with one or more Python-based data analysis libraries (i.e. Pandas and/or Polars)
- Current, active US Government Security Clearance of TS/SCI with Polygraph

- Master’s or PhD in Computer Science, Engineering, Mathematics, or a related discipline.
- Experience building data products incrementally and managing datasets from multiple sources.
- Experience operating very large data environments, such as data lakes, lakehouses, or data warehouses.
- Query performance tuning expertise using Unix/Linux profiling tools and SQL.
- Proficiency with AWS tools and technologies (e.g., SNS, Redshift, RDS, S3, EC2, Athena, Glue, Lambda, SageMaker, EC2 Load Balancing, AWS Diode, EventBridge, Cloudwatch Logs, SQS, Route 53).
- Experience creating visual data representations using BI platforms (e.g., Tableau, Power BI, QuickSight).
- Experience with Tableau Server configuration and administration, and Tableau Site administration.