Sr. Data Analyst

Advance Stores Company•Raleigh, NC

2d•Hybrid

About The Position

Senior Data Analyst The Senior Data Analyst is responsible for designing, building, and maintaining high quality analytical solutions across enterprise systems. This role sits within the Data & Analytics team under IT and bridges business requirements with technical execution. The analyst ensures data reliability, develops scalable models and dashboards, and supports cross-functional partners with accurate , timely insights. This position is 4 days in office, 1 day remote per week, based at our corporate headquarters in Raleigh, North Carolina (North Hills)

Requirements

Advanced to Expert SQL skills (joins, window functions, performance tuning).
Strong experience with Power BI (modeling, Lakehouse, Semantic Models, DAX, best practices).
Ability to design scalable analytical models and reusable Single Source of Truth Logic.
Experience working with large operational datasets (WMS, OMS & Commerce, TMS, APAL, Exploris , etc.).
Proven ability to diagnose and resolve upstream data issues.
Strong documentation discipline.

Nice To Haves

Knowledge of SnowSQL /TSQL, R, DAX, Power Query.
Understanding of ETL Patterns, Data Materialization and SQL-based transformations.
Understanding of supply chain flows (inbound, outbound, inventory).
Familiarity with automation tools (Power Automate, scheduler scripts).

Responsibilities

Data Engineering + Modeling (40%) Develop SQL logic for sourcing, transforming, and validating data across Snowflake, SAP BW, and WMS systems.
Build reusable, standardized SQL patterns for multi site data.
Partner with data architects/engineers on schema changes, ingestion updates, and pipeline reliability.
Conduct deep dive data integrity audits and support root cause analysis for upstream issues.
Power BI Development (40%) Own semantic modeling, DAX development, and visualization for enterprise dashboards.
Implement performance tuning, model compression, and DAX optimization.
Build scalable KPI frameworks with consistent date logic, definitions, and lineage.
Establish and enforce Power BI best practices and team standards.
Governance & Documentation (10%) Create transparent, repeatable documentation for metrics, lineage, and data logic.
Ensure BI assets meet certification, reliability, and audit-readiness standards.
Cross-Functional Leadership (10%) Collaborate closely with Operations, Finance, HR, and IT to define requirements.
Mentor junior analysts in SQL, DAX, and data reliability practices.
Serve as a technical SME who can challenge assumptions and guide data-driven decisions.