Sponsored Programs Data Analyst — BI Dashboards & AI

Laseagrant; Urbana (IL); Hybrid; USD 75,000 - 90,000; Full time

Job summary

University of Illinois Urbana-Champaign is seeking a Data Analyst in Sponsored Programs Administration to analyze proposal, award, and expenditure data and produce secure reports and visualizations.

The role combines domain knowledge of the sponsored research lifecycle with technical skills in reporting, BI, and data management, translating data from Banner, START myProposals, and SPA apps into actionable insights.

Qualifications

• Bachelor’s degree in Statistics, Data Science, Data Analytics, Computer Science, Information Systems, or a closely related field.
• Two years of experience writing and optimizing SQL queries against relational databases such as SQL Server and Oracle.
• Experience building reports and dashboards using Power BI, Tableau, or similar BI tools.
• Experience with ad hoc reporting and data analysis to support decision-making.

Responsibilities

• Analyze sponsored program data including proposal, award, and expenditure volume, administrative process performance, and compliance indicators to inform decisions and create reports and dashboards.
• Design, build, and maintain data visualizations and dashboards using Power BI for SPA leadership and campus stakeholders; leverage AI-assisted features as appropriate.
• Support data pipelines and integrations using Azure Data Factory and assist with migrations from legacy systems; build Denodo views for data virtualization.
• Develop functional expertise in sponsored program pre-award and post-award processes and maintain documentation and a data dictionary.
• Respond to user reporting requests in a timely, professional manner and manage multiple requests.

Skills

SQL

Power BI

Data visualization

Ad hoc reporting

Education

Bachelor’s degree

Tools

Azure Data Factory

Denodo

MS Access/SQL Server

Job description

University of Illinois Urbana-Champaign is seeking a Data Analyst in Sponsored Programs Administration to analyze proposal, award, and expenditure data and produce secure reports and visualizations.

The role combines domain knowledge of the sponsored research lifecycle with technical skills in reporting, BI, and data management, translating data from Banner, START myProposals, and SPA apps into actionable insights.