What are the responsibilities and job description for the UNIV-Database Administrator II-IS Research Applications position at MUSC Health?
Job Description Summary
The general nature of work for the position is participating in the support of database products and applications.
Entity
Medical University of South Carolina (MUSC - Univ)
Worker Type
Employee
Worker Sub-Type
Research Grant
Cost Center
CC005549 IS - Research Applications
Pay Rate Type
Salary
Pay Grade
University-07
Pay Range
56,210.00 - 80,105.00 - 104,000.000
Scheduled Weekly Hours
40
Work Shift
Job Description
This position is a mid-level position as part of a team responsible for developing and managing the extraction, transformation and loading of data to and from electronic medical records, data repositories and other complex healthcare IT systems and solutions for research. The individual will have a basic understanding of SQL, relational database models, data warehousing and data visualization concepts. The position will take the lead on several long-term projects working with clinical teams to integrate data form multiple sources, work with data architects to manage new data feeds and integrate solutions into existing workflows. The individual must handle confidential and sensitive healthcare data. HIPAA security and privacy regulations must be applied to existing and developed systems and processes.
Knowledge, Skills And Abilities
Proficient in SQL and using relational databases (MS-SQL, MySQL, Oracle)
Familiarity and experience with the Microsoft Azure Cloud platform
Practical experience with ETL and data integration tools (Pentaho Kettle, Microsoft SSIS).
Practical experience developing data models and marts.
Practical Experience Creating Data Visualizations (Tableau Preferred).
Aware of common data warehouse design principles and methodologies.
Basic understanding of Linux environments and navigational skills.
Very organized, high attention to detail, able to work independently.
Strong analytical and problem solving skills.
Strong interpersonal and communications skills (written/verbal).
Experience working with large sets of healthcare data.
Experience with XML and web services.
Experience with open source technologies.
Experience utilizing Agile methodology for development projects.
Job Responsibilities
ETL Developer: (35%) Actively contribute to project tasks such as integrating data sources, creating / maintaining ETL (extract, transform, load) jobs, database design, access and development, and data import and export. Define and deploy DataMarts for research or quality improvement. Support database platforms in multiple environments (Windows, Linux, MS-Azure).
Data Analyst: (25) Actively contribute to investigating new data sources, performing quality checks on new data sources, explaining new data sources to stakeholders and other analysts, creating data visualizations (tableau preferred) for users to access the data.
Project Management: (15%) Active participation in data services delivery, planning, and organization – contribute to team Kanban, documentation, workflows, data dictionaries and diagrams. Provide visibility into individual and team status via recurrent communication channels. Ensure projects meet milestone deadlines and report blockers and risks as appropriate.
Honest Broker: (15%) Support research at MUSC by securely brokering patient data to researchers. Assist investigators in defining data requirements to support longitudinal research. Manage multiple concurrent priorities and work under direction of senior technical staff. Ensure that HIPAA guidelines are strictly followed and that all data provided is approved by the IRB and/or the data request committee.
Administrative: (5%) Learning of new technologies and procedures as they become available at the organization. Assist with database administration, backups, monitoring, and optimization. Assist with migration and deployment to Microsoft Azure Cloud infrastructure. 5%
Other duties as required: (5%)
Additional Job Description
Minimum Requirements: A bachelor's degree in computer science, information systems or a related field and three (3) years experience in systems development and maintenance, technical support or the support of complex database management systems. 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
The general nature of work for the position is participating in the support of database products and applications.
Entity
Medical University of South Carolina (MUSC - Univ)
Worker Type
Employee
Worker Sub-Type
Research Grant
Cost Center
CC005549 IS - Research Applications
Pay Rate Type
Salary
Pay Grade
University-07
Pay Range
56,210.00 - 80,105.00 - 104,000.000
Scheduled Weekly Hours
40
Work Shift
Job Description
This position is a mid-level position as part of a team responsible for developing and managing the extraction, transformation and loading of data to and from electronic medical records, data repositories and other complex healthcare IT systems and solutions for research. The individual will have a basic understanding of SQL, relational database models, data warehousing and data visualization concepts. The position will take the lead on several long-term projects working with clinical teams to integrate data form multiple sources, work with data architects to manage new data feeds and integrate solutions into existing workflows. The individual must handle confidential and sensitive healthcare data. HIPAA security and privacy regulations must be applied to existing and developed systems and processes.
Knowledge, Skills And Abilities
Proficient in SQL and using relational databases (MS-SQL, MySQL, Oracle)
Familiarity and experience with the Microsoft Azure Cloud platform
Practical experience with ETL and data integration tools (Pentaho Kettle, Microsoft SSIS).
Practical experience developing data models and marts.
Practical Experience Creating Data Visualizations (Tableau Preferred).
Aware of common data warehouse design principles and methodologies.
Basic understanding of Linux environments and navigational skills.
Very organized, high attention to detail, able to work independently.
Strong analytical and problem solving skills.
Strong interpersonal and communications skills (written/verbal).
Experience working with large sets of healthcare data.
Experience with XML and web services.
Experience with open source technologies.
Experience utilizing Agile methodology for development projects.
Job Responsibilities
ETL Developer: (35%) Actively contribute to project tasks such as integrating data sources, creating / maintaining ETL (extract, transform, load) jobs, database design, access and development, and data import and export. Define and deploy DataMarts for research or quality improvement. Support database platforms in multiple environments (Windows, Linux, MS-Azure).
Data Analyst: (25) Actively contribute to investigating new data sources, performing quality checks on new data sources, explaining new data sources to stakeholders and other analysts, creating data visualizations (tableau preferred) for users to access the data.
Project Management: (15%) Active participation in data services delivery, planning, and organization – contribute to team Kanban, documentation, workflows, data dictionaries and diagrams. Provide visibility into individual and team status via recurrent communication channels. Ensure projects meet milestone deadlines and report blockers and risks as appropriate.
Honest Broker: (15%) Support research at MUSC by securely brokering patient data to researchers. Assist investigators in defining data requirements to support longitudinal research. Manage multiple concurrent priorities and work under direction of senior technical staff. Ensure that HIPAA guidelines are strictly followed and that all data provided is approved by the IRB and/or the data request committee.
Administrative: (5%) Learning of new technologies and procedures as they become available at the organization. Assist with database administration, backups, monitoring, and optimization. Assist with migration and deployment to Microsoft Azure Cloud infrastructure. 5%
Other duties as required: (5%)
Additional Job Description
Minimum Requirements: A bachelor's degree in computer science, information systems or a related field and three (3) years experience in systems development and maintenance, technical support or the support of complex database management systems. 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
