Seller Services is one of the fastest growing businesses within Amazon. The "Selling on Amazon" service enables third-party sellers to sell their products via Amazon and reach tens of millions of potential shoppers.

Japan Seller Services is seeking a Business Intelligence Engineer to join the BI team to support the growing new business: Amazon Furusato. The core focus of this role is to leverage data and BI capabilities to directly support the goals and initiatives of Amazon Furusato. Stakeholders include product/program managers, sales managers and leadership team. The ideal candidate will be excited about pulling complex data from large scale database using SQL, identifying and developing metrics that are relevant to the focus of programs, automating metrics tracking on Quicksight or Excel, diving deep into data to fix business issues and uncover growth opportunities, estimating business impact for the new program using proxy data, and running statistical models. The ideal candidate will possess strong business acumen and enjoy influencing business decisions while improving operational efficiency to drive higher productivity.

Core Competencies:

- Manage request intake independently and set priorities based on organizational needs.
- Manage multiple tasks simultaneously and deliver in the most efficient and effective way.
- Interact and communicate effectively with stakeholders, including senior leadership from multiple project areas.
- Translate complex or ambiguous business problems into clear analysis requirements.
- Proactively identify high-impact business problems and help partners create actionable priorities.
- Derive business insights from analysis and provide recommendations.
- Extract data from large-scale Redshift databases using optimized SQL queries.
- Design and implement data pipelines specific to Japan-unique business requirements.
- Develop metrics tracking and automate scheduled report refreshes (daily, weekly, monthly, and quarterly).
- Design and implement robust, extensible, and scalable solutions.
- Ensure data accuracy and reliability while adhering to globally standardized definitions.
- Demonstrate technical expertise (SQL, Python, Statistics, AWS technologies) in delivering BI solutions.
- Effectively communicate technical blockers and requirements with Business Intelligence teams in US/India.
- Balance technical trade-offs between long-term scalability and short-term deliverables.
- Review and interpret business documents to understand priorities.
- Write clear documentation outlining analysis details, insights, and recommendations.

Key job responsibilities
This position collaborates closely with business partners (Product/Program/Sales Managers) and technical partners (BIEs, Data Engineers, Data Scientists) across the following four pillars:

[Data Visualization]
Build, maintain, and develop comprehensive metrics dashboards in Quicksight/Excel for weekly/monthly/quarterly business reviews, serving both leadership teams and operational managers (product/program/account managers).

[Analytics]
Deliver insights and recommendations to support business decision-making. This includes opportunity/risk/impact analysis of new programs/product features and investigation of data quality/customer-facing issues. The position may require using statistical models and delivering concise analytical documents or contributing to business documentation.

[Ad-hoc Data Pull]
Design and execute SQL queries to extract complex data for short/long-term planning and quick decision-making. This requires good judgment in determining what should be supported by BIEs vs. self-managed by data requesters.

[Operational Efficiency]
Enhance BI team productivity through cross-regional collaboration with Business Intelligence Engineers and Data Engineers in US/India teams to develop and implement innovative solutions.

A day in the life
A day in the life of a Business Intelligence Engineer is dynamic and collaborative. The typical activities include:

- Taking BI requests through SIM ticketing system
- Collaborating with stakeholders to align on requirements via multiple channels (meetings, Slack, in-person discussions)
- Balancing priorities while evaluating speed vs. quality tradeoffs
- Tackling technical challenges at both organizational and team levels

About the team
Our diverse team of 10 collaborates to tackle technical challenges and drive innovation - from traditional analytics to AI-driven solutions - while maintaining a work-life harmony.