Lead Data Modeler: Data Warehouse & Governance

InterSystems; Boston (MA); On-site; USD 107,000 - 142,000; Full time

Benefits offered by this job

Medical, vision, and dental insurance

401(k) Profit Sharing Contribution

Paid Time Off and Holidays

Parental Leave

Tuition reimbursement

Job summary

InterSystems in Boston is seeking a Lead Data Modeler to own the design, governance, and evolution of our data warehouse strategy across CRM and operational systems.

You will translate fragmented legacy data into a unified, scalable model and collaborate with Data Engineering, Sales Tech, Marketing Tech, and business stakeholders to serve as the source of truth for analytics and applications.

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 design and governance of data models across the data lake/warehouse.
• Define canonical data definitions, relationships, and business logic across fragmented legacy systems.
• Build scalable data models to support analytics, reporting, and operations.
• Establish modeling standards, naming conventions, and documentation practices.
• Refine models as new data sources and use cases emerge.
• Partner with Data Engineers to identify and resolve data discrepancies and build validation frameworks.

Skills

Data modeling

SQL

Data architecture

Data governance

Stakeholder collaboration

Tools

InterSystems IRIS

PostgreSQL

Job description

InterSystems in Boston is seeking a Lead Data Modeler to own the design, governance, and evolution of our data warehouse strategy across CRM and operational systems.

You will translate fragmented legacy data into a unified, scalable model and collaborate with Data Engineering, Sales Tech, Marketing Tech, and business stakeholders to serve as the source of truth for analytics and applications.