UNIV - CTMS Reporting Program Manager - Office of Clinical Research, OVPR

Summary

MUSC Health is a medical university and academic clinical research organization. The CTMS Reporting Program Manager develops and maintains research dashboards, reports, metrics, and analytics using Power BI, Advarra Analytics, OnCore, Workday, and related systems. The role supports financial reconciliation, research systems operations, data governance, process improvement, stakeholder engagement, and training across the Office of Clinical Research.

Responsibilities

• Develop, maintain, and enhance enterprise research dashboards, reports, scorecards, and visualizations utilizing Power BI, Advarra Analytics, and other reporting tools
• Design and implement metric tracking processes that support OCR operational objectives and strategic priorities. Analyze research operational data to identify trends, opportunities, risks, and performance improvement initiatives. Develop recurring and ad hoc reports for OCR leadership, research administration offices, departments, and institutional committees. Translate complex data into meaningful visualizations and executive-level summaries to support organizational analysis and decision-making. Monitor and report on key research performance indicators, including study activation timelines, participant accrual against study targets, participant status, data entry timeliness and completeness, research financial performance, and operational efficiency
• Collaborate with stakeholders to define reporting requirements and develop analytics solutions that support operational and strategic research needs
• Evaluate data sources and identify opportunities to improve data collection, standardization, reporting, and analytics processes. Support development and validation of key performance indicators across research systems and programs. Perform data quality reviews and validation activities to ensure the accuracy, completeness, timeliness, and integrity of information reported from OnCore, Workday, Advarra Analytics, and other research systems. Integrate, validate, and reconcile data from multiple systems to meet enterprise reporting and analytics needs, including combining OnCore invoice and payment records with Workday financial data to support reporting on invoiced revenue, payments received, outstanding balances, reconciliation status, and clinical trial financial performance
• Serve as a backup resource for the OnCore support team. Assist with user support, issue resolution, testing, system maintenance, and workflow troubleshooting. Support report development, system optimization, and data integrity initiatives within OnCore and associated research systems
• Participate in system enhancement, upgrade, and implementation activities as assigned
• Collaborate with research and technical teams to identify and resolve issues impacting research operations and reporting
• Identify opportunities to improve reporting processes, operational efficiency, and data quality
• Support data governance initiatives, including development of reporting standards, definitions, and documentation. Document report methodologies, dashboard specifications, business requirements, and data definitions. Participate in quality improvement initiatives and operational assessments utilizing data-driven approaches
• Collaborate with investigators, study teams, departmental administrators, OCR leadership, and technical teams to support reporting and analytics needs. Develop and maintain user guides, training materials, and educational resources related to reporting tools and dashboards
• Present analytical findings, trends, and recommendations to stakeholders and leadership groups
• Serve as a subject matter resource for research metrics, reporting, and analytics within the Office of Clinical Research

Skills

• Bachelor's degree in Information Systems, Health Informatics, Data Analytics, Clinical Research, Public Health, Business Administration, Computer Science, or a related field
• Two (2) years of relevant experience in clinical research, healthcare analytics, business intelligence, research administration, or research systems support
• An equivalent combination of education, training, and experience may be considered
• Knowledge of clinical research operations and research administration processes
• Strong analytical, problem-solving, and critical-thinking skills
• Advanced proficiency in Microsoft Power BI, Excel, and data visualization tools
• Ability to analyze, interpret, and present complex data in meaningful and actionable formats
• Knowledge of key clinical research performance metrics and operational indicators
• Experience working with enterprise systems and data integration concepts
• Strong organizational skills with the ability to manage multiple priorities
• Excellent written and verbal communication skills
• Ability to work independently and collaboratively across diverse stakeholder groups
• Strong customer service and relationship management skills
• 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 outdoors in all weather and temperature extremes. (Infrequent)
• Ability to work in confined/cramped spaces. (Infrequent)
• Ability to perform job functions from kneeling positions. (Infrequent)
• Ability to squat and perform job functions. (Infrequent)
• Ability to perform 'pinching' operations. (Infrequent)
• Ability to fully use both hands/arms. (Frequent)
• 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 and carry 15 lbs., unassisted. (Infrequent)
• Ability to lift objects, up to 15 lbs., from floor level to height of 36 inches, unassisted. (Infrequent)
• Ability to push/pull objects, up to 15 lbs., unassisted. (Infrequent)
• Ability to maintain 20/40 vision, corrected, in one eye or with both eyes. (Continuous)
• Ability to see and recognize objects close at hand. (Frequent)
• Ability to see and recognize objects at a distance. (Frequent)
• Ability to match or discriminate between colors. (Frequent)
• Ability to determine distance/relationship between objects; depth perception. (Frequent)
• Good peripheral vision capabilities. (Continuous)
• Ability to maintain hearing acuity, with correction. (Continuous)
• Ability to hear and/or understand whispered conversations at a distance of 3 feet. (Frequent)
• Ability to perform gross motor functions with frequent fine motor movements. (Frequent)
• Ability to work in dusty areas. (Infrequent)
• Minimum Requirements: A bachelor's degree and three years relevant program experience
• Experience with OnCore Clinical Trial Management System (CTMS)
• Experience with Advarra Analytics
• Experience developing dashboards and reports using Microsoft Power BI
• Experience working within an academic medical center or clinical research environment
• Knowledge of clinical research operations, study activation, participant accrual, data entry timeliness, and financial management processes
• Experience using Workday financial data or similar enterprise financial systems for reporting and reconciliation
• Experience with SQL, database management, reporting tools, and data visualization platforms
• Familiarity with research systems such as REDCap, Epic Research, and eIRB
• Certification as a Clinical Research Professional (CCRP), Certified Clinical Research Coordinator (CCRC), or equivalent preferred

