Jobs via Dice
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
#J-18808-Ljbffr
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
#J-18808-Ljbffr