Data Engineer II, DBS BI

Overview

AWS Databases, Analytics and AI/ML Products and Services is one of the largest and fastest-growing business units within AWS. The team is rebuilding and revolutionizing data engineering and business intelligence systems to support fast-growing business needs.

• Design, implement, and support data warehouse/data lake infrastructure using AWS big data stack, Python, Redshift, Quick Sight, Glue/lake formation, EMR/Spark/Scala, Athena and other tools.
• Develop and manage ETLs to source data from various commercial, sales and operational systems and create a unified data model for analytics and reporting.
• Use business intelligence and visualization software (e.g., Quick Sight) to develop dashboards used by senior leadership.
• Enable technical and non‑technical internal customers to drive their own analytics and reporting (self‑serve reporting) and support ad‑hoc reporting when needed.
• Develop a deep understanding of vast data sources and determine when and which data to use to solve particular business problems.
• Work with Product Managers, Finance, Service Engineering Teams and Sales Teams on a day‑to‑day basis to support their analytics requirements.
• Manage numerous requests concurrently and prioritize them strategically.
• Partner and collaborate across teams/roles to deliver results.

• 5+ years of data engineering experience.
• 3+ years of developing and operating large‑scale data structures for business intelligence analytics using ETL/ELT processes.
• 3+ years of developing and operating large‑scale data structures for business intelligence analytics using OLAP technologies.
• 3+ years of developing and operating large‑scale data structures for business intelligence analytics using data modeling.
• 3+ years of developing and operating large‑scale data structures for business intelligence analytics using SQL.
• Experience with data modeling, warehousing, and building ETL pipelines.

• Experience with AWS technologies such as Redshift, S3, AWS Glue, EMR, Kinesis, Fire Hose, 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.