This resource will support the Medicare Advantage project
This position is responsible for creating comprehensive and deployable models that represent solid business requirements and yet are well understood and implementable by DBA’s, application and report developers. Position will focus on solution delivery while maintaining the benefits of flexibility and abstraction to change found in good data modeling disciplines. The solutions created will support both enterprise level databases as well as application specific databases.
Qualifications:
Strong Dimensional Data Modeling skills with 4+ years.
Logical Data Modeling skills with 5+ years of Logical Data Modeling experience for large transactional systems - (OLTP - not Data Warehousing)
Strong Analytical & Communication skills
Experience with working knowledge of data warehousing / business intelligence technologies
Excellent command of models that are fully attributed from those that are sparsely attributed and understand the necessity to represent requirements from both perspectives
Master the capture and management of model metadata that describes the logical to physical mapping characteristics as well as source to target mapping characteristics for database population
Understand the different users (technical vs. business) for metadata
Understands the difference between dimensional and relational data modeling methodologies.
Understands the difference between logical and physical data models, including the proven ability to create valid third normal form data models, and then appropriately denormalize them for physical performance requirements
Show proven capability with business interaction for facilitation and gathering of requirements for application and database design
Understand the differences between normalization and design of OLTP environments from Data Warehouse environments
Excellent communications skills; professional presentation skills; self-starter; cooperative attitude; team player
Additional Responsibilities include:
Performs detailed data analysis
Demonstrated ability to learn existing corporate data models
Demonstrated strong modeling skills
Participates in business requirements definition activities
Works closely with Information Technology and Business employees to ensure successful completion of projects
Skills
Years of Experience
Last Used
Experience as a Data Modeler
Experience with Dimensional Data Modeling
Experience with Logical Data Modeling
Experience with data warehousing
Experience with business intelligence technologies
Experience with capture and management of model metadata
Experience with source to target mapping characteristics for database population
Experience with creating valid third normal form data models
Experience with designing of OLTP environments from Data Warehouse environments