Data Modeler
$55 - $62 per hourNTT Data Americas, Inc.
NTT DATA's Client is seeking an experienced Data Modeler to design, develop, and maintain scalable enterprise data models supporting analytics, reporting, operational applications, data warehousing, and data integration initiatives.
The Data Modeler will collaborate closely with business stakeholders, Data Architects, Data Engineers, analysts, application teams, and governance teams to translate complex business requirements into well-defined conceptual, logical, and physical data models.
The ideal candidate will have strong hands-on experience in enterprise data modeling, relational and dimensional modeling, data warehousing, cloud data platforms, metadata management, and data governance. The role requires the ability to establish consistent data definitions, relationships, standards, and modeling practices across multiple business domains and technology platforms.
Key Responsibilities
Enterprise Data Modeling
Design, develop, and maintain conceptual, logical, and physical data models for enterprise data platforms, analytics solutions, and business applications.
Translate complex business requirements, business processes, and data requirements into scalable and reusable data structures.
Develop and maintain:
Relational data models
Dimensional data models
Star schemas
Snowflake schemas
Domain-oriented data models
Define entities, attributes, relationships, primary keys, foreign keys, business keys, hierarchies, and reference-data structures.
Design models that appropriately support transactional, analytical, historical, and reporting requirements.
Perform model normalization and denormalization based on application, integration, analytics, and performance requirements.
Data Warehousing & Analytics Modeling
Design dimensional models for enterprise data warehouses, data marts, and modern analytics platforms.
Define facts, dimensions, measures, hierarchies, and grain based on business and analytical requirements.
Design appropriate approaches for maintaining historical information, including Slowly Changing Dimensions (SCDs).
Ensure models support reporting, BI, advanced analytics, and downstream data-consumption requirements.
Partner with Data Engineers to ensure models can be effectively implemented within ETL/ELT and data-processing pipelines.
Data Standards & Governance
Define and enforce enterprise data-modeling standards, naming conventions, data types, and modeling best practices.
Partner with business and technical stakeholders to establish consistent definitions for critical business data.
Support master data, reference data, metadata management, and data-governance initiatives.
Identify authoritative data sources and help establish consistent definitions and relationships across enterprise systems.
Contribute to the development and maintenance of business glossaries and data dictionaries.
Participate in architecture and model design reviews to ensure proposed solutions comply with enterprise architecture and governance standards.
Metadata, Lineage & Documentation
Maintain comprehensive documentation for conceptual, logical, and physical data models.
Document:
Business definitions
Data entities and attributes
Source-to-target relationships
Data lineage
Business rules
Data ownership
Transformation requirements
Maintain model metadata using enterprise modeling and/or data-cataloging platforms.
Ensure appropriate traceability between business requirements, source systems, data models, transformation logic, and downstream consumption.
Data Quality & Integrity
Contribute to data-quality frameworks by identifying:
Mandatory and optional data elements
Valid relationships
Referential-integrity requirements
Data constraints
Validation rules
Business rules
Work with Data Engineering and Data Governance teams to identify and resolve data-quality and consistency issues.
Ensure models appropriately support auditability, historical tracking, lineage, and data traceability.
Identify data redundancies, inconsistencies, and opportunities for standardization and reuse.
Required Skills & Experience
12+ years of experience in data management, data architecture, data warehousing, or related disciplines, with significant hands-on data-modeling experience.
7+ years of strong experience developing conceptual, logical, and physical data models.
Deep understanding of:
Relational data modeling
Dimensional modeling
Star and snowflake schemas
Normalization and denormalization
Entity-relationship modeling
Data warehousing concepts
Strong understanding of facts, dimensions, hierarchies, grain, surrogate keys, business keys, and Slowly Changing Dimensions.
Strong experience defining entities, attributes, relationships, cardinality, primary/foreign keys, and referential-integrity rules.
Experience translating complex business requirements into enterprise data structures and models.
Strong knowledge of SQL and relational database concepts.
Experience with modern cloud data platforms, data lakes, data warehouses, or lakehouse architectures.
Understanding of ETL/ELT processes and data-integration patterns.
Experience with metadata management, data lineage, data dictionaries, and business glossaries.
Good understanding of Master Data Management (MDM), reference data, data quality, and data governance.
Experience working with enterprise architecture, Data Engineering, analytics, and application-development teams.
Data Modeling Tools
Hands-on experience with one or more enterprise data-modeling tools such as:
ER/Studio
ERwin Data Modeler
SAP PowerDesigner
Visio
Lucidchart
Or equivalent enterprise modeling platforms
Cloud & Technology Experience
Experience with one or more modern data platforms is preferred, including:
Snowflake
Databricks
Microsoft Azure / Azure Synapse
AWS data services
Google Cloud Platform / BigQuery
SQL Server
Oracle
PostgreSQL or other enterprise relational databases
Exposure to modern architectures such as data lakehouse, data mesh, domain-oriented data architecture, and cloud-native analytics platforms is an advantage.
Preferred Qualifications
Experience supporting large-scale enterprise data-transformation or modernization programs.
Experience modeling data across multiple business domains and source systems.
Experience working in complex environments involving both operational and analytical data.
Knowledge of data cataloging and governance platforms such as Collibra, Alation, Microsoft Purview, or equivalent tools.
Understanding of data privacy, security, retention, and regulatory requirements.
Experience working in Healthcare, Life Sciences, Pharmaceutical, or other regulated industries is preferred.
Familiarity with Agile delivery methodologies and enterprise architecture frameworks.
Key Competencies
Strong analytical and problem-solving skills.
Ability to understand complex business processes and translate them into structured data models.
Strong attention to detail and commitment to data consistency and quality.
Ability to communicate data concepts effectively to both technical and non-technical stakeholders.
Strong collaboration skills across business, architecture, engineering, governance, and analytics teams.
Ability to independently lead data-modeling discussions and design reviews.
Ideal Candidate Profile
The ideal candidate is a hands-on enterprise Data Modeler, rather than primarily a Data Engineer or BI Developer, who can demonstrate substantial experience creating and governing conceptual, logical, and physical models.
Candidates should be able to provide concrete examples of enterprise data models they have designed, explain their approach to relational versus dimensional modeling, and demonstrate strong knowledge of data warehousing, SCDs, metadata, lineage, governance, and modern cloud data architectures.
For more than 25 years, NTT DATA Services have focused on impacting the core of your business operations with industry-leading outsourcing services and automation. With our industry-specific platforms, we deliver continuous value addition, and innovation that will improve your business outcomes. Outsourcing is not just a method of gaining a one-time cost advantage, but an effective strategy for gaining and maintaining competitive advantages when executed as part of an overall sourcing strategy.
About NTT DATA Services:
NTT DATA Services is a recognized leader in IT and business services, including cloud, data and applications, headquartered in Texas. As part of NTT DATA, a $30 billion trusted global innovator with a combined global reach of over 80 countries, we help clients transform through business and technology consulting, industry and digital solutions, applications development and management, managed edge-to-cloud infrastructure services, BPO, systems integration and global data centers. We are committed to our clients' long-term success. Visit nttdata.com or LinkedIn to learn more.
NTT DATA Services is an equal opportunity employer and considers all applicants without regarding to race, color, religion, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, genetic information, physical or mental disability, veteran or marital status, or any other characteristic protected by law. We are committed to creating a diverse and inclusive environment for all employees. If you need assistance or an accommodation due to a disability, please inform your recruiter so that we may connect you with the appropriate team.
NTT DATA provides a reasonable range of compensation for U.S.-based positions. The starting pay range for this remote role is 55$/hr - 62$/hr . This range reflects the minimum and maximum target compensation for the position across all US locations. Actual compensation will depend on a number of factors, including the candidate's actual work location, relevant experience, technical skills, and other qualifications.
This position is eligible for company benefits including participation in medical, dental, and vision insurance, flexible spending or health savings account, and AD&D insurance, employee assistance, participation in a 401k program, and additional voluntary or legally-required benefits
This position is eligible for company benefits that will depend on the nature of the role offered. Company benefits may include medical, dental, and vision insurance, flexible spending or health savings account, life, and AD&D insurance, short-and long-term disability coverage, paid time off, employee assistance, participation in a 401k program with company match, and additional voluntary or legally required benefits.
$132.23k - $176.31k
...the trusted network for the AI‑powered world, connecting people, data, and applications through our expansive fiber network and... ...and AI-driven use cases. Establish platform standards for data modeling, ingestion, orchestration, observability, testing, security, and...SuggestedFull timeTemporary work$20.91 - $45.04 per hour
...and sensor solutions enable the distribution of power, signal and data to advance next-generation transportation, renewable energy,... ...expansion opportunities across categories and regions Build models to evaluate SKU productivity, velocity, and whitespace opportunities...SuggestedRemote jobWork experience placementSummer workInternshipLocal area- ...Role : Data Architect Location :Pittsburgh, PA or Strongsville, OH FTE Job Description Must Have Technical... ...~12-15 years of experience in data architecture, data modeling, or related roles. ~ Strong expertise in data modeling techniques...Suggested
- Job-ID: 22400Category: Data ManagementLocation: Pittsburgh, Pennsylvania, United StatesWorkplace: HybridPosted: 2026-11-11Job Role: Data... ...deep expertise in Apache Iceberg, metadata management, data modeling, ingestion frameworks, and large-scale migration strategies.Key...Suggested
- ...York, NY, United StatesSchedule: Full timePosted: 2026-09-02Title: Data ArchitectReports To: Director - Data EngineeringLocation:... ...Design and implement scalable data architecture, pipelines, and modeling strategies that power our enterprise data warehouse on GCP (BigQuery...SuggestedFull timePart timeSummer workCasual workLocal areaImmediate start
$120.8k - $181.2k
OverviewMcGuireWoods LLP is seeking a Data Architect to join our IT team. The Data Architect is responsible for the design and technical... ...integration issues.Establishes and applies appropriate data modeling, transformation, integration, performance, security, and data quality...Remote work- ...speed-to-market. We embrace cloud technologies, digitization, data assimilation, machine learning, artificial intelligence, IoT, interpreted... ...: Senior-level Functions: Data Architecture, Data Modeling, Data Integration, Data Governance, Technology Consulting Industries...Full timeShift work
- ...Job Title: Senior Data Analyst Location: Pittsburgh, PA Job type: Contract We Look for Either Data Architects or Very Senior... ...Data Analyst We need someone well experienced in data modeling fact dimension. This would be the only Data Analyst on the FNB Data...Contract work
- ...Job Title- Senior Data Architect Duration: 9 Months (initial budget through July 2026) - potential for conversion if candidate... ...architecture, including conceptual, logical, and physical data models. Collaborate on design using various data architectures...
$107.66k - $161.7k
...place to chat, explore and build with a wide variety of AI language models (bots), including o3, o4-mini, Claude 3.7 Sonnet, GPT Image 1... ...-end ownership of Machine Learning systems -- from prototyping, data pipelines and training, to realtime LLM application at scale...Remote jobFull timeWork experience placementInternship$104.8k - $149.3k
...toolsProven experience implementing Oracle 19c GRID/RAC architecture on RedHat Enterprise LinuxProficiency in SSH/KSH/BASH scriptingAdvanced Data Guard expertise (switchover and debugging)Experience with cloud environment technologies, preferably AWS, OCIKnowledge of Oracle...For contractorsWork experience placementWork at officeLocal areaWorldwideRelocation package- ...foundational problems executing on a high throughput system with dynamic data. About the Job: Design, develop, and deploy machine... ...by continually refining and advancing our algorithms and models. About You: Minimum Qualifications: Have a graduate degree...Permanent employmentFull timeWork at officeRemote workWork from homeFlexible hours
- ...Digital Core, Finance, Industry and Enterprise, Song, Supply Chain and Engineering, and Talent, with advanced capabilities in AI and Data, Industry and Process, and Technology. We serve approximately 9,000 clients and generated approximately $74 billion in FY26 revenue....Work experience placementLive inWork at officeLocal area
- ...Senior Data Governance Analyst A Senior Data Governance Analyst is a key member of the Data Governance Program at Northwest Bank... ...governance framework including the management of data, operating model, data policies and standards as well as the application of clearly...Casual workWork at officeShift work
- ...requirements, service quality, security, operability, and systems-management requirements. ~ Use appropriate tools , including models of components and interfaces, to develop complex architectures and translate requirements into detailed solution designs for...Full timeRemote work
- Job ID: SRJ_6866Location: Pittsburgh, PAEmployment Type: 1099, C2C, W-2Company: SRI Tech SolutionsRole: Collibra Data AnalystLocation: Pittsburgh, PA (Day 1 Onsite) Job Description: Must Have -Collibra Data Governance, Data analysis, SQL KnowledgeGood to have - Banking...
- ...Cleveland, OH / Pittsburgh, PA (Day 1 Onsite)Note - Pls submit only visa independent candidatesEmployment Type - FTEJob Description:Data Analyst + KafkaWe are seeking a highly skilled Big Data Analyst to join our data-driven team. The ideal candidate will be responsible...
- We are looking for a Data Analyst to support fraud-focused data initiatives in Pittsburgh, Pennsylvania. This Long-term Contract position is ideal for someone who can turn complex information into clear insights that help identify suspicious activity and strengthen anti...Long term contract
- ...Cleveland, OH / Pittsburgh, PA (Day 1 Onsite)Note - Pls submit only visa independent candidatesEmployment Type - FTEJob Description:Data Analysis & Insights: Conducted in-depth analysis of large datasets to identify trends, patterns, and actionable insights, driving data...
$124k - $280k
...ManagerJob Description & SummaryThe Opportunity As a Applied AI Health Data Architect you will shape data architecture solutions that... ...across AWS, Azure, Databricks, and Snowflake - Developing data models, warehouse structures, and transformation logic that support analytics...Full timeH1b- ...people, shareholders, partners, and communities.You Are:A senior data architecture leader with deep experience in enterprise data... ...enterprise data architecture standards, principles, governance models, and architecture review practices for major ALIP data initiatives...Work experience placementLive inWork at officeLocal area
- ...and Engineering, and Talent, with advanced capabilities in AI and Data, Industry and Process, and Technology. We serve approximately 9,... ...— own end-to-end design of Data 360 solutions including data model, ingestion strategy, identity resolution, unified profiles, segmentation...Work experience placementLive inWork at officeLocal area
$128.6k - $192.9k
Stantec’s Buildings team is on a mission to become the world’s leading integrated design practice. Our architects, engineers, interior designers, consultants, sustainability specialists, and technologists are passionate about the power of design. Our collaborative culture...Full timeContract workTemporary workPart timeFor contractorsCasual workWork at officeLocal areaFlexible hours$134.5k - $265.1k
...practice helps organizations build deeper customer relationships and drive sustained growth through customer and commercial strategy, data and analytics, Generative AI, digital products, marketing, commerce, sales, and service. As a Lead Business Transformation Architect...Local areaVisa sponsorship$190k
...competitive advantage and business superior performance through data, technology and digital. BCG Platinion sits within the TDA practice... ...deliver scalable AI architectures that integrate large language models (LLMs), data pipelines, and enterprise systems. AI Architecture...Work at officeLocal area- ...Pittsburgh, Pennsylvania. 15219.Join our team. Make a difference - for us and for your future.Position Title: Retail Channel Optimization Data AnalystBusiness Unit: Retail OperationsReports to: Retail Channel Optimization ManagerPosition Overview:This position is primarily...Full timeWork at office
- ...yesterday. We apply some of today’s latest technologies in AI, data analytics, and automation. Our team of over 975 Life and Annuity... ...Azure, including containerized and Kubernetes-based deployment models.Minimum of 5 years of experience defining API standards, integration...Work experience placementLive inWork at officeLocal area
$79.6k - $139.3k
...sponsorship of immigration related visa and/or green card status as part of the PERM process will not be available.CGI is seeking a Data Center Migration Consultant to support a major enterprise infrastructure and technology transformation. This role will work as part...Permanent employmentLocal area- We Are:The beginning of a new Data & AI decade that will reshape work and society has begun. Accenture is stepping boldly into this future with a clear strategy and purpose: to help clients optimize and reinvent their business with data & AI — backed by a $3B investment...Work experience placementLive inWork at officeLocal area
- ...Pennsylvania. 15219. Join our team. Make a difference - for us and for your future. Position Title: Retail Channel Optimization Data Analyst Business Unit: Retail Operations Reports to: Retail Channel Optimization Manager Position Overview: This...Full timeWork at office
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Modeler. Be the first to apply!
- sr data modeler Pittsburgh, PA
- data center architect Pittsburgh, PA
- database designer Pittsburgh, PA
- senior data architect Pittsburgh, PA
- senior data modeler Pittsburgh, PA
- data integration architect Pittsburgh, PA
- data architect Pittsburgh, PA
- data intern Pittsburgh, PA
- data collection researcher Pittsburgh, PA
- data operator Pittsburgh, PA





