SAS Analyst

Key Responsibilities

• Extract and analyze large volumes of transactional data from Amazon Redshift databases, including both header and detail-level transaction records for restaurant locations.
• Develop and maintain SAS programs to retrieve data for selected stores, products, pricing scenarios, and business channels.
• Perform monthly, weekly, and ad-hoc Quality Control (QC) validations on Price Mix reporting processes to ensure data accuracy, completeness, and consistency.
• Conduct data reconciliation between source systems, Redshift tables, and downstream reporting outputs.
• Calculate and validate key business metrics, including:
• Weighted Average Price (WAP)
• Mean (Average) Price
• Mode Price
• Net Sales
• Gross Sales
• Guest Counts
• Units Sold
• Channel-Level Performance Metrics
• Store-Level Performance Metrics
• Analyze pricing trends, promotional impacts, and product mix performance across stores and sales channels.
• Build SAS-based reporting datasets and analytical outputs to support pricing, revenue, and operational decision-making.
• Investigate data anomalies and perform root-cause analysis for discrepancies identified during QC reviews.
• Collaborate with business analysts, pricing teams, and data engineering teams to gather requirements and deliver analytical solutions.

Required Skills

• Strong experience in SAS Programming (Base SAS, PROC SQL, Macro Programming).
• Experience querying Amazon Redshift, SQL Server, Oracle, or other relational databases.
• Strong SQL development and data manipulation skills.
• Experience working with retail, restaurant, POS, sales, or transactional datasets.
• Knowledge of statistical calculations and pricing analytics.
• Experience performing data validation, reconciliation, and QC testing.
• Ability to analyze large datasets and derive business insights.
• Understanding of data warehousing concepts and dimensional data models.
• Strong analytical, problem-solving, and communication skills.

Preferred Qualifications

• 5+ years of SAS Development and Data Analytics experience.
• Experience with restaurant, retail, or consumer pricing analytics.
• Good to have with BI tool SAS Visual Analytics usage.
• Experience working in cloud-based data environments, including Amazon Redshift

Professional Skills

• Demonstrates a positive attitude and a strong sense of ownership in delivering high-quality analytical solutions.
• Exhibits patience and attention to detail when understanding business requirements, asking clarifying questions, and translating requirements into technical solutions.
• Strong listening and communication skills, with the ability to collaborate effectively with business analysts, and technical teams.
• Ability to work independently while managing multiple priorities in a fast-paced environment.
• Proactive problem-solver with a continuous improvement mindset.
• Committed to maintaining data quality, accuracy, and consistency through thorough validation and QC processes.
• Flexible and adaptable to changing business requirements and priorities.
• Strong analytical thinking and curiosity to investigate data issues and identify root causes.
• Team-oriented professional who fosters collaboration and knowledge sharing across teams.