> Markdown version of [/jobs/ext/2256553-data-modeler](https://www.wearedevelopers.com/jobs/ext/2256553-data-modeler). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Modeler - **Company:** InterSystems - **Location:** Cambridge, MA, United States - **Experience:** Expert - **Salary:** $107,000.0 - $142,000.0 - **Contract:** Permanent contract - **Skills:** Query Performance, Data Analysis, Business Logic, Big Data, Databases, Customer Data Management, Data Architecture, Data Validation, Information Engineering, Data Governance, Data Integrity, Extract Transform Load (ETL), Data Mapping, Data Normalization, Data Security, Data Structures, Data Warehousing, Database Queries, Python (Programming Language), PostgreSQL, Software Tools, Standard Sql, Data Streaming, Systems Integration, Enterprise Data Management, Data Ingestion, Database Optimization, Data Lakes, Operational Systems, Physical Data Models, Intersystems, Legacy Systems - **Published:** August 26, 2026 - **Apply:** https://www.careerjet.com/job/us2b8246becd03be1b80a70488241a6d31/eaa ## About the Role 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., * 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 ## Description 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 * 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. * 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. * 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. * 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. * 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. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [DataForce Studio](https://www.wearedevelopers.com/videos/1657-dataforce-studio) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering)