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-...