Skip to content

IT and Engineering > Data Modeler

Salary National Average

Low Medium High
96870.0000 118740.0000 152240.0000

Change from Previous Year:

+4%

Supply and Demand

Candidate Supply: 974 Job Openings: 5,539

0 50 100

More Difficult Less Difficult

Salary Variance

Enter City, State to view local salaries and candidate demand.

Short Description:

Establish and maintain an Enterprise Data Model that describes how data is processed, stored, and utilized. Manage the data structures required to support the enterprise through the BI program. Provide the means of system integration by understanding the source and target data and building the data mapping. Determine architectural approaches for data environments and help ensure that the data needs of the enterprise are met. Responsible for developing and maintaining a formal description of the data and data structures, including data definitions and models. Build strategy and design for managing data history.

Duties / Responsibilities:

  • Understand and translate business needs into data models supporting long-term solutions.
  • Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
  • Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
  • Optimize and update logical and physical data models to support new and existing projects.
  • Maintain conceptual, logical, and physical data models along with corresponding metadata.
  • Develop best practices for standard naming conventions and coding practices to ensure the consistency of data models.
  • Recommend opportunities for the reuse of data models in new environments.
  • Perform reverse engineering of physical data models from databases and SQL scripts.
  • Evaluate data models and physical databases for variances and discrepancies.
  • Validate business data objects for accuracy and completeness.
  • Analyze data-related system integration challenges and propose appropriate solutions.
  • Develop data models according to company standards.
  • Guide system analysts, engineers, programmers, and others on project limitations, capabilities, performance requirements, and interfaces.
  • Review modifications to existing software to improve efficiency and performance.
  • Examine new application design and recommend corrections if required.

Skills / Requirements / Qualifications

  • Database Management System Software: Amazon DynamoDB; Elasticsearch; MongoDB; Oracle PL/SQL 
  • Database User Interface and Query Software: Apache Hive; Blackboard software; IBM DB2; Transact-SQL 
  • Development Environment Software: Apache Kafka; Apache Maven; Go; Oracle SQL Developer 
  • Metadata Management Software: CA Erwin Data Modeler; Informatica software; SAP PowerDesigner; Talend Data Fabric
  • Web Platform Development Software: Django; Google Angular; React; Spring Framework 

Job Zones

  • Education: Most of these occupations require a four-year bachelor's degree, but some do not.
  • Related Experience: A considerable amount of work-related skill, knowledge, or experience is needed for these occupations. For example, an accountant must complete four years of college and work for several years in accounting to qualify.
  • Job Training: Employees in these occupations usually need several years of work-related experience, on-the-job training, or vocational training.
  • Job Zone Examples: Many of these occupations involve coordinating, supervising, managing, or training others. Examples include accountants, sales managers, database administrators, teachers, chemists, art directors, and cost estimators.
  • Specific Vocational Preparation in years: 2-4 years of preparation (7.0 to < 8.0)

Share Role Details

Return to job listings