
Data Specialist – Last Mile Analytics
Amazon India Pvt Ltd · Sep 2021 – May 2026
- Designed and developed interactive Amazon QuickSight dashboards integrating data from Redshift, S3, Athena, Glue, and Lambda leveraging SPICE datasets, Direct Query, calculated fields, drill-downs, and row-level security (RLS) to deliver governed, high-performance reporting solutions for business stakeholders.
- Built and optimized ETL/ELT data pipelines to convert fragmented operational data into structured, analysis-ready datasets implementing data quality checks, lineage tracking, and metadata documentation aligned with governance policies.
- Wrote complex SQL queries including multi-level CTEs, window functions, stored procedures, and conditional aggregations across PostgreSQL and Amazon Redshift to ensure data accuracy and support business decision-making.
- Performed data modelling, data preparation, and data quality validation creating and optimizing SPICE datasets and Direct Query-based reporting configurations for scalability and performance.
- Collaborated cross-functionally with program managers, data engineers, and business stakeholders to gather reporting requirements and convert them into actionable QuickSight visualization solutions.
- Partnered with audit and compliance teams to define and enforce data validation frameworks and quality standards across full-scale rollouts supporting data governance initiatives across regions and teams.
- Supported migration of legacy BI reports from Power BI and Tableau into Amazon QuickSight, ensuring continuity of business reporting and adoption of cloud-native analytics.

