Job Description

Description
ANALYST, MP&A
Brand: Victoria's Secret Location: Bangalore, Karnataka, IN
Job Area: Information Technology Employment type: Full-time Job ID: 03VK3
Description
Analyst Data Analytics
Description - External
Position Overview
The Merchandise Analytics team in Bangalore, India will work with the Merchandise Planning and Assortment team located in Columbus, OH. The team is responsible for applying Statistical Modeling, Advanced Analytics and reporting on the product assortment including inventory positioning by location, pricing, and promotions for the Victoria's Secret Lingerie, Pink and Victoria's Secret Beauty brands. The Analyst will be responsible for data coordination and transformation in support of large analytics projects. He / She will collaborate with the data / reporting teams as well as functional partners to coordinate the collection and management of required data.
Job Responsibilities
Collect, organize, and analyze data related to product assortment, sales, and customer behavior.
Use Python / SAS / SQL / Excel & other relevant technologies to deliver analytics, dashboards and automated recurring insights/reports at desired frequency
Develop and maintain reports and dashboards that communicate insights and findings to key stakeholders.
VS&Co provides a range of compensation for this role as shown. Your actual salary will be determined by a number of factors, including: your specific skills and experience, geographic region, or other relevant factors.
Qualifications
Qualification
Manage intake and transformation of large amounts of raw information in support of advanced analytics.
Answer business problems using a mix of Descriptive / Exploratory Analysis and Storytelling using Visualization.
Present findings to stakeholders in an easily consumable manner.
Bachelor's degree in science / engineering / computer applications
2-3 years of experience in reporting and analysis / automation preferably in retail product or inventory management
SKILLS / EXPERIENCE
Strong proficiency in Microsoft Excel, including advanced features such as Power Query for data transformation and automation (Experience with Python integration is a plus).
Proficient in SQL, with experience writing complex queries, optimizing performance, and managing relational databases.
Hands-on experience with reporting and visualization tools (such as Excel, PowerPoint, Snowflake, MicroStrategy, Tableau, PowerBI or other relevant software solutions).
Demonstrate the ability to automate insights / reports using Macros (SAS and Excel VBA) & other relevant technologies.
Experience working with large raw data sets and data ETL development including the design and maintenance of data extract, transform and load processes to streamline data collection and management.
Attention to detail with a focus on data hygiene and documentation including writing clear specs, data dictionaries and pipeline diagrams.
Collaborate with team members to integrate data sources, ensuring data integrity and consistency across the organization.