Analyst Data Analytics
Brand: Victoria's Secret
Location: Bangalore, Karnataka, IN
Job Area: Information Technology
Employment type: Full-time
Job ID: 04BAC
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.
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.
