Sponsored Research Reporting and Systems Administrator
University of North Carolina - Charlotte$55K–$75K/yri7h ago
Role Snapshot
The Sponsored Research Reporting & Systems Administrator supports the Research Development & Engagement Office by managing sponsored research reporting, data analysis, and system integrity across the institution's research lifecycle. This role ensures accurate data reporting for internal and external constituents while collaborating with IT and campus stakeholders on systems and process improvements.
Key Responsibilities: Generate lifecycle sponsored program reports (proposals, awards, financial, compliance), analyze data for trends and inconsistencies, troubleshoot and resolve Banner and eRA system issues, develop testing strategies for system implementations, and provide technical support to research administration users.
Skills & Tools: Advanced data analysis and SQL reporting capabilities, proficiency with enterprise financial systems (Banner, eRA), business analysis and process improvement expertise, strong communication skills for cross-functional collaboration, and technical troubleshooting abilities.
Qualifications: Bachelor's degree in business, information systems, data science, or related field with 3-5 years of experience in research administration, financial reporting, or systems support; familiarity with sponsored research environments and enterprise financial systems is preferred.
Compensation: $55K–$75K/yr (estimated)
Job Description
Reporting directly to the Data Reporting & Business Systems Lead Analyst within the Research Development & Engagement Office, the Sponsored Research Reporting & Systems Administrator will be responsible for reporting related to sponsored research for the institution. In addition, this position will collaborate with the university's IT financial systems team on internal systems related to lifecycle sponsored programs management to ensure accurate data reporting. The position will also be responsible for the evaluation, testing, and functional support of systems used by the Division of Research to ensure data integrity.
Sponsored Research Data Analysis & Reporting (50%)
Sponsored Research Data Analysis & Reporting (50%)
- Assist with ongoing data analysis and reporting activities for internal and external constituents.
- Generate all lifecycle sponsored program reports including proposal and award tracking and reporting, UNC System office reporting, financial reporting, and requested ad hoc reporting.
- Analyze sponsored research data to identify inconsistencies, trends, reporting issues, and opportunities for process or system improvements.
- Work with internal offices and stakeholders on high-level sponsored program activities involving technology transfer, compliance, legal, academic affairs, and other areas that rely on research administration data.
- Support the development, maintenance, and validation of reports used to monitor sponsored research activities and inform institutional decision-making.
- Collaborate with the Data Reporting and Business Systems team to ensure that research administration data is accurate, reliable, and appropriately represented in reports and other analytical products.
Business Analysis & Sponsored Research Systems & Financial Applications (25%)
- Partner with OneIT, campus stakeholders, and Division of Research subject matter experts to analyze business needs and resolve issues involving systems that support the post-award lifecycle of sponsored programs.
- Work with the OneIT Financial Systems Support Team to identify, troubleshoot, and resolve issues related to sponsored research awards in Banner in order to maintain accurate data for reporting.
- Serve as the primary lead for account code and program code issues associated with sponsored awards in Banner and NinerResearch. Develop processes to correct related errors.
- Work with OneIT and other campus stakeholders to identify and resolve data reporting and system issues in Banner, including errors in Data Integrity reports, PIFA reports, and sponsored award grant numbers.
- Work with Division of Research subject matter experts to assess how system implementations and integrations may impact proposals, awards, and financial compliance data.
- Evaluate emerging technologies and system capabilities to identify opportunities to improve reporting needs and streamline data entry processes to support future organizational needs.
Testing, Quality Assurance & Technical Support (25%)
- Develop and execute testing plans and strategies for eRA modules and related systems to ensure sponsored research data accuracy and integrity.
- Coordinate with the Data Reporting & Business Systems Lead Analyst, IT teams, and Division of Research subject matter experts to test system changes, enhancements, implementations, and integrations prior to production deployment.
- Evaluate system changes for potential impacts to research administration processes, financial transactions, reporting, and compliance.
- Provide technical and functional support to users and subject matter experts and coordinate issue resolution across functional and technical teams as it relates to sponsored research data.
- Other duties as assigned.