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.
