Business Intelligence Engineer , World Wide Engineering and Innovation

About the role

You will design and build automated dashboards, data models, and ETL pipelines that replace fragmented Excel-based reporting with self-service QuickSight analytics for Amazon’s global last-mile delivery station automation portfolio. Your work directly enables three PMO workstreams: capital project portfolio tracking, site launch intelligence, and workforce/resource planning. You’ll integrate data from internal platforms (enterprise data lakes, project management systems, procurement platforms, and approval workflows) into unified views that leadership uses daily to make multi-million dollar investment decisions.

Responsibilities

• Design and build ETL pipelines connecting internal data sources (enterprise data lakes, project tracking systems, procurement platforms, and approval workflows) into a unified analytics layer using Redshift and S3.
• Develop and maintain Amazon QuickSight dashboards for capital project tracking (inventory, funding status, closure timelines), site launch status, and resource utilization.
• Lead migration of manual Excel consolidation (9+ regional spreadsheets) into automated, self-refreshing data models.
• Partner with three PMO program managers to translate business requirements into scalable BI solutions—from requirements gathering through production deployment and iteration.
• Build data quality monitoring frameworks ensuring dashboards reflect ground truth within defined SLAs.
• Leverage existing internal data platforms and curated data layers rather than building bespoke ingestion from raw sources.
• Support operational reporting cadences: Monthly Business Reviews, Flash Reports, Prime event daily trackers, and ad-hoc VP-level requests.
• Design the data architecture for a resource utilization model (people-per-task calculations derived from project hours, roster data, and historical actuals).

About the Team

The WWEI MHE & Automation PMO is a newly formed function within Amazon’s World Wide Engineering and Innovation organization. We manage the capital portfolio, resource planning, and operational reporting for Amazon’s delivery station automation programs—including automated sortation (ADTA), robotic induction, Tetromino next-generation building templates, and 15+ other technology deployments across 6 continents. Our team is building the PMO discipline from the ground up, which means you’ll have outsized influence on tooling choices, data architecture, and team standards. We value automation over manual effort, building on existing platforms rather than reinventing, and making data accessible to non-technical stakeholders who need answers fast.

Basic Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL, etc.
• 1+ years of SQL, ETL, or Oracle 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 in statistical analysis packages such as R, SAS, and MATLAB.
• Bachelor’s degree in BI, finance, engineering, statistics, computer science, mathematics, or equivalent quantitative field.

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 $99,500–$160,000 USD annually, with additional compensation including sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on experience, qualifications, and location.