Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Senior Data Architect Snowflake / Dimensional Modeling

Expert In Recruitment Solutions

Job Description

Job Description

Title:Senior Data Architect – Snowflake / Dimensional Modeling
Location: Media, PA - Hybrid – 1–2 days/week onsite


LOCAL CANDIDATES ONLY: Candidates must currently live within 30 miles of Media, PA and be available onsite at Wawa 1–2 days per week .

IMPORTANT – ORIGINAL RESUMES ONLY: Please submit the candidate's original 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
Role Overview
Seeking a Senior Data Architect to lead the modernization of Wawa's enterprise dimensional data warehouse and analytics environment. The role is heavily focused on Snowflake, Python, Kimball/star-schema dimensional modeling, certified data products, and enterprise analytics architecture .
Key Responsibilities
  • Lead redesign and modernization of enterprise dimensional data warehouses using Kimball/star schema
  • Define standards for dimensional modeling, semantic consistency, certified datasets, and reporting structures
  • Develop conceptual, logical, and physical enterprise data models
  • Architect scalable Snowflake data and transformation solutions
  • Establish Python-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 data governance, lineage, quality, and consistency
  • Provide architecture leadership and mentorship to data engineers/modelers
  • Lead modernization roadmaps and improve scalability across the analytics ecosystem
Required Qualifications
  • 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 supporting Tableau, Power BI, or similar enterprise BI platforms
  • Strong communication and stakeholder-management skills
Preferred
  • AWS cloud experience
  • Databricks or distributed processing frameworks
  • Experience modernizing large enterprise analytics and reporting environments
