Data Modeling Advisor in Nashville, TN at Open Systems Technologies

Date Posted: 1/11/2020

Job Snapshot

  • Employee Type:
  • Location:
    Nashville, TN
  • Job Type:
  • Experience:
    At least 8 year(s)
  • Date Posted:

Job Description

A health services organization is seeking a Data Modeling Advisor to join their team in Nashville, TN.


  • Understand source systems and entities in scope for next generation data warehouse being initially developed under the initiative
  • Participate in the requirement gathering meetings with business stakeholders to understand the organization needs and capture data requirements
  • Understand the business requirements and translates it into conceptual, logical and physical data models
  • Analyze reporting/consumption/provisioning requirements that data models need to support
  • Analyze transactional data system requirements that data models need to support
  • Work with DMS Architecture team and Enterprise architect team to create DMS DataMart data model for business consumption
  • Work with DMS Architecture team and Enterprise architect team to create data models to support transactional data systems
  • Provide Health Care Domain inputs to data model design team
  • Develop conceptual data models
  • Develop logical data models
  • Develop physical data models
  • Conduct business review sessions and arrive at consensus on the design



  • Self-driven and able to function with minimal direction from Manager
  • Able to engage business and data stakeholders to resolve questions or issues
  • Able to handle multiple and sometimes competing priorities in a fast-paced environment
  • Must be a quick learner and a team player


  • 8+ years of the following experience: data analysis, business and functional requirements gathering, report and dashboard mock up/wireframe creation, process documentation, user facing, and excellent written and verbal communication skills
  • Intermediate to advanced MS SQL (SSMS), TeraData, and MS Excel skills
  • Intermediate to advanced skills with Erwin data modeling or other similar data modeling tools and concepts for data modeling
  • Logical reasoning and attention to detail skills
  • Experience with Medicare/Medicaid
Job keywords:


  1. Architect Jobs
  2. Systems Engineer Jobs