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