Data Analyst - Hybrid/Remote Analytics & BI

University of Illinois Urbana-Champaign; Urbana (IL); Hybrid; USD 75,000 - 90,000; Full time

Job summary

University of Illinois Urbana-Champaign in Champaign-Urbana is seeking a Data Analyst for Sponsored Programs Administration to analyze proposal, award, and expenditure data and deliver actionable reports and dashboards. The role emphasizes data governance, BI development, and collaboration with campus leadership.

You will work in a hybrid/remote setup, leveraging Power BI, SQL, and Azure Data Factory to support pre-award and post-award processes, while building documentation and ensuring data

Qualifications

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

Responsibilities

• Analyze sponsored program data including proposal, award, and expenditure volume, administrative process performance, and compliance indicators; develop, run, and maintain ad hoc and standard reports; manage user access and security for reports and dashboards.
• Design, build, and maintain data visualizations and dashboards using Power BI; leverage AI-assisted features and provide training for self-service reporting.
• Support data pipelines and integrations using Azure Data Factory; verify data integrity across systems; assist with transforming and migrating data from legacy databases; build and maintain data virtualization views.
• Develop expertise in pre-award and post-award business processes; document data terms and report logic; respond to user requests for reporting; apply project management to plan multiple requests.

Skills

SQL

Power BI

Data Visualization

Data Analytics

ETL

Azure Data Factory

Education

Bachelor's Degree in Statistics, Data Science, Data Analytics, Computer Science, Information Systems

Tools

Banner ERP

Kuali START

myProposals / myResearch

SQL Server

Denodo

MS Access

Job description

University of Illinois Urbana-Champaign in Champaign-Urbana is seeking a Data Analyst for Sponsored Programs Administration to analyze proposal, award, and expenditure data and deliver actionable reports and dashboards. The role emphasizes data governance, BI development, and collaboration with campus leadership.

You will work in a hybrid/remote setup, leveraging Power BI, SQL, and Azure Data Factory to support pre-award and post-award processes, while building documentation and ensuring data