Data Engineer II

Data Engineer II at Amazon.com Services LLC designs and builds analytical platforms and data pipelines to enable advanced analytics within the Perfect Order Experience - Centralized Analytics and Data Engineering team.

Location: Seattle, WA (onsite) • Salary: USD 132,100 - 178,800 per year • Experience: 5+ years • Education: Bachelor's degree or above in a quantitative/technical field such as computer science, engineering, statistics

Responsibilities

• Architect and sustain an analytics platform that provides access to large datasets and scalable compute resources.
• Create and manage data clusters that deliver access and insights aligned with business needs.
• Develop and operate data pipelines to move relevant data to the appropriate destinations.
• Apply sound data modeling practices to implement robust data structures.
• Collaborate with Engineering and Science teams to deploy advanced analytics algorithms for statistical analysis, prediction, clustering, and machine learning.
• Adopt reporting and analysis best practices, focusing on data integrity, test design, analysis, validation, and documentation.
• Build reliable and scalable data integration ETL pipelines.
• Promote and evangelize data handling best practices across the organization.
• Work with other technology teams to extract, transform, and load data from diverse sources.
• Continuously improve reporting and analysis processes, automating or simplifying self-service support for customers.

Requirements

• 5+ years of SQL experience.
• 5+ years in data engineering, database engineering, business intelligence, or business analytics.
• Experience with data warehouse architectures, data modeling, infrastructure components, ETL/ELT, and analytics tools and environments, data structures, and hands-on SQL coding.
• Knowledge of databases, storage concepts, and big data.
• Experience building and operating highly available, distributed systems for data extraction, ingestion, and processing of large data sets.
• Bachelor’s degree or higher in a quantitative/technical field such as computer science, engineering, statistics.
• Advanced SQL skills with large data sets using Oracle, SQL Server, and Redshift.

Technologies

• SQL
• Oracle
• SQL Server
• Redshift
• S3
• AWS Glue
• EMR
• Kinesis
• Firehose
• Lambda
• IAM

Benefits

• Health coverage including medical, dental, vision, prescription, and life insurance with optional supplemental life plans, EAP, mental health support, and flexible spending accounts
• 401(k) matching
• Paid time off
• Parental leave
• Sign-on payments and restricted stock units (RSUs)

About the Team

CADE’s mission is to unite data engineering practices, BI technology, and data-driven innovation to strengthen data governance, productivity, and customer insights. Through a centralized structure, CADE focuses on enhancing the data platform, building consolidated source of truth datasets, dashboards and reports, conducting holistic analyses and research, and driving AI innovation and data strategies.