Data Modeler

InterSystems
Boston
Workplace: OnsiteFull timeUSD 107,000 - 142,000 annuallyFunction: Data Analytics & Business IntelligenceExperience: 5+ yearsSkills: ["Data accuracy","Attention to detail","Communication"]

Own the design, governance, and evolution of a unified data lake/data warehouse. You’ll define canonical data definitions, source-to-target mappings, and transformation specifications to translate fragmented legacy CRM and operational systems into scalable, extensible models. Partner with Data Engineering and business stakeholders to ensure data quality, reconciliation, and governance, while administering warehouse schemas, access, performance, and documentation to enable reliable analytics and applications.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
InterSystems
InterSystems
1 day ago

Data Modeler

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 3 hours agoStatus: Live

Job Summary

Own the design, governance, and evolution of a unified data lake/data warehouse. You’ll define canonical data definitions, source-to-target mappings, and transformation specifications to translate fragmented legacy CRM and operational systems into scalable, extensible models. Partner with Data Engineering and business stakeholders to ensure data quality, reconciliation, and governance, while administering warehouse schemas, access, performance, and documentation to enable reliable analytics and applications.
Location: Boston
Workplace: Onsite
Employment Type: Full time
Job Function: Data Analytics & Business Intelligence
Seniority: Sr. Manager level

Key Responsibilities

  • •Design and maintain conceptual, logical, and physical data models across the data lake/warehouse.
  • •Define canonical data definitions and source-to-target mapping/transformation specifications for Data Engineers.
  • •Partner with Data Engineering to resolve discrepancies, develop validation/integrity checks, and monitor data quality.
  • •Maintain and optimize warehouse schemas/views, support ETL workflows, and manage user access and data security.
  • •Collaborate with Sales, CRM, Marketing, and stakeholders to gather requirements and standardize definitions while onboarding new data sources.

Pay and Benefits

Salary: USD 107,000 - 142,000 annually
Perks:Health InsuranceDentalVision401k

Key Requirements

  • •5+ years of experience in data modeling, data architecture, or related roles.
  • •Strong SQL skills 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:5+ years
Skills:Data accuracyAttention to detailCommunication
Tech Stack:SQLPostgreSQLIRISETLELTPython

Company Brief

InterSystems
Develops database management, interoperability, and analytics platforms—particularly for healthcare and financial services. Known for products like Caché, Ensemble, HealthShare and the InterSystems IRIS data platform enabling integrated data management and real-time applications.
Industry: Data Infrastructure
Company Size: Enterprise (1,001+ employees)
Growth: Established Company
Headquarters: Cambridge, United States
Founded: 1978
WebsiteLinkedIn