Business Intelligence Engineer

Transform data into trusted insights that power decisions for millions of Amazon Selling Partners worldwide. Join Spectrum Analytics as we build the data intelligence foundation for one of Amazon's fastest-growing businesses.

The Spectrum Analytics team is implementing data mesh architecture that will enable self-service analytics and AI-powered insights across Selling Partner Services (SPS). As a Business Intelligence Engineer I, you'll build foundational datasets, standardized metrics, and governance frameworks that eliminate data inconsistencies and empower teams to make confident, data-driven decisions. Your SQL expertise and analytical thinking will directly shape how we monitor developer usage, calculate fees, track compliance, and enable emerging GenAI capabilities through Amazon Quick Suite.

Why you'll love this role:
- High-impact greenfield work: Contribute to exciting transformation initiatives as we establish data governance standards and enable self-service analytics across the organization
- Visible business impact: Your BI solutions will directly support critical business decisions affecting millions of Selling Partners and thousands of third-party developers
- Collaborative environment: Partner with Data Engineers, Business Analysts, Software Development Engineers, and Program Managers in a world-class product development team
- Growth opportunities: Work with modern BI tools, AWS technologies, and cloud-based architecture while developing expertise in data governance, quality monitoring, and AI-ready data design
- Fast-paced innovation: Solve diverse data challenges in an environment where your work has highly visible impact on our rapidly growing business

If you're passionate about data quality, love solving analytical problems, and thrive in a collaborative environment where your work enables better business decisions, we want to talk with you.

Key job responsibilities
- Build and maintain small to mid-size BI solutions including datasets, queries, dashboards, and reports that enable data-driven decisions for Selling Partner API teams and stakeholders
- Write high-quality, efficient, testable code in SQL and Scala to extract, transform, and analyze data from distributed systems, ensuring outputs are tested against source data and business logic
- Create standardized, reusable datasets (signals) following data mesh governance principles that eliminate metric inconsistencies and enable self-service analytics across Spectrum
- Develop and maintain ETL processes using SQL and Scala that transform raw domain data into trusted, AI-ready datasets with proper lineage documentation and quality controls
- Build dashboards and visualizations using industry-standard BI tools (QuickSight, Tableau, Excel) that provide actionable insights on developer usage, fee calculations, compliance tracking, and risk monitoring
- Collaborate with Business Analysts, Data Engineers, Software Development Engineers, and business stakeholders to understand requirements, validate data quality, and ensure deliverables align with expectations
- Implement data governance standards including proper classification, Fine-Grained Access Control (FGAC), and standardized naming conventions across all datasets
- Investigate data anomalies, troubleshoot quality issues, and automate manual processes to improve operational efficiency
- Document BI solutions clearly to ensure ease of use, interpretation, and maintainability by team members and downstream consumers
- Partner with Analytics and domain teams to enable GenAI capabilities through Amazon Quick Suite while maintaining robust data security and access controls

A day in the life
You'll start your mornings collaborating with your Analytics teammates—reviewing code with senior engineers, discussing data quality issues flagged overnight, and planning your sprint priorities. Much of your day involves hands-on technical work: writing SQL queries to extract insights from massive datasets, developing Scala ETL scripts to transform raw data into standardized formats, and building dashboards in QuickSight that product managers and operations teams rely on daily.

You'll partner closely with Software Development Engineers to understand how data flows through our systems, work with Data Engineers to optimize pipelines, and meet with business stakeholders to translate their questions into actionable analytics. When a product manager asks "Why did developer adoption drop last week?" or an operations team needs to automate a manual report, you're the one investigating the data, finding the answer, and building solutions that prevent the same question from coming up again.

Your work directly impacts how Selling Partner API teams make decisions. The datasets you create become the foundation for compliance tracking, fee calculations, and developer usage monitoring across