Senior Data Modeler

As a Senior Data Modeler, you design the logical and physical data structures that underpin an organization's databases, data warehouses, and analytical systems. You create entity-relationship diagrams, define dimensional models, establish naming conventions, and ensure that data structures serve both operational and analytical needs. The senior title means you're setting data modeling standards and advising on enterprise data architecture.

Your work is foundational and high-stakes. A poor data model creates years of downstream problems — inefficient queries, duplicate data, reporting inconsistencies, and costly rework. Your day might involve designing a dimensional model for a new business domain, reviewing a developer's database schema changes, resolving conflicting definitions of the same business entity across systems, or documenting data lineage.

The challenge is designing for competing needs. Operational systems want normalized models for fast writes; analytical systems want denormalized models for fast reads. Business stakeholders want flexibility to ask new questions; DBAs want performance and stability. You're the translator between business concepts and technical structures, and every design decision involves trade-offs.