Data Engineer II, DBS BI

Amazon Web Services (AWS); Bellevue (WA); On-site; USD 132,100 - 178,800; Full time

Benefits offered by this job

Sign-on payments

RSUs

Health insurance

Paid time off

Parental leave

Job summary

Amazon Development Center U.S., Inc. is seeking an experienced Data Engineer to build data pipelines, data warehouses, and BI solutions on the AWS stack. You will collaborate with product and finance teams to deliver actionable insights and scalable data models.

You will mentor colleagues and drive best practices in data engineering, analytics, and reporting, delivering timely insights for senior leadership across the business.

Qualifications

• 5+ years of data engineering experience.
• 3+ years building and operating large-scale data structures for BI analytics using ETL/ELT.
• 3+ years building and operating large-scale data structures for BI analytics using OLAP.
• 3+ years building and operating large-scale data structures for BI analytics using data modeling.
• 3+ years building and operating large-scale data structures for BI analytics using SQL.
• Experience with data modeling, warehousing and ETL pipelines.

Responsibilities

• Design, implement, and support data warehouse / data lake infrastructure using AWS big data stack.
• Develop and manage ETLs to source data and create unified analytics data model.
• Create dashboards with BI tools (e.g., QuickSight) for senior leadership.
• Enable self-serve analytics for internal customers and support ad-hoc reporting.
• Understand vast data sources and select data to solve business problems.
• Collaborate with Product, Finance, Service Eng, and Sales on analytics needs.
• Manage multiple requests, prioritize as needed.
• Partner across teams and mentor engineers to grow the team.

Skills

Data engineering

ETL/ELT

OLAP analytics

Data modeling

SQL

Tools

Redshift

S3

Glue

EMR

Kinesis

Lambda

Job description

Description

AWS Databases, Analytics and AI/ML Products and Services is one of the largest and fast-growing business unit within AWS. We are working to rebuild and revolutionize data engineering and business intelligence systems within database, analytics and AI/ML organization to support fast growing business needs.

AWS Databases, Analytics and AI/ML Products and Services is one of the largest and fast-growing business unit within AWS. We are working to rebuild and revolutionize data engineering and business intelligence systems within database, analytics and AI/ML organization to support fast growing business needs. We are looking for experienced, self-driven Data Engineer. In this role, you will be building complex data engineering and business intelligence applications using AWS big data stack. You should have deep expertise and passion in working with large data sets, data visualization, building complex data processes, performance tuning, bringing data from disparate data stores and programmatically identifying patterns. You should have excellent business acumen and communication skills to be able to work with business owners to develop and define key business questions and requirements. You will provide guidance and support for other engineers with industry best practices and direction. Amazon Web Services (AWS) has culture of data-driven decision-making, and demands timely, accurate, and actionable business insights.

Key job responsibilities

• Design, implement, and support data warehouse / data lake infrastructure using AWS big data stack, Python, Redshift, QuickSight, Glue/lake formation, EMR/Spark/Scala, Athena etc.
• Develop and manage ETLs to source data from various commercial, sales and operational systems and create unified data model for analytics and reporting.
• Use business intelligence and visualization software (e.g., QuickSight.) to develop dashboards those are used by senior leadership.
• Empower technical and non-technical, internal customers to drive their own analytics and reporting (self-serve reporting) and support ad-hoc reporting when needed.
• Develop deep understanding of vast data sources and know exactly how, when, and which data to use to solve particular business problems.
• Work with Product Managers, Finance, Service Engineering Teams and Sales Teams on day-to-day basis to support their new analytics requirements.
• Manage numerous requests concurrently and strategically, prioritizing when necessary
• Partner/collaborate across teams/roles to deliver results.
• Mentor other engineers, influence positively team culture, and help grow the team.

Basic Qualifications

• 5+ years of data engineering experience
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes experience
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using OLAP technologies experience
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using data modeling experience
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using SQL experience
• 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, Bellevue - 132,100.00 - 178,800.00 USD annually

Company

Amazon Development Center U.S., Inc.

Job ID: A10431072