Data Analyst – HIV Grant – Roper Hospital

Overview

Location: 1481 Tobias Gadson Blvd Charleston, SC (West Ashley Area)

Shift: Monday – Thursday 8:00am-5:00pm and Friday 8:00am-12:00pm

Primary Function/General Purpose of Position

The Data Modeling is responsible for the design and development of the logical and physical data models based on source systems. The position works closely with Data Warehouse Architecture to design, model and implement standard input and output files which represent the business needs and can be used across the data platforms. The position facilitates consistent business analysis, data acquisition, access analysis and design, and database management.

Develops and designs complex and customized analytics that support quality outcomes and informatics initiatives. Develops data sets and data models for use by other analysts. Integrates large amounts of data which are extracted from various sources and works with the leaders to understand and utilize data and reports.

Essential Job Functions

• Create conceptual models, logical models, and physical data models for transactional and data warehouse systems. Creating and revising data integration modeling standards and guidelines. Collaborate with project groups to provide expertise with relational database systems and data modeling. Acquire data from multiple primary and secondary data sources and maintain databases/data systems.
• Analyze Business Requirements, design logical data models and systems functions and present to stakeholders. Develops solutions and analytics based on the analysis of customer business goals, objectives, needs, and existing infrastructure. Applies principles, concepts, and techniques of skills in developing solutions and strategies. Begins to integrate multiple technologies and applications within a specific customer solution.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Work closely with management to prioritize analytics initiatives based on business and information needs.
• Translate business and data requirements into data models in support of Enterprise Data Models, Data Warehouse and Analytical systems. Develop Data Warehouse Dimensional modeling constructs. Ensure data design follows the prescribed reference architecture and framework while reflecting appropriate business rules. Facilitate data integration, data conformity and data integrity and ensure data structures are designed for flexibility to support future business needs and enhancements.
• Pursue continuous improvements based on lessons learned and industry best practices while ensuring all processes include consideration for data integrity and data quality. Reverse engineer data from various source systems.

This document is not an exhaustive list of all responsibilities, skills, duties, requirements, or working conditions associated with the job. Employees may be required to perform other job-related duties as required by their supervisor, subject to reasonable accommodation.

• N/A

• Master’s degree
  -or
  - Bachelor’s degree + 2 years of experience
  -or- 6 years direct experience (required)

• Experience working with Business Objects and large relational databases in a “big data” environment (required)
• Experience in healthcare, science or information systems (required)
• Familiarity with the Cerner Millennium Data Model or similar systems (required)
• Technical expertise regarding data models, database design development, data mining and reporting techniques (required)

• N/A

• N/A

The following must be included in all position descriptions that involve direct or indirect patient care. This is a Joint Commission requirement. Also, select the age of the patient population served:

Demonstrates the knowledge and skills necessary to provide care appropriate to the age of the patients served on his or her assigned unit.

Demonstrates knowledge of the principles of growth and development of the life span and possesses the ability to assess data reflective of the patient’s status and interprets the appropriate information needed to identify each patient’s requirements relative to his or her age, specific needs and to…