Data Modeling

Data Modeler Job Description Template

The data modeler role is one of the highest-in-demand in modern strategies for handling data. With more and more businesses converting their current data models to NoSQL platforms, it not only requires expertise in RDBMSes, data warehouses, and the dimensional OLAP model, but also deep knowledge in big data platform design.

Share

The data modeler role is one of the highest-in-demand in modern strategies for handling data. With more and more businesses converting their current data models to NoSQL platforms, it not only requires expertise in RDBMSes, data warehouses, and the dimensional OLAP model, but also deep knowledge in big data platform design.

Engineers in this role create data models optimized across different data domains and for various purposes, working with enterprise requirements from business analysts, data architects, data administrators, database developers, and data scientists.

Data Modeler - Job Description and Ad Template

Copy this template, and modify it as your own:

Company Introduction

{{ Write a short and catchy paragraph about your company. Make sure to provide information about the company’s culture, perks, and benefits. Mention office hours, remote working possibilities, and everything else that you think makes your company interesting. }}

Job Description

The data modeler designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. These solutions support enterprise information management, business intelligence, machine learning, data science, and other business interests.

The successful candidate will:

  1. Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
  2. Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.

Responsibilities

  • Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, and machine learning).
  • Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models
  • Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
  • Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
  • Hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC.
  • Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
  • {{ Add any other relevant responsibilities here. }}

Skills

  • Bachelor’s or master’s degree in computer/data science technical or related experience.
  • 5+ years of hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
  • Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required.
  • Good knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required.
  • Experience in team management, communication, and presentation.
  • {{ Make sure to mention any other frameworks, libraries, or other technologies relevant to your project. }}
  • {{ List any education level or certification you may require. }}
See also:Toptal’s growing, community-driven list of essential Data Modeling interview questions

Recent Data Modeling Articles by Toptal Engineers

Find the right Data Modeling interview questions

Read a list of great community-driven Data Modeling interview questions.
Read them, comment on them, or even contribute your own.

Read the Questions

Hire a Top Data Modeling Expert Now

Toptal is a marketplace for top data modeling experts. Top companies and startups choose Toptal data modeling freelancers for their mission-critical software projects.

See Their Profiles

Lian Yagoda

Freelance Data Modeling Expert
IsraelToptal Member Since November 26, 2021

Lian has a decade of experience with different BI platforms, working as a BI developer and technical support consultant. She is an expert in data modeling, querying, manipulation, and visualization of data outputs, and she likes to use Sisense, Tableau, Qlik Sense, Power BI, and Looker. Lian enjoys using her skills to contribute to the exciting technological advances daily.

Show More

Oliver Holloway

Freelance Data Modeling Expert
United KingdomToptal Member Since May 10, 2016

Oliver is a versatile data scientist and software engineer combining over a decade of experience and a postgraduate mathematics degree from Oxford. Career assignments have ranged from building machine learning solutions for startups to leading project teams and handling vast amounts of data at Goldman Sachs. With this background, he is adept at picking up new skills quickly to deliver robust solutions to the most demanding of businesses.

Show More

Christopher Karvetski

Freelance Data Modeling Expert
United StatesToptal Member Since August 24, 2016

Dr. Karvetski has ten years of experience as a data and decision scientist. He has worked across academia and industry in a variety of team and client settings, and has been recognized as an excellent communicator. He loves working with teams to conceive and deploy novel data science solutions. He has expertise with R, SQL, MATLAB, SAS, and other platforms for data science.

Show More

Eva Bojorges Rodriguez

Freelance Data Modeling Expert
MexicoToptal Member Since November 11, 2014

Eva is a skilled back-end developer and machine learning engineer with experience in scalability issues, system administration, and more. She has a flair for well-structured, readable, and maintainable applications and excellent knowledge of Python, Ruby, and Go. She is a quick learner and has worked in teams of all sizes.

Show More

Sidney Park

Freelance Data Modeling Expert
New ZealandToptal Member Since February 12, 2022

Sidney is an experienced business intelligence and data engineer. His expertise includes BI dimensional modeling, data pipelines, dashboards, reports, and handling API-related data. He has served as team Scrum Master, led migration and upgrade projects, mentored team members, and was recognized as the top employee for his ability to build excellent client relationships.

Show More

Laura Michela

Freelance Data Modeling Expert
United StatesToptal Member Since September 7, 2019

Laura is a data-driven strategist with expertise in turning data into actionable insights. Laura fell in love with Tableau 7.0 in her MBA business analytics program and never looked back. Now, she is a Tableau certified professional and spends her days telling stories with data to influence business decisions.

Show More

Renee Ahel

Freelance Data Modeling Expert
CroatiaToptal Member Since June 18, 2020

Renee is a data scientist with over 12 years of experience, and five years as a full-stack software engineer. For over 12 years, he has worked in international environments, with English or German as a working language. This includes four years working remotely for German and Austrian client companies and nine months working remotely as a member of the Deutsche Telekom international analytics team.

Show More

Aljosa Bilic

Freelance Data Modeling Expert
SwitzerlandToptal Member Since August 8, 2016

Aljosa is a data scientist and developer who has more than eight years of experience building statistical/predictive machine learning models, analyzing noisy data sets, and designing and developing decision support tools and services. He joined Toptal because freelancing intrigues him, and the best projects and people are to be found here.

Show More

Darin Erat Sleiter

Freelance Data Modeling Expert
BrazilToptal Member Since October 11, 2016

Darin is a data scientist and engineer with a PhD in physics from Stanford. He's passionate about data and machine learning and has worked on data science projects across numerous industries and applications. Darin's co-founded an AI company and led a team of data scientists to build a product which uses machine learning and optimization techniques to reduce energy consumption in data centers. He's eagerly waiting for quantum computers.

Show More

Benjamin Li

Freelance Data Modeling Expert
CanadaToptal Member Since November 3, 2021

Benjamin has over two decades of software and big data development experience, including data modeling and data warehouse design. His active toolset includes Spark, Python, Scala, AWS, Azure, SQL, Hive, Linux, Microsoft BI solutions, C#.NET, and Java. His orientation to detail and strong analytical and problem-solving skills make him an excellent addition to any team. A kind and intentional communicator, Benjamin always produces high-quality work.

Show More

Derek Owens-Oas

Freelance Data Modeling Expert
United StatesToptal Member Since January 21, 2020

Derek has a PhD in statistical science from Duke and has worked as a data scientist and software developer at Xylem. He's the founder of Tech Smart Magic. Published in the Journal of Classification and a TA of the year, he's an expert in research and teaching. He provides interactive apps, visualizations, and reports. Derek's Python and R programming, top AI and ML methods, and ability to communicate make him an asset to any company. His specialties include text data and online social networks.

Show More

Discover More Data Modeling Experts in the Toptal Network

Start Hiring

Toptal Connects the Top 3% of Freelance Talent All Over The World.

Join the Toptal community.