CrawlJobs Logo

Data Modeler

United States, Norwell 130000.00 USD / Year · Job Posted March 21, 2026
Apply Position
Job Link Share

Job Description

We are seeking an experienced Data Modeler to design and implement high-quality analytical data models that support enterprise reporting, analytics, and data science use cases. The ideal candidate will have hands-on expertise in silver and gold layer modeling, dimensional data warehouse design, and Python automation to streamline data modeling, validation, and documentation processes.

Requirements

  • Experience with database modeling tools such as LucidChart
  • Experience with standard data models such as S-95
  • Design and develop silver and gold layer data models following medallion architecture principles
  • Create and maintain dimensional models (Star and Snowflake schemas) for enterprise data warehouses
  • Define fact and dimension tables aligned with business KPIs and analytical requirements
  • Apply best practices for slowly changing dimensions (SCDs) and historical data tracking
  • Lead end-to-end data warehouse design and modeling initiatives
  • Translate business requirements into scalable, performant data models
  • Optimize models for query performance, usability, and extensibility
  • Partner with data engineers to ensure accurate implementation of models
  • Develop Python-based automation for data model validation, reconciliation and documentation
  • Automate metadata extraction, schema comparison, and impact analysis
  • Support automated testing of data models and transformations
  • Build reusable Python utilities to improve modeling efficiency
  • Collaborate with data engineers, analysts and architects
  • Participate in design reviews and ensure alignment with enterprise data standards
  • Support data governance initiatives including data definitions, lineage, and documentation
  • Ensure consistency in naming conventions, data types, and modeling standards

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Similar Jobs for

Data Modeler

8 matching positions

Data Modeler

We are looking for a Data Modeler to support a healthcare organization in Morris...
Location
Location
United States , Morristown
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Hands-on experience designing data models across relational, dimensional, and NoSQL environments
  • Strong working knowledge of ETL processes and data pipeline concepts
  • Proficiency with Python for data-focused development and automation tasks
  • Experience using Apache Spark in large-scale data processing environments
  • Familiarity with Apache Hadoop and distributed data ecosystems
  • Working knowledge of Apache Kafka for streaming or event-driven data architectures
  • Ability to document metadata, lineage, and business definitions in a clear and organized manner
  • Strong collaboration skills with the ability to work effectively across engineering, architecture, and analytics teams
Job Responsibility
Job Responsibility
  • Create and refine conceptual, logical, and physical data structures for relational databases, dimensional warehouses, and NoSQL platforms
  • Produce and update entity relationship diagrams, data movement documentation, and related artifacts that align with enterprise data practices
  • Work alongside data engineers and solution architects to ensure models support efficient data ingestion, transformation, and downstream reporting needs
  • Convert business objectives and functional use cases into well-structured database designs that promote performance, flexibility, and long-term growth
  • Lead model evaluations, uphold data modeling standards, and offer mentorship and technical direction to less experienced team members
  • Maintain data dictionaries, metadata records, and lineage documentation to improve transparency and usability across the data estate
  • Partner with analytics and reporting stakeholders to develop star and snowflake schema designs for warehouse and data mart solutions
  • Address data integrity concerns, duplication risks, and quality issues by applying disciplined modeling techniques and sound design principles
  • Contribute to governance efforts by supporting data standardization and cataloging activities across the organization
  • Participate in Agile delivery cycles, providing modeling deliverables and documentation in iterative sprint-based workstreams
What we offer
What we offer
  • medical
  • vision
  • dental
  • life and disability insurance
  • 401(k) plan
Read More
Arrow Right

Data Modeler

Randstad Digital Switzerland is seeking an accomplished Data Modeler to support ...
Location
Location
Switzerland , Geneva
Salary
Salary:
Not provided
https://www.randstad.com Logo
Randstad
Expiration Date
August 31, 2026
Flip Icon
Requirements
Requirements
  • 7+ years in Data Engineering, Architecture, or Analytics Consulting, preferably within complex or regulated industries like Aviation
  • Proficiency in Python, SQL, and dbt for sophisticated ETL/ELT development
  • Strong experience with modern cloud data warehousing, specifically Snowflake
  • Experience with AWS services and data orchestration tools
  • Familiarity with R for statistical transformations is a plus
  • Strong understanding of data modeling principles and hands-on experience designing Source-to-Target mapping
  • Proven experience designing and implementing robust data quality frameworks and validation checks
  • Excellent communication and documentation skills are essential for knowledge transfer and stakeholder collaboration
Job Responsibility
Job Responsibility
  • Build end-to-end automated pipeline workflows for complex aviation data ingestion, processing, and transformation
  • Develop reusable scripts and models for ingestion, orchestration, and transformations using Python, SQL, dbt, and R (where applicable), setting the foundation for scalable data workflows
  • Create and maintain detailed Source-to-Target (S2T) mapping diagrams, clearly documenting data flow, transformation logic, business rules, and data quality checks to guide ETL/ELT development
  • Develop a Data Quality Module (monitoring ingestion, transformation, and publication) and a Data Stewardship Module (supporting human-in-the-loop validation/correction) using dbt and Streamlit
  • Adhere to modern CI/CD practices and ensure thorough documentation and knowledge transfer to internal staff for sustainable operations
