Senior Data Modeler for Enterprise AI and Knowledge

Teradata; Augusta (ME); On-site; USD 102,000 - 153,000; Full time

Benefits offered by this job

Flexible work model

Inclusive culture

Comprehensive benefits

Job summary

Teradata seeks a Senior Data Modeler to lead the design of enterprise-scale data models powering analytics, AI, and knowledge platforms across multiple domains.

You will translate complex business domains into conceptual, logical, and physical models, collaborating with engineering, governance, and AI teams to ensure scalable, governed data assets and reusable semantic representations for enterprise insights.

Qualifications

• 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.

Responsibilities

• 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.
• 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.
• 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.
• 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.
• 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.

Skills

Strong SQL

Database design

Enterprise data modeling

Cloud data platforms

Bridge business & tech

Education

Bachelor's or Master's degree in Computer Science or related

Tools

Erwin

ER/Studio

PowerDesigner

Collibra

Alation

Informatica

Microsoft Purview

Snowflake

Databricks

Job description

Teradata seeks a Senior Data Modeler to lead the design of enterprise-scale data models powering analytics, AI, and knowledge platforms across multiple domains.

You will translate complex business domains into conceptual, logical, and physical models, collaborating with engineering, governance, and AI teams to ensure scalable, governed data assets and reusable semantic representations for enterprise insights.