CrawlJobs Logo
Aramark Logo Aramark · IT - Software Development

Data Modeling Engineer

United States, Philadelphia, PA or Rockville, MD 85000.00 - 100000.00 USD / Year · Job Posted February 20, 2026
Apply Position
Job Link Share

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.

Job Responsibility

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

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
  • Strong communication and documentation skills

Nice to have

  • 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

What we offer

  • medical
  • dental
  • vision
  • work/life resources
  • retirement savings plans like 401(k)
  • paid days off such as parental leave and disability coverage
Aramark - All Job Offers

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Suggested Tags: Frontend Developer Secretary Talent Manager Salesforce Administrator Data Analyst
Similar Jobs for

Data Modeling Engineer

8 matching positions

Lead Data Engineer - Data Transformation (Modeling and Architecture)

Lead Data Engineer - Data Transformation (Modeling and Architecture). Do you lov...
Location
Location
United States , Richmond, Virginia; McLean, Virginia; Cambridge, Massachusetts
Salary
Salary:
179400.00 - 225100.00 USD / Year
capitalone.com Logo
Capital One
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's Degree
  • At least 4 years of experience in application development
  • At least 2 years of experience in big data technologies
  • At least 1 year experience with cloud computing (AWS, Microsoft Azure, Google Cloud)
Job Responsibility
Job Responsibility
  • Build and maintain comprehensive data models—spanning conceptual, logical, and physical layers—to ensure scalable architecture and high data integrity across enterprise systems
  • Lead design of the org data landscape by applying Consumer Driven design principles, ensuring that data structures reflect business realities and evolving organizational needs
  • Architect and implement robust data ecosystem solutions, including Data Lake and Data Warehouse patterns, to support diverse analytical and operational requirements
  • Support high-performance data pipelines and complex transformations that utilize SQL, Spark, and Python to process large-scale datasets efficiently
  • Define and Enforce rigorous data governance standards while managing metadata frameworks to ensure data compliance and discoverability
  • Translate complex technical concepts into actionable business insights, working independently to lead initiatives and collaborate with stakeholders to meet organizational goals
  • Contribute to the evolution of the data ecosystem by designing AI-ready architectures
  • Collaborate with and across Agile teams to design, develop, implement, and support technical solutions
  • Work with a team of developers with deep experience in machine learning, AI, distributed microservices, and full stack systems
  • Share your passion for staying on top of tech trends, experimenting with and learning new technologies, participating in internal & external technology communities, and mentoring other members of the engineering community
What we offer
What we offer
  • Performance based incentive compensation, which may include cash bonus(es) and/or long term incentives (LTI)
  • Comprehensive, competitive, and inclusive set of health, financial and other benefits
  • Fulltime
Read More
Arrow Right

Fabric Data Engineer / Azure Data Engineer

Location
Location
Salary
Salary:
Not provided
myticas.com Logo
Myticas Consulting
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Hands-on Data Engineer with strong Microsoft Fabric experience, including Lakehouse, OneLake, Data Factory/Pipelines, Warehousing, and Fabric ecosystem services
  • Strong Python development skills for data engineering, data transformation, automation, and pipeline development
  • Experience working with Microsoft Fabric Lakehouse architecture, including data ingestion, transformation, storage, and analytics enablement
  • Strong understanding of data engineering fundamentals, including data modeling, partitioning, optimization, and performance tuning
  • Experience supporting Azure Data Platform technologies, including Azure Data Factory, Azure Synapse Analytics, Azure Storage, and related services
  • Ability to work within large-scale enterprise data environments supporting multiple business units and data domains
  • Knowledge of Medallion Architecture (Bronze, Silver, Gold) and practical implementation of modern data lakehouse solutions
  • Experience integrating and transforming structured and semi-structured data sources including APIs, databases, JSON, CSV, and cloud-based systems
  • Understanding of Fabric operational monitoring, capacity consumption monitoring, and platform governance best practices
  • Ability to clearly explain and demonstrate the distinction between Fabric Files, Tables, Lakehouses, Warehouses, and OneLake storage concepts
Job Responsibility
Job Responsibility
  • Design, build, and support scalable ETL/ELT data pipelines across enterprise Azure environments
  • Ability to support integration across multiple systems, applications, databases, and cloud platforms
Read More
Arrow Right

Lead Analytics Engineer - Data Modeling & Quality

