Business Analyst I, CMT

Amazon Inc.; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Amazon.com in Bengaluru seeks a data-driven BI analyst to design and deliver scalable analytics solutions that inform pricing, promotions, and performance metrics.

You will partner with data engineering, ML and business teams to standardize data, build dashboards, and interpret insights that drive fast, informed decision making.

This role requires strong SQL, ETL, Excel and visualization skills, plus the ability to communicate complex findings to diverse stakeholders.

Qualifications

• 1+ years of tax, finance or related analytical field experience.
• Experience with SQL or ETL.
• Experience defining requirements and using data and metrics to draw business insights.
• 2+ years of Excel (including VBA, pivot tables, array functions, power pivots) and data visualization tools such as Tableau.
• 1+ years of business or financial analysis experience.
• Experience gathering business requirements, using BI tools to extract data, formulate metrics and build reports.

Responsibilities

• Design, develop and maintain scalable, automated systems, reports and dashboards for analytics needs.
• Dive deep into ETL pipelines, report architecture and metric definitions; debug issues.
• Engage with leadership and stakeholders to understand analytical needs and recommend BI solutions.
• Own the design, development, and maintenance of performance metrics, reports, analyses, dashboards to drive decisions.
• Standardize data and report consumption across customer groups; ensure data integrity and proper validation.

Skills

SQL/ETL

Data analysis

Excel advanced

Data visualization

Education

Bachelor's degree in quantitative field

Tools

Tableau

Power BI

QuickSight

Job description

Amazon.com operates in a virtual, global e-commerce environment without boundaries, and operates a diverse set of businesses worldwide, including Retail, third party marketplaces, e-commerce platforms, web services for developers. Amazon’s global price perception is how the population perceives Amazon’s pricing compared to other retailers. Elements that make up customer price perception include the perceived; (1) competitiveness of the retailers pricing (i.e. who has the perceived lowest prices), (2) clarity of price information on the site, (3) the price vs quality of the products offered (i.e. the value), (4) the price the customer expects to pay for the product at a given retailer, and (5) how Amazon messages pricing in press and advertising.

CMT Central Analytics team is responsible for the metrics and programs that define customer price perception today. The team is responsible for driving new initiatives to deepen our understanding and measurement of price perception, as well as delivering projects that will improve Amazon’s price perception overtime. We protect Amazon Customers and influence projects to improve price perception and price satisfaction.

Opportunity

Do you want to be part of the team that ensures Amazon keeps its “best price” promise across millions of products worldwide? Does the challenge of driving decisions in a dynamic environment excite you? Do you love solving complex business problems using technology? Are you seeking an environment where you can drive innovation? Are you a passionate self-starter? If the answer to the above questions is a resounding “YES”, read on!

The ideal candidate is a motivated self-starter that can work in a fast paced, ambiguous environment with limited supervision. You must be a fast learner who can quickly absorb the nuances of Amazon's varied pricing programs and processes.

Amazon is one of the world’s most trusted companies. Help us keep it that way.

Key job responsibilities

1. Design, develop and maintain scalable, automated, user-friendly systems, reports, dashboards, etc. that will support analytical and business needs of our customers.
2. Diving deep to fully understand the ETL pipelines, report architecture and metric definitions, Debugging report issues and unblocking workflows.
3. Engage with leadership and diversified stakeholder groups to understand their analytical needs and recommend Business intelligence solutions.
4. Own the design, development, and maintenance of ongoing performance metrics, reports, analyses, dashboards, etc. to drive key business decisions
5. Standardize data and report consumption across all customer groups. Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation
6. Work with data engineering, Machine learning and software development teams to enable the appropriate capture and storage of key data points
7. Conduct written and verbal presentation to share insights and recommendations to audiences of varying levels of technical sophistication.

About the team

The Competitor Monitoring Team (CMT) drives the Amazon flywheel, by providing competitive pricing information and other dimensions such as availability, promotions, ship price and rebate which are relevant to customer’s purchasing decisions to the Retail and 3P businesses in an automated, near real time manner. This makes CMT a major contributor to Amazon’s pricing, overall competitiveness and customer delight/satisfaction against worldwide competitors.

Basic Qualifications

• 1+ years of tax, finance or a related analytical field experience
• Experience with SQL or ETL
• Experience defining requirements and using data and metrics to draw business insights
• 2+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization tools such as Tableau experience
• 1+ years of business or financial analysis experience
• Experience gathering business requirements, using industry standard business intelligence tool(s) to extract data, formulate metrics and build reports

Preferred Qualifications

• Bachelor's degree or above in a quantitative field such as statistics, mathematics, data science, business analytics, economics, finance, engineering, or computer science, or Master's degree or equivalent
• Experience that includes strong analytical skills, attention to detail, and effective communication abilities
• 2+ years of relevant work experience in business intelligence, analytics, statistics, data engineering, data science or related field
• Good proficiency in SQL, ETL management, data modelling, and working with Big Data
• Experience with data visualization using QuickSight, Tableau, Power BI, or similar tools
• Experience collaborating with business and data engineering teams

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.

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status. Veterans, military spouses, and people with disabilities are encouraged to apply.