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 life
You 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 team
Our 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 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
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
