Data Analyst - Sponsored Programs Administration

Duties

Responsibilities

Analyze sponsored program data including proposal, award, and expenditure volume, administrative process performance, and compliance and regulatory indicators to identify trends, evaluate performance, and inform decision-making by SPA and campus research leadership; develop, run, and maintain the ad hoc and standard reports that support this analysis, drawing on data from Banner, Kuali-based START, and SPA’s homegrown applications; manage user access and security for reports and dashboards.

Design, build, and maintain data visualizations and dashboards, primarily using Power BI, translating sponsored program data into clear, actionable insight for SPA leadership and campus stakeholders; leverage AI-assisted features to accelerate analysis and report development; provide training and support to enable self-service reporting and dashboard use.

Support data pipelines and integrations using Azure Data Factory, developing and applying manual and automated verification and validation checks to ensure the accuracy and integrity of sponsored program data as it moves across systems; assist with transforming and migrating data from legacy MS Access databases to SQL Server and Denodo; build and maintain Denodo views for data virtualization.

Develop functional expertise in sponsored program pre-award and post-award business processes to inform data and reporting work; create and maintain documentation and a data dictionary for key terms, fields, and report logic; respond to user requests for reporting and data assistance in a timely, professional manner. Apply project management techniques to plan, prioritize, and track multiple concurrent reporting and analysis requests. Perform other duties as assigned, consistent with the mission of Sponsored Programs Administration and the University.