EI
Senior Data Architect – Snowflake / Dimensional Modeling
Expert In Recruitment Solutions
🇺🇸 United States
On-site
Senior
2 weeks ago
- Snowflake
- Python
- SQL
- Tableau
- Power BI
- AWS Cloud
- Databricks
2 weeks ago
Location:Media, PA -Hybrid – 1–2 days/week onsite
LOCAL CANDIDATES ONLY: Candidates must currently livewithin 30 miles of Media, PA and be available onsite at Wawa1–2 days per week.
IMPORTANT – ORIGINAL RESUMES ONLY: Please submit the candidate'soriginal resume exactly as provided by the candidate. Do not add job-description keywords, skills, technologies, or experience to a resume. If I find that a resume has been altered to add experience the candidate does not have, the vendor will be removed from consideration.
Project Details
- Candidate Radius: Must currently live within 30 miles
Seeking aSenior Data Architect to lead the modernization of Wawa's enterprise dimensional data warehouse and analytics environment. The role is heavily focused onSnowflake, Python, Kimball/star-schema dimensional modeling, certified data products, and enterprise analytics architecture.
Key Responsibilities
- Lead redesign and modernization of enterprise dimensional data warehouses usingKimball/star schema
- Define standards for dimensional modeling, semantic consistency, certified datasets, and reporting structures
- Develop conceptual, logical, and physical enterprise data models
- Architect scalableSnowflake data and transformation solutions
- EstablishPython-based data engineering standards and reusable patterns
- Design curated/certified datasets supporting executive dashboards, operational reporting, and self-service BI
- Align KPI definitions, reporting logic, and semantic models across the organization
- Drive datagovernance, lineage, quality, and consistency
- Provide architecture leadership and mentorship to data engineers/modelers
- Lead modernization roadmaps and improve scalability across the analytics ecosystem
- 8+ years of enterprise data architecture, analytics engineering, or data warehousing experience
- MUST HAVE: Strong Snowflake expertise
- MUST HAVE: Advanced Python development
- MUST HAVE: Deep Kimball/star-schema dimensional modeling experience
- MUST HAVE: Enterprise dashboarding and certified data product experience
- Strong SQL development and optimization
- Experience designing curated reporting layers and semantic models
- Experience supportingTableau, Power BI, or similar enterprise BI platforms
- Strong communication and stakeholder-management skills
- AWS cloud experience
- Databricks or distributed processing frameworks
- Experience modernizing large enterprise analytics and reporting environments
Senior Data Architect – Snowflake / Dimensional Modeling · Expert In Recruitment Solutions