SQL Reporting Specialist
Communication and Information Systems
Reports To: Associate Director - Communication & Information Systems
The SQL Reporting Specialist is a member of the Communications and Information Systems Department (CIS). The CIS department maintains the College database systems and integrations with other systems. The SQL Reporting Specialist works with the Institutional Research department to create data reports for the College. Additionally, this position develops and implements a set of techniques or analytics applications to transform raw data into meaningful information using data-oriented programming languages and visualization software. This position will also apply data mining, data modeling, natural language processing, and machine learning to extract and analyze information from large structured and unstructured datasets. The SQL Reporting Specialist will visualize, interpret, and report data findings as well as be responsible for creating dynamic data reports.
Essential Job Functions
Important responsibilities and duties may include, but are not limited to, the following:
- Maintains SQL Server Reporting Services (SSRS) reporting software for the college.
- Translates a variety of reporting formats into SQL Server Reports.
- Develops New SQL Reports as per end-users requests.
- Develops Stored Procedures for computed columns which are necessary for the reports.
- Gives Reporting Services Training to all Departments and end-users.
- Maintains reporting SQL database, resolving data issues, and identifying new required data elements, add to and maintain data transforms.
- Reviews ERP update documentation for items that may impact SQL reporting databases. Perform necessary testing in development environment before live deployment. Perform any required pre-install or post install functions required with the updates.
- Participates in projects and provides updates in Monday.com.
- Designs and develops Reporting Services reports in Development environments using SQL Server Data Tools and Visual Studio.
- Moves tested SQL scripts, stored procedures, views, functions, and reports definition files from Development environment to Production environment.
- Develops Stored Procedures/Views/Functions/Triggers/Tables based on the Technical Requirements of Reports.
- Maintains and supports existing Applications/Reports and develops enhancements as per end user requests.
- Documents reporting services specific Business Requirement Documentation (BRD) for each and every Report.
- Sets up and manages SSRS security model.
- Facilitates User Acceptance Testing (UAT) of SSRS Reports.
- Checks the Reports/Stored Procedures/Views/Functions Performance and does SQL Performance Tuning to improve the performance.
- Troubleshoots any problems that arise from the database, the software and the software configuration.
- Administers MSSQL Server and Database Security and maintains Active Directory Security Groups.
- Writes queries using SQL Server Management Studio (SSMS) to query data and data structures.
- Works with college representatives to design, create, implement and maintain reporting capabilities.
- Investigates and analyzes requests and problems using technical skills to draft and propose effective solutions.
- Provides assistance and backup for other members of CIS Enterprise Applications team when necessary.
- Performs other tasks and duties as assigned.
- Associates degree in related field and two years of relevant work experience OR an equivalent combination of education and experience to total 4 years.
- Bachelor’s degree
- Experience with Ellucian Products.
- Experience in post-secondary education environment.
- Advanced skills in the use of Microsoft SQL Server administration and maintenance
- Database design
- Custom reporting programming
- Experience with relational databases and query retrieval languages
- Experience in MSSQL maintenance and report writing (SQL, T-SQL, SSIS, SSAS, SSRS, SAN, DTS, ETL).
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).
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.
- 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:
- Share your experience with reporting (designing, creating, implementing and maintaining).
- Describe your experience with various computer software. Please be detailed and specific on the software you have used.
- Describe responsibilities you have had in meeting deadlines, developing and scheduling multiple projects, record keeping, and organizing your work as it would relate to the responsibilities of this position.
- Submit online application and all required materials by the deadline.
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 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.