Sr. Retail SQL Analyst

Key Responsibilities • Analyze retail business data with a focus on soft line retail (e.g., apparel/shirts) to inform key performance indicators (KPIs) and business decisions. • Utilize intermediate to advanced SQL skills to extract, join, and transform large datasets from cloud data warehouses (e.g., Snowflake, BigQuery, Redshift). • Support both theme park and e-commerce retail operations through data exploration, analytics, and reporting. • Develop and maintain interactive dashboards and reports using Tableau or similar data visualization tools for self-service analytics and business storytelling. • Conduct deep-dive analyses on retail performance, including pricing, promotions, customer behavior, inventory health, and product lifecycle metrics. • Collaborate with cross-functional teams (merchandising, planning, marketing, finance, technology) to translate business requirements into actionable analytics solutions. • Prepare data and perform light modeling to support advanced analytics or data science projects, including validating model outputs. • Communicate analytical findings and business recommendations clearly to both technical and non-technical stakeholders. • Support operational efficiency and strategic decision-making through actionable business insights. • Assist in data preparation and automation initiatives for improved analytics workflow and business operations. Required Skills & Experience • 3+ years analytical experience in retail, ideally with a blend of retail and analytics (retail expertise is key). • 3+ years hands-on SQL experience (data discovery, understanding storage, data retrieval, writing robust queries). • 3+ years retail industry experience, with strong understanding of retail KPIs and operations. • Experience with retail inventory systems, POS data, and product lifecycle metrics. • Strong business acumen and ability to bridge business and technical requirements. Preferred/Bonus Skills • Experience with Tableau or other dashboard/data visualization tools. • Pricing analytics experience (majority of role focus). • Familiarity with Snowflake, BigQuery, or Redshift. • Coding proficiency in Python (e.g., pandas, NumPy, matplotlib) for analytics. • Business Intelligence and A/B testing/statistical analysis background. • Bachelor’s degree in Mathematics, Economics, Data Science/Analytics, Computer Science, Operations Research, or related field.