Job Code: (Insert Job Code) - Home | UMass Amherst



REPORTS TO: Alice Lorch, MD DATE: 02/2021 Revised

POSITION SUMMARY:

The Project Coordinator will work with a team of data scientists that is led by the Chair of Ophthalmology and the Director of Quality. Project coordinator will do SQL programming and focus on maintaining, storing and retrieving accurate data. S/he will perform a variety of tasks specifically aimed toward the answering of diverse questions within various Ophthalmology subspecialties, with a focus on rare medical and surgical outcomes.

ESSENTIAL FUNCTIONS:

• Extracts data using SQL queries, from the IRIS database and other related data science systems.

• Interacts with biostatistician to refine queries, merge and clean data, and prepares data for integration with R statistical programming software.

• Writes and develops a variety of SQL and/or Postgresql queries to store, sorts and retrieves data.

• Manages data across multiple tables.

• Works on the integration and processing of imaging modalities.

• Interacts with clinical teams in a limited fashion to understand clinical reasoning behind the data set.

• Ensures proper handling of data to ensure a smooth transfer of knowledge.

• Maintains relationships with a wide variety of researchers and clinicians.

• Meets or exceeds departmental standards for accurate reporting.

• Compiles and distributes reports as requested.

• Handles confidential information at a high level.

• May attend various departmental meetings

• Translates project ideas from clinical staff into actionable queries and resulting clean data sets for the biostatistician to work with.

EDUCATION AND EXPERIENCE:

Associates or bachelor’s degree and/or equivalent combination of education and experience.

Masters level student preferred

Minimum 1 to 3 years of experience working with SQL

Strong organizational skills a must with the ability to maintain detailed records

Proficient working knowledge of various file types (excel, CSV, etc.)

Excellent communication (verbal/written) and interpersonal skills

Ability to work with a team and independently.

WORKING CONDITIONS: Office environment.

PHYSICAL REQUIREMENTS: Potential lifting of 5 to 20 lbs.

HOURS: 20 hours per week.

Compliance: | |Mandatory In-service | |HIPAA |(Health Insurance Portability and Accountability Act) | | | | |Age Specific Competencies | | | | | | | |IDX | | | | | |

HIPAA Privacy Training and Sanctions

All employees who have access to health information whose confidentiality is protected by the HIPAA Privacy Rule are required by the Rule to receive training so that they have an understanding and knowledge of the Privacy Rule that corresponds to their job responsibilities and of the group health plan’s policies and procedures that impact on their job duties.  Training on the requirements of the HIPAA Privacy Rule and the plan’s health information policies and procedures under the direction of the institution’s privacy officer is a pre-requisite for this position. Employees who violate the requirements of the HIPAA Privacy Rule will be subject to discipline, up to and including termination. This description is intended to indicate essential tasks and levels of work difficulty that will be required of positions that will be given this title. It is not intended to limit or in any way modify the right of supervisors to assign, direct, or control the work of staff members under their supervision. The use of a particular expression or illustration describing duties shall not be held to exclude other duties not mentioned but that are of similar kind or level of difficulty

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download