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

Similar Jobs