Senior Business Intelligence Engineer, WW FBA Central Analytics We seek a Senior Business Intelligence Engineer to drive data strategy and analytics across multiple high-impact workstreams within our organization. This role operates at the intersection of business intelligence, data platform modernization, and AI-powered analytics. You will own end-to-end BI solutions that transform how stakeholders consume and act on data across the organization. Key job responsibilities - You will design and own unified dimensional frameworks with consistent metric definitions, dimensional cuts, and calculation logic across all reporting surfaces. - You will define metric hierarchies that connect controllable inputs to business outputs, ensuring every metric has a complete definition including formula, data source mapping, calculation logic, data quality rules, and interpretation guidelines. - You will build scalable reporting tables and semantic models that serve multiple downstream use cases (WBR, MBR, dashboards, ad-hoc analysis, GenAI agents) from a single governed source. - You will own end-to-end WBR/MBR reporting infrastructure across WW FBA regions, including automated assembly, validation, and delivery. - You will build and maintain dashboards and self-service analytics solutions that enable PMs to answer business questions without filing a ticket. - You will develop variance decomposition frameworks, root cause analysis templates, and dimensional deep-dive capabilities that support leadership decision-making. - You will translate business questions into analytical approaches, working directly with PMs, Ops, Finance, and Science teams to scope requirements and deliver insights. - You will design and build analytics data models in the lakehouse architecture (Redshift, S3, Spark) optimized for both recurring reporting and ad-hoc exploration. - You will own the semantic layer that connects raw data to business meaning, ensuring consistent definitions across all consumers (dashboards, agents, reports, ad-hoc queries). - You will establish dimensional modeling standards (metric-in-rows format, fully descriptive column names, standardized grain definitions) that support GenAI Text-to-SQL applications. - You will build and maintain validated semantic models that power natural language query agents, ensuring accuracy for business user queries against WBR/MBR data. - You will develop proactive alerting and anomaly detection capabilities that surface issues before they reach leadership review forums. - You will mentor BAs across partner teams on how to leverage the governed analytics infrastructure rather than building independent forks. BASIC QUALIFICATIONS - 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 - 5+ years of as a Data Analyst, Data Engineer, Business Intelligence Analyst, 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 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 PREFERRED QUALIFICATIONS - Experience working directly with business stakeholders to translate between data and business needs - Experience managing, analyzing and communicating results to senior leadership 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, WA, Seattle - 130,400.00 - 176,300.00 USD annually