Ga - Pre-Professional - Office Of Technology Solutions - Data Analyst - Fall 2024

Title: GA - Pre-Professional - Office of Technology Solutions - Data Analyst - Fall 2024
Division Name: Finance and Planning
Department:Office of Technology Solutions
Campus Location: Normal, IL

The Graduate Assistant Data Analyst is responsible for assisting with data analysis, data warehouse development, and data governance 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. A fundamental understanding of relational and dimensional data structures as well as an understanding of databases (e.g. Oracle, SQL) will be expected.
The Graduate Assistant Data Analyst will also have responsibilities for supporting faculty with their data analysis, statistical consulting, and data visualization needs related to their research interests. This includes also supporting faculty who are interested in statistical methodologies, available statistical software, ways to visualize their data results, and other resources as part of their research.
Essential:
30% - Data Analytics:
Create/modify SQL queries from multiple sources for assigned projects.
Identify trends and relationships among data.
Create/modify predictive models, sentiment analysis, and statistical results.
30% - Statistical Consulting and Research:
Provide statistical and data consulting services to faculty researchers. This includes, but is not limited to consulting on statistical methodologies, making recommendations on appropriate software, and providing 1:1 support for research needs of faculty members. The GA will also seek to encourage and support in-depth collaborative research projects, and to increase the quality of quantitative and qualitative research performed at the ISU
20% - Documentation:
Maintain documentation for the data analysis completed.
Assist in translating business requirements to technical specifications.
10% - Research:
Research Business Intelligence tools, processes, and methodologies and provide summary reports as requested.
Marginal:
10% - Perform other duties as assigned

The work environment for this position has the standard computer-related discomforts including eye strain from viewing a computer screen for long periods of time and wrist strain from repetitious hand movements on a keyboard and mouse.
The scope of responsibility and workload of this position can be very stressful.
Weekend or after-hours work may be required to support change management or disaster recovery.
Overnight travel (2-5 days) for training and/or professional development is infrequent but may be required.

$1473 monthly

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 in the following categories.
Masters Programs (M.S., M.A., MBA)
Biological Sciences
Biomathematics
Biotechnology
Applied Economics
Quantitative Economics
Economics - Financial Economics
Geographic Information Systems
Math - Applied Statistics
Mathematics
Information Systems - Systems Development (M.S., M.A.)
Technology - Quality Management and Analytics (M.S., M.A, GCert)
3. Possess strong interpersonal skills to gather and analyze large amounts of detailed information and summarize for reporting and presentation
4. Demonstrated experience with statistical or data visualization software
5. Possess strong self-motivated analysis and problem-solving disposition with the ability to synthesize findings into communicable actions and recommendations
6. Manage project-related tasks and monitor progress and results
7. Possess an understanding of structured, semi-structured data solutions and familiarity with operational and analytical database concepts.
8. Able to read and write SQL queries.
9. Ability to complete research and clearly document and communicate findings related to data warehousing, reporting, analytics or data governance.
10. Possess experience with Microsoft Excel and Microsoft Word

1. Demonstrated experience with statistical software applications including, but not limited to at least one of the following: SPSS, SAS, Stata, Matlab
2. Demonstrated experience with GIS software
3. Demonstrated experience with data analytics programming in Python, R Studio, or Spark.
4. Demonstrated experience with data reporting tools, such as PowerBI, Tableau, and/or Cognos
5. Demonstrated experience with statistical analysis and understanding of appropriate statistical methodologies
6. Familiarity with data governance concepts.
7. Experience with data analysis, data profiling, and data cleansing.

Any schedule Monday - Friday, 8:00am - 5:00pm

August 2024

Resume / C.V.
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"

Note: If you have not yet been assigned a University ID, but are interested in applying for this graduate assistantship, please proceed with the graduate assistant application process. For the first question regarding your University ID, simply enter in nine (9) zeros (e.g., 000000000).
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.

Traci Zagaroli, tdrigsb@ilstu.edu

This position is subject to a criminal background investigation and if applicable, an employment history review, based on University Policy 3.1.30 and any offer of employment is contingent upon you passing a satisfactory criminal background investigation and/or an employment history review. You may not begin work until the criminal background investigation results have been received and cleared by Human Resources.

Illinois State University is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

If you are an individual with a disability and need a reasonable accommodation under the Americans with Disabilities Act (ADA) or other state or federal law you may request an accommodation by contacting the Office of Equal Opportunity and Access at (309) 438-3383. The Office of Equal Opportunity and Access will hold any confidential information you provide in confidence.

If you are having difficulty accessing the system, please call Human Resources at (309) 438-8311.