Senior Data Modeler

Teradata
Concord, NH, United States
1 day ago
Apply on www.techcareers.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Compensation
$127,000.0
Working hours
Regular working hours

Tech stack

3d Models Adaptable Database Systems Artificial Intelligence Amazon Web Services Data Analysis Microsoft Azure BigQuery Information Systems Databases Data Architecture Data Governance Data Infrastructure
+49 more
Data Integration Data Structures Data Vault Modeling Database Design Dimensional Modeling Graph Database Information Model Knowledge Management Knowledge-Based Systems PostgreSQL Machine Learning Meta-Data Management Metadata Repositories Microsoft Visio Microsoft SQL Server MongoDB MySQL Neo4j Oracle (Applications) PowerDesigner Reference Data Lucidchart Data Mesh Standard Sql SAP (Applications) Search Technologies Teradata SQL Enterprise Data Management Google Cloud Cloud Platform System Azure Data Factory Retrieval-Augmented Generation Snowflake Data Strategy Data Layers Data Lakes Information Technology Collibra AWS Data Analytics Cosmos DB Operational Systems Data Management Physical Data Models Semantic Modeling Domain Driven Design Azure Synapse Analytics Automation Anywhere Amazon Redshift Databricks

Job description

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.

Requirements

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

This role is best suited for a senior practitioner who can operate as both a hands-on data modeler and a strategic information architect, helping shape the enterprise data foundation for analytics, AI, and knowledge-driven innovation.

Benefits & conditions

Pay Rate: 101600.0000 - 127,000.00 - 152500.0000 Annually

Starting pay for the successful applicant will depend on geographic location, internal equity, job-related knowledge, skills, and candidate experience. Sales roles will be eligible for commission payments tied to quota achievement. All other permanent roles will be eligible for one of our annual incentive plans, which are based on company financial attainment and individual performance. Employees in this position are eligible to participate in the Company’s benefits programs, which generally include health care, life and disability insurance, retirement savings, and time-off programs. Benefit details vary by country and plan, including eligibility and available options, and will be shared during the hiring process. Additional information is available here: https://www.teradata.com/About-Us/Careers/Benefits

Employees in this position are also eligible to participate in the Company’s comprehensive benefits programs, which include healthcare, life and disability insurance plans, a 401(k)-retirement savings plan, and time-off programs. Specific details of these benefits, including eligibility criteria and plan options, will be provided during the hiring process and can be reviewed here: https://www.teradata.com/About-Us/Careers/Benefits

About the 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.techcareers.com
Prepare application

Good distractions

Loading talks and stories from around this role…