Sr. Business Intelligence Engineer, B2c, Amazon Leo

Amazon Amazon · Big Tech · Bellevue, WA · Business Intelligence

This role is for a Senior Business Intelligence Engineer at Amazon Leo, focusing on building analytics and data foundations for the global marketing engine. The engineer will design and build datasets, dashboards, and pipelines, manage backend data architecture in Customer Data Platform (Treasure Data), and ensure data accuracy and actionability across the customer journey. Responsibilities include architecting datasets, developing SQL transformations and data models, managing dashboards, conducting deep-dive analysis, translating business questions into analytical approaches, and driving alignment on KPIs and data governance. The role requires collaboration with various teams and involves strategic and technical decision-making.

What you'd actually do

  1. Architect, build, and maintain foundational business datasets across our tech stack and other internal systems to support analytics, reporting, and customer growth use cases.
  2. Develop SQL-based transformations, data models, and ETL/ELT workflows to structure and unify marketing and customer data for customer lifecycle use cases.
  3. Design, optimize, and manage Amazon QuickSight dashboards that provide visibility into acquisition performance, attribution, and lifecycle funnels.
  4. Conduct deep-dive analysis to identify funnel drop-offs, diagnose performance issues, uncover customer insights, and evaluate marketing effectiveness.
  5. Translate ambiguous business questions into structured analytical approaches, data models, and scalable self-service tools.

Skills

Required

  • 10+ years of professional or military experience
  • 5+ years of SQL 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
  • Experience programming to extract, transform and clean large (multi-TB) data sets
  • Experience with theory and practice of design of experiments and statistical analysis of results
  • Experience with AWS technologies
  • Experience in scripting for automation (e.g. Python) and advanced SQL skills.
  • Experience with theory and practice of information retrieval, data science, machine learning and data mining

Nice to have

  • Experience working directly with business stakeholders to translate between data and business needs
  • Experience managing, analyzing and communicating results to senior leadership