Analyst Programmer

Lake Michigan College

Posted on: 2019-02-20 16:24:38

Application due date:

Link to posting:

Job description:


JOB TITLE:                                                                                                                                         DATE:

Institutional Research Analyst Programmer                                                                                February 4, 2019

DIVISION:                                                                                                                                           REPORTS TO:

Academic Affairs                                                                                                                                 Director of Institutional Research                        

DEPARTMENT:                                                                                                                                  CLASS:

Institutional Research                                                                                                                         Staff

APPROVED BY:                                                                                                                                GRADE:

Provost and Vice President of Academic Affairs                                                                          TBD


The Institutional Research Analyst Programmer is responsible for the design, creation, and maintenance of institutional data reports to support academic quality and student success initiatives, particularly Guided Pathways and Title III. Duties include, but are not limited to, the development and maintenance of programming and analysis to develop reports from the Banner student information system and other centralized data repositories in support of the Office of Institutional Research, academic programs and disciplines, and academic support departments. This position works closely with the Title III Project Director and IR Coordinator developing surveys, interview protocols, and other data tools specifically for Guided Pathways. This position is responsible for the security of data and data use from delivered reports. The IR Analyst Programmer provides support for accreditation, Guided Pathway projects, and other initiatives as directed by the Director of Institutional Research. The position requires excellent time management skills and requires working collaboratively with other offices on campus to provide excellent reporting service. The person chosen will serve on cross-functional teams, including the Guided Pathways Leadership team, as well as, the Discipline/Program Review and Student Success Committees.  He or she will also participate in state and national Guided Pathway conferences and workshops.


1.       Creates, edits, and maintains reports using Cognos Business Intelligence, SPSS, Excel and other data analytic tools.

2.       Use database query languages, SQL and Oracle, to retrieve, examine, evaluate, combine, and manipulate data from multiple sources.

3.       Assists in the creation and maintenance of effective, valid, and reliable performance indicator data dashboards and report cards to provide high quality data on academic quality and student success initiatives to inform formative and summative decision making.

4.       Assists faculty, staff, and project teams with data for initiatives; collaborates to determine data needs of projects.

5.       Compiles and distributes cohort, longitudinal, and comparative data related to academic program quality and student outcomes.

6.       Analyzes, translates, and disseminates data in user-friendly visual documents (e.g., tables, charts, graphs, etc.) and disseminates results via appropriate electronic media, written reports, and in-person presentations.

7.       Collaborates with colleagues to ensure that data used to inform decisions are accurate, relevant, and accessible.

8.       Reviewing/maintaining business rules and preparing data for state, federal, and ad-hoc compliance reporting.

9.       Organize and execute complex data requests, research data availability and access methods including strong analytical and problem solving skills.

10.    Creates, manages, collects and analyzes survey and other data from across the College in support of institutional research related to academic quality and student success initiatives, particularly Guided Pathways and Title III.

11.    Design surveys directly related to academic quality and student success, including identification of target populations, sampling, procedures to be used, and development of survey instruments and materials in collaboration with the Coordinator of Institutional Research.

12.    Provide qualitative research support in both methods and analyses.

13.    Keeps current on promising practices in institutional research and shares with appropriate college personnel.

14.    Performs other duties as assigned.


Under the limited supervision of the Director of Institutional Research. May supervise student employees.


Bachelor’s degree required in Computer Sciences, Psychology, Math, Sociology, or related degree. A Master’s degree strongly preferred. Five or more years of experience of a combination of the following activities: using business analytics, i.e., Cognos, writing SQL queries of student information systems, i.e. Banner, and using Excel or SPSS to conduct data analysis, is required. Three or more years of experience working with and preferably in an office of institutional research in higher education required. Experience with institutional effectiveness and student outcome models, research design, statistical techniques, and manipulating large data sets. Experience with Banner information and other reporting systems highly preferred.  Strong analytical, database, and communication skills. Demonstrated ability to design and produce accurate and effective research reports. Ability to work in a team environment.