Sql data analyst [h1.location_city]

Thank you for considering a career at Roper St. Francis Healthcare!

Scheduled Weekly Hours :

40

Work Shift :

Days (United States of America)

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 modes 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.

Licensing / Certification

N / A

Education

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

Work Experience

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)

Training

N / A

Language

N / A

Patient Population

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 provide the care needed as described in departmental policies and procedures.​

Neonates (0-4 weeks)

Infant (1-12 months)

Pediatrics (1-12 years)

Adolescents (13-17 years)

Adults (18-64 years)

Geriatrics (65 years and older)

XNot applicable to this position

Working Conditions / Physical Requirements

Frequent sitting. Frequently requires long periods of working at a computer. Intermittent walking. May require lifting or moving items up to 25 lbs. Frequent use of finger / hand dexterity. Constant talking or hearing. Corrected hearing and vision to normal range. No exposure to blood, body fluids or tissue. Possible exposure to infectious materials, communicable diseases and / or other conditions common to a healthcare environment. Requires work under stressful conditions, deadlines, and / or irregular hours. Ability to read and comprehend. Frequent home reading assignments. Travel may be required. All work must be performed in cooperative team environment.

Skills

Hard / Tech / Clinical Skills

Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy

Understand what data is needed to address a business question and how to analyze it and interpret results.

Proven ability to extract / source data from multiple disparate data sources and integrate them into a single data set in canonical form

Demonstrate acumen in data profiling and data modeling

Adept at queries, report writing and presenting findings

Problem Solving – formulates workable, creative solutions and makes high quality decisions with limited time and data

Soft / Interpersonal Skills :

Effectively manages time and priorities to complete most important assignments on time

Effectively communicates with and aligns different parties including customers, partners, a peer network of stakeholders, senior executives, technical resources as well as partner staff using verbal and written communication skills

Critical Thinking – offers new perspectives, thinks out of the box, challenges the status quo to innovate remarkable solutions

Quality – extremely high attention to detail, passion for continuous improvement and operational excellence and commitment to deliver outstanding customer service

Roper St. Francis Healthcare is an equal opportunity employer.

As a teammate, you’re part of a Misson that matters. We support your well-being – personally and professionally. Our benefits are built to grow with you and meet your unique needs, every step of the way.

What we offer

Competitive pay, incentives, referral bonuses and 403(b) with employer contributions (when eligible)

Medical, dental, vision, prescription coverage, HAS / FSA options, life insurance, mental health resources and discounts

Paid time off, parental and FMLA leave, and short- and long-term disability

Tuition assistance, professional development and continuing education support

Department :

HIV Program Services - Roper Hospital