Read More
Arrow Right

Data Modeler

Join us as a Data Modeller at Barclays, where you'll spearhead the evolution of ...
Location
Location
India , Pune
Salary
Salary:
Not provided
barclays.co.uk Logo
Barclays
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Partner with business stakeholders to understand their data needs and their desired functionality for the data product. Translate these requirements into clear data modelling specifications.
  • Designs and implements high-quality data models that optimize data access, storage, and analysis as well as ensuring alignment to BCDM.
  • Creates comprehensive and well-maintained documentation of the data models, including entity relationship diagrams, data dictionaries, and usage guidelines.
  • Collaborates with data engineers to test and validate the data models.
  • Obtains sign-off from the DPL, DPA and the Technical Product Lead on the logical and physical data models.
  • Continuously monitor and optimise the performance of the models and data solutions to ensure efficient data retrieval & processing.
Job Responsibility
Job Responsibility
  • Analysis and documentation of business requirements to translate them into data models aligned with organisational goals.
  • Development and maintenance of data dictionaries and glossaries to define data elements and their usage.
  • Analysis and monitoring of data usage patterns to identify opportunities for data optimisation and improvement, in partnership with the Data Base Administrator.
  • Strategic architecture definition and product selection.
  • Production of logical designs in relevant subject area (technical, data, operational), showing for example: processes, objects, data flows, inputs, stored data and outputs. Identifying common components.
  • Implementation of architectures and Identification, ownership and resolution of design related issues.
  • Definition and documentation of data architectures standards, principles and strategies.
  • Fulltime
Read More
Arrow Right

Data Modeler

GeoLogics is working with a top Aerospace and Defense client looking for a Data ...
Location
Location
United States , Sterling Heights
Salary
Salary:
52.00 - 62.00 USD / Hour
geologics.com Logo
GeoLogics
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Excellent oral and written communications
  • Be directly involved in developing data models and process flows as well as liaising with multiple stakeholders - mainly engineering, to document and/or validate the current state or As-Is business process
  • Proven ability to work within teams in which your contributions are critical to success
  • Proficiency with tools such as Power BI, Visual Basic, MSExcel, MATLAB/Simulink, Mathcad, MagicDraw, Midas, AWS/AWS Redshift, SSAS, Alation, Dataiku, Oracle, SQL
  • Experience using entity-relationship diagrams (ERDs), dimensional modeling, normalization techniques, and metadata repositories to design and document data structures
  • Understanding of data warehousing concepts
  • Experience with big data technologies like Hadoop or Spark
  • Familiarity with cloud-based data services such as AWS or Azure
  • Background in data governance and data quality concepts
  • Excellent problem-solving and analytical skills
Job Responsibility
Job Responsibility
  • Design and implement conceptual, logical, and physical data models to represent organizational data accurately
  • Collaborate with business analysts, data architects, developers, and other stakeholders to gather requirements and ensure models meet business and technical needs
  • Maintain a central data dictionary, enforce data standards, and ensure compliance with data governance policies
  • Optimize performance of data infrastructure by tuning data models for efficiency, reduce redundancy, optimize reusability at the right levels and improve database performance
  • Design solutions for integrating data across systems and perform reverse engineering of existing databases when necessary
  • Develop and maintain documentation, naming conventions, and coding standards to ensure consistency across data systems helping the business to define 'what does good look like?'
  • Ensure that data is stored securely, efficiently, and in a manner that is accessible for analysis and reporting
  • Ensuring the accuracy, consistency, and reliability of data, implementing data validation and quality control processes
  • Optimize data pipelines for speed, scalability, and performance, ensuring that data is available when and where it's needed
  • Collaborate with data scientists, analysts, and other stakeholders to understand data requirements and ensure that data infrastructure meets their needs
  • Fulltime
Read More
Arrow Right

Data Modeler

We are currently seeking a Data Modeler to join our team in Bangalore, Karnātaka...
Location
Location
India , Bangalore
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong hands on experience in data modeling across conceptual, logical, and physical layers, including 3NF and dimensional modeling
  • Experience modeling complex logic, rules, and supporting metadata in a data driven manner
  • Strong analytical mindset with the ability to interpret requirements and translate them into implementable data designs
  • Proven ability to collaborate effectively with engineering and architecture teams
  • Strong troubleshooting and problem solving skills related to data design and structure
  • Practical, data driven approach to design decisions and trade offs
  • Working knowledge of SQL and modern data platforms, including cloud based and NoSQL data stores
  • Working knowledge of at least one data modeling tool such as PowerDesigner, ERwin, Hackolade, or equivalent
  • Familiarity with AI assisted development tools, using them to improve productivity and documentation quality where appropriate
  • Fulltime
Read More
Arrow Right

Data Modeler

