Mid-Level

Data Modeler

You design the blueprint for how organizations store, organize, and relate their data. By creating logical and physical data models, you ensure that databases are structured in ways that make data accessible, consistent, and useful โ€” so analysts, developers, and systems can actually find and trust what they need.

Career Level
Junior
Mid
Senior
Director
VP
Executive
Work Personality
I
C
R
A
E
S
Investigativeanalytical, curious
Conventionalorganizing, detail-oriented
Based on Holland Code framework
Job markets for Data Modelers
Employment concentration ยท ~400 areas
Based on employment in related occupations
Mapped SOC categories:
BLS Occupational Employment Statistics
What it's like

What it's like to be a Data Modeler

Your day often involves working between business requirements and technical implementation. You might spend the morning meeting with business stakeholders to understand what data they need and how they use it, then translate that into entity-relationship diagrams, dimensional models, or schema designs. You're thinking about normalization, naming conventions, relationships, and data types โ€” the architectural decisions that determine whether a database is easy or painful to work with.

Collaboration with both business and technical teams is constant. You work closely with database administrators who implement your designs, ETL developers who populate them, and analysts who query them. Data governance discussions โ€” who owns data, what definitions mean, how quality is maintained โ€” often pull you into cross-functional conversations. You're frequently the person who surfaces inconsistencies in how different teams define the same business concept.

People who tend to thrive here are logical thinkers who enjoy creating structure from chaos. If you get satisfaction from designing an elegant schema that makes complex data relationships clear and queryable, the work is deeply satisfying. If you prefer working with data directly โ€” running analyses and building reports โ€” the meta-level nature of modeling (designing how data is stored rather than using it) may feel too abstract.

AchievementAbove avg
IndependenceAbove avg
Working ConditionsAbove avg
RecognitionModerate
RelationshipsLower
SupportLower
O*NET Work Values survey
StrategyExecution
InfluencingDirected
StructuredAdaptable
ManagingContributing
CollaborativeIndependent
Data warehouse vs operationalModeling methodologyTool stackData governance maturityCloud vs on-premise
Data modeling varies significantly by context. In **data warehouse and analytics environments**, you're typically building dimensional models (star/snowflake schemas) optimized for querying and reporting. In operational contexts, you're designing normalized models that support application transactions. The tooling differs too โ€” some teams use **dedicated modeling tools** (Erwin, PowerDesigner, dbt) while others work directly in SQL or cloud-native platforms. Organizations with mature data governance programs tend to give modelers more influence and resources, while less mature organizations may expect you to handle modeling alongside other data engineering tasks.

Is Data Modeler right for you?

An honest look at who tends to thrive in this role โ€” and who might find it challenging.

This role tends to work well for...
Logical thinkers who enjoy designing structure
Data modeling is fundamentally about creating order โ€” defining entities, relationships, and rules that make data usable. If you enjoy designing systems of organization, this is the pure form of that skill.
People who bridge business and technical worlds
You need to understand business concepts well enough to model them accurately and technical constraints well enough to make the model implementable. This hybrid thinking is the core of the role.
Detail-oriented perfectionists (in a good way)
A poorly named column or misunderstood relationship can cause months of downstream confusion. If you naturally care about getting details right, that precision directly improves data quality.
Those who enjoy standards and consistency
Enforcing naming conventions, data types, and modeling patterns across an organization requires someone who values consistency. If that sounds satisfying rather than tedious, you'll fit.
This role tends to create friction for...
People who prefer working directly with data and insights
Data modeling is meta-work โ€” you're designing how data is stored, not analyzing it. If you want to answer business questions directly, the abstraction layer can feel removed from impact.
Those who need fast, visible results
Data models evolve slowly and their impact is indirect. If you need to see immediate results from your work, the slow feedback loop can be frustrating.
People who dislike detailed documentation
Model documentation, data dictionaries, and metadata management are core deliverables. If thorough documentation feels tedious, a large portion of the work won't appeal.
Those who avoid organizational politics
Data definitions and ownership are surprisingly political. If navigating disagreements about what terms mean and who owns data sounds unpleasant, that's a regular part of the job.
โœฆ Editorial โ€” written by Truest from industry research and career patterns
Career Paths

Where this role sits in the broader career landscape โ€” and where it can take you.

$239K$179K$119K$60K$0KLower paying387 metro areas, sorted by salary level
All experience levels1
This level's estimated range
INDUSTRIES PAYING ABOVE AVERAGE
1 BLS OEWS May 2024 covers all Data Modelers (SOC 15-1243.00, 15-1253.00, 15-2041.00, 15-2051.00), not just this title ยท BEA RPP 2023
* Top salaries exceed this figure. BLS caps reported wages at ~$240K to protect individual privacy in high-earning roles.
Exploring the Data Modeler career path? Truest helps you figure out if it's the right fit โ€” and plan your path forward.
Explore career tools
1
Cloud data platforms
Understanding Snowflake, BigQuery, Redshift, and cloud-native modeling patterns is increasingly essential as organizations migrate
2
Data governance
Moving from modeling to governing โ€” setting policies, standards, and stewardship programs โ€” is the path to senior and leadership roles
3
dbt and analytics engineering
The rise of analytics engineering and transformation-layer tools creates new opportunities for modelers who understand modern data stacks
4
Business domain expertise
Deep understanding of a specific domain (finance, healthcare, retail) makes your models more accurate and your career more specialized
What types of data models is the team building โ€” operational, analytical, or both?
What modeling tools and methodologies does the team use?
How mature is the organization's data governance program?
How does the modeling team collaborate with data engineering and analytics?
What's the biggest data modeling challenge the team is working on right now?
โœฆ Editorial โ€” career progression and interview guidance based on industry patterns
The Broader Landscape

Roles like this one sit within a broader occupational category. The numbers below reflect that full landscape โ€” helpful for context, but your specific experience will depend on level, specialty, and where you work.

$60Kโ€“$210K
Salary Range
10th โ€“ 90th percentile
528K
U.S. Employment
+15.18%
10yr Growth
43K
Annual Openings

How this category is changing

$80K$77K$74K$71K$68K201920202021202220232024$68K$80K
BLS OEWS May 2024 ยท BLS Employment Projections 2024โ€“2034

Skills & Requirements

MathematicsReading ComprehensionCritical ThinkingReading ComprehensionActive ListeningJudgment and Decision MakingActive ListeningComplex Problem SolvingCritical ThinkingReading Comprehension
O*NET OnLine ยท Bureau of Labor Statistics
15-1243.0015-1253.0015-2041.0015-2051.00

Navigate your career with clarity

Truest gives you tools to understand your strengths, explore roles that fit, and plan your next move.

Explore Truest career tools
Federal data: BLS Occupational Employment & Wage Statistics (May 2024) ยท BLS Employment Projections ยท O*NET OnLine
Truest editorial: Fit check, role profile, things that vary, advancement analysis, lateral moves, interview questions.