Data Modeler
Core
Lead Data Modeler owning the design, governance, and evolution of the data warehouse and data lake, translating fragmented legacy systems into a unified, scalable data model.
Role type
Senior Lead Data Modeler
Builds
Unified data models, schemas, views, and data governance frameworks for analytics and operational workflows
Domain
Enterprise Data Management / Data Warehousing
Deliverable
production ML models | product features
Required skills
Data modeling (conceptual, logical, physical), SQL, source-to-target mapping, data normalization/denormalization, schema design, ETL/ELT process definition, data quality governance, database administration
Preferred skills
CRM data platforms, InterSystems IRIS, Python for data analysis, AI tools for data mapping
Technologies
SQL, IRIS, PostgreSQL, ETL/ELT tools
Responsibilities
Design and maintain conceptual, logical, and physical data models; define canonical data definitions and business logic; establish modeling standards and documentation; analyze legacy datasets and define source-to-target mappings; resolve data discrepancies and validate data integrity; optimize warehouse schemas and query performance; manage user access and data security; partner with stakeholders to clarify data requirements; contribute to enterprise data architecture strategy
Seniority
Senior, hands-on IC with leadership responsibilities
