Business Analyst I, APAC Retail BI
At Amazon, we strive to be the most innovative and customer centric company on the planet. Come work with us to develop innovative products, tools and research driven solutions in a fast-paced environment by collaborating with smart and passionate leaders, program managers, inventory managers, vendor managers and marketing managers.
This role is based out of our Bangalore corporate office and is for an passionate, dynamic, analytical, innovative, hands-on, and customer-obsessed Business Analyst.
Key job responsibilities
The ideal candidate will have experience working with large datasets and distributed computing technologies. The candidate relishes working with large volumes of data, enjoys the challenge of highly complex technical contexts, and, is passionate about data and analytics.He/she should be an expert with data modeling, ETL design and business intelligence tools, has hand-on knowledge on columnar databases such as Redshift and other related AWS technologies.
He/she passionately partners with the customers to identify strategic opportunities in the field of data engineering. He/she should be a self-starter, comfortable with ambiguity, able to think big (while paying careful attention to detail) and enjoys working in a fast-paced team that continuously learns and evolves on a day to day basis.
A day in the lifeKey job responsibilities:
This role primarily focuses on deep-dives, creating dashboards for the business, working with different teams to develop and track metrics and bridges.
- Build complex SQL queries
- Design, develop and maintain scalable, automated, user-friendly systems, reports, dashboards, etc. that will support our analytical and business needs
- In-depth research of drivers of the Localization business
- Analyze key metrics to uncover trends and root causes of issues
- Suggest and build new metrics and analysis that enable better perspective on business
- Capture the right metrics to influence stakeholders and measure success
- Develop domain expertise and apply to operational problems to find solution
- Work across teams with different stakeholders to prioritize and deliver data and reporting
- Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation- Experience defining requirements and using data and metrics to draw business insights
- Experience with SQL or ETL
- Experience in Excel (macros, index, conditional list, arrays, pivots, lookups)
- Knowledge of data visualization tools such as Quick Sight, Tableau, Power BI or other BI packages
- Experience using very large datasets
- Experience creating complex SQL queries joining multiple datasets, ETL DW concepts- Experience in Amazon Redshift and other AWS technologies