UNIV - Senior Data Architect, Research Analytics - Department of SCTR

Job Description Summary

The Senior Data Architect, Research Analytics will lead the South Carolina Clinical and Translational Science (SCTR) Institute’s data and reporting strategy and will engage with enterprise IS data leadership and teams to strategize for the design, creation, refinement, and long-term sustainability of an enterprise research data repository that integrates and curates data from multiple disparate systems across the research lifecycle. This role serves as a critical technical and strategic partner to IS and research leadership and administration, finance, operations, compliance, and analytics teams.

The Senior Data Architect will lead the development of a trusted, scalable research data environment supporting SCTR’s metric tracking and reporting and continuous quality improvement data strategy and decision-making. The position will enable comprehensive reporting across financial performance, awards, earned revenue, operational efficiency, research performance, regulatory compliance, and study and participant-level metrics.

Medical University of South Carolina (MUSC - Univ)

Employee

Classified

CC001064 COM SCTR Operations CC

Salary

University-TEC
07

81,192.

-

40

• Engage with enterprise IS Data teams to design and maintain the logical and physical architecture of a centralized research repository integrating data from numerous source systems, including but not limited to:
• Financial systems (awards, expenditures, revenue, effort)
• Grants and contracts management systems
• Clinical trial management systems (CTMS)
• Research service request systems (SPARC)
• Institutional Review Board (IRB) and Compliance Systems
• Learning management and training systems
• Human resources and faculty appointment systems
• Define standards for data modeling, normalization, dimensional modeling, and metadata management to ensure data quality, scalability, and performance

• Lead the development of robust ETL/ELT pipelines to ingest, harmonize, and curate data from disparate systems with varying structures, definitions, and data quality.
• Ensure alignment between System APIs, and Integrations looking at workflows of systems such as RIMD, SPARC, CTMS, IRB, Epic, and financial systems.
• Establish and document authoritative data sources, business rules, and transformation logic for research metrics.
• Ensure consistent representation of investigators, departments, academic medical center (AMC) affiliations, colleges, and organizational hierarchies across systems.
• Implement processes to manage historical data, changes to organizational structures, and longitudinal reporting. (Essential)

• Translate business requirements into data models and visualizations across key research domains, including:
• Financial performance (awards, expenditures, earned revenue, cost recovery)
• Research portfolio and award activity
• Operational performance and efficiency
• Research study activation timelines and cycle times
• Participant recruitment volumes, accrual rates, and demographic characteristics
• IRB approvals, protocol status, and regulatory timelines
• Required training and compliance approvals
• Ensure the data mart supports reproducible, auditable research metrics used for internal and external reporting.

• Partner with research operations and quality teams to enable data-driven continuous quality improvement initiatives.
• Develop metrics and dashboards that identify process bottlenecks, variability, and opportunities for improvement across the research lifecycle.
  
  Support longitudinal trend analysis and…