Business Intelligence Engineer , Customer Experience and Business Trends

Amazon; Arlington (VA); On-site; USD 100,000 - 160,000; Full time

Job summary

Amazon in Arlington, VA is seeking a Business Intelligence Engineer for BEAM to build a curated data catalog and reusable analytics assets for agent-based surfaces. You will design MCP interfaces and tools, enabling LLM agents to query BEAM data with trust and determinism.

You will collaborate with data scientists and product managers to translate analytical needs into self-service capabilities, ensuring observability and guardrails to prevent misreporting across CX and business trends.

Qualifications

• 5+ years of SQL, ETL, or Oracle experience.
• 5+ years of statistical analysis experience.
• 5+ years of automated reporting experience.
• 3+ years of processing large multi-dimensional datasets from multiple sources.

Responsibilities

• Build and maintain the curated data catalog and reusable foundation/metric tables that power BEAM's Intelligence Engine.
• Design and implement MCP servers and skills that expose BEAM data and analyses to LLM agents for natural-language querying (Text-to-SQL, metric lookup, retrieval).
• Build deterministic query and metric layers so agents cite and route to real data rather than estimating with guardrails.
• Develop ETL pipelines and data models (SQL, Python) turning raw internal + third-party data into analysis-ready assets.
• Partner with data scientists, economists, and product managers to translate recurring analytical needs into reusable, self-service capabilities.
• Instrument evaluation and observability to measure and improve agent answer quality over time.

Skills

SQL

ETL

Statistical analysis

Automated reporting

Large datasets

Education

Bachelor's degree in Computer Science, Engineering, Mathematics, Statistics, Economics, or related field

Tools

AWS Redshift

S3

Athena

Glue

MCP

Text-to-SQL

Job description

Business Intelligence Engineer , Customer Experience and Business Trends

Amazon's Customer Experience and Business Trends (CXBT) organization is hiring a Business Intelligence Engineer for its Benchmarking, Economics, Analytics and Measurement (BEAM) team. BEAM turns fragmented internal and external data into decision‑grade intelligence for senior leaders across Amazon.

This role anchors our Intelligence Engine initiative: the layer that makes BEAM's data and analytical depth pluggable into agent‑based surfaces. Rather than building one‑off dashboards, you'll build a curated data catalog and reusable analytical assets, then expose them to LLM agents through MCP (Model Context Protocol) servers and skills so that stakeholders can ask questions in natural language and get trustworthy, deterministic answers grounded in BEAM's data.

We're looking for a strong BIE who is genuinely excited about the agentic/GenAI shift and understands the mechanics behind it, not just the buzzwords. You should be comfortable designing the data and tooling that make an LLM agent reliable: clean metric stores, well‑defined tools/skills, MCP interfaces, and guardrails that keep the agent from hallucinating numbers.

Key job responsibilities

• Build and maintain the curated data catalog and reusable foundation/metric tables that power BEAM's Intelligence Engine.


• Design and implement MCP servers and skills that expose BEAM data and analyses to LLM agents for natural‑language querying (Text-to-SQL, metric lookup, retrieval).


• Build deterministic query and metric layers so agents cite and route to real data rather than estimating — including refusal/guardrail behavior for out‑of‑coverage requests.


• Develop ETL pipelines and data models (SQL, Python) that turn raw internal + third‑party data into analysis‑ready assets.


• Partner with data scientists, economists, and product managers to translate recurring analytical needs into reusable, self‑service capabilities.


• Instrument evaluation and observability so we can measure and improve agent answer quality over time.

About the team

CXBT is a group of diverse functions dedicated to understanding, improving, and influencing customer experience globally, across all of Amazon. We are builders who develop products, services, and data‑driven approaches that shape offerings for nearly every Amazon business and customer type — consumers, developers, sellers, brands, employees, investors, streamers, and gamers. We work backwards from customer needs, combine technical and non‑technical methods, and track industry and business trends. Our roles span Product Managers, Data Scientists, Economists, Business Intelligence Engineers, Data Engine, Applied Scentist, and Product Manager.

Basic Qualifications

• 5+ years of using SQL, ETL (Extract, Transform, Load), or Oracle experience


• 5+ years of performing statistical analysis experience


• 5+ years of developing automated reporting experience


• 3+ years of processing large, multi‑dimensional datasets from multiple sources experience


• Bachelor's degree or foreign equivalent in Computer Science, Engineering, Mathematics, Statistics, Economics, or a related field

Preferred Qualifications

• Experience in data mining, ETL, etc. and using databases in a business environment with large‑scale, complex datasets


• Hands‑on experience building LLM agents and an understanding of the underlying mechanics — MCP (Model Context Protocol), tools/skills, retrieval/RAG, and prompt design.


• Experience exposing data to agents via MCP servers or building Text-to-SQL / natural‑language query interfaces.


• Understanding of how to make LLM outputs reliable: deterministic query layers, grounding, evaluation, and guardrails against hallucinated numbers.


• Experience with AWS data services (Redshift, S3, Athena, Glue) and modern data‑modeling patterns.


• Familiarity with retail/e‑commerce or benchmarking data and metrics.

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

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, VA, Arlington - 99,500.00 - 160,000.00 USD annually

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