Senior Analyst Merchandising Reporting(Python, SQL, PowerBI)

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., 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, The primary purpose of the Senior Analyst - Merchandising Reporting role is to lead and deliver high-impact, data-driven analytical solutions that improve store space productivity, optimize store layouts and adjacencies, and support strategic merchandising initiatives across Lowe's stores.

This role is responsible for independently structuring analytical problems, developing scalable approaches, synthesizing complex data into actionable insights, and influencing business decisions through clear recommendations. The Senior Analyst partners closely with cross-functional teams across Store Planning, Visual Merchandising, Assortment Planning, Project Management, and business leadership to evaluate opportunities, quantify impact, and support execution-ready recommendations.

This position requires strong analytical thinking, business acumen, and the ability to balance strategic intent with practical execution constraints. The individual must be comfortable working in a matrixed organization, managing ambiguity, and driving workstreams with a high degree of ownership and accountability.

Roles & Responsibilities:

Core Responsibilities:

• Lead analytical workstreams supporting store optimization, space productivity, new store planning, and strategic enterprise initiatives

• Translate business questions into structured analytical approaches, hypotheses, and decision frameworks

• Build and validate analyses related to store performance, space allocation, adjacency optimization, category flow, capacity, and productivity impacts

• Develop data-driven recommendations that improve store layout effectiveness, customer flow, operational efficiency, and business performance

• Partner with cross-functional stakeholders to align on scope, assumptions, risks, dependencies, and success metrics

• Create business cases, impact assessments, and executive-ready summaries to support prioritization and leadership decisions

• Support pre/post analysis for strategic initiatives and identify insights that can inform future optimization efforts

• Leverage multiple data sources to create a holistic view of performance drivers, store traits, and opportunity areas

• Improve repeatability and scalability of analysis by standardizing templates, methodologies, and reporting approaches

• Contribute to capability building in areas such as space analytics, productivity reporting, capacity tracking, and decision support tools

• Present findings and recommendations to managers, directors, and cross-functional business partners with clarity and confidence

• Coach junior analysts as needed by sharing best practices in problem solving, analytical rigor, and stakeholder communication

• End to end project execution and building reports/dashboards from scratch

Do you have experience in Tableau?, Do you have a Bachelor's degree?, Years of Experience:

4 to 6 years of Experience

3 + years of Experience in Reporting, Data Vizualization and Analytics, RPA

2 + years of Retail Experience, Bachelor's Degree in Business, Engineering, Statistics, Economics or any other Quantitative discipline

Skill Set Required

Primary Skills (must have)

• Wrangling data using complex SQLs and data extraction processes using data tools like SQL Assistant, DBeaver etc across databases in GCP, Hadoop

• Proficiency in doing data transformations & creating reports using MS Excel

• Working with large data sets & generating actionable insights

• Demonstrated experience working cross-functionally and with global partners

• Experience with other Microsoft Office tools (e.g., Word, PowerPoint)

Secondary Skills (desired)

• 1-2 year experience in Retail category analytics working directly with merchants

• Experience with business intelligence and reporting tools (e.g., PowerBI, MicroStrategy, Tableau etc.)

• Experience working with Big data & data transformation tools such as Python, SAS, R etc

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 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