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 cloudbased service offerings are also requirements to raise the bar in this role.
The Data Engineer will be responsible for scaling existing infrastructure incorporating new data sources and building robust data pipelines for production level systems. In partnership with business intelligence engineers and analysts the Data Engineer will work backwards from the customer to build reliable and scalable data solutions to meet the business needs.
Finally this individual will work closely with project management teams to ensure proper guidance use cases and documentation is available to our Sales and Operations teams.
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.
Design and develop all components of data solutions using Amazon Redshift and Amazon Aurora Postgres to create an Operations data warehouse.
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 hasnt followed a traditional path or includes alternative experiences dont let it stop you from applying.
Why AWS Amazon Web Services (AWS) is the worlds most comprehensive and broadly adopted cloud platform. We pioneered cloud computing and never stopped innovating thats why customers from the most successful startups to Global 500 companies trust our robust suite of products and services to power their businesses.
Inclusive Team Culture Here at AWS its in our nature to learn and be curious. Our employeeled affinity groups foster a culture of inclusion that empower us to be proud of our differences. Ongoing events and learning experiences including our Conversations on Race and Ethnicity (CORE) and AmazeCon conferences inspire us to never stop embracing our uniqueness.
Mentorship & Career Growth Were continuously raising our performance bar as we strive to become Earths Best Employer. Thats why youll find endless knowledgesharing mentorship and other careeradvancing resources here to help you develop into a betterrounded professional.
Work/Life Balance We value worklife harmony. Achieving success at work should never come at the expense of sacrifices at home which is why we strive for flexibility as part of our working culture. When we feel supported in the workplace and at home theres nothing we cant achieve in the cloud.
Bachelors degree in Computer Science Engineering Mathematics or a related field plus 5 years of industry experience.
4 years of developing and operating largescale 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 Hadoopbased big data solutions).
Experience with one or more Pythonbased data analysis libraries (i.e. Pandas and/or Polars)
Current active US Government Security Clearance of TS/SCI with Polygraph
Masters 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.
Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race national origin gender gender identity sexual orientation protected veteran status disability age or other legally protected status.
Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process including support for the interview or onboarding process please visit
for more information. If the country/region youre applying in isnt listed please contact your Recruiting Partner.