Database Reporting Analyst

ICC Illinois Central College

East Peoria (IL)

On-site

USD 50,000 - 57,000

Full time

4 days ago

Be an early applicant

Application generator

An application made for this job — a tailored resume and cover letter that speak straight to the posting.

Get past ATS filters

Benefits offered by this job

Paid time off

11 paid holidays

Medical, dental, vision, life and long

Tuition waivers for employee, spouse,

On-site childcare center

403(b) retirement plans

State University Retirement System

Job summary

Illinois Central College is seeking a Database Reporting Analyst at the East Peoria Campus. The role focuses on developing queries and reports to support self-service and ad-hoc reporting for Institutional Research, aligning with data standards and reporting deadlines.

The position requires a bachelor’s degree and experience with SQL, MS Office, and data analysis practices. The analyst will collaborate with BI staff and serve as a liaison between Technology Services and Institutional Research.

Qualifications

Bachelor’s degree or higher in a relevant field as listed in the minimum qualifications.
Experience with SQL query creation.
Proficient in Microsoft Office Suite.
Proficient with standard data analysis practices.
Strong attention to detail.
Strong organizational and prioritization skills.
Strong verbal and written communication skills.
Strong interpersonal skills and ability to work with diverse stakeholders.

Responsibilities

Develop queries and reports to progress long-term solutions for customer self-service and ad-hoc reporting requests.
Interact directly with requestors to gather requirements and translate them into usable reports.
Ensure compliance with state and internal reporting standards and deadlines.
Design and maintain on-demand reports using BI tools and the data warehouse.
Support enrollment, course offerings, completions, credit hours, and program data reporting.
Collaborate with Business Intelligence analysts and IT to validate data and test measures.

Skills

SQL

MS Office

Data analysis

Attention to detail

Organization & prioritization

Communication skills

Interpersonal skills

Education

Bachelor’s degree in Computer Science

Bachelor’s degree in MIS / Data Science / Statistics

Bachelor’s degree in Social Sciences

Tools

SQL Server Management Studio

SQL Server Reporting Services

Pyramid Analytics

Excel

Job description

Position Title: Database Reporting Analyst Campus: East Peoria Campus Employment Type: Management, StaffFull time Department: Institutional Research Start Date: 09/16/2026

Compensation for the Database Reporting Analyst is $50,377.60 - $56,680.00 annually.

Job Description: Summary Database Reporting Analyst is primarily responsible for developing queries and reports to progress long-term solutions for customer self-service and support ad-hoc reporting requests. This position will interact directly with requestors and requires a professional, customer-focused approach to providing information following the standards for the Office of Institutional Research.

Essential Functions

This list is meant to be representative, not exhaustive. Some incumbents may not perform all the duties listed while in other cases related duties may also be assigned. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Gather and interpret data needs from users, translate requirements using appropriate reporting and data use standards, and document final requirements in a manner that is clear to users, provides an internal record, and fosters user understanding of data policies. Utilize Pyramid Analytics (or, the college’s business intelligence reporting application) and the college’s enterprise data warehouse to develop queries and/or reports, sometimes in conjunction with standardized reports, to fulfill requests for student-, course-, and program-related statistics, mailing lists, and review of other constituent data. Ensure the college’s ability to meet mandatory state and federal reporting requirements and deadlines by cultivating expert content knowledge, regularly reviewing data elements, and maintaining internal process documentation to produce reports on enrollment, course offerings, completions, credit hours, and program data. Ensure a high level of accuracy, security, consistency, and clarity of presentation in ad-hoc and standard research requests. Create and maintain reporting standards and recommend related database objects as necessary to address emerging user requirements. Design and maintain custom, on-demand summary reports using the college’s business intelligence reporting applications and enterprise data warehouse. Design and maintain custom, on-demand record-level reports required in the development of new database objects using MS Access, Excel and/or SQL Server Manager Studio. Assist Business Intelligence analysts in planning and executing data self-service models to meet customer needs through design, review, and maintenance of reports and dashboards. Serve as a liaison between Technology Services and Institutional Research. Support and expand the IR Office’s information infrastructure by supporting the Business Intelligence Analysts with data validation, measure creation, and data model testing. Support the annual planning and budgeting, academic program review, and strategic planning processes with data and analysis. Perform related duties as required.

Minimum Qualifications

Bachelor’s degree in Computer Science, Management Information Systems, Statistics, Data Science, Library & Information Sciences, or a Social Sciences field.
Experience with query creation in Structured Query Language (SQL)
Proficient in Microsoft Office Suite.
Proficient with standard statistical processes, database management, and data analysis practices.
Strong attention to detail.
Strong organizational and prioritization skills.
Strong verbal and written communication skills.
Strong interpersonal skills, including the ability to establish and maintain cooperative and professional working relationships with others.

Preferred Qualifications

One (1) or more years of related work experience, including while as an undergraduate and graduate student, in data analysis, database reporting, or data management.
Experience with data warehousing methods.
Experience using Microsoft SQL Server Management Studio and SQL Server Reporting Services.
Experience with business intelligence reporting tools.
Strong understanding of the use and application of data within an institution of higher education.
Experience working in an institution of higher education, particularly in the institutional research function.
Familiarity with federal and/or state compliance reporting processes within public higher education.

EEOC Statement

Illinois Central College provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, gender, national origin, age, ancestry, pregnancy, physical or mental disability, sexual orientation, gender identity or expression, marital or familial status, order of protection status, use of VESSA rights, genetic information, military or veteran status (including discharge status), or any other protected status in accordance with applicable federal, state, and local laws.

Benefits

paid time off
11 paid holidays
2 floating holidays medical, dental, vision, life and long-term disability insurance
tuition waivers for employee, spouse and dependent children
on-site childcare center
403(b) retirement plans
and State University Retirement System pension plan

To learn more about full-time health care benefits at ICC.

Make an Impact at Illinois Central College

At Illinois Central College, our employees help transform lives through education and strengthen the communities we serve. From faculty to staff, every role contributes to student success and community impact. At ICC you’ll have the opportunity to: