Title:  Data Modeling Engineer

Job Description

The Data Modeling Engineer builds dimensional models and Business Vault structures in Snowflake based on approved architectural designs and specifications. This SQL-first role applies approved business logic and KPI definitions to produce performant, documented, and governed data products that power BI, analytics, and AI use cases. The role partners closely with data engineering teams on upstream Data Vault inputs and with BI teams using Power BI to ensure accurate, reliable, and consumption-ready modeled data. Architectural design decisions are provided; this role focuses on implementation and build execution within Snowflake.

Data Modeling Engineer
Department: Data Architecture & Engineering
Reports To: Director, Data Architecture & Engineering

Location: Philadelphia, PA or Rockville, MD

Job Responsibilities

Modeling & Semantics
- Build architect-approved star schemas and subject-area dimensional models.
- Implement bridge tables resolve many-to-many relationships, hierarchies, and allocation logic prior to or within dimensional modeling.
- Apply established dimensional modeling patterns including surrogate keys, SCD Type 1/2, conformed dimensions, and approved bridge-table techniques.
- Implement approved KPI definitions, filters, and business rules into governed semantic views.
- Deliver business-friendly semantic layers optimized for Power BI consumption, standardizing metrics and hiding technical complexity.

Governance, Quality & Performance
- Apply Snowflake governance controls including data masking, sensitivity tagging, and (where applicable) row access policies.
- Ensure all modeled objects are documented using Snowflake comments and metadata standards.
- Validate modeled outputs for accuracy, completeness, and reconciliation to source-of-truth totals.
- Tune SQL for performance and cost efficiency, applying Snowflake best practices.
- Support SDLC and SOC 1 evidence requirements through clear documentation and controlled change processes.

Operations & Reliability
- Support scheduled refreshes and dependencies using Snowflake-native orchestration or approved tooling.
- Monitor modeled layers and resolve data, logic, or performance issues affecting downstream consumers.
- Partner with upstream teams to triage and resolve source data issues when needed.

Collaboration & Delivery
- Partner with BI developers to ensure semantic layers answer business questions without additional tool-side modeling.
- Collaborate with Data Engineers to align on grain, keys, freshness windows, and data contracts.
- Participate in sprint planning, estimation, and delivery ceremonies; communicate status and risks proactively.

AI-Enabled Development
- Use AI-assisted development tools to accelerate SQL development, refactoring, optimization, and documentation.
- Maintain full accountability for correctness, governance, and semantic integrity of all AI-assisted outputs.

Qualifications

Required Qualifications
- Strong hands on experience with Snowflake
- Familiarity and comfortability with Data Vault 2.0 methodology
- Advanced SQL expertise, including complex joins, window functions, and performance tuning.
- Strong understanding of dimensional modeling concepts including SCDs, surrogate keys, and conformed dimensions.
- Experience encoding business logic and KPI definitions into curated semantic views.
- Experience supporting semantic models and datasets consumed by Power BI and other BI tools
- Familiarity with Snowflake governance features including data masking and sensitivity tagging.
- Experience supporting production data models through SDLC and incident resolution.
- Strong communication and documentation skills.

Preferred Qualifications
- Experience optimizing Snowflake performance and cost.
- Experience optimizing datasets for Power BI performance and usability.
- Exposure to BI and AI consumption patterns requiring clear semantics and business-friendly metadata.
- Familiarity with Git-based workflows and Azure DevOps.
- Experience contributing to a centralized semantic or data modeling function.

Benefits

COMPENSATION: The salary range for this position is $85,000 to $100,000. If both numbers are the same, that is the amount that Aramark expects to offer.  This is Aramark’s good faith and reasonable estimate of the compensation for this position as of the time of posting. 

Aramark offers comprehensive benefit programs and services for eligible employees including medical, dental, vision, and work/life resources.   Additional benefits may include retirement savings plans like 401(k) and paid days off such as parental leave and disability coverage.  Benefits vary by location and are subject to any legal requirements or limitations, employee eligibility status, and where the employee lives and/or works.  For more information about Aramark benefits, click here Aramark Careers - Benefits & Compensation.   

About Aramark

Our Mission

Rooted in service and united by our purpose, we strive to do great things for each other, our partners, our communities, and our planet.

At Aramark, we believe that every employee should enjoy equal employment opportunity and be free to participate in all aspects of the company. We do not discriminate on the basis of race, color, religion, national origin, age, sex, gender, pregnancy, disability, sexual orientation, gender identity, genetic information, military status, protected veteran status or other characteristics protected by applicable law.

About Aramark

The people of Aramark proudly serve millions of guests every day through food and facilities in 15 countries around the world. Rooted in service and united by our purpose, we strive to do great things for each other, our partners, our communities, and our planet. We believe a career should develop your talents, fuel your passions, and empower your professional growth. So, no matter what you're pursuing - a new challenge, a sense of belonging, or just a great place to work - our focus is helping you reach your full potential. Learn more about working here at http://www.aramarkcareers.com or connect with us on Facebook, Instagram and Twitter.