Description
About the Team
The TESS (Transportation Execution Systems & Services) Analytics team is part of NA Transportation Services and is responsible for delivering data-driven insights, dashboards, automation, and governance solutions that support transportation configuration, network planning, and operational excellence. We partner closely with TESS Program Managers, Network Planners, Operations teams, and cross-functional organizations including TITANS, SortTech, and ShipTech to drive measurable business outcomes.
Role Summary
We are seeking a Business Analyst to join the TESS Analytics team. In this role, you will build and maintain analytical solutions — including dashboards, reports, ETL pipelines, and automated monitoring systems — that enable TESS stakeholders to make faster, data-informed decisions. You will work directly with Program Managers and Operations teams to translate business requirements into scalable analytics deliverables.
Key job responsibilities
Key Responsibilities
- Design, build, and maintain dashboards and reports using Amazon QuickSight, supporting programs such as Config Validation, Quality Metrics, Klaxon Monitoring, and Network Planning
- Develop and optimize SQL queries and ETL jobs (Datanet) to transform raw data into actionable datasets
- Partner with TESS Program Managers to gather requirements, define KPIs, and deliver analytical solutions aligned to business goals
- Support the Klaxon alarm system by building and maintaining automated monitoring dashboards that detect configuration defects (e.g., missing Stacking Filters, VSM misconfigurations)
- Contribute to ETL governance initiatives — inventory management, deprecation workflows, and performance optimization
- Perform ad-hoc deep-dive analyses to support root cause investigations, quality misses, and operational reviews (WBR, MBR)
- Maintain data quality and integrity across TESS-BI datasets through schema validation and standardization
- Support on-call BI operations including data queries, logic changes, and stakeholder requests
- Document analytical processes, data dictionaries, and solution designs
Basic Qualifications
- 2+ years of Excel or Tableau (data manipulation, macros, charts and pivot tables) experience
- 2+ years of complex Excel VBA macros writing experience
- Bachelor's degree or equivalent
- Experience defining requirements and using data and metrics to draw business insights
- Experience with SQL or ETL
- Knowledge of data visualization tools such as Quick Sight, Tableau, Power BI or other BI packages
Preferred Qualifications
- Experience creating complex SQL queries joining multiple datasets, ETL DW concepts
- Experience using very large datasets
- Knowledge of SQL
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.
Company - ADCI HYD 13 SEZ
Job ID: A10433476
