Data Engineer II, GMAC FP&A

Amazon.com Services LLC is hiring a Data Engineer II for its Global Media and Entertainment Finance organization. The role builds scalable data infrastructure, pipelines, reporting, and analytics capabilities to support financial reporting and forecasting, while contributing to data strategy and warehouse design.

Responsibilities

• Architect and develop end to end scalable data applications and data pipelines
• Design and build data reporting solutions across different visualization platforms (e.g. Quicksight)
• Establish scalable, efficient, automated processes for reporting, dashboards, data analyses and ML model development
• Ability to query, program, and perform analysis on large datasets using SQL languages and Python
• Build data infrastructure and manage other AWS resources including EC2, RDS, Redshift, EMR, etc
• Collaborate with other teams to extract, transform, and load data from a wide variety of data sources using SQL and AWS big data technologies
• Participate in data strategy and road map exercises, data warehouse design and implementation

Preferred

• 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)
• Experience in implementing modern machine-learning methods (e.g., boosted regression trees, random forests, neural networks)
• AWS
• Amazon Redshift
• Amazon S3
• AWS Glue
• Amazon EMR
• Amazon Kinesis
• Amazon Kinesis Data Firehose
• AWS Lambda
• IAM Roles
• Permissions
• Non-Relational Databases
• Object Storage
• Document Stores
• Key-Value Stores
• Graph Databases
• Column-Family Databases
• Machine Learning
• Boosted Regression Trees
• Random Forests
• Neural Networks

Benefits

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

Company

• Online retail and cloud computing services
• Seattle, Washington, USA
• https://amazon.com/
• Founded in 1994
• 10001+ employees

Qualifications

• 3+ years of data engineering experience
• Experience with data modeling, warehousing and building ETL pipelines
• Experience in at least one modern scripting or programming language, such as Python, Java, Scala, or NodeJS
• 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)
• Experience in implementing modern machine-learning methods (e.g., boosted regression trees, random forests, neural networks)

Required skills

• AWS Glue, Amazon EMR, Amazon Redshift, Amazon S3, Data Engineering, Data Modeling, Data Warehousing, ETL Pipelines, Java, Node.js, Python, Scala

Experience

• 3+ years