Urgent Need Data Modeler – LucidChart exp must – Norwell, MA

Job Title: Data Modeler – LucidChart exp must
Location: Norwell, MA
Contract

Exp: 10+ years

Job Summary:
We are seeking an experienced Data Modeler to design and implement high-quality analytical data models that support enterprise reporting, analytics, and data science use cases. The ideal candidate will have hands-on expertise in Silver and Gold layer modeling, dimensional data warehouse design, and Python automation to streamline data modeling, validation, and documentation processes.

Key Responsibilities:
Experience with database modeling tools such as LucidChart”
Experience with standard data models such as S-95
Design and develop Silver and Gold layer data models following medallion architecture principles.
Create and maintain dimensional models (Star and Snowflake schemas) for enterprise data warehouses.
Define fact and dimension tables aligned with business KPIs and analytical requirements.
Apply best practices for slowly changing dimensions (SCDs) and historical data tracking.
Lead end-to-end data warehouse design and modeling initiatives.
Translate business requirements into scalable, performant data models.
Optimize models for query performance, usability, and extensibility.
Partner with data engineers to ensure accurate implementation of models.
Develop Python-based automation for data model validation, reconciliation and documentation.
Automate metadata extraction, schema comparison, and impact analysis.
Support automated testing of data models and transformations.
Build reusable Python utilities to improve modeling efficiency.
Collaborate with data engineers, analysts and architects.
Participate in design reviews and ensure alignment with enterprise data standards.
Support data governance initiatives including data definitions, lineage, and documentation.
Ensure consistency in naming conventions, data types, and modeling standards.

Required Skills and Qualifications:
8 12+ years of experience in data modeling and data warehousing.
Strong hands-on experience with Silver & Gold layer modeling
Dimensional modeling (Star / Snowflake schemas) and Data warehouse design
Python automation. Deep understanding of fact/dimension design, grain definition, and KPI modeling.
Experience with large-scale analytical datasets.

Good to Have:
Microsoft Certified: Azure Data Engineer Associate or Azure Enterprise Data Analyst Associate.
Experience with cloud data platforms (Azure).Exposure to CI/CD and version control for data models.
Knowledge of metadata management and data governance tools.
Wast management or oil and gas domain knowledge