Business Intelligence Engineer II, Supply Tech Sciences

Amazon continues to invest in its Advertising business, and Publisher Technologies builds the services and data capabilities that enable Amazon’s first party publishers to improve customer experiences and monetize their inventory. The Publisher Technology Data, Insights, and Analytics team provides the near real time data, analytics, reporting, and data management tools used by hundreds of teams across Amazon to understand advertising performance, make business decisions, and support machine learning at scale.As a Business Intelligence Engineer II, you will design and own analytical solutions that turn large, complex datasets into actionable insights. You will build data models, ETL pipelines, dashboards, metrics, and reporting tools while working across engineering, science, product, and business teams. You will investigate performance trends, establish reliable measurement frameworks, and design experiments that improve publisher and advertiser experiences.You will own mid to large scale BI solutions, often starting with loosely defined business problems and translating them into clear analytical approaches and deliverables. The role requires strong SQL, data modeling, visualization, and analytical skills, along with the ability to understand data lineage, identify the business context behind metrics, and communicate findings that influence product and business decisions.Key job responsibilities- Design, build, and maintain BI solutions including data models, ETL workflows, dashboards, and reports that serve your team and its stakeholders, ensuring solutions are testable, performant, and well-documented.- Collaborate with business partners and technical teams to refine ambiguous problems into specific deliverables, recommend alternatives, and anticipate future analytical needs based on a deep understanding of the business context.- Apply SQL expertise and data engineering best practices to extract, transform, and load data at scale, while optimizing query performance and minimizing resource usage across the team's data infrastructure.- Create compelling data visualizations and self-service reporting tools that enable stakeholders to interpret results independently and make informed decisions quickly.- Mentor peers on the team's BI architecture and data lineage, contribute to design and scoping discussions, and apply basic statistical methods to support analytical rigor in solving business problems.A day in the lifeYou start your morning reviewing a stakeholder request for a new metric, working through the data lineage to understand how upstream systems generate the underlying signals. After refining the requirements in a quick sync with your business partner, you spend focused time writing SQL and building a new data model. In the afternoon, you pair with a teammate to review a dashboard prototype, offer feedback on visualization choices, and wrap up by documenting your design decisions for the broader team.About the teamOur team is focused on delivering trusted, high-quality business intelligence that empowers partners across the organization to make better decisions. We build and maintain analytical solutions that connect data from multiple sources into clear, reliable insights our customers depend on every day.We value collaboration, technical craft, and a shared commitment to getting the details right. As we continue to scale our capabilities, you will play a key role in shaping how we approach data architecture and analytics for the years ahead.Basic qualifications- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience- 1+ years of SQL, ETL or Oracle experience- 1+ years of processing large, multi-dimensional datasets from multiple sources experience- 1+ years of performing statistical analysis experience- 1+ years of developing automated reporting experience- Experience with data visualization using Tableau, Quicksight, or similar tools- Experience with data modeling, warehousing and building ETL pipelines- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modelingPreferred qualification - 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 datasetsAmazon 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 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 .USA, WA, SEATTLE - 99,500.00 - 160,000.00 USD annually