BIE II, SCOT NEST

Amazon.com Inc.; New York (NY); On-site; USD 110,000 - 185,000; Full time

Job summary

Amazon.com Services LLC is seeking a Business Intelligence Engineer to design, develop, and deliver automated BI reporting for UPX and CPF/UPO expansion across global networks. You will own end-to-end measurement frameworks, dashboards, and pipelines driving model accuracy, adoption, and benefits realisation.

You will collaborate with Science, S&OP, Product, and Finance teams, presenting analyses to senior leadership and enabling data-backed decisions across multiple regions.

Qualifications

• 3+ years analyzing and interpreting data with Redshift, Oracle, NoSQL.
• 1+ years SQL, ETL or Oracle experience.
• 1+ years processing large, multi-sourced datasets.
• 1+ years performing statistical analysis.
• 1+ years developing automated reporting.
• 3+ years in related occupation.
• Experience with data visualization using Tableau, Quicksight or similar.
• Experience in data modeling, warehousing and ETL pipelines.
• Experience in statistical packages such as R, SAS, Matlab.
• Python scripting to process data for modeling.

Responsibilities

• Own end-to-end BI reporting for UPX and CPF/UPO expansion across networks.
• Build launch/adoption measurement dashboards and pipelines.
• Design guardrail reporting for model performance and plan quality.
• Maintain BAU reporting: weekly, monthly packs and dashboards.
• Architect dimensional models and ETL pipelines into a single source of truth.
• Drive standardisation of metrics across networks with cross-team collaboration.
• Apply AI tools to automate reporting workflows.
• Translate analyses into narratives for senior leadership.

Skills

Redshift/Oracle/NoSQL

SQL & ETL

Statistical analysis

Automated reporting

Tableau/Quicksight

Python scripting

Education

Bachelor's degree or equivalent

Tools

AWS (EC2, DynamoDB, S3, Redshift)

Job description

Job ID: 10585495 | Amazon.com Services LLC

As a Business Intelligence Engineer in Network Evolution Science & Tech (NEST), you will own the design, development, and delivery of reporting and measurement solutions that power the global expansion of our flagship planning platforms — UPX (Unified Planner Experience) and CPF/UPO (the coordination and optimization layer) — into emerging fulfillment networks worldwide.

You will work at the intersection of supply chain planning, operational intelligence, and optimization-model performance. Your reporting products will directly inform decisions that affect planner productivity, plan quality, and automation adoption as we scale from a single network in production to the full universe of non-core networks: Sub Same Day, Quick Commerce, Distribution Centres (SDC/1DC/rDC), AMXL, Rural and Super Rural+, AWD, and more, across all regions. You will design the measurement frameworks that show whether each new network launch is delivering accurate, trusted, adopted plans — before gaps reach decision-makers. And you will own the reporting suite that keeps the NEST function accountable to launch milestones, model performance, and benefits realisation.

You will operate independently, managing ambiguity with rigor and judgment — much of what you measure does not exist yet and will be defined as networks onboard. You will partner closely with Science, Engineering, Product, S&OP planning teams, UPO/UPX platform partners, and Finance. You will present your analysis and recommendations independently to senior leadership, influence launch and prioritisation decisions through data-backed arguments, and contribute to the team's AI-driven transformation agenda.

Key job responsibilities

• Own end-to-end design, development, and maintenance of automated BI reporting that measures UPX and CPF/UPO expansion across every network × country — model accuracy, planner adoption, plan-vs-actuals, and benefits realisation.
• Build the network launch and adoption measurement framework: dashboards and pipelines tracking optimisation-model accuracy, planner cycle time, adoption rates, and manual-process retirement as networks onboard (Sub Same Day, Quick Commerce, SDC, 1DC, rDC, AMXL, Rural and Super Rural+, AWD).
• Design model-performance and plan-quality guardrail reporting with scalable alerting that flags when outputs or upstream signals breach thresholds, enabling proactive intervention.
• Own the BAU reporting suite: weekly flash reports, WBR/MBR/QBR packs, peak readiness dashboards, launch-milestone tracking, and forecast-accuracy reporting.
• Architect dimensional data models and ETL pipelines integrating upstream signals, UPO/CPF, UPX, and network planning tools into a single source of truth.
• Drive metric standardisation across networks by partnering with Science, S&OP, and platform teams on definitions, methodologies, and data quality.
• Independently apply AI tools to automate reporting workflows and improve speed, quality, and self-service.
• Translate deep-dive analyses into narratives for Director- to VP-level audiences, and own data quality, pipeline reliability, SLAs, and on-call support.

About the team

Network Evolution Science & Tech (NEST) team owns planning optimization for networks outside the core FC network — 8 network types across 12 countries and 2,000+ non-core nodes (Sub Same Day, SDC, 1DC, rDC, Quick Commerce, Grocery, Rural and Super Rural+, AMXL, AWD). Our north star: every planner creates, analyses, and publishes plans through automated optimization on UPX — no spreadsheets, no tribal knowledge. Spanning operations research, optimization modelling, data science, and program management, we automate planning so S&OP capacity scales sub-linearly as the network grows. We're now building the reporting foundation that makes this expansion visible, measurable, and governable.

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
• 3+ years of in the job offered or a related occupation experience
• 1+ years of using SQL, ETL (Extract, Transform, Load), or Oracle experience
• Bachelor's degree or foreign equivalent in Computer Science, Engineering, Mathematics, Statistics, Economics, or a related field
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with data modeling, warehousing and building ETL pipelines
• Experience in Statistical Analysis packages such as R, SAS and Matlab
• 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

Amazon 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 https://amazon.jobs/content/en/how-we-hire/accommodations 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 https://amazon.jobs/en/benefits .

USA, NY, New York - 109,500.00 - 185,000.00 USD annually

USA, WA, Bellevue - 99,500.00 - 160,000.00 USD annually

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status. Veterans, military spouses, and people with disabilities are encouraged to apply.