Financial Aid Business Analyst (Data Analyst)

Within the Institutional Analytics (IA) division, the Compliance and Reporting team is comprised of institutional research, decision support, and analytic professionals at Indiana University. The primary responsibilities of the area entail mandated (Federal, State, and accreditor) and external reporting, decision support reporting for university leadership, and the data architecture and rendering of the underlying student data structures for the institution.

Learn more about the IA team here.

Job Summary

As a Financial Aid Business Analyst on the IA Compliance and Reporting team, the incumbent will be responsible for the following:

Department-Specific Responsibilities

• Leverages knowledge of financial aid policies and processes, other student data, and financials data to effectively collect and understand report requirements; analyzes and identifies the appropriate data to satisfy report requests; and produces accurate, clear, and well-informed reports of financial aid data for standard and ad hoc requests.
• Defines, creates, and publishes financial aid and other institutional data views to serve all campuses, in perpetuity. These data views and analytical reports serve as the official data representations for IU to both internal and external stakeholders.
• Serves as a resource for employees needing information about financial aid tables, data groups, and fields. Creates and updates reports and business processes documentation.
• Supports the Institutional Analytics office by researching and staying up-to-date on federal, state, and external survey policies associated with financial aid that may affect data reporting within the university. This is done in collaboration with the University Financial Aid Office.
• Develops and generates complex data extracts from the IU Student Information System (Oracle/Peoplesoft) and the IU data warehouse (DSS and/or ODS tables) environments to address financial aid and institutional reporting/decision support needs and mandated compliance reporting. University administration relies upon this work for decision support and evaluative analytics.
• Collaborates with other units within Institutional Analytics to support data literacy programming and broaden the accessibility of critical information needed for campus constituents.

General Responsibilities

• Provides experienced analysis of existing data and data structures and satisfies ad-hoc reporting/analysis requests.
• Creates reporting specifications for new reports/dashboards/analytical tools and performs testing/validation; ensures integrity, accessibility, and accuracy of reports/dashboards and data structures; reviews and approves user requests for access to reporting data and tools.
• Consults with faculty and/or staff to identify new business reporting needs and provides guidance and interpretation of complex environments and data.
• Documents data analysis efforts (data sources, reporting specifications, tools, issue/problem resolutions).
• Performs experienced analysis to interpret and determine validity and quality of data.
• Performs migration and conversion of data as needed in support of analysis efforts.
• Researches and stays up-to-date on emerging technologies and tools and makes recommendations for implementation to improve data analysis services and approaches.

Qualifications

Combinations of related education and experience may be considered. Education beyond the minimum required may be substituted for work experience. Work experience beyond the minimum required may be substituted for education.

EDUCATION

Required

• Bachelor's degree

Preferred

• Degree in computer science, information science, or related field
• Master's degree or a certificate in institutional research or higher education and student affairs

WORK EXPERIENCE

Required

• 2 years of data analysis, reporting, or related experience

Preferred

• 2 years of experience in higher education with knowledge specifically related to student financial aid
• 2 years of experience developing and maintaining student data reporting systems and infrastructure in a large, complex institution, preferably at a school that uses PeopleSoft for their student data system

LICENSES AND CERTIFICATES

Preferred

• NASFAA certification for financial aid professionals

SKILLS

Required

• Proficient communication skills
• Maintains a high degree of professionalism
• Demonstrates time management and priority setting skills
• Demonstrates a high commitment to quality
• Possesses flexibility to work in a fast paced, dynamic environment
• Seeks to acquire knowledge in area of specialty
• Highly thorough and dependable
• Demonstrates a high level of accuracy, even under pressure

Preferred

• Strong student financial aid background
• Proficiency using SQL or other relational database reporting tools
• Strong technical expertise in data management, development of database applications, and a basic understanding of business intelligence and relational database concepts
• Proficient use of Tableau and Excel
• Must be adept at learning new technologies and functionality of new systems
• Ability to maintain a high degree of confidentiality and ability to manage sensitive data

Working Conditions / Demands

This role requires the ability to effectively communicate and to operate a computer and other standard office productivity equipment. The position involves sedentary work as well as periods of time moving around an office environment and the campus. The person in this role must be able to perform the essential functions with or without an accommodation.

We ask that our remote employees have access to a reliable internet connection and a dedicated, properly equipped workspace at a fixed location within the United States that is free of distractions and dependencies.

Work Location

Bloomington, Indiana or Indianapolis, Indiana

This position is eligible for remote work or to work a hybrid schedule (mix between remote and in-person work), subject to change in the future based on university policy and business needs.

Benefits Overview

For full-time staff employees, Indiana University offers a wide array of benefits including:

• Multiple plan options for medical insurance
• Dental insurance
• Health Savings Account with generous IU contribution
• Life insurance, LTD, and AD&D options
• Base retirement plan contribution from IU, subject to vesting
• Additional supplemental retirement plan options
• Tuition benefit for IU classes
• 10 paid holidays per year
• Generous Paid Time Off
• Paid Parental Leave
• Employee Assistance Program (EAP)

Learn more about our benefits by reviewing our online Benefits Brochure .

Job Classification

Career Level: Career

FLSA: Exempt

Job Function: Information Technology

Job Family: Data Analysis & Engineering
Click here to learn more about Indiana University's Job Framework.

Posting Disclaimer

This posting is scheduled to close at 11:59 pm EST on the advertised Close Date. This posting may be closed at any time at the discretion of the University, but will remain open for a minimum of 5 business days. To guarantee full consideration, please submit your application within 5 business days of the Posted Date.

If you wish to include a cover letter, you may include it with your resume when uploading attachments.

Equal Employment Opportunity

Indiana University is an equal employment and affirmative action employer and a provider of ADA services. All qualified applicants will receive consideration for employment based on individual qualifications. Indiana University prohibits discrimination based on age, ethnicity, color, race, religion, sex, sexual orientation, gender identity or expression, genetic information, marital status, national origin, disability status or protected veteran status. Indiana University does not discriminate on the basis of sex in its educational programs and activities, including employment and admission, as required by Title IX. Questions or complaints regarding Title IX may be referred to the U.S. Department of Education Office for Civil Rights or the university Title IX Coordinator. See Indiana University's Notice of Non-Discrimination here which includes contact information .

Campus Safety and Security

The Annual Security and Fire Safety Report, containing policy statements, crime and fire statistics for all Indiana University campuses, is available online . You may also request a physical copy by emailing IU Public Safety at or by visiting IUPD.

Contact Us

Request Support
Telephone:

Apply for Job

• Staff Positions
• Sign In
• New User
• Enable Screen Reader Mode