Data Engineer I, Secure Third Party Tools (S3T)

Amazon Inc.; Austin (TX); On-site; USD 101,000 - 160,000; Full time

Benefits offered by this job

Sign-on payments

Restricted stock units (RSUs)

Health insurance

EAP

Mental Health Support

Medical Advice Line

Flexible Spending Accounts

401(k) matching

Paid time off

Parental leave

Job summary

Amazon Inc. is seeking a Data Engineer I to design, implement, and support secured access to large datasets within an Austin on-site environment. You will build end-to-end data infrastructure and ETL pipelines in collaboration with SDEs/DEs and applied scientists.

You’ll shape data strategy and contribute to the technical roadmap, working with BI engineers to enable data access and self-service capabilities for analytics teams.

Qualifications

• 1+ years of data engineering experience.
• Experience with data modeling, warehousing, and building ETL pipelines.
• Experience with one or more query languages, such as SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, or Scala.
• Experience with one or more scripting languages, such as Python or KornShell.

Responsibilities

• Design, implement, and support a platform that provides secured access to large datasets.
• Architect, develop, and maintain end-to-end scalable data infrastructure and data pipelines.
• Shape the team’s data strategy and technical roadmap for data storage and pipeline design and implementation.
• Collaborate with other technology teams to extract, transform, and load data from a variety of sources using SQL, scripting, and AWS big data technologies.
• Design and implement complex ETL pipelines and BI solutions.
• Partner with business owners, developers, and Business Intelligence Engineers to explore new data sources and deliver data for use.
• Enable team self-servicing by providing skills to handle complex work independently and improve autonomy.

Skills

Data engineering

Data modeling

Warehousing

ETL pipelines

SQL

Python

KornShell

Tools

Hadoop

Hive

Spark

EMR

Informatica

ODI

SSIS

BODI

Datastage

Job description

Amazon’s Security Foundations team is looking for a Data Engineer I to help build and run Secure Third Party Tools (S3T). In this role, you will design, implement, and support secured access to large datasets while contributing to end-to-end, scalable data infrastructure and pipelines.

This is an Austin, TX onsite position supporting data engineering across teams, working alongside SDEs/DEs and applied scientists to deliver reliable data access, transformations, and ETL outcomes.

What you’ll do

• Design, implement, and support a platform that provides secured access to large datasets.
• Architect, develop, and maintain end-to-end scalable data infrastructure and data pipelines.
• Shape the team’s data strategy and technical roadmap for data storage and pipeline design and implementation.
• Collaborate with other technology teams to extract, transform, and load data from a variety of sources using SQL, scripting, and AWS big data technologies.
• Design and implement complex ETL pipelines and other BI solutions.
• Partner with business owners, developers, and Business Intelligence Engineers to explore new data sources and deliver data for use.
• Enable team self-servicing by providing skills to handle complex work independently, improving autonomy and productivity while supporting a culture of self-reliance.

Requirements

• 1+ years of data engineering experience.
• Experience with data modeling, warehousing, and building ETL pipelines.
• Experience with one or more query languages, such as SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, or Scala.
• Experience with one or more scripting languages, such as Python or KornShell.

Technologies you may work with

• SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL
• Scala, Python, KornShell
• Hadoop, Hive, Spark, EMR
• Informatica, ODI, SSIS, BODI, Datastage
• AWS big data technologies
• ETL

Preferred qualifications

• Experience with big data technologies such as Hadoop, Hive, Spark, and EMR.
• Experience with one or more ETL tools such as Informatica, ODI, SSIS, BODI, or Datastage.

Compensation and benefits

Salary: USD 101,300 - 160,000 per year.

• Sign-on payments
• Restricted stock units (RSUs)
• Health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance, and an 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
• Parental leave