Advance Auto Parts · 4 hours ago
Sr. Data Analyst
Raleigh, NC
Full-time
Hybrid
Senior LevelAdvance Auto Parts is a leading automotive parts retailer, and they are seeking a Senior Data Analyst to design, build, and maintain analytical solutions across enterprise systems. This role involves ensuring data reliability, developing scalable models and dashboards, and supporting cross-functional partners with timely insights.
AutomotiveRetail
Responsibilities
Develop SQL logic for sourcing, transforming, and validating data across Snowflake, SAP BW, and WMS systems
Build reusable, standardized SQL patterns for multisite data
Partner with data architects/engineers on schema changes, ingestion updates, and pipeline reliability
Conduct deepdive data integrity audits and support rootcause analysis for upstream issues
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
Create transparent, repeatable documentation for metrics, lineage, and data logic
Ensure BI assets meet certification, reliability, and audit-readiness standards
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
Qualification
Required
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
Preferred
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)
Company
Advance Auto Parts
Advance Auto Parts is the largest automotive aftermarket parts provider in North America, serves both the professional installer.
Founded in 1932
10001+ employees
Funding
Current Stage
Public CompanyTotal Funding
$1.95B2025-07-28Post Ipo Debt· $1.95B
2001-11-29IPO
Leadership Team
Shane O'Kelly
President and Chief Executive Officer
Ryan Grimsland
Executive Vice President & Chief Financial Officer
Recent News
The Motley Fool
2026-01-19
2026-01-16
Company data provided by crunchbase