DE, Amazon Talent Solutions, ITDS Data Foundations

Amazon Inc.; Seattle (WA); On-site; USD 132,000 - 179,000; Full time

Job summary

Amazon Inc. is seeking a Data Engineer to join the cross-functional Data Foundations team in ITDS. You will build and operate scalable ETL/ELT pipelines, design data schemas, and own metrics and dashboards used by engineers, analysts, and data scientists to power business decisions.

You will collaborate with BI analytics, data scientists, and business analysts, tuning queries and expanding data storage capabilities to support hundreds of integrations across talent data domains.

Qualifications

• 3+ years of data engineering experience
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using OLAP technologies
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using data modeling
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using SQL
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using Oracle
• 3+ years of in the job offered or a related occupation experience
• Bachelor's degree or foreign equivalent in Computer Science, Engineering, Information Systems, Mathematics, or a related field
• Experience with data modeling, warehousing and building ETL pipelines

Responsibilities

• 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.

Skills

Data engineering

ETL/ELT

OLAP technologies

SQL

Oracle

Data modeling

Education

Bachelor's degree in CS/Engineering/IS/Math

Tools

Redshift

S3

AWS Glue

EMR

Kinesis

Lambda

IAM

Job description

Description

There are now more than 1.3 million Amazonians worldwide. As part of People eXperience and Technology organization, the Amazon Talent Solutions team’s mission is to create innovative, science-based, and inclusive products and experiences for all Amazonians to help us become “Earth’s Best Employer.”

We are seeking a highly motivated Data Engineer for a cross functional Data Foundations team in the Integrated Talent Development Systems (ITDS) organization. In this role, you will define and deliver streaming and batch ingestion architectures that unify service data domains into a cross-cutting talent data model that is vended for both analytics and operational use cases, powering 100s of downstream integrations. This role requires deep expertise with data processing, storage, and vending technologies. You will explore the cutting edge and apply it to solve scale and performance challenges inherent to horizontal data services.

Key job responsibilities

As a Data Engineer, you will/may:

• 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.

Basic Qualifications

• 3+ years of data engineering experience
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes experience
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using OLAP technologies experience
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using data modeling experience
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using SQL experience
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using Oracle experience
• 3+ years of in the job offered or a related occupation experience
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using each of the following: ETL (Extract, Transform, Load)/ELT (Extract, Load, Transform) processes experience
• Bachelor's degree or foreign equivalent in Computer Science, Engineering, Information Systems, Mathematics, or a related field
• Experience with data modeling, warehousing and building ETL pipelines

Preferred Qualifications

• Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions
• Experience with non-relational databases / data stores (object storage, document or key-value stores, graph databases, column-family databases)

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, 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 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 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, WA, Seattle - 132,100.00 - 178,800.00 USD annually