GA Pre-Professional - Data Analyst - Spring 2027

The Graduate Assistant Data Analyst is responsible for assisting with data analysis, data validation, data warehouse development, data governance, and business intelligence assignments. This includes SQL development and analytics of data from a variety of sources. Performs research and analysis of data warehouse and business intelligence solutions. This also includes documentation of the databases, tables, fields and BI solutions. Responsibilities may include performing data quality assurance testing, validating data against business requirements, identifying and resolving data discrepancies, documenting processes, creating dashboards and reports, and helping uncover trends and insights that support business objectives. Fundamental understanding of relational and dimensional data structures as well as an understanding of databases (e.g. Oracle, SQL) will be expected., 30% - Data Analysis & Reporting

• Assist in analyzing data from multiple data sources.
• Develop and execute SQL queries to extract, transform, and analyze data.
• Identify trends, patterns, and insights that support business and operational decision-making.
• Support ad hoc reporting and analytical requests from stakeholders.

20% - Data Quality & Validation

• Perform data quality assurance testing to ensure data accuracy, consistency, and completeness.
• Validate data against established business requirements and specifications.
• Identify, research, troubleshoot, and resolve data discrepancies and inconsistencies.
• Assist in maintaining data quality standards and best practices.

20% - Data Governance & Documentation

• Support data governance initiatives through documentation and process improvement efforts.
• Create and maintain documentation for databases, tables, fields, reports, dashboards, and data definitions.
• Assist in developing and maintaining data dictionaries and metadata documentation.

10% - Data Warehouse & Database Support

• Assist with the development, maintenance, and enhancement of data warehouse structures.
• Support data integration processes between source systems and the data warehouse.
• Work with relational and dimensional data models to support reporting and analytics needs.

10% - Research & Business Intelligence

• Create dashboards, visualizations, and reports using business intelligence tools.
• Collaborate with staff to gather business requirements and translate them into analytical solutions.
• Support the design and implementation of data-driven solutions to meet organizational objectives.

10% - Perform other duties as assigned

1. Eligible for appointment as per the requirements in the Graduate Assistant Handbook, which can be found at http://hr.illinoisstate.edu/downloads/GA_Handbook.pdf
2. Must be a degree-seeking graduate student at Illinois State University
3. Ability to gain knowledge in a variety of data sources
4. Experience with data analysis, data profiling and data cleansing.
5. Possess strong self-motivated analysis and problem-solving disposition with ability to synthesize findings into communicable actions and recommendations
6. Ability to manage project related tasks and monitor progress and results
7. Possess understanding of structured, semi-structured data solutions and familiarity with operational and analytical database concepts.
8. Able to read and write SQL queries., 1. Demonstrated experience with data analytics programming in Python or R
9. Demonstrated experience with data reporting tools, such as PowerBI, Tableau, and/or Cognos
10. Demonstrated experience with statistical analysis and understanding of appropriate statistical methodologies
11. Familiarity with data governance concepts., You must be eligible for employment in the United States and at Illinois State University and/or for the number of hours required for the position.

Illinois State University student employees are restricted to no more than 28 hours per week of on-campus employment for all positions held. International students are restricted by their visa status to no more than 20 hours per week of on-campus employment when the university is in session but may work up to 28 hours per week when the university is not in session. Please contact the Office of International Student and Scholar Services for guidance on visa restrictions on work hours. The University cannot grant exceptions to visa status rules/laws.