"Alerted.org

RESPONSIBILITIES

I. JOB SUMMARY/RESPONSIBILITIES:

• Leads in all aspects of the design, development, and deployment of data warehousing and analytic solutions, including supporting data models and meta data.

• The data domains covered across The Queen’s Health System include clinical, financial, and patient experience data.

• Consults in sourcing, loading, and analyzing data, developing visualizations, and interacting with clinical and administrative staff to empower meaningful improvements in healthcare.

• Contributes to clinical and operational performance improvement initiatives through activities such as data analysis and support, dashboard and metric development, and clinical disease cohort and registry building.

• Supervises and directs work of assigned staff.

II. TYPICAL PHYSICAL DEMANDS:

• Essential: finger dexterity, seeing, hearing, speaking.

• Continuous: sitting, static gripping of an object for prolonged periods.

• Frequent: walking.

• Occasional: standing, stooping/bending, climbing stairs, walking on uneven ground, lifting and carrying usual weight of 1 pound up to 5 pounds, reaching above, at and below shoulder level, frequent gripping of an object.

• Operates computer, calculator, telephone, fax,printer and smart phone.

III. TYPICAL WORKING CONDITIONS:

• Not substantially subjected to adverse environmental conditions.

IV. MINIMUM QUALIFICATIONS:

A. EDUCATION/CERTIFICATION AND LICENSURE:

• Bachelor’s degree in Information Technology (IT) or related field; four (4) years experience in IT demonstrating hands on independent contribution to database or business intelligence projects such as hand coded SQL queries, data modeling, report development may be substituted for the educational requirement.

• Must successfully complete and maintain certification(s) in the application(s) assigned, and as may be specified per the training agreement.

B. EXPERIENCE:

• In addition to educational requirement, six (6) years related experience in the following:

o Demonstrated application of information technology data and programming principles, theories, concepts, and best practices (e.g. requirements documentation, source code control, change management, promotions, segregation of duties).

o Advanced tenants of Relational Database Management Systems (RDBMS) principles, processes, technologies and tools including management, reporting and visualization of data.

o Hand coded Structured Query Language (SQL) query development

o Advanced database object development, beyond tables and views, such as stored procedures, user defined functions, check constraints, clustered indices, tuning and optimization

• Strong sense of customer service to consistently and effectively address business and clinical partners’ needs

• Comfortable with ambiguity and changing priorities and direction in projects and core work

• Enjoys participating in a collaborative work environment partnering with colleagues inside and outside of own department.

• Maintain a high level of confidentiality

• Self-motivated; comfortable working independently under general direction

• Effective written and verbal communication and presentation skills.

V. PREFERRED QUALIFICATIONS:

A. EDUCATION/CERTIFICATION AND LICENSURE:

• Graduate degree.

• Database, Microsoft, Developer certifications.

B. EXPERIENCE:

• Working with healthcare data systems, understanding of clinical operational measures, including experience with Electronic Medical/Health Record Systems (EMR/EHR) and data (Epic/Clarity ideally).

• Experience with health care regulatory and clinical quality measurements frameworks such as NCQA HEDIS, Meaningful Use, PQRS, OPPE, CORE measures, etc.

• Education/Understanding of analytics and statistics.

• Experience with Microsoft SQL Server - Integration Services (SSIS), Transact SQL (T-SQL), Reporting Services (SSRS), and Analysis Services (SSAS).

• Experience with enterprise class database systems (e.g. Teradata, Oracle, DB2, MS SQL Server).

• Hands on experience with Extract, Transform, and Load (ETL) applications.

• Familiarity with development methodologies including the AGILE development approaches.

• Experience with QlikView or other similar visualization and analysis tools (e.g. Tableau).

• Experience with data driven web application development, e.g. ASP.net.

• Experience with scorecard/dashboarding visualizations to sustain and drive process improvement.

• Prior experience in leading projects and/or work streams and assignments.

• Ability to lead and mentor other team members.

• Experience with Big Data structures, platforms, programming languages such as R, Hadoop, Hive, NoSql, Cloudera, MongoDB, predictive analytics, machine learning.

Equal Opportunity Employer/Disability/Vet