Arcadia is the only healthcare data and software company dedicated to healthcare...
Location
Location
United States
Salary
Salary:
Not provided
themuse.com Logo
The Muse
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Advanced SQL: window functions, complex CTEs, aggregation patterns, performance tuning on columnar databases
  • DBT: hands-on experience authoring models, tests, macros, and yml documentation
  • familiarity with incremental strategies
  • Healthcare data literacy: working knowledge of claims data (professional, institutional, pharmacy), clinical data (EHR entities), and common quality dimensions (member months, coverage rates, null patterns)
  • Data quality mindset: ability to differentiate source data issues from transform issues, design systematic validation checks, and communicate data quality findings clearly
  • Clear communicator — able to translate technical findings for clients and non-technical stakeholders
  • Strong analytical judgment — you can look at a distribution and know when something is wrong
  • Ability to manage several projects simultaneously, leveraging AI tooling to stay organized and efficient
  • Genuine desire to learn and apply AI tools for operational efficiency
Job Responsibility
Job Responsibility
  • DATA MODELING & DBT DEVELOPMENT: Author, review, and maintain DBT models using Spark/Hudi from ingest through bronze and silver
  • Help clients understand their data model, assumptions, and limitations through intentional validation
  • Troubleshoot and fix issues, then write DBT tests to catch issues proactively
  • Optimize SQL performance for slow-running jobs
  • Partner with Data Engineering on Hudi table design, partition strategy, and incremental patterns
  • DATA QUALITY OWNERSHIP: Triage and classify data quality alerts, distinguishing source-level issues from transform-layer failures
  • Design and maintain volume monitors and DQ monitors (null rate, distribution, future-date checks)
  • Author and apply clinical DQ rules (entity volume, field coverage, LOINC coverage, referential integrity) and claims validation rules across silver and gold layers
  • Conduct quality reviews for connector promotions — evaluating silver entity coverage, validation rule pass rates, and bronze-to-silver transformation correctness
  • Own the ticket queue for DQ, attribution, hierarchy, and customer-specific data quality issues, writing clear customer-facing findings
What we offer
What we offer
  • Pet Insurance
  • Health Insurance
  • Dental Insurance
  • Vision Insurance
  • FSA
  • HSA
  • HSA With Employer Contribution
  • Life Insurance
  • Short-Term Disability
  • Long-Term Disability
Read More
Arrow Right

Software Engineer / Data Engineer

We are looking for a Software Engineer / Data Engineer to build and enhance inte...
Location
Location
United States , New York
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years of relevant experience in software engineering, data engineering, or a closely related technical role
  • Strong backend development expertise in Python, with practical experience building production-grade services and data-driven applications
  • Hands-on experience with PySpark, Databricks, and AWS for data processing, platform development, and cloud-based deployment
  • Ability to work across multiple layers of technology, including APIs, databases, application logic, frontend components, and infrastructure
  • Familiarity with JavaScript or TypeScript and exposure to modern frontend frameworks such as React or Next.js
  • Experience developing solutions that incorporate large language models
  • broader machine learning knowledge is an advantage
  • Proven ability to translate loosely defined business or research needs into well-structured technical solutions
Job Responsibility
Job Responsibility
  • Create and support internal applications, including dashboards, research platforms, and workflow solutions that improve day-to-day productivity across the firm
  • Develop and maintain AI-enabled internal systems such as application services, knowledge retrieval capabilities, agent-based tools, and monitoring frameworks for performance and quality
  • Collaborate with investment professionals and data science teams to convert research processes into stable, user-focused software products
  • Define technical direction for new systems, selecting appropriate architecture and establishing engineering standards that can scale with future development
  • Build backend services and data pipelines using Python, PySpark, and Databricks to support analytics, automation, and application functionality
  • Contribute to frontend experiences for internal users with modern web technologies such as Next.js, React, and interactive visualization tools
  • Design solutions that connect APIs, user interfaces, data storage, and cloud infrastructure into cohesive, maintainable platforms
What we offer
What we offer
  • medical, vision, dental, and life and disability insurance
  • company 401(k) plan
  • free online training
Read More
Arrow Right

Data Engineer (Data Visualization Dashboard)

We are seeking a skilled Data Engineer to support a Data Analytics project. The ...
Location
Location
Malaysia , Kuala Lumpur
Salary
Salary:
4500.00 - 6000.00 RM / Month
https://www.randstad.com Logo
Randstad
Expiration Date
August 24, 2026
Flip Icon
Requirements
Requirements
  • Strong experience in ETL development and data pipeline design
  • Solid programming skills in Python for data transformation
  • Familiarity with data modeling and best practices in data engineering
  • Ability to work independently and deliver results on a tight timeline
  • 2 years experience
  • Python
  • Dashboard visualization
  • Bachelor's in Computer Software or related
