Overview
On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)
Skills
data modeling
Snowflake
Redshift
BigQuery
Synapse
Databricks
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.
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
- 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)
- 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.