Data Modeling Engineer at Aramark building dimensional models and BI data products in Snowflake. Collaborating with data engineering and BI teams to ensure data accuracy and reliability.
Responsibilities
Build dimensional models and Business Vault structures in Snowflake based on approved architectural designs
Apply approved business logic and KPI definitions
Partner closely with data engineering teams
Ensure accurate, reliable, and consumption-ready modeled data
Focus on implementation and build execution within Snowflake
Build architect-approved star schemas and subject-area dimensional models
Implement bridge tables resolve many-to-many relationships, hierarchies, and allocation logic
Deliver business-friendly semantic layers optimized for Power BI consumption
Validate modeled outputs for accuracy and completeness
Support SDLC and SOC 1 evidence requirements through clear documentation
Requirements
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.
Process Engineer at Anglian Water designing and optimizing water and wastewater treatment systems. Collaborating across teams to ensure compliance and safety in engineering solutions.
PDK Engineer working with cross - functional teams at Pragmatic Semiconductor. Focusing on the design, development, maintenance, and testing of Process Design Kits in Cambridge.
Senior Manager developing scalable workflow - driven solutions for enterprise platforms at State Street. Collaborating with cross - functional teams to ensure performance and reliability in complex business processes.
Senior Conveyor Engineer leading installation and operational activities of conveyor equipment in GM facilities. Overseeing projects while collaborating with internal teams and external partners at multiple plants.
Microsoft Purview Engineer at Musco Sports Lighting enhancing data governance and compliance solutions. Collaborating with IT teams and managing data classification, retention, and compliance standards.
Project Engineer for Musco designing custom lighting solutions and ensuring project specifications in Oskaloosa, IA. Requires collaboration with internal and external stakeholders to meet client technical needs.
Systems Safety Engineer developing safety strategies for Keyless & Passive Power Moding at General Motors. Collaborating with global teams to ensure compliance with safety standards and regulations.
Ingenieur en efficacité énergétique chez NEPSEN supervisant des projets en performance énergétique de bâtiments. Contribuant à des audits, rénovations et pilotage de contrats de performance énergétique.
Advanced Device Development Engineer on Logic Technology Development team at Intel. Designing, executing, and analyzing semiconductor experiments in a collaborative and innovative environment.
Industrial Hygiene/Safety Engineer overseeing safety programs at Intel's semiconductor manufacturing sites in Penang. Protecting worker health and ensuring compliance with safety standards and regulations.