Senior Data Modeler

Teradata; San Diego (CA); Hybrid; USD 140,000 - 210,000; Full time

Job summary

Teradata seeks a highly experienced Senior Data Modeler to lead enterprise-scale data modeling across domains including analytics, AI, and knowledge platforms. This role emphasizes scalable conceptual, logical, and physical models and collaboration with engineering, analytics, governance, and AI teams.

You will establish modeling standards, ensure scalability, interoperability, and AI readiness for Context Engine and related platforms.

Qualifications

• Bachelor's/Master's in CS, IS, Data Management, Math, Engineering or related field.
• 8+ years in data modeling, information architecture or enterprise data architecture.
• Hands-on experience creating conceptual, logical and physical data models for large-scale environments.
• Deep understanding of relational modeling, normalization, dimensional and analytical schema design.
• Experience modeling enterprise-wide domains and integrating data across complex systems.
• Strong SQL and database design expertise.
• Experience with cloud-based data platforms and modern data architectures.
• Ability to bridge business and technical stakeholders.

Responsibilities

• Design and maintain enterprise conceptual, logical, and physical data models across domains.
• Create scalable models for transactional, operational, analytics, ML, and AI workloads.
• Develop canonical data models, business information models and semantic layers.
• Drive standardization of entities, relationships, taxonomies, hierarchies and definitions.
• Define and enforce data modeling best practices and architecture standards.
• Model data for modern cloud data platforms and real-time architectures.
• Collaborate with data engineers to implement various modeling approaches.
• Support data product development and data mesh architectures.
• Design models supporting analytics, AI, ML, RAG and knowledge systems.
• Build semantic representations to improve discoverability and reuse.
• Contribute to enterprise ontology, taxonomy, and knowledge graphs.

Skills

Conceptual Modeling

Logical Modeling

Physical Modeling

Dimensional Modeling

Data Vault Modeling

Domain‑Driven Design

Semantic Modeling

SQL

Cloud Data Platforms

Enterprise Architecture

Education

Bachelor's degree in Computer Science / Information Systems / Data Management / Mathematics / Engineering

Master's degree in related field

Tools

Erwin

ER/Studio

SaaP PowerDesigner

Lucidchart

Visio

Collibra

Alation

Informatica

Microsoft Purview

Job description

Our Company

At Teradata, we believe that people thrive when empowered with better information. Teradata Autonomous Knowledge Platform activates enterprise intelligence by unifying data, knowledge and business context to achieve tangible outcomes. With Teradata, organizations can provide agents with full context for impact when it matters. Our solution lets businesses connect and scale on premises, in the cloud, or through a hybrid approach. Teradata delivers real business value with AI.

Our Company

At Teradata, we believe that people thrive when empowered with better information. Teradata Autonomous Knowledge Platform activates enterprise intelligence by unifying data, knowledge and business context to achieve tangible outcomes. With Teradata, organizations can provide agents with full context for impact when it matters. Our solution lets businesses connect and scale on premises, in the cloud, or through a hybrid approach. Teradata delivers real business value with AI.

What You’ll Do

We are seeking a highly experienced and hands‑on Senior Data Modeler to lead the design and evolution of enterprise‑scale data models that power analytics, AI, knowledge discovery, operational systems, and next‑generation data and knowledge platforms across multiple domains. This role is ideal for a technically deep practitioner who excels at translating complex business domains into scalable, high‑quality conceptual, logical, and physical data models. The successful candidate will have extensive experience modeling large‑scale enterprise data assets across structured, semi‑structured, and graph‑oriented environments while partnering closely with engineering, architecture, analytics, governance, and AI teams.

You will be responsible for establishing data modeling standards, driving enterprise‑wide consistency, and ensuring that data is organized for scalability, interoperability, discoverability, governance, and AI readiness for Teradata Context Engine, our Autonomous Knowledge Platform. Context Engine is a platform that converts enterprise data estates into governed, agent‑ready knowledge. Built for organizations where AI reliability and auditability are non‑negotiable, Context Engine enables companies to deploy AI workflows on the data they already own — without rebuilding their infrastructure, without retraining their models, and without waiting for generic AI synthesis to learn the business terminology that took their analysts years to master.

Responsibilities

Data Architecture & Modeling

• Design and maintain enterprise conceptual, logical, and physical data models across multiple business domains.
• Create scalable data models supporting transactional systems, operational platforms, analytics, machine learning, and AI workloads.
• Develop canonical data models, business information models, and semantic layers that enable consistent enterprise understanding of data.
• Drive standardization of entities, relationships, taxonomies, hierarchies, and business definitions across the organization.
• Define and enforce data modeling best practices, naming conventions, modeling patterns, and architecture standards.

Enterprise Data Platform

• Model data for modern cloud data platforms, data lakes, lakehouses, warehouses, and real‑time streaming architectures.
• Design data structures optimized for performance, scalability, governance, and consumption.
• Collaborate with data engineers to implement dimensional, normalized, denormalized, and domain‑oriented data models.
• Support data product development initiatives and data mesh architectures.

