Academic Data Analyst

Driven by data? All about analytics? Revved up over research? If so, Hawkeye Community College has a great opportunity for you!

The Institutional Research Office, which is responsible for the accreditation of the College with State and Regional accrediting bodies, is looking for an Academic Data Analyst to join their team.

The Academic Data Analyst provides support to our Institutional Research (IR) Office in reporting data to the state department of education and the Higher Learning Commission, as well as supporting our IR Office with data compliance checks to ensure data integrity. Additionally, in this role you will implement techniques and analytics to transform raw data into user-friendly reports for departments across Hawkeye’s campus. You will also assist and administer various college-wide surveys such as PACE and SmartEvals. Furthermore, as the Academic Data Analyst, you will design, develop, and maintain ETL processes using data warehouse design best practices.

Hawkeye Community College is a comprehensive community college focused on meeting the needs of the community by providing quality, affordable learning experiences for a diverse student body through our Adult Learning Center, Business and Community Education Department as well as through more than 50 career and technical programs and liberal arts transfer programs. Hawkeye Community College’s mission is about empowering students, strengthening businesses and enriching communities with a vision to improve the quality of life in the communities we serve.

Essential Job Functions

Important responsibilities and duties may include, but are not limited to, the following:

• Responsible for development of accreditation compliance data reports.

• Creates specialized reports for academic program analysis, oversees programming of academic program review system, and the advisory committee database system.

• Produces reports for analysis of student trends and performance such as tracking student academic program cohort persistence, retention, completion, and transfer-out data using the College LMS system, the National Student Clearinghouse, and other data resources.

• Provides oversight and programming updates of the College Enrollment Report.

• Collaborates with academic leaders in development of reports for analysis in improving outcomes and services to students.

• Responsible for development, production maintenance, and reporting of institutional data using Microsoft SQL Server 2012/2016 and SQL Reporting Services with extensive use of Visual Studio.

• Requires working with database structures and modeling, query tools, report writers and customer report programming. The tools used include SQL Server Management Studio, Business Intelligence Development Studio, Analysis Services, SQL, Transact SQL, Entrinsik Informer and Ellucian/Colleague.

• Writes and troubleshoots SQL Code and design stored procedures, functions, tables, views, triggers, indexes, constraints, and scheduled jobs.

• Writes queries to extract data and data structures of the system and troubleshoots problems that arise from reports, the database, software and the software configuration.

• Develops, manages, and maintains reports and/or data extracts for use by individual users (e.g. assessment information, enrollment, student progress, etc.) for the purpose of providing information customized to meet specific needs.

• Maintains .NET programs.

• Works with college representatives to design, create, implement, and maintain reporting capabilities and standards.

• Works closely with technical and non-technical end users, gathering ad hoc reporting requirements, converting requirements into technical specifications, and training how to produce and use reports.

• Collaborates in development of user materials (e.g., FAX, training support handouts, field definitions, etc.).

• Participates in cross-training functions as both teacher and student.

• Performs other duties as assigned.

• Unless otherwise approved under Hawkeye’s remote work policy, regular on campus and/or onsite attendance is considered an essential function of the position.

Minimum Qualifications

• Associates degree in a related field and two years of relevant work experience OR an equivalent combination of education and experience to total 4 years.

• Demonstrated experience in programming with working knowledge to include Microsoft SQL Server /Reporting Services.

• Demonstrated ability to maintain and improve editing of .NET applications.

• Demonstrated ability to prioritize projects and manage resources.

• Demonstrated excellent written and verbal communication skills to positively interact with faculty, staff and vendors.

• Demonstrated strong organizational skills with exceptional follow through and attention to detail.

• Demonstrated proficiency in Microsoft Office Excel as well as other Microsoft Office and Google Suite programs.

• A demonstrated commitment to diversity, equity, and inclusion through inclusive behaviors and helping contribute to a culture of inclusivity, and a vibrant, diverse, equitable and inclusive learning and working environment.

Preferred Qualifications

• Bachelor’s degree in a related field.

• Demonstrated working knowledge of ERP Systems such as Ellucian/Colleague, etc.

• Experience in a post-secondary educational setting.

• Demonstrated knowledge and experience in using Visual Studio and/or Entrinsik Informer.

Working Conditions

Anticipated schedule is Monday – Friday 8 am – 4:30 pm.

Work is performed either in or a combination of an office setting and/or classroom setting using technology. Requires good hand-eye coordination including visual acuity to use a keyboard and read technical information; arm, hand and finger dexterity, including ability to grasp. Sit, stand, bend, lift and move frequently during working hours. During course of day, interact with students, faculty and staff in person, by telephone and computers.

Employment Status

Full time, exempt position with comprehensive or competitive benefits program including health, dental, vision, life, and LTD insurance, a Section 125 plan for medical and dependent care expenses; holiday, personal, sick, and vacation leave; tuition reimbursement and/or remission; and a choice of retirement programs—IPERS (defined benefit) or TIAA (defined contribution).

Application Procedure

• Complete an online application at www.hawkeyecollege.edu/employment

  • Submit/upload a cover letter addressing the following:

    • Detail your experience with SQL/Visual Studio/Reporting Services/Informer (designing, creating, implementing and maintaining).

    • Describe your level of experience with various computer software. Please be detailed and specific on the most recent versions of the software you have used.

    • Describe responsibilities you have had in meeting deadlines, developing and scheduling multiple projects, data validation/integrity, and time management.

    • Explain your level of involvement and experience with providing data/reports for compliance and/or accreditation.

  • Submit/upload a resume.

  • Submit/upload 3 professional references with a minimum of 1 being from a current/past supervisor.

• All required documents must be submitted in order for your application to move forward.

• Priority screening is set to begin on Thursday, August 10, 2023. Completed applications, along with the required materials, received after the priority screening date will be considered at the discretion of the college.

All application materials must be submitted by Wednesday, August 9, 2023 by 11:59 PM CST.

Hawkeye Community College is an equal opportunity and affirmative action employer, committed to equity and diversity in its educational services and employment practices: hawkeyecollege.edu/about/diversity-inclusion/equal-opportunity. The College does not discriminate on the basis of sex; race; age; color; creed; national origin; religion; disability; sexual orientation; gender identity; genetic information; or actual or potential parental, family, or marital status in its programs, activities, or employment practices. Veteran status is also included to the extent covered by law. Any person alleging a violation of equity regulations shall have the right to file a formal complaint. Inquiries concerning application of this statement should be addressed to: Equity Coordinator and Title IX Coordinator for employees, 319-296-4405; or Title IX Coordinator for students, 319-296-4448; Hawkeye Community College, 1501 East Orange Road, P.O. Box 8015, Waterloo, Iowa 50704-8015; or email equity-titleIX@hawkeyecollege.edu, or the Director of the Office for Civil Rights, U.S. Department of Education, Citigroup Center, 500 W. Madison, Suite 1475, Chicago, IL 60661, phone number 312-730-1560, fax 312-730-1576, email: OCR.Chicago@ed.gov.

If any applicant is in need of a reasonable accommodation in completing the application process, please notify a member of Human Resource Services.