SQL Academic Reporting Specialist

  • Hawkeye Community College
  • Waterloo, IA
  • Apr 21, 2022
Full time Information Systems

Job Description

Job Summary

Are you passionate about analytics?  Do you love the challenge of building reports?  Do you enjoy all things academic? 

 

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

 

The SQL Academic Reporting Specialist provides support to the Institutional Research (IR) Office in accreditation data reporting, as well as supporting the IR Office with data compliance checks to ensure data integrity. This position implements techniques and analytics to transform raw data into user-friendly reports which may incorporate the use of various programming languages and visualization software.

 

This position also designs, develops, optimizes, maintains and supports ETL processes using data warehouse design best practices and SQL Server Integration Services (SSIS) to integrate data from multiple source systems into a Data Warehouse, cleansing data, transforming and loading data from multiple formats using SSIS and stored procedures. Additionally, advanced SQL reporting skills for utilization of charts, drill-downs, hyperlinks and condition color-coding will be used on a daily basis.  This position works closely not only with their supervisor but with stakeholders as well on requirements and functional specifications to understand reporting priorities and user outcome parameters.

 

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 “PROVIEW2”.
  • Produces reports for analysis of student trends and performance.
  • Develops reports for tracking student academic program cohort persistence, retention, completion, and transfer-out data.
  • Develops reports using student learning outcome data from the College LMS system for reporting to accrediting bodies.
  • Responsible for Student Outcomes reporting with inclusion of student transfer data.
  • Responsible for updates to advisory committee database system.
  • 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.
  • Establishes reporting efficiencies to serve academic deans and administrative assistants for review of student and program related data.
  • 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, and Ellucian/Colleague.
  • Writes and troubleshoots SQL Code and design stored procedures, functions, tables, views, triggers, indexes, and constraints. Knowledge and ability to schedule jobs. Investigates, analyzes, and prioritizes data and uses both technical and interpersonal skills to draft and propose effective solutions.
  • Troubleshoots any problems that arise from the reports, the database, the software, and software configuration.
  • Writes queries to extract data and data structures of the system.
  • 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.
  • Checks the accuracy of data from reports.
  • 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., training support handouts, field definitions, etc.).
  • Actively participates in cross-training functions as both teacher and student.
  • Performs other duties as assigned.

 

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.

 

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 a choice of retirement programs—IPERS (defined benefit) or TIAA (defined contribution).

 

Working Conditions

Requires skills for succeeding in an office environment, 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. Work is performed in an office setting. Sit, stand, bend, lift and move intermittently during working hours. During course of day, interact with student, faculty and staff in person, by telephone and computers.

Application Procedure

  • Complete an online application at hawkeyecollege.edu/employment
    • Submit/upload a resume.
    • Submit/upload 3 references with a minimum of 1 being from a current/past supervisor.
    • Submit/upload a cover letter addressing the following:
      • Detail your experience with SQL/Visual Studio/Reporting Services (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 the online application and all required materials by Thursday, May 12, 2022. Preference will be given to applicants who submit the required materials on or before May 12th.  This position will remain open until filled.  

Hawkeye Community College is an equal opportunity and affirmative action employer, committed to equity and diversity in its educational services and employment practices: https://www.hawkeyecollege.edu/about/diversity-inclusion/equal-opportunityThe 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.

Listing Logo