Vacancy posted 21 days ago
Similar jobs that could be interesting for youBased on the Senior Data Architect Snowflake / Dimensional Modeling in Blue Bell, PA vacancy
  • $170k - $210k

     ...We are looking for a visionary and hands-on Senior Data Architect to lead our data modeling, integration patterns, and semantic dataset initiatives. In...  ...Modeling: Deep expertise in conceptual, logical, physical, dimensional, canonical, and domain-oriented data modeling... 
    Senior
    Contract work
    Temporary work
    Remote work
    Flexible hours

    EPAM Systems Inc

    Conshohocken, PA
    4 days ago
  •  ...Description Job Description Title: Senior Data Architect / Migration Engineer Location:...  ...Partner with engineering on the shared data model between the configuration compiler and...  ..., including Oracle, AWS, and Snowflake Required Qualifications Strong relational... 
    Senior
    Remote work

    Expert In Recruitment Solutions

    Blue Bell, PA
    21 days ago
  • $132.23k - $176.31k

     ...‑powered world, connecting people, data, and applications through our expansive...  ...join us today. The Role The Senior Lead Marketing Data Platform Architect is responsible for defining,...  ...Establish platform standards for data modeling, ingestion, orchestration, observability... 
    Senior
    Full time
    Temporary work

    Lumen

    Philadelphia, PA
    3 days ago
  • $124k - $280k

     ...Opportunity As a Applied AI Health Data Architect you will shape data architecture solutions...  ...across cloud environments. As a Senior Manager you will lead large...  ...across AWS, Azure, Databricks, and Snowflake - Developing data models, warehouse structures, and transformation... 
    Senior
    Full time
    H1b

    PwC

    Philadelphia, PA
    15 hours ago
  •  ...more sustainable model. Our mission is...  .... By combining data-driven insights, innovative...  ...As Principal Data Architect, you will define...  .... Mentor senior engineers and data...  ...in data modeling, dimensional and relational modeling...  ...such as Snowflake, Databricks, cloud... 
    Suggested
    For subcontractor
    Immediate start
    Flexible hours

    ParetoHealth

    Philadelphia, PA
    25 days ago
  •  ...country.Job DescriptionCapTech Data Architects match our clients’ business...  ...warehouse tools including Snowflake and DataBricksAdvanced proficiency...  ..., storage and relational modeling leveraging industry standard...  ...level: Mid-Senior LevelIndustry: Management Consulting
    Senior
    Work at office
    Remote work
    Visa sponsorship
    Work visa
    Flexible hours

    CapTech

    Philadelphia, PA
    4 days ago
  • $160k

     ...Description Job Description Senior Machine Learning Engineer...  ...machine learning, predictive modeling, scoring, decisioning, and applied...  ...time working directly with data, features, models, scoring...  ...Azure Databricks, Spark, MLflow, Snowflake, or similar). Solid... 
    Senior
    Contract work
    Remote work
    Work visa

    GTT, LLC

    Philadelphia, PA
    21 days ago
  •  ...ResiliEnt Business Solutions is searching for a Senior Oracle PL/SQL Developer with Data Modeling experience. ~10+ years of professional experience...  ...applications. Ability to work effectively with developers, architects, business analysts, and other stakeholders.... 
    Local area
    Relocation

    ResiliEnt Business Solutions LLC

    Philadelphia, PA
    18 days ago
  •  ...advanced capabilities in AI and Data, Industry and Process, and...  ...Are:A seasoned SAP Finance Data Architect with deep retail and fashion industry...  ...the finance information model that clients run their...  ...Retail & Fashion you will:Engage senior client Finance executives on how... 
    Senior
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Philadelphia, PA
    15 hours ago
  •  ...end solutions that unify data, streamline operations,...  ...Principal or Senior Principal to take on the role of Data Cloud Architect within our Salesforce practice...  ...design, data ingestion and modeling, identity resolution...  ...hyperscale data platforms (ex: Snowflake), robust database... 
    Temporary work
    Work experience placement
    Local area

    Slalom

    Philadelphia, PA
    4 days ago
  •  ...We are seeking an experienced Senior Oracle Database Software Engineer to design, develop, optimize, and maintain enterprise-grade database...  ...in Oracle RDBMS, advanced PL/SQL development, healthcare data, and enterprise software engineering. The candidate will collaborate... 
    Senior
    Contract work

    Neshent Technologies

    Blue Bell, PA
    a month ago
  •  ...Job Description: Position Title Senior Principal Scientist Pharmacology 3Rs Portfolio...  ...in vivo ex vivo complex in vitro models (CIVMs)/microphysiological systems (MPS)/...  ...and in silico (in partnership with data science colleagues) NAM opportunities relevant... 
    Senior
    Full time
    Local area

    Johnson & Johnson

    Spring House, PA
    2 days ago
  •  ...certifications including Certified Technical Architect (CTA). Visit us here to find out more...  ...practiceWho You Are:You are a senior Data Cloud and AI Architect within Accenture’...  ...of Data Cloud solutions including data model, ingestion strategy, identity resolution... 
    Senior
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Philadelphia, PA
    1 day ago
  •  ...with advanced capabilities in AI and Data, Industry and Process, and Technology...  ...are a cross-Financial Services skilled senior Data 360 and AI Architect within Accenture’s Financial Services...  ...of Data 360 solutions including data model, ingestion strategy, identity... 
    Senior
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Philadelphia, PA
    3 days ago
  • $115k - $146k

    Role: Google Data Architect Who You’ll Work With:At Slalom we co-create custom software, data...  ...certification* Looker, Looker Studio, and semantic modeling* Gemini Enterprise, Vertex AI, MLOps,...  ...Azure, Teradata, Hadoop, Informatica, Snowflake, or legacy data platforms to Google... 
    Temporary work
    Work at office
    Local area
    Flexible hours

    Slalom

    Philadelphia, PA
    4 days ago
  • $106k - $159k

     ...tomorrows for all.Job Title: Data Architect Who You'll Work WithOur Data...  ...(GCP), Databricks, and Snowflake. Our Data Engineering teams...  ...disciplines including data modeling, governance, metadata, quality...  ...targeted base pay salary ranges:Senior Consultant* New York, Boston... 
    Temporary work
    Work at office
    Local area

    Slalom

    Philadelphia, PA
    1 day ago
  • We Are:The beginning of a new Data & AI decade that will reshape work and society...  ...Power Ecosystem. You Are:You are a data/senior data architect who designs enterprise data fabric...  ...product concepts, cloud data platforms (Snowflake, Databricks, Azure Synapse, BigQuery),... 
    Senior
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Philadelphia, PA
    1 day ago
  • We are looking for an experienced Data/Information Architect to shape and advance a modern cloud-based data environment....  ...The role centers on designing high-performing Snowflake solutions, establishing strong data models, and connecting information from multiple business... 
    Long term contract

    Robert Half

    Wayne, PA
    15 hours ago
  •  ...experience in software engineering or IT systems architecture, of which three (3) years must demonstrate experience as a Cloud Engineer/Architect with experience in cloud engagements and digital transformations (e.g. working with Azure or AWS, developing technical... 
    Senior

    EHS TECHNOLOGIES CORPORATION

    Philadelphia, PA
    10 days ago
  • $95k - $120k

     ...Senior Analytics Engineer Location: Philadelphia...  ...-based activation and data platform, transforming...  ...stack built on dbt and Snowflake, along with AI tools...  ...well-documented data models, then turning those models...  ...of relational and dimensional data modeling, as well... 
    Senior
    Full time
    Summer work
    Work at office
    Flexible hours
    2 days per week

    Health Union, LLC

    Philadelphia, PA
    3 days ago
  •  ...Opportunity Description This is an opportunity to join a data-rich technology leader with a combined audience of hundreds of millions...  ...implement, and maintain high-performance CTR and CVR prediction models that power ad ranking and recommendation systems. Build and... 
    Senior
    Immediate start
    Worldwide

    Toogeza

    Philadelphia, PA
    4 days ago
  • $85.1k - $161.7k

    We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, culture...
    Senior
    Full time
    Work experience placement
    Internship
    Local area

    RSM

    Philadelphia, PA
    3 days ago
  • $124k - $280k

     ...ManagerJob Description & SummaryThe OpportunityAs a Google AI & Data Solutions Architect you will lead client-focused solution design for generative...  ...within our Data and Analytics Engineering practice. As a Senior Manager you will lead large projects, apply sound judgment,... 
    Senior
    Full time
    H1b

    PwC

    Philadelphia, PA
    2 days ago
  • $140k - $170k

     ...Research Platform Architect The Federal Reserve Bank of St. Louis is seeking a Research...  ...students, and developers worldwide. The Data Architect will lead the design and modernization...  ...designing scalable data platforms, data models, and data governance frameworks to... 
    Full time
    Worldwide
    Flexible hours

    Federal Reserve System

    Philadelphia, PA
    3 days ago
  • $135k

     ...a Database Engineer and Architect to create foundational data and database architectures...  ..., enterprise information modeling, lineage, data quality,...  ...patterns, including relational, dimensional, denormalized,...  ...Azure SQL, Amazon Aurora, Snowflake, Databricks, and comparable... 
    Contract work
    Work at office
    Immediate start
    Remote work

    AGE Solutions

    Philadelphia, PA
    19 days ago
  • $165k - $175k

     ...hybrid role in King of Prussia, PA ~ This role is for a senior MLOps/ML Engineer with strong backend experience who...  ...infrastructure to deploy, operationalize, and support ML models in production. This is not a Data Scientist role focused primarily on building and... 
    Senior
    Work at office
    3 days per week

    PhillyTech.Co

    King of Prussia, PA
    12 days ago
  • $7.61k

     ...: SRI Tech SolutionsJob Title: Sr Azure Data Architect Location: Philadelphia , PA Total Years...  ...Description: Understand SAP Hana Data Model and Landscape and solution a transient layer...  ...and Implementation approaches to senior stakeholders. • Partner with cross-functional... 
    Senior
    Hourly pay

    SRI Tech

    Philadelphia, PA
    15 hours ago
  • $133.3k - $181.7k

     ...We are seeking a client-focused Data Analytics, AI & Microsoft Fabric Pre-Sales Architect to join our Artificial...  ...strategiesDefine best practices across data modeling, pipelines, and...  ...understanding of:Data warehousing and dimensional modelingETL/ELT and modern data... 
    Full time
    Contract work
    Local area
    Flexible hours

    Armanino

    Philadelphia, PA
    1 day ago
  •  ...Overview We are hiring a Data Engineer to join our Data Technologies...  ...- and back-office systems Architect and implement modern data...  ...with application teams to model, transform, and deliver data...  ...Databricks, Trino, Iceberg, Snowflake, Parquet, Apache Arrow, Polars... 
    Senior

    Susquehanna International Group, LLP

    Bala Cynwyd, PA
    15 hours ago
  •  ...Company Position: Senior Technical Lead...  ...following: with Snowflake, including query tuning...  ...secure views, and data-sharing concepts;...  ...and persistence model such as MongoDB,...  ...capabilities; Implement dimensional modeling...  ...Collaborate with data architects, technical leads,... 
    Senior
    Work experience placement
    Flexible hours

    SEI

    Oaks, PA
    9 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Senior Data Architect Snowflake / Dimensional Modeling. Be the first to apply!