BIE I, AOP - RoW Central Data Engineer Team

Amazon; Bengaluru; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

Amazon in Bengaluru seeks a Professional BIE Engineer to own production-grade data systems for RoW operations. You will design, build, and maintain data pipelines, Redshift models, and AWS-based infrastructure to enable real-time and batch analytics.

The role requires strong SQL, Python/Java, data modeling, and experience with Redshift/Aurora and cloud tools. You will collaborate with Analysts, Data Scientists, and PMs across India and emerging markets.

Qualifications

• 2+ years of analyzing data with Redshift, Oracle, NoSQL.
• Experience with data visualization using Tableau, Quicksight, or similar tools.
• Experience with one or more analytics visualization tools and statistical methods.
• Experience with scripting language (Python, Java, or R).

Responsibilities

• Design and build data pipelines — ingest data from diverse sources and land into Redshift and Aurora.
• Own Redshift infrastructure — optimize SQL, manage WLM, keys, and performance bottlenecks.
• Design data models and schemas; enforce partitioning, retention, and data quality checks.
• Deliver on ambiguous requirements — break down tasks and drive to production with minimal hand-holding.
• Build automation and self-healing systems using AWS services (Lambda, ECS, Step Functions).
• Operate AWS data infra with Redshift, Aurora, S3, Lambda, ECS Fargate, SQS, SNS, CDK/CFN, Secrets Manager, EventBridge.
• Drive cost optimization in SQL workloads and pipeline design without compromising reliability.
• Support stakeholders — collaborate with BAs, Data Scientists, PMs to deliver clean data pipelines.

Skills

Redshift

Tableau

Quicksight

SQL

Python

Java

R

NoSQL

Education

Master's degree or Advanced technical degree

Tools

CDK/CloudFormation

AWS

S3

Lambda

ECS Fargate

Job description

Description

The RoW Central Data Engineering team builds and operates the central data infrastructure backbone for Amazon's Rest-of-World (ROW) business operations, serving 5,000+ daily users across 14,000+ dashboards and 70,000+ daily data job runs. We run mission-critical systems including a centralized Amazon Redshift cluster, Aurora RDS real-time applications, Tableau Server, and a suite of automated data pipelines that ingest from EDX, SNS, Andes, APIs, and S3.

We are looking for a Professional BIE Engineer who takes ownership seriously, thinks clearly under ambiguity, and brings strong technical depth across databases, cloud infrastructure, and data pipeline engineering. You will work alongside senior engineers and technical managers to design, build, and maintain production-grade data systems that directly enable operational decision-making across RoW countries, India, and other emerging markets. If you enjoy untangling complex data problems and taking end-to-end ownership of your solutions, this role is for you.

Key job responsibilities

• Design and build data pipelines — architect and implement robust batch, intraday, and near-real-time ETL/ELT pipelines ingesting data from diverse sources including EDX datasets, SNS events, Andes tables, REST APIs, and S3, landing data reliably into Redshift and Aurora.
• Own Redshift infrastructure — write, optimize, and tune SQL and ETL workloads on Amazon Redshift; manage WLM queues, distribution/sort keys, materialized views, and query performance; proactively identify and resolve performance bottlenecks.
• Manage big data lifecycle — design data models and schemas (star/snowflake), enforce data partitioning and retention policies, implement data quality checks, and ensure data accuracy and freshness SLAs are consistently met.
• Deliver on ambiguous requirements — independently break down loosely defined business asks into concrete technical deliverables with clear scope, milestones, and acceptance criteria; drive from requirement to production with minimal hand-holding.
• Build automation and self-healing systems — reduce manual toil through automation (Lambda, ECS, Step Functions, CloudWatch alarms); contribute to the team's Server Auto Maintenance Program and ETL cleanup initiatives.
• AWS cloud engineering — use AWS services (Redshift, Aurora RDS, S3, Lambda, ECS Fargate, SQS, SNS, CDK/CloudFormation, Secrets Manager, EventBridge) to build scalable, cost-efficient, and maintainable data infrastructure.
• Drive cost optimization — proactively identify inefficiencies in SQL workloads, cluster utilization, and pipeline design; propose and implement optimizations that reduce AWS spend without compromising reliability.
• Support stakeholders and data consumers — partner with Business Analysts, BI Engineers, Data Scientists, and PMs to understand data needs; deliver clean, documented, raw data pipelines; maintain clear boundaries around pipeline ownership and scope.
• Maintain operational excellence — participate in on-call rotation, respond to production incidents with urgency and structured root cause analysis, and implement permanent fixes rather than workarounds.

A day in the life

Oncall: Review pipeline/infra/services run status on dashboards; triage any failed jobs or data freshness alerts; provide ETA and updates to stakeholders as needed.

Core hours: Work on active sprint deliverables — this may include writing CDK infrastructure code, developing Redshift SQL models, building a new EDX ingestion pipeline, or debugging a WLM contention issue on the central cluster.

Collaboration: Join a sync with stakeholders to understand a new data onboarding request; push back clearly when scope creep or non-standard pipeline patterns are introduced; document the agreed design in the team wiki.

Deep work: Independent heads-down time on complex tasks — performance tuning a slow Redshift query, infra upgrade, refactoring a Lambda trigger handler, or writing a CDK stack for a new ECS data job etc.

Wrap-up: Update task statuses in SIM tickets; code review a peer's PR; document any patterns or learnings into the team's internal knowledge base.

There is no one telling you exactly what to do each hour — you are expected to manage your own task queue, surface blockers early, and keep work moving forward with accountability.

About the team

We are a small, high-impact engineering team established in 2020. Our mission is to provide a unified, highly available, and scalable data infrastructure for Amazon's Rest-of-World operations — covering India, Japan and emerging markets that collectively represent a major and fast-growing segment of Amazon's global business.

We operate at significant scale:

• Central Redshift Cluster — 5,000+ daily active users, 70,000+ daily job runs, 14,000+ dashboards on Tableau, QuickSight, and Fusion
• Tableau Server — 144 developers, 8,000+ dashboards, 20,000+ daily visits
• Aurora RDS — real-time operational applications (capacity alerts, reactive scheduling tools)
• GenAI Platform — MyUniverse, our internal data hub, now integrated with Stella 3.0 — an digital AI agent that automates 90%+ of routine operational tasks cross teams.

We are a lean team that punches above our weight. Every engineer owns a broad surface area, ships real systems used by thousands of people daily, and is expected to continuously raise the bar — both on the technical side and on how we serve our stakeholders. We value clarity of thought, ownership without ego, and building things that last.

Basic Qualifications

• 2+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with one or more industry analytics visualization tools (e.g. Excel, Tableau, QuickSight, MicroStrategy, PowerBI) and statistical methods (e.g. t-test, Chi-squared)
• Experience with scripting language (e.g., Python, Java, or R)

Preferred Qualifications

• Master's degree, or Advanced technical degree
• Knowledge of data modeling and data pipeline design
• Experience with statistical analysis, co-relation analysis

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.