Join us as a Data Modeler. At Barclays, we don’t just adapt to the future, we cr...
Location
Location
India , Pune
Salary
Salary:
Not provided
barclays.co.uk Logo
Barclays
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong Data Modeling Expertise
  • Ability to design conceptual, logical, and physical data models using standards like 3NF, Dimensional Modeling, and Data Vault
  • Database Design & SQL Proficiency
  • Deep understanding of RDBMS, keys, indexing, normalization, SQL DDL/DML, and query optimization
  • Modeling Tools Proficiency
  • Experience with tools such as ERwin, ER/Studio, PowerDesigner, or SQL Developer Data Modeler
  • Data Architecture & Integration Understanding
  • Knowledge of ETL/ELT flows, source‑to‑target mappings, lineage, and how models fit into the broader architecture
  • Business Requirements Analysis
  • Ability to translate functional requirements into robust, traceable data models and entities
Job Responsibility
Job Responsibility
  • Analysis and documentation of business requirements to translate them into data models aligned with organisational goals
  • Development and maintenance of data dictionaries and glossaries to define data elements and their usage
  • Analysis and monitoring of data usage patterns to identify opportunities for data optimisation and improvement, in partnership with the Data Base Administrator
  • Strategic architecture definition and product selection
  • Production of logical designs in relevant subject area (technical, data, operational), showing for example: processes, objects, data flows, inputs, stored data and outputs. Identifying common components
  • Implementation of architectures and Identification, ownership and resolution of design related issues
  • Definition and documentation of data architectures standards, principles and strategies
  • Fulltime
Read More
Arrow Right

Data Modeler

The Data Modeler role involves designing enterprise-grade data models for a lead...
Location
Location
India , Bangalore
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong experience in data modeling tools such as ERWin, ER/Studio, PowerDesigner, or similar
  • Expertise in SQL, relational databases (Oracle, SQL Server, PostgreSQL, etc.)
  • Experience designing models for cloud data platforms such as Azure Synapse, Databricks, Snowflake, or AWS Redshift
  • Understanding of ETL/ELT pipelines, data integration techniques, and structured/unstructured data
  • Knowledge of data warehousing methodologies (Kimball, Inmon, Data Vault is a plus)
  • Familiarity with modeling for API-based systems, event-driven systems, and NoSQL databases is an advantage
  • Exposure to CIS, Billing, Metering, Asset Management, or Work/Field Management systems
  • Understanding of asset hierarchies, network topology, geospatial data (GIS), and meter data
  • Strong problem-solving and analytical thinking
  • Excellent communication and stakeholder collaboration skills
Job Responsibility
Job Responsibility
  • Design conceptual, logical, and physical data models for enterprise data platforms, data warehouses, and data lakes
  • Develop models aligned with industry standards, utilities data structures, and organizational data strategy
  • Ensure data models support scalability, performance, and future analytics requirements
  • Work closely with data architects to define data integration and data flow design across systems
  • Work with business SMEs to understand domain-specific processes such as: Metering & Billing, Customer Information Systems (CIS), Distribution/Transmission Operations, Asset & Work Management, Outage Management Systems (OMS)
  • Translate domain-driven requirements into accurate and optimized data models
  • Collaborate with business analysts, solution architects, ETL engineers, and application teams
  • Ensure alignment between business requirements and data modeling deliverables
  • Participate in workshops, requirement clarifications, and design walkthroughs
  • Define data standards, naming conventions, and modeling best practices
  • Fulltime
Read More
Arrow Right

Data Modeler

The Data Modeler role requires expertise in developing and maintaining data mode...
Location
Location
India , Remote
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience delivering data models for P&C, Specialty insurance projects with exposure to Lloyd’s/London Market and Syndicate data structures is required
  • Understanding of insurance domain concepts and proficiency with data modelling tools(eg Erwin)
  • Expertise in enterprise data modelling, including conceptual, logical, and physical models for transactional domains
  • Experience in data modelling using Dimensional Star/Snowflake, Data Vault, and 3NF methodologies
  • Knowledge of data warehousing and ETL/ELT pipelines
  • Experience with Azure Data Factory and Databricks, designing data pipelines can be advantageous
  • Understanding and knowledge of system development life cycle methodologies (such as agile software development)
  • Excellent collaboration and communications skills to deal with senior leaders, stakeholders and technical teams is required
  • Flexibility and bringing a curious and creative mindset, open to new things and able to propose innovative idea
  • A minimum of 5 years of experience is required
Job Responsibility
Job Responsibility
  • Develop and maintain data models-Logical and Physical, to support business needs ensuring data integrity for Insurance domains
  • Design models aligned to Databricks medallion architecture by translating the requirements of underwriting, delegated authority, reinsurance, actuarial, claims and finance
  • Implement and maintain modelling standards, naming conventions, metadata and documentation working closely with data analyst, data engineers, and associates in data office
  • Review existing models and propose simplification, standardisation and target state improvements across projects and for wider requirements
  • Lead the evolution of requirements, refine and translate the specifications into data models to enable development phase
  • Ensure the models accurately reflect Insurance processes and data elements before handing it over to engineering
Read More
Arrow Right