Degree in Higher Ed Admin, Computer Science, Business Analytics, or Business Administration. Experience with Web based reporting and Business Intelligence tools.
The Office of Student Financial Aid at Iowa State University is seeking a Data Analyst I or Data Analyst II to provide research and data analysis for institutional leaders and data preparation for required reporting. The Data Analyst provides timely data to the Director of Student Financial Aid to direct the strategic use of student financial aid. The team contributes to a university wide culture of data-informed decision making by collaborating with the offices of Enrollment Research and Analytics, Institutional Research, and Information Technology to provide relevant data and analysis to campus partners and campus leaders.
Duties for the Data Analyst position include maintaining the financial aid database by weekly downloading and storing new files; assist with data validation for transfer to new platform; creating reports and conducting analysis using a variety of data sources and tools (e.g. Power BI, Cognos 11, MS Excel, MS Access, Stata, Workday, etc.); compiling institutional data for internal and external reports and data submissions; maintaining and creating new data visualizations and reports for administrators and the university community utilizing MS Excel, Power BI, and Workday; request custom IT reports for appropriate award year to assist with annual compliance reports/surveys; assign accounting codes to awards for tracking and reporting purposes; Â preparing reports and analysis of institutional data and survey results; Create templates in MS Excel to assist with award calculation/tracking; providing support in compiling, managing and analyzing data to inform departmental policy discussions; and responding to ad hoc requests from constituents across campus.
The university seeks a professional with a commitment to and understanding of the academic mission, possess critical thinking skills to ensure consistency and accuracy of methods employed, attention to detail, and possess the ability to explain data to multiple audiences with differing levels of understanding. The Data Analyst will have the ability to work both independently and as part of a team and must have the capacity to work well in a fast-paced, deadline driven environment.Â Must be self-motivated and exhibit patience in supporting the identification, resolution, and documentation of process issues.
This position will be filled at the I or II level.
Data Analyst I Minimum Requirements: Bachelor's Degree and is a PS807 pay level.
Data Analyst II Minimum Requirements: Bachelorâs degree and 3 years of related experience and is a PS808 pay level.
Level I Example of Duties â¢ Gathers operational data to examine past organization performance. â¢ Assist in the preparation, cleansing, and verification of data. â¢ Perform basic data manipulation and analysis techniques. â¢ Develops and analyzes organizational data to quantify the competitive performance of business segments, evaluate potential operational changes, and design new approaches and methodologies. â¢ Applies and integrates statistical, mathematical, predictive modeling and business analysis skills to manage and manipulate high volume data from a variety of sources. â¢ Recommends actions for future developments & strategic business opportunities, as well as enhancements to operational policies. â¢ May be involved in exploratory data analysis, confirmatory data analysis and/or qualitative analysis.
Level II Example of Duties â¢ Gathers operational data to examine past organization performance. â¢ Assists in the preparation, cleansing, and verification of data. â¢ Performs data manipulation and analysis techniques. â¢ Develops and analyzes organizational data to quantify the competitive performance of business segments, evaluate potential operational changes, and design new approaches and methodologies. â¢ Applies and integrates statistical, mathematical, predictive modeling and business analysis skills to manage and manipulate high volume data from a variety of sources. â¢ Recommends actions for future developments & strategic business opportunities, as well as enhancements to operational policies. â¢ Develops and maintains complex data storage structures needed to support data warehouse functions. â¢ Trains and assists users, managers and technical staff regarding access, use and storage of data and maximizing database design effectiveness. â¢ May be involved in exploratory data analysis, confirmatory data analysis and/or qualitative analysis.
Level I Level Guidelines â¢ Individual contributor position with developing professional and/or technical skills working under immediate to general supervision â¢ Grasps professional-level knowledge and concepts of field while working in a progressive learning mode â¢ Works on problems and issues of somewhat limited scope â¢ Follows standard practices and procedures in analyzing situations or data for which answers are available or can be obtained â¢ Responds to inquiries and issues, escalating to manager or higher level workers as appropriate â¢ May lead projects of limited scope and complexity â¢ May provide guidance to students
Level II Level Guidelines â¢ Intermediate-level position with solid professional and/or technical skills working under general supervision to achieve goals â¢ Applies broad, working knowledge of the principles of the field to moderately complex, difficult, and varied problems and issues â¢ Exercises judgment within defined procedures and practices to determine appropriate action and resolve problems â¢ Responds to a broad range of inquiries and requests â¢ May provide training and/or direction to lower-level staff â¢ May lead projects of moderate scope and complexity â¢ Provides guidance to students
Number of Months Employed Per Year:
12 Month Work Period
To apply for this position, please click on âApplyâ and complete the Employment Application. Please be prepared to enter or attach the following:
1) Resume/Curriculum Vitae 2) Letter of Application/Cover Letter
If you have questions regarding this application process, please email email@example.com or call 515-294-4800 or Toll Free: 1-877-477-7485.
Why Choose ISU? Iowa State University is committed to fostering a workplace of belonging, where diversity is celebrated and equity is a core value. Our Iowa State Employees enjoy comprehensive health and work life benefits, including medical and dental; as well as: â¢ Retirement benefits including defined benefit and defined contribution plans â¢ Generous vacation, holiday and sick time and leave plans â¢ Onsite childcare (Ames, Iowa) â¢ Life insurance and long-term disability â¢ Flexible Spending Accounts â¢ Various voluntary benefits and discounts â¢ Employee Assistance Program â¢ Wellbeing program â¢ This job may also be eligible for flexible work schedules and flexible workplace options that may include flexible working hours and a hybrid working environment.
Iowa State University is classified as a Carnegie Foundation Doctoral/Research University-Extensive, a member of the Association of American Universities (AAU), and ranked by U.S. News and World Report as one of the top public universities in the nation. Over 36,000 students are enrolled and served by over 6,200 faculty and staff (see www.iastate.edu). Ames, Iowa is a progressive community of 60,000, located approximately 30 minutes north of Des Moines, and recently voted the best college town in the nation (see www.visitames.com).
Iowa State University is an equal opportunity employer committed to excellence through diversity and strongly encourages applications from all qualified applicants, including women, underrepresented minorities, and veterans. ISU is responsive to the needs of dual career couples, is dedicated to work-life balance through an array of policies, and is an NSF ADVANCE institution.
Iowa State University is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, or protected Veteran status and will not be discriminated against.