UNIV - Systems Programmer/ Developer II - Department of PHS

Medical University of South Carolina • Charleston, SC

8d • $52,100 - $88,600 • Onsite

About The Position

Implements changes to and maintains Common Data Models (CDMs) for a variety of research purposes across the department. Works with other organizations to obtain the data required to populate the CDMs as well as write and maintain Extract, Transform and Load (ETL) scripts for the CDMs. Partners closely with Project Management (PM) teams across MUSC to gather data requirements for new research projects. Analyzes and normalizes relevant information related to business processes, functions, and operations to evaluate data credibility and determine relevance and meaning. Develops, implements, and oversees policies and procedures to ensure the integrity and availability of databases and their accompanying software. Assists in developing and implementing long term data management plans. This position will also handle incoming requests for research data queries.

Requirements

• A high school diploma and three years work experience in the modification and maintenance of system programs, the design and development of system software, or the testing and debugging of system software.
• An associate's degree or a bachelor's degree in a related field may be substituted for the required work experience.

Responsibilities

• Data analyst tasks working on developing SQL for research data requests (serving as a data honest broker), which include developing and running queries and reports and verifying results for research projects.
• ETL Development: Evaluate ETL (Extract, Transform, Load) tools/solutions as database sizes grow to include more data and different data types. Maintain, modify existing, and/or develop new ETL to support our projects.
• Prepare reports for research colleagues, leadership, scientific publications and presentation.
• Gathering data requirements for new and existing funded studies and working with various data owners to determine sources of needed data.
• Work with other team members and project managers as needed through meetings and collaborative programming to ensure that the assigned tasks are accomplished in a timely manner.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: High school or GED