Overview
On Site
Accepts corp to corp applications
Contract - Contract
Skills
ETL
Data Modeler
semantic
Job Details
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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.