Hiring: Lead Data Modeler Company: InterSystems Location: Boston, MA Job Posted Time: 2026-09-16 13:09:33 Target Skills & Keywords : Data Lake, Data Warehouse, ELT, ETL, PostgreSQL, Python, SQL About the job Experience: •5+ years of experience in data modeling, data architecture, or related roles. Required Skills: •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. •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. Qualifications: •Strong SQL skills with the ability to independently analyze complex datasets. •In-depth knowledge of data normalization, denormalization, and schema design trade-offs. •Demonstrated capacity to work with ambiguous, messy legacy data and derive structured solutions. •Strong attention to detail and commitment to data accuracy and consistency. •Operational familiarity with InterSystems IRIS or similar enterprise data platforms. •Proficiency in Python for data analysis or validation workflows. •Strong communication skills with the ability to work across technical and business teams Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!