Back to jobs
New

Data Modeler

Boston, MA

We are looking for a highly motivated, systems-oriented Lead Data Modeler to own the design, governance, and evolution of our data warehouse at InterSystems. 

This role sits at the center of our data lake / data warehouse initiative and will be responsible for defining how data is structured, understood, and used across the organization. You will work closely with Data Engineering, Sales Tech, CRM, Marketing Technology, and business stakeholders to translate fragmented legacy CRM and operational systems into a unified, scalable data model. 

This is a hands-on role requiring strong SQL and data analysis skills, with an emphasis on data modeling, source-to-target mapping, and cross-system reconciliation. You will not primarily build ingestion pipelines, but you will define exactly how data should flow, transform, and be represented - serving as the source of truth for all downstream analytics and applications. 

In addition to modeling, this role will own core aspects of data governance, user access design, user support, and internal data warehouse administration within InterSystems. 

 

Key Responsibilities 

  1. 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. 
  1. 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. 
  1. Data Quality, Reconciliation & Discrepancy Resolution 
  • Partner with Data Engineers to identify and resolve discrepancies across systems and pipelines. 
  • Develop frameworks for data validation, integrity checks, and consistency monitoring. 
  • Investigate edge cases and ambiguous data definitions with SMEs and stakeholders. 
  • Establish processes for ongoing data quality governance as the platform scales. 
  1. Data Warehouse Administration  
  • Maintain and optimize schemas and views within the data warehouse, ensuring high performance and reliability. 
  • Support ETL workflows, data integrity checks, and reporting pipelines. 
  • Manage user access, roles, and data security within the warehouse environment. 
  • Monitor query performance and optimize schemas and indexing strategies. 
  • Maintain clear, up-to-date documentation of schemas, tables, and data flows. 
  1. Cross-Functional Collaboration & Communication 
  • Partner with Sales, CRM, Marketing, and other stakeholders to gather and clarify data requirements. 
  • Translate complex data structures into clear, understandable documentation for non-technical users. 
  • Work closely with Data Engineering to ensure seamless execution of ingestion and transformation logic. 
  • Align with internal teams to standardize definitions and avoid duplication of data efforts. 
  1. Platform Growth & Governance 
  • Own the onboarding of new data sources into the data warehouse platform. 
  • Define scalable patterns for integrating additional systems over time. 
  • Establish and manage user groups, access patterns, and data consumption layers. 
  • Contribute to long-term strategy for enterprise data architecture at InterSystems. 

 

 

Short-Term Goals (0–6 months) 

  • Build a comprehensive understanding of existing CRM and operational data sources. 
  • Develop the initial unified data model across core systems. 
  • Define and document source-to-target mappings for key datasets. 
  • Stand up and organize the data warehouse schema. 
  • Establish user groups, access controls, and initial governance processes. 
  • Partner with Data Engineering to support initial ingestion and validation pipelines. 
  • Identify and resolve major discrepancies across legacy systems. 

Long-Term Goals (6–24 months) 

  • Expand the data model to incorporate additional business domains and data sources. 
  • Evolve the platform into a scalable, enterprise-grade data lake / warehouse. 
  • Establish robust data governance, documentation, and quality monitoring frameworks. 
  • Enable self-service analytics through well-structured and well-documented datasets. 
  • Drive standardization of data definitions across the organization. 
  • Continuously optimize performance, usability, and scalability of the platform. 

 

Required 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. 

Preferred Qualifications 

  • 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.

Other compensation may include a discretionary annual variable target incentive.

The company also provides generous employee benefits including:

  • Medical, vision, and dental insurance
  • Short-term and long-term disability, and life insurance
  • 401(k) Profit Sharing Contribution
  • Paid Time Off and Holidays
  • Parental Leave
  • Tuition reimbursement

The estimated base compensation range for this role is:

$107,000 - $142,000 USD

About InterSystems

InterSystems, a creative data technology provider, delivers a unified foundation for next-generation applications for healthcare, finance, manufacturing, and supply chain customers in more than 80 countries. Our data platforms solve interoperability, speed, and scalability problems for large organizations around the globe to unlock the power of data and allow people to perceive data in imaginative ways. Established in 1978, InterSystems is committed to excellence through its 24×7 support for customers and partners around the world. Privately held and headquartered in Boston, Massachusetts, InterSystems has 38 offices in 28 countries worldwide. For more information, please visit InterSystems.com.

 

AI Disclaimer

InterSystems may use AI tools for its internal operations including administrative tasks during recruitment (e.g., organizing candidate information).  InterSystems’ approach to AI is guided by the InterSystems Responsible AI Guidelines. AI is not used to make or influence hiring decisions. All decisions are made by InterSystems employees.

Candidates may use AI for CV or interview preparation, provided materials are truthful and reflect their own experience.  AI tools and third-party transcription services must not be used during interviews or assessments.

Please note that the use of wearable technology, including any AI-related tools or other technology-connected devices (such as META or Google smart glasses and/or wearables, and/or any similar devices), is strictly prohibited during the interview and screening process with InterSystems.  Any applicant who requires a wearable device or any type of technology support during the interview process as a reasonable accommodation under the ADA or applicable state or country laws and regulations must contact the InterSystems Human Resources Department prior to attending or participating in any interview or screening process.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Education

Select...
Select...
Select...
InterSystems Employment History *
Select...

Please indicate relationship to job location

Select...
Select...
Select...
Select...

At InterSystems, we take your privacy seriously.  Our Data Protection Information Notice outlines how we collect, use, and protect your information throughout the application process.  This includes:  

  • The types of personal data you provide,
  • How and why we process your data,
  • Who may access or receive your data,
  • Possible transfers of your data abroad (if at all),
  • How long we retain your data, and
  • Your right(s) regarding your data.

You can access our full Data Protection Notice here: https://www.intersystems.com/Privacy-Policy-Candidates/ for comprehensive details on these practices.

For questions about this Notice, you may contact us at DPO@InterSystems.com.

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in InterSystems’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 07/31/2029

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.