Data Modeling Advisor

nashville, Tennessee

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:

Files must be less than 2 MB.
Allowed file types: doc docx pdf.

Vertical Tabs