Job Description

Job Summary

The SQL Accreditation & Compliance Reporting Specialist provides support to the Institutional Research (IR)Office. The Institutional Research Office is responsible for the accreditation of the College with State and Regional accrediting bodies. In addition to accreditation data reporting, this position supports the IR Office with data compliance checks to ensure data integrity. This position requires the ability to implement techniques and analytics to transform raw data into user-friendly reports which may incorporate the use of various programming languages and visualization software. Advanced SQL reporting skills for utilization of charts, drill-downs, hyperlinks and condition color-coding is used on a daily basis. Design, develop, optimize, maintain and support 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. Work closely with supervisor and stakeholders on requirements and functional specifications to understand reporting priorities and user outcome parameters.

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.
• Ability to write and troubleshoot 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., FAX, 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 knowledge and experience in using Visual Studio/Reporting Services.
• Demonstrated advanced skills in the use of Microsoft SQL Server administration, maintenance, and database design.
• 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 students, faculty, staff and vendors.
• Demonstrated strong organizational skills with exceptional follow through and attention to detail.
• Demonstrated high 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

• Experience in working with Ellucian/Colleague.
• Experience in a post-secondary educational setting.

Employment Status (generally completed by HR)

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 online application at hawkeyecollege.edu/employment including a resume, 3 references with a minimum of 1 being a current/past supervisor and 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 an online application and all required materials by February 27^, Preference will be given to applicants who apply on or before February 27^th. The 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-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 

eq************@ha************.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: 

OC*********@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.

How to Apply

• Complete online application at hawkeyecollege.edu/employment including a resume, 3 references with a minimum of 1 being a current/past supervisor and 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 an online application and all required materials by February 27^, Preference will be given to applicants who apply on or before February 27^th. The position will remain open until filled.

Job Categories: Equal Opportunities. Job Types: Full-Time. Salaries: Not Disclosed.

267 total views, 0 today

Apply for this Job