Data Modeler

Boston, MAfull timeOn Site

Apply on Employer Site

mid

$107k–$142k

H1B: no

Inter Systems Lead Data Modeler at InterSystems owns design, governance, and evolution of the data warehouse, translating fragmented legacy systems into a unified data model. The role involves data modeling, source-to-target mapping, data quality governance, and warehouse administration.

Responsibilities

Data Modeling & Architecture Ownership
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 that reduce redundancy and support analytics, reporting, and operational workflows.
Establish modeling standards, naming conventions, and documentation practices across the platform.
Continuously refine models as new data sources and use cases emerge.
Source-to-Target Mapping & Data Translation
Analyze legacy CRM and other operational datasets to understand structure, quality, and business meaning.
Define detailed source-to-target mapping logic for ingestion into the data model.
Provide clear, implementation-ready transformation specifications to Data Engineers.
Validate incoming data against expected mappings and ensure alignment with defined models.
Act as the primary owner of how legacy data translates into the unified system.

Qualification

5+ years of experience in data modelingExperience designing conceptualExperience working with databases (IRISAbility to work with ambiguousExperience supporting data governance

Required

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.

Preferred

Experience working with CRM or customer data platforms.
Familiarity with InterSystems IRIS or similar enterprise data platforms.
Experience supporting data governance, access control, and data quality initiatives.
Proficiency in Python for data analysis or validation workflows.
Experience using AI tools to accelerate data analysis, mapping, and documentation.
Strong communication skills with the ability to work across technical and business teams
We are an equal-opportunity employer and do not discriminate because of race, color, religion, sex, national origin, ancestry, marital status, veteran status, age, disability, sexual orientation or gender identity or expression or any other legally protected category. InterSystems is an E-Verify Employer in the United States.
InterSystems is providing a current good faith estimate of the anticipated base salary range for this position depending on a variety of factors including experience, education, skills, and performance.

Benefits

Dental
Vision
401(k)
PTO
Tuition
Parental Leave
Life Insurance

Company

Inter Systems

View company page

Source: greenhouse

Active within the past hour

More roles at Inter Systems

Senior Automation Engineer

Boston, MA

Senior Product Manager, Public Sector

Boston, MA

Sales Ops Analyst – Territory

Boston, MA

Benefits and Compensation Team Lead

Boston, MA