GA Pre-Professional - Data Analyst

Title: GA Pre-Professional
- Data Analyst
- Spring 2027
Division Name: Finance and Planning
Department: Decision Support
Campus

Location:

Normal, IL

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.

• 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.

• 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.

• 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.

• 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.

• 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.

Perform other duties as assigned

$1510 monthly stipend

1. Eligible for appointment as per the requirements in the Graduate Assistant Handbook, which can be found at (Use the "Apply for this Job" box below)..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
2. Demonstrated experience with data reporting tools, such as PowerBI, Tableau, and/or Cognos
3. Demonstrated experience with statistical analysis and understanding of appropriate statistical methodologies
4. Familiarity with data governance concepts.

TBD

January 2027

1. Resume
2. Cover Letter
3. Reference List

Please Note
:
These documents are required to be submitted online in order to complete the application process. Please have these documents ready prior to clicking on "Apply"

Benefits for Graduate Assistants can be found in the Graduate Assistant Handbook.

Note:

If you have not yet been assigned a University , but are interested in applying for this graduate assistantship, please proceed with the graduate assistant application process. For the first question regarding your…