Sr. Retail SQL Analyst

Must-Haves:
**Looking for an emphasis on soft line retails (e.g. shirts).**

**More experience on the Retail side is whats needed here. Ultimately it is a blended role (Retail & Analytics) but the Retail piece is KEY. Ideally want those with more Analytics than Retail**

• Minimum 3 years analytical experience in retail especially applying insights to business KPIs and decision-making.
• Intermediate SQL skills (3 years): data discovery understanding storage and data retrieval.
• Minimum 3 years Retail industry experience (KPIs etc.)

Nice-to-Haves:

• Tableau or other data visualization tools and building of dashboards for them
• Experience with pricing analytics (60% of the role).
• Familiarity with Snowflake BigQuery Redshift.
• Coding / technical aptitude in Python and for data analysis purposes (using pandas NumPy matplotlib)
• Ability to support data preparation and light modeling tasks.
• Business Intelligence background
• A/B testing concepts and basic statistical techniques
• Bachelors degree in Mathematics Economics Data Science/Analytics Computer Science Operations Research or a related field

Future Skill Growth Opportunities:

• AI chatbot efficiency for operations
• Automation for Salesforce/Snowflake releases
• Business process analysis technical requirements
• Resume-building with AI-related projects

Role Context:

• Supports Theme Parks and Ecommerce retail divisions.
• Works with a team of data scientists and engineers.
• Needs someone who can bridge business and technical requirements.

Team Overview:
The Merchandise Business Insight and Analytics (MBIA) team is part of Disneys CPGP organization which creates and sells Disney products worldwide. The MBIA team supports the full retail lifecycle by providing analytics reporting and insights that empower data-informed decision-making for a broad community of stakeholders across Category and Location Planning Product Development Merchandising and Retail Operations.

Position Overview:
We are seeking a Senior Analyst to support retail analytics initiatives across both Disneys theme parks and The Disney Store e-commerce division. This role will focus on delivering high-impact business insights through data exploration dashboard development and analytical modeling to support areas such as merchandise planning promotional performance inventory health and operational efficiency. The ideal candidate brings strong business acumen retail expertise and technical proficiency in SQL Data Visualizations (e.g. Tableau) and Python (preferred). This role plays a critical part in transforming data into actionable insights that improve business performance guest experience and strategic outcomes across Disneys global retail footprint.

Technical & Functional - Responsibilities:
Technical........

Business Acumen - Strong understanding of retail KPIs and operations with the ability to translate data into meaningful business recommendations that drive revenue efficiency or guest satisfaction.
Retail Analytics - Experience supporting the business including merchandising buying planning operations marking retail environments across brick-and-mortar and ecommerce channels. Familiarity with retail inventory systems POS data and product lifecycle metrics.
SQL & Data Management - Advanced SQL skills to extract join and transform large datasets; experience with cloud data warehouses such as Snowflake BigQuery or Redshift.
Dashboarding & Data Visualization - Expert-level experience building dashboards and reports in Tableau or similar tools to drive self-service analytics and business storytelling.

Functional.......
Deliver Actionable Business Insights: Conduct deep-dive analyses on retail performance including pricing and promotional effectiveness customer behavior and product lifecycle to inform merchandising and planning decisions.
Build and Maintain Visual Dashboards: Develop intuitive automated Tableau dashboards and self-service reporting tools to monitor key performance indicators and support cross-functional teams in decision-making.
Collaborate with Cross-Functional Teams: Partner with merchandising marketing finance and technology stakeholders to translate business needs into data-driven solutions and clearly communicate analytical findings.
Develop Scalable Analytical Solutions: Write robust SQL code to query clean and manipulate large datasets from cloud-based sources (e.g. Snowflake BigQuery) in support of repeatable scalable analytics workflows.
Support Data Science Initiatives: Collaborate with data scientists on advanced projects by preparing data inputs conducting exploratory data analysis and validating model outputs to ensure business relevance.