Qualifications

Must Haves

• Bachelor's degree in Information Systems, Health Informatics, Data Analytics, Clinical Research, Public Health, Business Administration, Computer Science, or a related field
• Two (2) years of relevant experience in clinical research, healthcare analytics, business intelligence, research administration, or research systems support
• An equivalent combination of education, training, and experience may be considered
• Knowledge of clinical research operations and research administration processes
• Strong analytical, problem-solving, and critical-thinking skills
• Advanced proficiency in Microsoft Power BI, Excel, and data visualization tools
• Ability to analyze, interpret, and present complex data in meaningful and actionable formats
• Knowledge of key clinical research performance metrics and operational indicators
• Experience working with enterprise systems and data integration concepts
• Strong organizational skills with the ability to manage multiple priorities
• Excellent written and verbal communication skills
• Ability to work independently and collaboratively across diverse stakeholder groups
• Strong customer service and relationship management skills
• 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 outdoors in all weather and temperature extremes. (Infrequent)
• Ability to work in confined/cramped spaces. (Infrequent)
• Ability to perform job functions from kneeling positions. (Infrequent)
• Ability to squat and perform job functions. (Infrequent)
• Ability to perform 'pinching' operations. (Infrequent)
• Ability to fully use both hands/arms. (Frequent)
• 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 and carry 15 lbs., unassisted. (Infrequent)
• Ability to lift objects, up to 15 lbs., from floor level to height of 36 inches, unassisted. (Infrequent)
• Ability to push/pull objects, up to 15 lbs., unassisted. (Infrequent)
• Ability to maintain 20/40 vision, corrected, in one eye or with both eyes. (Continuous)
• Ability to see and recognize objects close at hand. (Frequent)
• Ability to see and recognize objects at a distance. (Frequent)
• Ability to match or discriminate between colors. (Frequent)
• Ability to determine distance/relationship between objects; depth perception. (Frequent)
• Good peripheral vision capabilities. (Continuous)
• Ability to maintain hearing acuity, with correction. (Continuous)
• Ability to hear and/or understand whispered conversations at a distance of 3 feet. (Frequent)
• Ability to perform gross motor functions with frequent fine motor movements. (Frequent)
• Ability to work in dusty areas. (Infrequent)
• Minimum Requirements: A bachelor's degree and three years relevant program experience

Nice to Haves

• Experience with OnCore Clinical Trial Management System (CTMS)
• Experience with Advarra Analytics
• Experience developing dashboards and reports using Microsoft Power BI
• Experience working within an academic medical center or clinical research environment
• Knowledge of clinical research operations, study activation, participant accrual, data entry timeliness, and financial management processes
• Experience using Workday financial data or similar enterprise financial systems for reporting and reconciliation
• Experience with SQL, database management, reporting tools, and data visualization platforms
• Familiarity with research systems such as REDCap, Epic Research, and eIRB
• Certification as a Clinical Research Professional (CCRP), Certified Clinical Research Coordinator (CCRC), or equivalent preferred

Benefits

• Remote work arrangement