AI, Analytics & Knowledge Systems

• Design models that support advanced analytics, AI, machine learning, RAG applications, semantic search, and knowledge management platforms.
• Build and maintain business‑friendly semantic representations that improve discoverability and reuse.
• Contribute to enterprise ontology, taxonomy, and knowledge graph initiatives where applicable.

Governance & Quality

• Partner with data governance teams to align models with data quality, stewardship, privacy, security, and compliance requirements.
• Establish traceability between business definitions, metadata, source systems, and downstream data assets.
• Ensure model consistency across operational, analytical, and AI ecosystems.
• Support master data management (MDM) and reference data initiatives.

Collaboration & Leadership

• Work directly with business stakeholders to understand complex processes and translate them into enterprise information models.
• Mentor junior modelers, architects, and engineers on data modeling principles and best practices.
• Lead architecture reviews and influence long‑term data strategy.
• Drive cross‑functional alignment across product, engineering, analytics, governance, and architecture organizations.

Who You’ll Work With

Partner with AI and data science teams to model features, training datasets, metadata, lineage, and business context.

Required Qualifications

What Makes You a Qualified Candidate

• Bachelor's or Master's degree in Computer Science, Information Systems, Data Management, Mathematics, Engineering, or related field.
• 8+ years of experience in data modeling, information architecture, or enterprise data architecture.
• Demonstrated hands‑on expertise creating conceptual, logical, and physical data models for large‑scale enterprise environments.
• Deep understanding of relational modeling theory, normalization, dimensional modeling, and analytical schema design.
• Experience modeling enterprise‑wide business domains and integrating data across complex systems.
• Strong SQL and database design expertise.
• Experience working with cloud‑based data platforms and modern data architectures.
• Proven ability to bridge business and technical stakeholders.

Preferred Qualifications

• Experience with cloud ecosystems such as Azure, AWS, or Google Cloud.
• Experience with Databricks, Snowflake, Synapse, BigQuery, Redshift, or similar platforms.
• Knowledge of Data Vault, Kimball, Inmon, data mesh, and domain‑driven design methodologies.
• Experience with metadata management, data catalogs, and lineage platforms.
• Exposure to graph databases, semantic technologies, ontologies, RDF, or knowledge graphs.
• Understanding of AI/ML data requirements and semantic modeling for generative AI applications.
• Experience supporting enterprise governance and master data management programs.

Technical Skills

Data Modeling & Architecture

• Conceptual, Logical, and Physical Data Modeling
• Enterprise Information Modeling
• Dimensional Modeling (Star/Snowflake)
• Data Vault Modeling
• Master & Reference Data Modeling
• Canonical Data Models
• Domain‑Driven Design
• Semantic Data Modeling

Data Platforms

• Azure Data Platform
• Snowflake
• Databricks
• Synapse Analytics
• AWS Data Services
• Google Cloud Data Platform

Databases

• SQL Server
• PostgreSQL
• Oracle
• MySQL
• MongoDB
• Snowflake
• Graph Databases (Neo4j, Neptune, Cosmos DB Graph)

Tools

• Erwin
• ER/Studio
• SAP PowerDesigner
• Lucidchart
• Visio
• Collibra
• Alation
• Informatica
• Microsoft Purview

What You’ll Bring

• Deep hands‑on modeling expertise with enterprise‑scale architecture thinking.
• Strong business domain abstraction skills and technical implementation ability.
• Experience designing data foundations that support analytics, governance, AI, and knowledge management.
• Ability to influence enterprise standards while remaining close to implementation details.
• Passion for creating reusable, understandable, and scalable information structures that become strategic organizational assets.

Why We Think You’ll Love Teradata

We prioritize a people‑first culture because we know our people are at the very heart of our success. We embrace a flexible work model because we trust our people to make decisions about how, when, and where they work. We focus on well‑being because we care about our people and their ability to thrive both personally and professionally. We are committed to actively working to foster an inclusive environment that celebrates people for all of who they are

Why We Think You’ll Love Teradata

We prioritize a people‑first culture because we know our people are at the very heart of our success. We embrace a flexible work model because we trust our people to make decisions about how, when, and where they work. We focus on well‑being because we care about our people and their ability to thrive both personally and professionally. We are an anti‑racist company because our dedication to Diversity, Equity, and Inclusion is more than a statement. It is a deep commitment to doing the work to foster an equitable environment that celebrates people for all of who they are. Teradata invites all identities and backgrounds in the workplace. We work with deliberation and intent to ensure we are cultivating collaboration and inclusivity across our global organization. We are proud to be an equal opportunity and affirmative action employer. We do not discriminate based upon race, color, ancestry, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related conditions), national origin, sexual orientation, age, citizenship, marital status, disability, medical condition, genetic information, gender identity or expression, military and veteran status, or any other legally protected status.