Business Intelligence Engineer, Amazon

DescriptionBecome a Customer Obsessed Business Intelligence Engineer for Amazon Private BrandsAt Amazon, we're on a mission to be the most customer-centric company on Earth. To achieve this, we're seeking exceptional, talented, and driven builders to help us deliver remarkable customer experiences.We're looking for a dynamic, customer-obsessed, and innovative Business Intelligence Engineer to join our Amazon Private Brands team. Our Private Brands offer customers outstanding quality at great prices, and we need skilled software engineers to build new systems that will help customers discover these products.In this role, you'll be a key connector between the various facets of Amazon Private Brand data, driving insights across areas like sustainability, compliance, sourcing, and more. To succeed you'll need excellent SQL and Git skills as well as ETL optimization experience and visualization tool expertise. Most importantly you need to be a strong communicator who is able to prioritize and make tradeoffs quickly.If you're a customer obsessed, data-driven builder ready to make a real impact, we want to hear from you. Join us in creating the future of data within Amazon Private Brands.Key job responsibilitiesAs a business intelligence (BI) engineer within Amazon Private Brands, you will be a crucial member of our data analytics team, responsible for designing, implementing, and maintaining robust BI solutions that empower our business stakeholders to make data-driven decisions. Your key responsibilities will include collaborating closely with the business and subject matter experts to deeply understand their reporting and analytics requirements.Leveraging your expertise, you will design and develop complex data models, ETL (extract, transform, load) processes, and interactive dashboards/visualizations using AWS services like Redshift, Glue, Amazon Quicksight, and LLMs like Amazon Q. Automating data integration and transformation workflows will be a core part of your role, ensuring timely, accurate, and scalable reporting capabilities.Additionally, you will be responsible for optimizing query performance to support increasing data volumes and user demands, guaranteeing our BI infrastructure remains efficient and reliable. Providing data support and hands-on training to end-users will also be a key focus, as will continuously staying on top of the latest BI trends and technologies to recommend strategic improvements.If you are a data-driven problem-solver with a passion for turning raw data into actionable intelligence, we encourage you to join our team!A day in the lifeAs a BI engineer at Amazon Private Brands, your days will be dynamic and diverse. One moment you could be crafting complex data visualizations to empower senior leadership with actionable insights, and the next you might be writing SQL to smoothly collate billions of records. You'll also collaborate with senior data engineers to solve intricate ETL pipeline discrepancies. Change is the only constant at Amazon, ensuring you're constantly exploring new avenues and optimizing datasets to drive business impact.About the teamPrivate Brand Analytics provides essential data support for various Amazon Private Brands divisions. Team events and making the most of our office time foster a cohesive and supportive environment, ensuring we all work towards a common goal.Our enthusiastic Seattle-based team eagerly awaits your arrival as we continue our shared journey of learning and development.Basic Qualifications

Experience with theory and practice of design of experiments and statistical analysis of results

Experience in scripting for automation (e.g. Python) and advanced SQL skills.

5+ years of SQL experience

Knowledge of data warehousing and data modeling

Experience with AWS tools such as Quicksight, S3, and Redshift, Glue, Athena and Lambda

Preferred Qualifications

Experience working directly with business stakeholders to translate between data and business needs

Experience managing, analyzing and communicating results to senior leadership

Experience programming to extract, transform and clean large (multi-TB) data sets

Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us.Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $117,300/year in our lowest geographic market up to $202,800/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site.