Business Intelligence Engineer, Customer Data & Analytics, Customer Strategy

Amazon Amazon · Big Tech · NY +1 · Business Intelligence

This Business Intelligence Engineer role focuses on owning and scaling the customer data infrastructure and attribute store for e-commerce platforms (Shopbop and Zappos). The role involves designing data schemas, defining governance standards, building scalable data pipelines in partnership with Data Engineering, and creating dashboards and reporting for customer insights, marketing, and leadership. It also includes integrating third-party data sources, operationalizing models with Data Science, and driving measurement infrastructure for analysis and performance tracking. The ideal candidate has strong data engineering fundamentals, strategic thinking, and business judgment, with experience in SQL, data warehousing, and AWS technologies.

What you'd actually do

  1. Own the customer tables and customer attribute store end-to-end, defining schema design, data quality standards, and governance that ensure completeness, accuracy, and accessibility across Shopbop and Zappos.
  2. Partner with Data Engineering to architect scalable data pipelines, define SLAs for freshness and reliability, and drive the technical roadmap for the customer data layer.
  3. Build and maintain dashboards and reporting tools that enable Customer Insights, Marketing, and Leadership to track customer KPIs, segment performance, and strategy effectiveness.
  4. Lead deep dives with Customer Insights Managers to segment customers, measure lifecycle and acquisition impact, and surface actionable trends.
  5. Own third-party data sources and tooling, ingestion cycles, compliance, and integrations connecting external data into our customer ecosystem.

Skills

Required

  • 10+ years of professional or military experience
  • 5+ years of SQL experience
  • 1+ years of processing large, multi-dimensional datasets from multiple sources 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.
  • 3+ years of developing automated reporting experience
  • Experience working directly with business stakeholders to translate between data and business needs
  • Experience managing, analyzing and communicating results to senior leadership
  • Knowledge of data warehousing and data modeling

Nice to have

  • Experience with data pipeline and orchestration tools such as Airflow, dbt, or AWS Glue
  • Experience integrating third-party data sources with first-party customer data
  • Experience with customer segmentation frameworks and lifecycle analytics
  • Experience with Python or R for data analysis and automation
  • Understanding of data governance, data quality monitoring, and documentation best practices
  • Experience within e-commerce or retail
  • Experience with customer data platforms or customer attribute stores
  • Usage of generative AI tools to enhance workflow efficiency, with a willingness to learn effective prompting and evaluation practices
  • Ability to recognize opportunities where generative AI could enhance products, workflows, or customer experiences

What the JD emphasized

  • 10+ years of professional or military experience
  • 5+ years of SQL experience
  • Experience with AWS technologies
  • Experience in scripting for automation (e.g. Python) and advanced SQL skills.
  • 3+ years of developing automated reporting experience
  • Knowledge of data warehousing and data modeling