Data Engineer II, Product BI

Amazon; Seattle (WA); On-site; USD 132,000 - 179,000; Full time

Benefits offered by this job

Health insurance

401(k) matching

Paid time off

Job summary

Amazon in Seattle, WA is seeking an experienced Data Engineer to design and operate large-scale data structures and ETL/ELT pipelines for BI analytics. You will model data, optimize warehousing, and collaborate across teams to deliver scalable data solutions.

Candidates should have strong SQL skills, Oracle experience, and hands-on work with AWS data services such as Redshift, S3, Glue, and EMR. This is a full-time, on-site role with comprehensive benefits.

Qualifications

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

Responsibilities

• Build scalable data pipelines to support BI analytics.
• Develop and optimize data structures for large-scale warehousing.
• Collaborate with teams to implement OLAP solutions and data models.

Skills

Data engineering

ETL/ELT

OLAP analytics

SQL

Data modeling

Oracle

Tools

Redshift

S3

AWS Glue

EMR

Kinesis

Lambda

IAM

Job description

Description

We provide product innovations from foundational services such as Amazon Elastic Compute Cloud (EC2), Redshift Serverless, Containers (ECS, EKS) and other Streaming services to consistently release new product innovations/drive insights that continue to set AWS’s services and features apart in the industry. We are customer obsessed and focus on building innovation.

We build data products to simplify our customer's problems, bring operational and technical efficiency. We need to be able to build scalable solutions for ever growing data , be compliant and adopt to diverse business needs

About AWS

Amazon Web Services (AWS) is the world’s most comprehensive and broadly adopted cloud platform. We pioneered cloud computing and never stopped innovating — that’s why customers from the most successful startups to Global 500 companies trust our robust suite of products and services to power their businesses.

Diverse Experiences

AWS values diverse experiences. Even if you do not meet all of the qualifications and skills listed in the job description, we encourage candidates to apply. If your career is just starting, hasn’t followed a traditional path, or includes alternative experiences, don’t let it stop you from applying.

Work/Life Balance

We value work-life harmony. Achieving success at work should never come at the expense of sacrifices at home, which is why we strive for flexibility as part of our working culture. When we feel supported in the workplace and at home, there’s nothing we can’t achieve in the cloud.

Inclusive Team Culture

Here at AWS, it’s in our nature to learn and be curious. Our employee-led affinity groups foster a culture of inclusion that empower us to be proud of our differences.

Mentorship & Career Growth

We’re continuously raising our performance bar as we strive to become Earth’s Best Employer. That’s why you’ll find endless knowledge-sharing, mentorship and other career-advancing resources here to help you develop into a better-rounded professional.

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
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using Oracle 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, Seattle - 132,100.00 - 178,800.00 USD annually