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

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

Cornerstone Building Brands

CDL Class B driver Job at Cornerstone Building Brands

 ...Shift: Full-Time, Day Shift DUTIES AND RESPONSIBILITIES The Driver will be expected to transport, deliver, and/or unload windows and...  ...equipment used and submits paperwork daily Plans trips/reads maps Determines shortest and safest route for delivering loads... 

State of Florida

MEDIATOR-CIRCUIT/FAMILY - 22010640 Job at State of Florida

 ...Requisition No:867382 Agency: State Courts System Working Title: MEDIATOR-CIRCUIT/FAMILY - 22010640Pay Plan: State Courts System Position Number:22010640 Salary: 52,664.52 Posting Closing Date: 06/01/2026 Total Compensation Estimator How to Apply... 

Summit Sky Consulting

Online Customer Sales Representative - Entry Level with Trainings (Remote) Job at Summit Sky Consulting

 ...currently looking for an ambitious, results-oriented Sales Representative to become part of our rapidly expanding remote team. This position offers the chance to work with a dynamic organization that prioritizes collaboration, growth, and client satisfaction, while providing... 

Mérieux NutriSciences - North America

Microbiologist I Job at Mérieux NutriSciences - North America

 ...Regular MERIEUX NUTRISCIENCES As a trusted partner, our Public Health mission is to make food systems safer, healthier and more...  ...plating. General understanding of bacterial plate counts and entry-level microbiological techniques. General knowledge of Laboratory... 

Egon Zehnder

Researcher, Executive Search Job at Egon Zehnder

 ...client teams of consultants and other Researchers in the execution of Executive Search, Board, and Advisory projects for multiple clients within...  ...monitoring relevant market shifts in a segment or function, company updates, and people moves Act as a partner with consultants...