SQL Analyst

Job Title -- MAZDC5697389 Sales Executive -- Anindya Mazumdar Must-Haves: Looking for an emphasis on soft line retails, (e.g., shirts). • • More experience on the Retail side is what's 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 Bachelor’s 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 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, etc. in 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