BIE II, SCOT NEST

About the role

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.

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

Additional information

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If the country/region you're applying in isn't listed, please contact your Recruiting Partner.

Pay and benefits

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.

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

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