Description
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
- 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.
Similar jobs
Est. 140,000 USD
Machinify is a leading healthcare intelligence company with expertise across the payment continuum, delivering unmatched value, transparency, and efficiency to health plan clients across the country. Deployed by over 85…
Est. 105,000 USD
About Judi Health Judi Health is a health technology company providing benefit administration solutions to employers, unions, health plans, and government entities. Judi Health replaces fragmented, outdated systems with…
We are a Canadian leader in digital automotive solutions. Our flagship brands -AutoTrader.ca, AutoSync, Dealertrack Canada and CMS - help Canadians buy, sell, and finance vehicles with confidence. AutoTrader.ca is Canada…
Why Choose Bottomline? Are you ready to transform the way businesses pay and get paid? Bottomline is a global leader in business payments and cash management, with over 35 years of experience and moving more than $16 tri…
Est. 124,000 USD
Vulcan Elements is manufacturing American rare-earth permanent magnets for a secure, resilient future. With a focus on national security and economic resiliency, we serve critical industries such as defense, aerospace, a…
Glance AI is an AI commerce platform shaping the next wave of e-commerce with inspiration-led shopping, less about searching for what you want and more about discovering who you could be. Operating in 140 countries, Glan…
Glance AI is an AI commerce platform shaping the next wave of e-commerce with inspiration-led shopping, less about searching for what you want and more about discovering who you could be. Operating in 140 countries, Glan…
Est. 250,000 USD
The Company: AvePoint is the Microsoft Cloud expert. Over 15,000 companies and 5 million cloud users trust AvePoint to accelerate the migration, management, and protection of their Office 365 and SharePoint data. AvePoin…
Est. 115,000 USD
Black Duck Software, Inc. helps organizations build secure, high-quality software, minimizing risks while maximizing speed and productivity. Black Duck, a recognized pioneer in application security, provides SAST, SCA, a…
About Rimes Rimes provides the Intelligence Fabric for Capital Markets, a trusted data network and intelligence architecture that transforms fragmented data, operations and workflows into decision-grade intelligence. The…
Software Engineer - III About the Role GHX is building a next-generation Intelligent Process Automation (IPA) platform powered by LLMs and AI-native document understanding. We extract structured data from complex healthc…
WPP is the trusted growth partner for the world’s leading brands. We unite cutting-edge media intelligence and data solutions, world-class creativity, next-generation production, transformative enterprise solutions and e…
Est. 120,000 USD
At NiCE, we don’t limit our challenges. We challenge our limits. Always. We’re ambitious. We’re game changers. And we play to win. We set the highest standards and execute beyond them. And if you’re like us, we can offer…
Est. 85,000 GBP
Why Sony Interactive Entertainment? Sony Interactive Entertainment isn’t just the Best Place to Play — it’s also the Best Place to Work. Sony Interactive Entertainment (SIE) is the company behind the PlayStation brand. A…
Est. 165,000 USD
At Wilson Elser, we are redefining what it means to work at a national law firm. With more than 1,400 attorneys across 46 offices nationwide, we are recognized among the top 100 law firms by The American Lawyer and ranke…
Est. 152,500 USD
About SRS Acquiom SRS Acquiom delivers the smartest way to run a deal™ through a platform and services designed to help deal parties manage complex M&A and loan agency transactions more efficiently. Based in Denver,…
About the Role At PubMatic, data operates at unmatched scale. As a Senior Machine Learning Platform Engineer, you will design and scale the infrastructure and frameworks that enable machine learning development, experime…
About Agoda At Agoda, we bridge the world through travel. Our story began in 2005, when two lifelong friends and entrepreneurs, driven by their passion for travel, launched Agoda to make it easier for everyone to explore…
Est. 120,000 USD
Why join CompuNet? CompuNet values its people more than any other asset—and realizes the contributions made by each employee are a reflection of their education, experience, certifications, expertise and passions. We str…
Black Duck Software, Inc. helps organizations build secure, high-quality software, minimizing risks while maximizing speed and productivity. Black Duck, a recognized pioneer in application security, provides SAST, SCA, a…
Sr. Security Engineer - IAM Truveta provides unprecedented real-world data and real-time intelligence, powered by a dataset built with and owned by US health systems united in a mission of Saving Lives with Data. Togethe…
At Anaplan, we are a team of innovators focused on optimizing business decision-making through our leading AI-infused scenario planning and analysis platform so our customers can outpace their competition and the market.…
Est. 115,000 USD
About Judi Health Judi Health is a health technology company providing benefit administration solutions to employers, unions, health plans, and government entities. Judi Health replaces fragmented, outdated systems with…
Est. 141,000 USD
Fanatics Commerce is the global leader in licensed sports merchandise, operating a vertically integrated platform that designs, manufactures, and delivers officially licensed apparel, jerseys, headwear, and collectibles…
Est. 120,000 USD
Role Purpose The Partner Manager, Technology Alliances is responsible for building and growing Diligent's technology ecosystem by identifying, developing, and managing strategic technology partnerships that enhance our p…
Est. 84,000 EUR
Here’s a summary of the role: You’re a hands‑on engineer who likes solving real problems at scale. You’ll design and build new features in a flagship SaaS product, modernise legacy systems, and shape the future architect…
Why Valtech? We’re the experience innovation company - a trusted partner to the world’s most recognized brands. To our people we offer growth opportunities, a values-driven culture, international careers and the chance t…
WPP is the trusted growth partner for the world’s leading brands. We unite cutting-edge media intelligence and data solutions, world-class creativity, next-generation production, transformative enterprise solutions and e…
About WPP Media WPP is the trusted growth partner for the world’s leading brands. With exceptional talent, trusted data and intelligence, and world-class partnerships – all united by our pioneering agentic marketing plat…
Est. 120,000 GBP
About Baringa Baringa is a global consulting firm that partners with leaders to drive change and create value. With deep industry expertise, and enabled by advanced technology, the firm helps clients to deliver with grea…