UNIV - Systems Programmer/ Developer II - Department of PHS

MUSC Health; Charleston (SC); On-site; USD 52,100 - 88,600; Full time

Job summary

Medical University of South Carolina (MUSC) is seeking a data professional to implement and maintain Common Data Models (CDMs) for research, and to write ETL scripts to populate these models. The role collaborates with PM teams to gather data requirements for new studies and to ensure data credibility and availability.

Responsibilities include developing SQL, ETL processes, and generating reports for leadership and publications.

Qualifications

• High school diploma and 3 years of work in modification/maintenance of system programs or related fields.
• Associate's or bachelor's degree may substitute for required work experience.
• Experience with data queries and research data requests is a plus.

Responsibilities

• Develop and run SQL queries and reports for research data requests.
• Develop, maintain, and evaluate ETL processes to support projects.
• Prepare reports for colleagues, leadership, publications and presentations.
• Gather data requirements for funded studies with data owners.
• Collaborate with team members and PMs to complete tasks on time.

Skills

SQL

ETL development

Data analysis

Report generation

Collaborative teamwork

Education

High school diploma + 3 years related experience

Associate's or Bachelor's degree may substitute

Tools

ETL tools

SQL tooling

Job description

Job Description Summary

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.

Job Description Summary

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.

Entity

Medical University of South Carolina (MUSC - Univ)

Worker Type

Employee

Worker Sub-Type

Research Grant

Cost Center

CC001038 COM PHS Operations CC

Pay Rate Type

Salary

Pay Grade

University-TEC04

Pay Range

52,100.00 - 70,300.00 - 88,600.000

Scheduled Weekly Hours

40

Job Duties

• 35% 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.
• 30% 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.
• 15% Prepare reports for research colleagues, leadership, scientific publications and presentation.
• 10% Gathering data requirements for new and existing funded studies and working with various data owners to determine sources of needed data.
• 10% 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.

Additional Job Description

Minimum 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. Physical Requirements: (Note: The following descriptions are applicable to this section: Continuous - 6-8 hours per shift; Frequent - 2-6 hours per shift; Infrequent - 0-2 hours per shift) Ability to perform job functions in an upright position. (Frequent) Ability to perform job functions in a seated position. (Frequent) Ability to perform job functions while walking/mobile. (Frequent) Ability to work indoors. (Continuous) Ability to work in confined/cramped spaces. (Infrequent) Ability to bend at the waist. (Frequent) Ability to fully use both hands/arms. (Continuous) Ability to perform repetitive motions with hands/wrists/elbows and shoulders. (Frequent) Ability to reach in all directions. (Frequent) Possess good finger dexterity. (Continuous) Ability to maintain tactile sensory functions. (Continuous) Ability to lift, lower, push or pull objects 15 lbs. or more, unassisted. (Infrequent) Ability to maintain 20/40 vision, corrected. (Continuous) Ability to see and recognize objects close at hand. (Continuous) Ability to see and recognize objects at a distance. (Continuous) Ability to match or discriminate between colors. (Continuous) Ability to determine distance/relationship between objects; depth perception. (Continuous) Good peripheral vision capabilities. (Continuous) Ability to hear and/or understand conversations. (Continuous) Ability to perform gross motor functions with frequent fine motor movements. (Continuous) Ability to work in dusty areas. (Infrequent)

If you like working with energetic enthusiastic individuals, you will enjoy your career with us!

The Medical University of South Carolina is an Equal Opportunity Employer. MUSC does not discriminate on the basis of race, color, religion or belief, age, sex, national origin, gender identity, sexual orientation, disability, protected veteran status, family or parental status, or any other status protected by state laws and/or federal regulations. All qualified applicants are encouraged to apply and will receive consideration for employment based upon applicable qualifications, merit and business need.

Medical University of South Carolina participates in the federal E-Verify program to confirm the identity and employment authorization of all newly hired employees. For further information about the E-Verify program, please click here: http://www.uscis.gov/e-verify/employees