AWS Data Engineer: Cloud ETL & Analytics

Amazon Web Services (AWS); Seattle (WA); On-site; USD 101,000 - 160,000; Full time

Benefits offered by this job

Health insurance

401(k) matching

Paid time off

Parental leave

Life & AD&D insurance

Job summary

Amazon Data Services, Inc. in Seattle is seeking a Data Engineer to enhance our data architecture and deliver end-to-end data engineering solutions for complex analytics.

You will collaborate with BI engineers and software engineers to translate data into actionable insights and support internal customers with reporting infrastructure. The role focuses on developing automated ETL pipelines, data modeling, and building scalable data warehouses/data lakes, while ensuring data security and proper

Qualifications

• 1 year of data engineering experience.
• Experience with data modeling, warehousing and building ETL pipelines.
• Experience with one or more query language (e.g., SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, Scala)
• Experience with one or more scripting language (e.g., Python, KornShell)
• Preferred: Hadoop, Hive, Spark, EMR and ETL tools (Informatica, ODI, SSIS, BODI, Datastage).

Responsibilities

• Develop and maintain automated ETL pipelines (with monitoring) using scripting languages such as Python, Spark, SQL and AWS services such as S3, Glue, Lambda, SNS, SQS, KMS.
• Implement and support reporting and analytics infrastructure for internal business customers.
• Develop and maintain data security and permissions solutions for enterprise scale data warehouse and data lake implementations including data encryption and database user access controls and logging.
• Develop data objects for business analytics using data modeling techniques.
• Develop and optimize data warehouse and data lake tables using best practices for DDL, physical and logical tables, data partitioning, compression, and parallelization.
• Develop and maintain data warehouse and data lake metadata, data catalog, and user documentation for internal business customers.
• Work with internal business customers and software development teams to gather and document requirements for data publishing and data consumption via data warehouse, data lake, and analytics solutions.

Skills

Data engineering

Data modeling

ETL pipelines

SQL

Scripting

Tools

Python

KornShell

Spark

HiveQL

SparkSQL

Job description

Amazon Data Services, Inc. in Seattle is seeking a Data Engineer to enhance our data architecture and deliver end-to-end data engineering solutions for complex analytics.

You will collaborate with BI engineers and software engineers to translate data into actionable insights and support internal customers with reporting infrastructure. The role focuses on developing automated ETL pipelines, data modeling, and building scalable data warehouses/data lakes, while ensuring data security and proper