Data Modeler/Semantic Designer Job at Lorven technologies, Boston, MA

K1MrVEMza1BINUthZ29EbmZHWDlRem9nWGc9PQ==
  • Lorven technologies
  • Boston, MA

Job Description

Position: Data Modeler/Semantic Designer

Location: Boston, MA

Job Mode: Contract

Job Summary

We are seeking an experienced Data Modeler / Semantic Designer to design, develop, and maintain conceptual, logical, and physical data models, as well as semantic layers that enable accurate, consistent, and high-performance analytics. The ideal candidate will work closely with business stakeholders, data engineers, and BI teams to translate business requirements into scalable data models and semantic definitions.

Key Responsibilities

Data Modeling

  • Design and maintain conceptual, logical, and physical data models for enterprise data platforms
  • Create fact and dimension models (Star / Snowflake schemas) for analytics and reporting
  • Define data relationships, keys, constraints, and normalization standards
  • Support data warehouse, data lake, and lakehouse architectures

Semantic Layer Design

  • Design and manage semantic layers for BI and analytics tools
  • Define business metrics, KPIs, hierarchies, measures, and calculations
  • Ensure consistent metric definitions across dashboards and reports
  • Optimize semantic models for performance and usability

Technical Skills

  • Strong experience in data modeling (Conceptual, Logical, Physical)
  • Expertise in dimensional modeling (Kimball methodology)
  • Hands-on experience with semantic modeling in BI tools
  • Strong SQL skills
  • Experience with data warehouses / lakehouses (Snowflake, Redshift, BigQuery, Synapse, Databricks, etc.)
  • Knowledge of ETL / ELT pipelines and data transformations

Job Tags

Contract work,

Similar Jobs

Walmart

Whlsale Trade Yard Driver Job at Walmart

 ...position. If none are listed, there are no minimum qualifications._Minimum Qualifications: At least 21 years of age. Valid state-issued driver's license One (1) year of verifiable Full-Time driving experience operating a commercial vehicle in the previous 5 years. A... 

D'Youville College

Chemistry Department - Adjunct Job at D'Youville College

 ...Chemistry Department - Adjunct Position Summary: The Department of Chemistry at DYouville University is seeking qualified candidates to join a pool of adjunct instructors for potential teaching opportunities in lectures and labs, including General Chemistry... 

American Driver

Class A Regional Drivers - Recent Grads Accepted Job at American Driver

 ...per week on average Mix of drop & hook, live load, and live unload Breakdown, detention, and stop pay included Day and night shifts available Pay & Benefits Weekly earnings around $1,500 $15 per stop Full benefits after 30 days (medical,... 

ScribeAmerica

Clinical Assistant Job at ScribeAmerica

 ...providers on the front lines and gain valuable experience as a Clinical Assistant. Were proud to be acknowledged as a Best Places...  ...Accompany providers during patient visits to assist in documenting the provider assessment and exam Gain substantial knowledge... 

Signal of Northern Virginia

Unarmed Security/Patrol Officer (Fredericksburg/Stafford) Job at Signal of Northern Virginia

 ...Unarmed Security Officer - Central Park, Fredericksburg, and Stafford - Immediate Start Current DCJS 01...  ...holidays. As a Unarmed Security Officer (Roving Patrol Officer), responsibilities include: Conducting roving vehicle and foot patrols through property streets,...