Spreadsheet: 09a9dc3a-0b2a-421e-92d6-360ec6b7fa9a
Sheet: IR Staff Matrix

INSTITUTIONAL RESEARCH STAFF DUTIES MATRIX
([NAME] 06/11/12)
DIRECTOR  ([NAME], X5316) |  | RESEARCH ANALYST ([NAME] #5671) |  | APPLICATIONS PROGRAMMER  ([NAME], X5435) |  | DATA SPECIALIST  (Workstudy, X5429)
Strategic Planning collaborator for all departments and campuses. Facilitate in identifying their vision of how they will meet strategic planning objectives. Assist them in shaping their vision into measurable projects with metrics and schedules. Provide the technical support to achieve their goals. |  | Support strategic planning initiatives by providing technical support to campuses and departments, i.e., collect, code, and prepare data for analysis, develop data visualizations, and conduct basic statistical analyses |  | Manage SQL data system to include table building, development of queries, reports and training as required |  | Assists with creating and maintaining term-specific and academic year frozen flat files for official reporting purposes
Develop benchmarks, databases, analytical studies and presentations to support accreditation, program evaluations, strategic planning, and decision making. |  | Provide project management to ensure the continuity and completion of objectives. |  | Monitor data integrity in all databases. |  | Submit daily College Opportunity Fund (COF) query files and complete weekly error reports.
Support grant writers, continuing education program, concurrent enrollment programs, strategic plan project managers, and corporate solutions & small business development with technical advice, data, and reporting. |  | Assist in developing benchmarks, databases, analytical studies and presentations to support accreditation, program evaluations, strategic planning, and decision making |  | Create and submit College Opportunity Fund (COF) Invoice, Reconciliation, and correction files and term-specific COF Correction files and provide internal COF reports. Responsible for problem resolution. |  | Produces weekly enrollment and FTE report
Oversee collection and analysis of data for institutional policy analysis, internal and external reporting, and academic or administrative decision making |  | Create Dashboards for various departments on aspects of student success, trends, FTE, room utilization, etc. |  | Create and maintain term-specific and academic year frozen flat files for official reporting purposes |  | [NAME] all internal surveys and completes related data entry
Support institutional effectiveness projects to include instructional master planning, facilities master planning, strategic planning, and external reporting requirements |  | Manage environmental scanning activities in support of institutional initiatives and program evaluation, to include census data collection and EMSI analysis. |  | Creates Data Integrity Reports for file freezes |  | Completes recurring data requests using prepared procedures
Participates in assessment planning and reporting activities |  | Create efficient, repeatable processes and documentation for all assigned projects |  | Works with admissions/records staff to ensure accuracy of student data in Banner and SQL, including problem resolution. |  | Updates trend analyses
Completes official FTE reports to CDHE and CCCS |  | Manage GIS databases and reporting. |  | Provides SQL/SPSS/ACCESS programming and support |  | Completes standard statistics
Manages and signs off on SURDS reporting processes |  | Help guide stakeholders in data-informed next steps |  | Submit files to National Student Clearinghouse to track transferring students, and update SQL database. |  | Creates Data Integrity Reports for file freezes
Ensures appropriate college representation on state data advisory and IR groups |  | Serve as advisor/consultant for techniques of institutional research, research methodologies, and the design and execution of surveys. |  | Prepare procedures to automate office tasks |  | Assists with Common Data Set (CDS)
Assist the Office of College Communications by providing data for media dissemination. |  | Directs creation, distribution, and data entry of all internal surveys and completes related analyses. |  | Participate in testing ODS or other data projects for CCCS IT
Work closely with the system office (CCCS), CDHE, and other governmental agencies to coordinate FRCC data continues to meet legislative and system requirements. |  | Manage Institutional Research Web Site. |  | Prepare SARS database and work with SARS team to fulfill their data requirements.
Oversees accuracy of Data Warehouse data, as well as develops error reports for internal and external use.  Also tests the ODS/EDW for CCCS IT and participates on support and decision-making committees. |  | Oversee completion of annual Common Data Set (CDS) for CDHE and inclusion on the IR Web Site. |  | Prepare procedures for recurring data requests
Complete and/or coordinate IPEDS Surveys |  | Produce annual FRCC Fact Book to include compilation of data/information, formatting, etc. |  | Complete ad hoc data requests
Provide SQL and SPSS Programming Support |  | Provide SQL and SPSS programming to include writing ad hoc and standard syntax to support data collection and reporting processes.
Manage data collection and reporting for WIA |  | Analyze and report CAAP and Accuplacer test data for internal and external reporting.
Complete annual [NAME] 40 |  | Complete annual WUE report.
Complete ad hoc data requests |  | Manages data collection and reporting for concurrent enrollment (high school) reports.
Submit daily College Opportunity Fund (COF) query files |  | Support retention and assessment efforts at FRCC through ad hoc and scheduled student retention research and reporting.
Complete standard statistics and FTE reports for Census and End of Term |  | Serve on a variety of internal and external committees for the purpose of communicating trends, developments, and issues to college and external constituencies.
Supervise all IR staff. |  | Manage IR team site on the intranet.
Manage all IR offices. |  | Prepares, distributes, collects, and uploads data to CCCS for VE-135 survey.
Oversee all IR projects/activities |  | Produces weekly enrollment and FTE report
Custodian of official reporting data bases and files |  | Creates and maintains ACCESS databases and forms that simplify office procedures