Bus and WH Data Analyst-Full Time- Day Shift

The following information is designed to outline the functions and position requirements of this job. It does not identify all tasks that may be expected, nor address the performance standards that must be maintained. Job functions may change based on organizational need.

 

General Position Summary:

 

Designs, maintains, and provides support for data warehouse systems and related data marts. Creates data design, database architecture, and data repositories. Ensures data accuracy. Evaluates new data warehouse applications for possible adoption and improves performance of existing applications.

 

Performs advanced business analysis using various techniques, e.g. statistical analysis, explanatory and predictive modeling, data mining. Determines best practices and develops actionable insights and recommendations for the current business operations or issues. Works closely with the internal or external client to identify analytical requirements. May handle special analytical projects as needed. May assist in implementing or developing systems to capture business operation information.

 

The Business Data & Data Warehouse Analyst position establishes data accuracy and validity derived from a variety of information resources.  This position plays an active role in designing, building and maintaining reports from various information systems used to make strategic business decisions.  This position supports numerous business units and stakeholders requiring reports and data.  This position also manages stakeholder requirements and documentation. 

 

Essential Functions / Major Responsibilities:

 

·         Acquire, manage, manipulate, and analyze data and report results to support Population Health and payment initiatives, primary care transformation, financial, clinical, and operational goals.

·         Responsible for end-to-end report development, medical and financial cost and utilization trend analysis; interacting with end users to gather requirements and understand report objectives; and will provide data management and analytic support.

·         Identifies and accesses appropriate source systems and selects appropriate data to produce report content to meet requestors’ needs. 

·         Decides report format best suited to organize data in a meaningful way to produce desired results.

·         Assists in benchmarking processes by gathering and pulling related data as needed.

·         Reviews data for integrity and accuracy; audits and ensures data integrity of information entered into the information systems.

·         Reviews post-software installation and conducts audits and troubleshoots the reporting environment if necessary. 

·         Proposes methodologies to improve data quality through analyzing and understanding data inconsistencies.

·         Displays proper etiquette and mannerisms that reflect the SHINE Behavioral Standards.

·         Promotes the Patient Safety Standards as a core value of the organization.

 

 

Secondary Functions:

 

·         Participates in departmental and association wide informational meetings and in services, including staff meetings, association wide forums, and seminars.

·         Reviews department and association wide policies and procedures annually.

·         All other duties as assigned.

 

Job Scope:

 

This job involves:

·         Recurring work situations with occasional variations from the norm.

·         A high degree of complexity.

·         Designing, implementing and maintaining both established as well as future systems and procedures.

·         Performance of duties under moderate supervision.

 

 

 

Supervisory Responsibility:

 

·         None.

 

Interpersonal Contacts:

 

Contacts:

·         Are normally made with others both inside and outside the hospital.

·         Are usually made with own department as well as other departments or locations.

·         Contain discussion about confidential/sensitive matters.

·         Are made via telephone, e-mail, video and face-to-face interaction.

·         Are usually with staff members, with little to no visitor contact.

 

 

Specific Job Skills & Mental Activities:

 

This position requires operational knowledge of all equipment and software systems in the Information Services Department. These include, but are not limited to:  SQL database, Paragon HIS, computer hardware, fax, printer, copy machine, scanner, shredder, phone systems, and commonly used hospital computer programs (including Windows Operating Systems, MS Office, Adobe Acrobat, e-mail, and internet).

 

This person must also have knowledge of databases and data models used in SQL (including queries and reports).  

 

This person must be service oriented and have excellent computer skills, problem-solving skills, customer service skills, organizational skills, multitasking skills, professional interpersonal skills, time management skills, the ability to prioritize work, and telephone etiquette.

 

This employee needs strong organizational skills with emphasis on attention to detail, the ability to work well independently and in a team setting and be able to correctly and calmly explain situations to varying skill levels and vocational backgrounds.

 

Must be able to read, write, speak and understand English.

 

Education and/or Experience:

 

·         Bachelor’s Degree in IT, Business, or related field (preferred).

·         Project Management Professional (preferred).

·         Lean Six Sigma Black Belt (preferred).

·         Advanced computer skills (required).

·         One year experience in a similar role with previous exposure to working with Microsoft SQL (required).

·         Experience with McKesson Information Systems (preferred).

·         Demonstrated ability in data extraction, complex analysis, and reporting.

·         Knowledge of clinical operations and process improvement methodologies.

·         Familiarity with healthcare terminology such as diagnosis code, CPT, DRG, etc.

·         Comprehensive understanding of all computer applications used within the department.

·         Demonstrated ability to build, maintain, and manipulate spreadsheets and graphs through the use of Excel, Crystal Reports, SSRS, and other reporting technologies.

·         Ability to work effectively and efficiently with a degree of accuracy under tight deadlines and high volumes.

·         Excellent time management and organizational skills.

·         Excellent problem-solving skills.

 

Physical Demands & Job Conditions:

 

 

 

Exert up to 20 lbs. of force occasionally, and/or up to 10 lbs. of force frequently, and/or a negligible amount of force constantly to move objects. Physical demands are in excess of those of Sedentary work. Light work usually requires walking or standing to a significant degree. Worker is exposed to extensive computer work.

 

Physical motions include finger dexterity, standing, walking, talking, reaching, feeling, sitting, bending, grasping, listening/hearing, handling, lifting up to 20 pounds, and repetitive motions of the hands, wrists, and feet.

 

This is a safety sensitive position.

 

OSHA Exposure Category:

 

 

Involves no regular exposure to blood, body fluids, or tissues, and tasks that involve exposure to blood, body fluids, or tissues and are not a condition of employment.