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

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

Doosan Bobcat NA US

Painter Job at Doosan Bobcat NA US

Job Information Sets up and operates painting and drying units along conveyor line to coat metal products with paint. 2nd Shift: 4:30pm-3:00am Mon-Thurs. Mandatory OT on Fridays Pay Scale: $20.75-$29.97 Role & Responsibility Principal Responsibilities ...

Reddit

Senior Staff Machine Learning Engineer, Ads Ranking Job at Reddit

 ...Reddit is a community of communities. Its built on shared interests, passion, and trust, and is home to the most open and authentic conversations on the internet. Every day, Reddit users submit, vote, and comment on the topics they care most about. With 100,000+... 

AtkinsRéalis

ITS Traffic Engineer Job at AtkinsRéalis

ITS Traffic Engineer Location New York, NY : ITS/Traffic Engineer Why join us? We are hiring! Atkins seeks an ITS Traffic Engineer to join our team in Princeton, NJ or New York City, NY . This role will perform ITS and Traffic tasks related to ITS/Traffic Engineering... 

West Bloomfield Dermatology and Mohs Surgery

Dermatology Medical Assistant Job at West Bloomfield Dermatology and Mohs Surgery

 ...West Bloomfield Dermatology and Mohs Surgery is seeking a medical assistant for our busy practice. We are looking for someone friendly, knowledgeable, and with great interpersonal skills. Experience as a medical assistant in Dermatology is REQUIRED and experience in Mohs... 

Roufs Property Maintenance

Iron Range (Hibbing)- Crew Member Janitorial Job at Roufs Property Maintenance

 ...Hibbing, Chisholm area Crew Member. Evening shift, after 5pm start time. Job Description Key Responsibilities include but are not...  ...crouch; kneel; blood borne pathogens; and driving. Job Types: Full-time, Part-time We are a family owned company headquartered in...