Under Armour India Business Analyst Interview: Rounds, Questions and Preparation

What the job involves

As a Business Analyst in a GCC or consulting firm, you will translate business needs into clear requirements, analyse data to find insights, and support project teams with documentation and testing. In fast-growing consumer brands like Under Armour India, you may work on retail analytics, supply chain reporting, or digital transformation projects that require close coordination with global teams. The role is a mix of stakeholder communication, data crunching, and process improvement.

Role and Technical Knowledge

1. 1

   What is the difference between a BRD and an FRD?

   Explain that BRD focuses on business needs and objectives, while FRD details functional requirements for the technical team. Give a retail example, such as a BRD for improving inventory visibility and an FRD for the specific reporting dashboard.

2. 2

   How would you write a user story for a feature that lets store managers view daily sales on their mobile?

   Use the format: 'As a store manager, I want to view daily sales on my mobile so that I can track performance on the go.' Include acceptance criteria like real-time data, filter by date, and secure login.

3. 3

   What are some key KPIs you would track for a retail brand's e-commerce website?

   Mention conversion rate, average order value, cart abandonment rate, and customer acquisition cost. Explain how each helps measure business health.

4. 4

   Explain a basic SQL query to find the top 5 products by revenue last month.

   Describe using SELECT, SUM, GROUP BY, ORDER BY, and LIMIT. Mention joining product and sales tables, and filtering by date.

Practical Scenarios and Case Questions

1. 5

   You are asked to analyse why sales dropped in a particular region. How would you approach this?

   Start by breaking down the problem: check data for seasonality, competitor activity, store-level performance, and marketing campaigns. Suggest a hypothesis-driven approach and mention validating with stakeholders.

2. 6

   A stakeholder keeps changing requirements mid-project. How would you handle it?

   Emphasise documenting changes, assessing impact on timeline and cost, and communicating trade-offs. Suggest using a change request process and prioritising with the stakeholder.

3. 7

   You have two weeks to deliver a report, but the data from the warehouse is incomplete. What do you do?

   Talk about escalating early, using available data to provide interim insights, and setting clear expectations with the requester. Highlight proactive communication and workaround solutions.

4. 8

   How would you measure the success of a new loyalty program for a sportswear brand?

   Define metrics like enrollment rate, repeat purchase rate, average spend per member, and retention. Suggest A/B testing or comparing with a control group.

Behavioural and HR Questions

1. 9

   Tell me about a time you worked in a team to solve a problem.

   Use STAR format: describe the situation, your role, the actions you took, and the result. Focus on collaboration and your specific contribution.

2. 10

   Why do you want to work as a Business Analyst in a GCC or consulting environment?

   Connect your interest in problem-solving and data with the exposure to global clients and diverse projects. Mention eagerness to learn and adapt.

3. 11

   Describe a situation where you had to explain a complex idea to someone non-technical.

   Show how you simplified jargon, used visuals or analogies, and checked for understanding. Highlight patience and clarity.

4. 12

   Where do you see yourself in three years?

   Express a desire to deepen domain expertise, take on more responsibility, and possibly lead small projects. Align with the company's growth path.

Company and Sector Awareness

1. 13

   What do you know about the GCC model and how it differs from traditional IT services?

   Explain that GCCs are captive centres of global companies, focusing on core business functions, while IT services firms serve multiple clients. Mention cost efficiency, innovation, and global collaboration.

2. 14

   Why are you interested in working for a consumer brand like Under Armour India?

   Show passion for the brand's mission, products, and digital innovation. Relate to your skills in analytics and desire to impact retail or supply chain.

3. 15

   How do consulting firms like the Big 4 add value to clients?

   Discuss their expertise in strategy, operations, technology, and risk. Mention their ability to bring best practices and drive transformation.