Lead Data Modeler - Data Warehouse & Governance

InterSystems Corporation; Boston, Northern (MA, KY); Hybrid; USD 126,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

Job summary

InterSystems is seeking a Lead Data Modeler to own the design, governance, and evolution of our data warehouse. You will shape how data is structured, understood, and used across the organization, partnering with Data Engineering, Sales Tech, CRM, and Marketing Tech.

This hands-on role emphasizes SQL, data modeling, source-to-target mapping, and data quality. You will define data flows, act as source of truth, and contribute to enterprise data architecture.

Qualifications

• 5+ years of data modeling, data architecture, or related roles.
• Strong SQL skills to analyze complex datasets.
• Experience designing conceptual, logical, and physical data models.
• Experience with IRIS, PostgreSQL, or similar databases.
• Ability to translate legacy systems into a unified data model.
• Attention to data quality and consistency.

Responsibilities

• Design and maintain conceptual, logical, and physical data models across the data lake/warehouse.
• Define canonical data definitions, relationships, and business logic across fragmented legacy systems.
• Build scalable, extensible models for analytics, reporting, and workflows.
• Establish modeling standards, naming conventions, and documentation practices.
• Continuously refine models as new data sources emerge.
• Own source-to-target mappings and data translation for ingestion.
• Validate data against mappings and ensure alignment with models.
• Partner with Data Engineers to resolve discrepancies across systems.
• Maintain and optimize schemas and views for performance and reliability.

Skills

Data Modeling

Data Architecture

SQL

Source-to-Target Mapping

ETL/ELT

Data Governance

Data Quality

Tools

InterSystems IRIS

PostgreSQL

Job description

InterSystems is seeking a Lead Data Modeler to own the design, governance, and evolution of our data warehouse. You will shape how data is structured, understood, and used across the organization, partnering with Data Engineering, Sales Tech, CRM, and Marketing Tech.

This hands-on role emphasizes SQL, data modeling, source-to-target mapping, and data quality. You will define data flows, act as source of truth, and contribute to enterprise data architecture.