UNIV - Senior Data Architect, Research Analytics - Department of SCTR
About The Position
The Senior Data Architect, Research Analytics will lead the South Carolina Clinical and Translational Science (SCTR) Institute’s data and reporting strategy. This role involves engaging with enterprise IS data leadership and teams to strategize for the design, creation, refinement, and long-term sustainability of an enterprise research data repository. This repository will integrate and curate data from multiple disparate systems across the research lifecycle. The position serves as a critical technical and strategic partner to IS and research leadership, as well as 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. This will enable comprehensive reporting across financial performance, awards, earned revenue, operational efficiency, research performance, regulatory compliance, and study and participant-level metrics.
Requirements
- A bachelor's degree in computer science, information systems or a related field and four years’ experience in systems development and maintenance, technical support or the support of complex database management systems.
- Related experience may be substituted for the bachelor's degree on a year-for-year basis.
- A bachelor's degree and four years experience in automated information or communication system design, installation, operation, repair, sales or marketing.
- Related experience may be substituted for the bachelor's degree on a year-for-year basis.
Responsibilities
- 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.
- 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 benchmarking to assess the impact of operational changes.
- Support SCTR and research leadership and grant reporting by delivering reliable, interpretable data for strategic decision-making. Enable analyses used to justify workforce hires, capacity needs, and resource allocation based on research volume, complexity, and performance indicators. Ensure visualizations and KPIs are suitable for board-level, sponsor-facing, and regulatory reporting.
- Collaborate with data governance bodies to define data ownership, stewardship, access controls, and usage standards and support evaluation requests for integrating new vendor promoted tools and technologies into existing infrastructure. Implement data quality monitoring, validation, and remediation processes. Ensure compliance with institutional policies and applicable regulations related to data privacy, security, and research compliance.
- Act as a technical liaison between SCTR, IT, research administration, clinical research teams, finance, and institutional leadership. Translate complex technical concepts into clear, actionable insights for non-technical stakeholders. Provide technical leadership and mentorship to analysts, data engineers, and reporting teams.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
