Business Analyst, RBS ARTS at Amazon

Apply for the Business Analyst, RBS ARTS position at Amazon in Chennai. Build automation tools, optimize executive dashboards, and query large datasets using SQL, Advanced VBA, and QuickSight.

About the Company: Amazon

Amazon is a global technology leader guided by four foundational principles: customer obsession rather than competitor focus, a passion for invention, a commitment to operational excellence, and long-term thinking. Driven by the excitement of building technologies and services that change lives, Amazon operates at the scale of a massive enterprise while maintaining the agile, innovative heart of a startup.

The RBS ARTS (Automation Reporting and Tech Sciences) group is a highly specialized internal engineering and science hub. This division focuses on building automated reporting systems, scaling self-service data pipelines, and implementing data science workflows that support Amazon’s retail, fulfillment, and selling partner networks worldwide. The team design tracking tools that help leadership make quick, data-driven decisions affecting millions of customers.

About the Role: Business Analyst

Are you a customer-obsessed analyst who thrives in fast-paced environments and loves turning messy data into clean, automated tools? Amazon is hiring a full-time, permanent Business Analyst, RBS ARTS to join its data operations hub in Chennai, Tamil Nadu, India (under the corporate entity ADCI – BLR 14 SEZ). This position is tailored for professionals who bring 1+ years of experience in an analytical field combined with a strong background in script-driven spreadsheet automation.

As a Business Analyst in the ARTS team, you will take full ownership of a suite of business intelligence tools, executive dashboards, and automated metrics used by global leaders. This role requires comfortable handling of ambiguity and excellent communication skills. You will dive deep into large backend databases using SQL, build complex VBA macros to eliminate manual processes, and design interactive QuickSight or Tableau reports that reveal operational trends and improvement opportunities.

Key Responsibilities & Data Automation Workflows

• Business Intelligence Ownership: Create, deploy, and continuously improve standard operational metrics, key performance indicators (KPIs), and executive dashboard suites.

• Database Querying & Extraction: Dive deep into massive backend data architectures—specifically Oracle and Amazon Redshift clusters—using advanced SQL to isolate specific operational trends.

• Workflow Automation Scripting: Write, test, and maintain complex Excel VBA macros to automate recurring data processing tasks and minimize manual reporting steps.

• Dashboard Visual Design: Convert raw data tables into scannable, digestible business intelligence visuals using reporting software like Amazon QuickSight or Tableau.

• Cross-Functional Requirements Gathering: Partner directly with business operations leaders and global program teams to translate ambiguous challenges into structured data tracking requirements.

• Report Schedule Management: Configure and supervise internal report scheduling tools to ensure consistent data delivery under tight operational timelines.

• Root-Cause Deep Dives: Conduct ad-hoc data investigations to answer targeted business questions, providing actionable recommendations to optimize the selling partner experience.

Candidate Prerequisites & Key Technical Skills

Successful candidates must balance a strong detail-oriented approach to big data processing with the ability to summarize technical insights simply for cross-functional stakeholders.

Required Experience & Technical Baseline (Basic Qualifications):

• Professional Tenure: 1+ years of hands-on experience in tax, finance, operations analytics, or a related quantitative corporate field.

• Automation Expertise: 2+ years of specific, hands-on experience writing complex Excel VBA macros from scratch to automate data flows.

• Technical Foundations: Solid, working familiarity with writing SQL queries or setting up Extract, Transform, Load (ETL) data steps.

• Analytical Mindset: Proven experience defining reporting requirements and using data metrics to draw actionable business insights.

Preferred Technical Qualifications:

• Advanced Visual Platforms: Prior experience developing and deploying self-service data visuals within Tableau or Amazon QuickSight.

• Big Data Management: Practical exposure to running queries across very large datasets and cloud-scale data warehouses (e.g., Redshift).

Core Position Specifications

• Position Title: Business Analyst, RBS ARTS (Automation Reporting and Tech Sciences)

• Hiring Organization: Amazon (Amazon Development Centre India – ADCI)

• Corporate Work Location: Chennai, Tamil Nadu, India

• Job Identification Code: A10448642

• Employment Framework: Full-Time, Permanent corporate assignment

• Functional Department: Business Intelligence & Retail Operations

• Role Category: Business Analyst / Analytics Support