- Design, implement, and automate deployment of our distributed system for collecting and processing log events from multiple sources.
- Design data schema and operate internal data warehouses and SQL/NoSQL database systems.
- Own the design, development, and maintenance of ongoing metrics, reports, analyses, and dashboards that engineers, analysts, and data scientists use to drive key business decisions.
- Monitor and troubleshoot operational or data issues in the data pipelines.
- Drive architectural plans and implementation for future data storage, reporting, and analytic solutions.
- Develop code based automated data pipelines able to process millions of data points.
- Improve database and data warehouse performance by tuning inefficient queries.
- Work collaboratively with Business Analysts, Data Scientists, and other internal partners to identify opportunities/problems.
- Provide assistance with troubleshooting, researching the root cause, and thoroughly resolving defects in the event of a problem.
A day in the life
Our internship program provides hands-on learning and building experiences for students who are interested in a career in data engineering. In addition to working on an impactful project, you will have the opportunity to engage with Amazonians for both personal and professional development, expand your network, and participate in fun activities with other interns throughout the summer. No matter the location of your internship, we give you the tools to own your internship and learn in a real-world setting.
- Are 18 years of age or older
- Work 40 hours/week minimum and commit to 12 week internship maximum
- Are enrolled in a academic program that is physically located in the United States
- Experience with data transformation
- Experience with database, data warehouse or data lake solutions
- Experience with SQL
- Experience with one or more scripting language (e.g., Python, KornShell, Scala)
- Currently enrolled in or will receive a Bachelor’s Degree, Master's Degree, or advanced technical degree in Computer Science, Computer Engineering, Information Management, Information Systems, or an equivalent technical discipline with an expected conferral date between October 2027 – December 2030.
- Experience with AWS
- Experience building data pipelines or automated ETL processes
- Knowledge of writing and optimizing SQL queries in a business environment with large-scale, complex datasets
- Experience with big data processing technology (e.g., Hadoop or ApacheSpark), data warehouse technical architecture, infrastructure components, ETL, and reporting/analytic tools and environments
- Experience with data visualization software (e.g., AWS QuickSight or Tableau) or open-source project
- Previous technical internship(s), if applicable
- Can articulate the basic differences between datatypes (e.g. JSON/NoSQL, relational)
- Understand the basics of designing and implementing a data schema (e.g., normalization, relational model vs dimensional model)
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 https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.
The starting pay for this position is listed below. Starting Day 1 of employment, Amazon offers EAP, Mental Health Support, Medical Advice Line, 401(k) matching. Learn more about our benefits at https://hiring.amazon.com/why-amazon/benefits.
Seattle, WA, USA – 106,590.00 USD Annually