Data Engineer, Analytics & Data Engineering

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.

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., * 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

• Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions
• 4+ years of developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes experience
• Experience with SQL
• Experience in at least one modern scripting or programming language, such as Python, Java, Scala, or NodeJS
• 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

The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off, and parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits .

USA, VA, Arlington - 132,100.00 - 178,800.00 USD annually

Why AWS? Amazon Web Services (AWS) is the world’s most comprehensive and broadly adopted cloud platform. We pioneered cloud computing and never stopped innovating - that’s 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, it’s in our nature to learn and be curious. Our employee-led 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 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.

Work/Life Balance We value work-life 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, there’s nothing we can’t achieve in the cloud.