BI Engineer, AWS Finance, Analytics and Science Team

Socket.dev; Seattle (WA); On-site; USD 100,000 - 160,000; Full time

Benefits offered by this job

Health insurance

401(k) matching

Paid time off

Parental leave

Job summary

Amazon is seeking a creative, analytical Business Intelligence Engineer to join the ACES BI team in Seattle, WA. The role focuses on SQL, ETL, data wrangling, and Python for modeling and analysis, partnering with Finance, Science, and Business groups to answer key questions and guide decisions.

Experience with Redshift is preferred. You will design and maintain metrics, ensure data integrity, and use AI to automate workflows and reveal new patterns in large datasets, enabling self-serve data

Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience.
• Experience with data modeling, warehousing and building ETL pipelines.
• Experience using Python scripting to process data for modeling.
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling.

Responsibilities

• Work with business customers to gather requirements and deliver complete data analytical solutions
• Learn why customers are asking for data and what their underlying questions and business goals are
• Own the design, development, and maintenance of ongoing metrics and analyses used to drive key business decisions
• Recognize and adopt best practices, including data integrity, accuracy, and reliability, as well as documentation
• Leverage AI and emerging innovation in data infrastructure to automate repetitive workflows, accelerate analyses, and unlock new patterns from complex datasets
• Drive data democratization throughout the organization, enabling others to self-serve their data needs

Skills

SQL

Python

ETL

Data wrangling

Data analysis

Data modeling

Tools

Redshift

Oracle

NoSQL

Job description

AWS is one of Amazon’s largest and fastest-growing businesses, serving millions of customers in more than 190 countries. We use cloud computing to reshape the way global enterprises leverage information technology.

The AWS Central Economics & Science (ACES) team drives best practices for objectively applying economics and science to decision-making across AWS. Partnering with Finance, Science, and Business teams, ACES identifies, frames, and analyzes complex, ambiguous problems of the highest priority. The ACES Business Intelligence (BI) team supports strategic decision-making across the AWS global organization, delivering data-driven insights that power sales operations and business performance optimization. We are looking for a creative, analytical, and enthusiastic Business Intelligence Engineer to join us.

The ideal candidate is an expert in SQL, ETL, and general data wrangling, with exemplary communication skills. They thrive in ambiguity within a fast-paced, evolving environment and can think big while maintaining careful attention to detail. They are passionate about business intelligence tools and skilled at partnering with stakeholders to answer key business questions.

Key job responsibilities

• Work with business customers to gather requirements and deliver complete data analytical solutions
• Learn why customers are asking for data and what their underlying questions and business goals are
• Own the design, development, and maintenance of ongoing metrics and analyses used to drive key business decisions
• Recognize and adopt best practices, including data integrity, accuracy, and reliability, as well as documentation
• Leverage AI and emerging innovation in data infrastructure to automate repetitive workflows, accelerate analyses, and unlock new patterns from complex datasets
• Drive data democratization throughout the organization, enabling others to self-serve their data needs

Basic Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• Experience with data modeling, warehousing and building ETL pipelines
• Experience using Python scripting to process data for modeling
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling

Preferred Qualifications

• Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift
• Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets

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 - 99,500.00 - 160,000.00 USD annually