Senior Analyst, Merch Ops Analytics

Lowe's Companies, Inc.; Bengaluru; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Lowe’s Bengaluru on-site office hosts a Sr. Analyst who partners with the Merchandising team to deliver insights across product categories and store performance.

You will apply retail analytics, SQL, Power BI and advanced Excel to drive SKU planning, scorecards and strategic recommendations, working with cross-functional partners globally.

Qualifications

• Bachelor's degree or MBA in a quantitative field is required.
• 3+ years of data analytics experience in retail or similar domain.
• Strong SQL, Power BI, Excel, and data visualization skills.

Responsibilities

• Provide analytics support to Merchandising for SKU rationalization and product line reviews.
• Develop scorecards and insights to guide data-driven decisions.
• Communicate findings clearly to leaders with actionable recommendations.
• Collaborate with cross-functional and global partners for project continuity.

Skills

Retail Analytics

Power BI

SQL

Advanced Excel

Data Visualization

Data Modeling

Business Insights

Stakeholder Management

Strong Communication & Articulation

Education

Bachelor’s Degree in Engineering, Statistics, Economics or Quantitative discipline

MBA/PGDM

Tools

SQL Assistant

DBeaver

Teradata

Hadoop

Python

SAS

R

PowerBI

MicroStrategy

Tableau

Job description

Innovate in Bengaluru

This position is based at our on-site office in Bengaluru. Lowe’s offers an ultramodern work environment, complete with cutting-edge technology, collaborative workspaces, an on-site gym and clinic, and other perks to enhance your work experience.

About Lowe’s

Lowe’s is a FORTUNE® 100 home improvement company serving approximately 16 million customer transactions a week in the United States. With total fiscal year 2024 sales of more than $83 billion, Lowe’s operates over 1,700 home improvement stores and employs approximately 300,000 associates. Based in Mooresville, N.C., Lowe’s supports the communities it serves through programs focused on creating safe, affordable housing, improving community spaces, helping to develop the next generation of skilled trade experts and providing disaster relief to communities in need. For more information, visit Lowes.com.

About Lowe’s India

Lowe’s India, the Global Capability Center of Lowe’s Companies Inc., is a hub for driving our technology, business, analytics, and shared services strategy. Based in Bengaluru with over 4,500 associates, it powers innovations across omnichannel retail, AI/ML, enterprise architecture, supply chain, and customer experience. From supporting and launching homegrown solutions to fostering innovation through its Catalyze platform, Lowe’s India plays a pivotal role in transforming home improvement retail while upholding strong commitment to social impact and sustainability. For more information, visit Lowes India

About the Team

The Merch Ops Analytics team supports the Assortment Planning function at Lowe’s to assist in item level planning across all Lowe’s stores. The team provides leverages advanced analytics to gather insights and share recommendations to the business in optimizing assortments via SKU Rationalization, Product Line Reviews and other strategic initiatives to ensure that Lowe’s stocks the right product in the right store in the right quantity

Job Summary:

The principal purpose of the Sr. Analyst is to be the Analytics partner with the Merchandising organization and deliver the insights and recommendations to drive a deeper understanding of product categories. This information will be utilized by Merchandising teams as they work to create an optimal strategy for their product category, which in turn will influence different merchandising strategies across all our fulfillment channels.

To accomplish this, the Sr. Analyst must have solid knowledge of retail and/or business analytics. This position is responsible for following analytical best practices, accurately reporting and analyzing results and identifying insights for decision making; determine additional research/analytics that may be needed to enhance the solution; and coordinate with cross-functional teams to ensure project continuity and strategic alignment

Roles & Responsibilities:

Core Responsibilities:

• Solves problems and shares information to enable alignment across the organization in order to facilitate better decision making by collaborating with a team of peers; providing support to functional areas for product line reviews, business reviews & strategic initiatives
• Enables business partners to make informed decisions based on root cause drivers of performance by working with functional partners to develop and maintain scorecards; analyzing and providing insights and performance analysis
• Communicates financial and non-financial analysis and insights to leaders by preparing analyses through leveraging multiple data sources; identifying complete, consistent, and actionable insights & recommendations; translating insights into clear, understandable themes
• Demonstrate resourcefulness and resilience in the face of change, obstacles, and adversity. This includes adapting to competing demands and shifting priorities. This also includes improving adaptability, pursuing new skills and knowledge, and regularly seeking feedback from others

Years of Experience:

• 3+ years’ experience in Data Analytics

Education Qualification & Certifications (optional)

Required Minimum Qualifications

• Bachelor’s Degree in Engineering, Statistics, Economics or any other Quantitative discipline or MBA/PGDM

Skill Set Required

Primary Skills (must have):

Retail Analytics, Power BI, SQL, Advanced Excel, Statistical Analysis, Data Modeling, Data Visualization, Business Insights, Stakeholder Management and Strong Communication & Articulation Skills.

• Wrangling data using complex SQLs and data extraction processes using data tools like SQL Assistant, DBeaver etc across databases in Teradata, Hadoop
• Experience working with Big data & performing data transformations using Python (preferred), SAS, R etc
• Advanced proficiency in MS Excel and experience in creating reports & dashboards
• Advanced proficiency in business intelligence and reporting tools such as PowerBI (preferred), MicroStrategy, Tableau etc
• Demonstrated experience working cross-functionally and with global partners
• Capable of end-to-end project execution & engaging with stakeholders at each stage
• Good understanding of retail math & statistics

Secondary Skills (desired)

• 1+ year experience in Retail category analytics working directly with merchants
• Ability to build analytical solutions using modelling and advanced statistical techniques for solving business problems related to Merchandising

Lowe’s is an equal opportunity employer and administers all personnel practices without regard to race, color, religious creed, sex, gender, age, ancestry, national origin, mental or physical disability or medical condition, sexual orientation, gender identity or expression, marital status, military or veteran status, genetic information, or any other category protected under federal, state, or local law.