Job Responsibility
Job Responsibility
  • Design, develop, and maintain ETL workflows using AWS Glue, Python, and related tools
  • Integrate data from various sources into a centralized data lake or warehouse
  • Ensure data quality and consistency across ETL processes
  • Optimize data pipeline performance and troubleshoot issues
  • Collaborate with analytics and business teams to understand data requirements
What we offer
What we offer
  • Insurance
  • Travelling allowance
  • Fulltime
Read More
Arrow Right

Full-Stack Data Engineer – Data & ML Automation (Databricks)

We are seeking a Fullstack Data Engineer who can operate at the intersection of ...
Location
Location
India , Pune
Salary
Salary:
Not provided
Codvo AI
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience with CLI tools, scripts, and utilities for automating data platform workflows
  • Experience with Databricks APIs, Terraform, Databricks SDK
  • Experience designing integration tests, end-to-end pipeline tests, validation frameworks for Databricks ETL/ELT pipelines and ML inference workflows
  • Experience building internal applications using React, Streamlit, or similar frameworks
  • Experience with spec-driven development, coding agents and automation patterns, CI/CD workflows for data/ML systems
Job Responsibility
Job Responsibility
  • Develop CLI tools, scripts, and utilities to automate repetitive workflows across the data platform
  • Automate Databricks workflows, job deployments, environment provisioning, and MLOps operations using Databricks APIs, Terraform, Databricks SDK
  • Design and implement integration tests, end-to-end pipeline tests, validation frameworks for Databricks ETL/ELT pipelines and ML inference workflows
  • Improve reliability, observability, and overall engineering productivity across the data & ML team
  • Build quick internal applications using React, Streamlit, or similar frameworks to visualize data flows, provide model inference demos, enable operational or configuration controls
  • Develop internal productivity and monitoring dashboards
  • Apply best practices around spec-driven development, coding agents and automation patterns, CI/CD workflows for data/ML systems
  • Fulltime
Read More
Arrow Right

Data Engineer / Data Scientist – MLOps & Machine Learning

Location
Location
United States , Charlotte
Salary
Salary:
70.00 USD / Hour
bhsg.com Logo
Beacon Hill
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years of hands-on experience as a Data Engineer or Data Scientist in large-scale, cloud-based data environments
  • Strong experience building or supporting MLOps workflows in Databricks
  • Hands-on experience with MLflow, including experiment tracking, model registry, and deployment workflows
  • Strong understanding of machine learning fundamentals and model lifecycle management
  • Solid data science foundation with understanding of ML theory, mathematics, and statistical concepts
  • Experience building, training, validating, and deploying machine learning models
  • Ability to explain model selection decisions and ML approaches clearly
  • Strong collaboration and communication skills with the ability to work well across cross-functional teams
  • Strong personality fit and ability to work effectively in team-oriented environments
  • Willingness to work onsite
Job Responsibility
Job Responsibility
  • Design, build, and support scalable machine learning and data workflows in cloud environments
  • Develop and maintain MLOps pipelines using Databricks and MLflow
  • Track, manage, and deploy machine learning models across environments
  • Work closely with data scientists, engineers, and business stakeholders to deliver ML-driven solutions
  • Analyze large datasets and apply machine learning techniques to solve business problems
  • Support model monitoring, optimization, and continuous improvement initiatives
  • Collaborate on architecture, best practices, and scalable ML engineering standards
Read More
Arrow Right

Data Engineer / Data Scientist

Location
Location
Salary
Salary:
Not provided
serokell.io Logo
Serokell
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 2+ years of experience in data engineering, data science, or a closely related field.
  • Proficiency in Python (Pandas, NumPy, or similar libraries)
  • ability to read and ideally write TypeScript.
  • Experience designing and working with relational databases (PostgreSQL) and time-series databases (InfluxDB or similar, such as TimescaleDB or ClickHouse).
  • Experience building and maintaining REST APIs (data aggregation and serving layer).
  • Familiarity with simulation systems, agent-based modeling, or scenario generation pipelines.
Job Responsibility
Job Responsibility
  • Own design and development of core data components within a complex distributed system, including defining data models, processing pipelines, and data flow between system parts.
  • Collaborate with backend engineers to maintain backend services that aggregate, transform, and expose data through well-structured APIs for other services.
  • Work with autonomous system components and their orchestration, ensuring reliable execution and data exchange.
What we offer
What we offer
  • Competitive salary.
  • Attractive international projects.
  • Participation in leading world conferences.
  • International teams and a multicultural environment.
  • Fully remote work and flexible working hours.
  • Flexible time off whenever you need it.
  • Investment in your professional and career growth, corresponding to wage growth.
  • Mentoring and training.
  • Opportunity to contribute to one of the functional programming industry’s leading blogs.
  • Therapy sessions to support your well-being.
Read More
Arrow Right