Lead Data Modeler: Data Warehouse & Governance

Mass Digital Health; Boston (MA); On-site; USD 126,000 - 163,000; Full time

Benefits offered by this job

Medical, vision, dental insurance

Disability & life insurance

401(k) matching contributions

Paid time off & holidays

Parental leave

Tuition reimbursement

Job summary

InterSystems in Boston, MA is seeking a Lead Data Modeler to own the design, governance, and evolution of our data warehouse. You will drive canonical data definitions, models, and source-to-target mappings across CRM and operational datasets to enable scalable analytics.

You will collaborate with Data Engineering, Sales Tech, CRM, Marketing Tech, and business stakeholders to translate fragmented systems into a unified data model, while owning data governance, access design, and warehouse

Qualifications

• 5+ years of experience in data modeling, data architecture, or related roles.
• Strong SQL skills with the ability to independently analyze complex datasets.
• Experience designing conceptual, logical, and physical data models.
• Experience working with databases (IRIS, PostgreSQL, or similar).
• Strong understanding of data normalization, denormalization, and schema design trade-offs.
• Experience defining source-to-target mappings and working with ETL/ELT processes.
• Ability to work with ambiguous, messy legacy data and derive structured solutions.
• Strong attention to detail and commitment to data accuracy and consistency.

Responsibilities

• Own the data modeling and architecture across the data lake/warehouse.
• Define canonical data definitions, relationships, and business logic across fragmented systems.
• Build scalable models that support analytics, reporting, and workflows.
• Establish modeling standards, naming conventions, and documentation practices.

Skills

SQL

Data modeling

Database design

IRIS / PostgreSQL

Data quality

Source-to-target mappings

Legacy data handling

Attention to detail

Tools

InterSystems IRIS

Python

Job description

InterSystems in Boston, MA is seeking a Lead Data Modeler to own the design, governance, and evolution of our data warehouse. You will drive canonical data definitions, models, and source-to-target mappings across CRM and operational datasets to enable scalable analytics.

You will collaborate with Data Engineering, Sales Tech, CRM, Marketing Tech, and business stakeholders to translate fragmented systems into a unified data model, while owning data governance, access design, and warehouse