> Markdown version of [/jobs/ext/3864848-data-analyst-sponsored-programs-administration](https://www.wearedevelopers.com/jobs/ext/3864848-data-analyst-sponsored-programs-administration). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst - Sponsored Programs Administration - **Company:** University of Illinois Urbana-Champaign - **Location:** Urbana, IL, United States (Remote available) - **Experience:** Experienced - **Salary:** $75,000.0 - $90,000.0 - **Contract:** Temporary contract - **Skills:** Microsoft Access, ASP.NET, Artificial Intelligence, Data Analysis, C Sharp (Programming Language), Information Systems, Databases, Data Dictionary, Extract Transform Load (ETL), Data Migration, Data Systems, Data Virtualization, Data Visualization, Relational Databases, Entity Framework, Microsoft SQL Server, Oracle Databases, Oracle (Applications), Power BI, Software Engineering, Verification and Validation (Software), PL-SQL, Tableau (Software), Transact-SQL, Web Applications, Azure Data Factory, Information Technology, Banner Advertisement, Data Analytics, Data Management, Data Pipelines, Custom Reports - **Published:** October 22, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=dddd3c1afa10d7bc ## About the Role * Bachelor's Degree in Statistics, Data Science, Data Analytics, Computer Science, Information Systems, or a closely related field. * Two (2) years of experience writing and optimizing SQL queries (T-SQL, PL/SQL, or similar) 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., * Experience with Power BI specifically, including data modeling, DAX, and report/dashboard publishing and workspace administration. * Experience with sponsored research administration, grants management, or research compliance in a higher education or research institution setting. * Familiarity with the University's Banner ERP system and/or Kuali Research (START myProposals/myResearch). * Experience with Azure Data Factory or other ETL/data pipeline tools. * Experience with Denodo or other data virtualization/federation platforms. * Experience migrating or modernizing legacy MS Access databases to SQL Server or similar platforms. * Experience with Oracle databases. * Light application development experience (C#, ASP.NET Core, Entity Framework) sufficient to build, deploy, and maintain visualizations within a homegrown web application ecosystem., * Strong analytical and problem-solving skills, with attention to data accuracy and integrity. * Ability to translate functional/business requirements into technical reporting and data solutions. * Strong communication skills, with the ability to explain data and technical concepts to non-technical audiences. * Strong time management skills with the demonstrated ability to manage multiple concurrent reporting and analysis requests and to quickly re-prioritize based on user needs. * Proven ability to collaborate successfully as a member of a small team. * Proven record of customer service excellence. ## Description The best data analysts don't just understand data-they understand the people and processes behind it. As a Data Analyst with Sponsored Programs Administration, you'll develop deep expertise in the data, business processes, and systems that help support faculty across the University in their quest to secure and manage externally funded research. You'll work closely with colleagues to understand how they work, solve reporting challenges, improve access to information, and develop tools that make complex processes easier to navigate. This isn't a role where you'll simply produce reports-it's an opportunity to become a trusted partner, a problem solver, and a person others turn to when they need to understand the data behind the work., Reporting to the Senior Assistant Director of Data and Systems, the Data Analyst will primarily be responsible for analyzing sponsored program data including proposal, award, and expenditure activity, administrative process performance, and compliance and regulatory indicators and producing, maintaining, and securing reports and data visualizations that support Sponsored Programs Administration (SPA)'s pre-award and post-award functions. This position combines functional knowledge of the sponsored research lifecycle with technical expertise in reporting, business intelligence, and data management, and serves as a key resource for translating institutional research administration data drawn from the Banner ERP system, the Kuali-based START myProposals and myResearch portals, and SPA's homegrown applications into insights that inform decisions by SPA and campus research leadership. The role also creates and maintains documentation and a data dictionary for key data terms and report logic, trains staff on self-service reporting and dashboard use, and stays current with emerging AI-enabled data analysis and reporting capabilities., * 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.