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

S

KILLS

/

E

XPERIENCE

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.