Posting Date: October 26, 2007
Closing Date: Position Open Until Filled - Application
review will begin November 26, 2007.
Title: Institutional Research Systems Analyst
Salary Range: $45,000 - $55,000
FTE: 1.00
Location: The position is located on the University of
Oregon campus in Eugene, OR
A. GENERAL DESCRIPTION OF THE POSITION
- Provide comprehensive studies, develop models, and generate reports that
aggregate, analyze, and explain student and related data in support of Oregon
University System (OUS) policy development, using appropriate applications,
programming languages, databases, and analytic tools.
- Gather, compile and analyze qualitative information and statistical
data relating to academic programs, students, OUS institutions and Oregon
high schools; make interpretations, develop conclusions and present the
information in a graphical format.
- With database administrator and other analysts, collaborate in the definition,
and collection of student and course data submitted by OUS institutions; identify,
collect and integrate into an OUS database external data that enhances the
value of OUS data.
B. QUALIFICATIONS:
- Requirements include a Bachelor’s degree in a field related to
research, analysis or computing (or equivalent work experience), a minimum
of two years’ experience in data analysis; three years experience
with Enterprise Data System design, ETL, BI analysis and reporting, and
enterprise-based web application; demonstrated competence in research and
basic statistical reporting; and familiarity with the postsecondary educational
environment. Prefer experience using relational databases (e.g., Oracle),
SAS (or equivalent), SQL (or equivalent), procedural programming languages,
and Microsoft Suite applications (Excel, Word, Power Point). Prefer experience
with multiple education sectors.
C. KNOWLEDGE AREAS
This position requires:
- Understanding of privacy laws and regulations regarding student records,
and data security and controls. Works with sensitive and confidential data.
- An understanding of data collection, validation, storage, and retrieval
techniques using both sequential files and relational databases (especially
Oracle RDBMS) and the ability to handle large data sets efficiently. Facility
in the design and manipulation of large databases.
- Skill in research design, data gathering and manipulation, and statistical
aggregation and analysis, including the ability to present information clearly
using appropriate database, spreadsheet, and graphical tools. Critical to
the design process is the ability to anticipate the data consumer's unexpressed
needs and questions.
- Familiarity with a broad array of higher education-related data and
the ability to evaluate its validity and relevance in relation to policy
development.
- Strong communication and interpersonal skills. From program documentation
to interoffice memoranda or the presentation of research, the position requires
the ability to write clear, organized, and economical prose. At the same
time, the position requires the ability to work collaboratively with a variety
of constituencies including other staff in the Chancellor's Office, staff
at individual institutions, staff in other educational sectors in Oregon,
and members of external agencies to provide direction, advice, coordination,
and help in the collection, interpretation, and use of data.
- Highly desirable knowledge areas: programming facility in a number of
computer languages, especially web-based applications, SAS or SPSS, and
Oracle's PL/SQL and SQL*Plus, together with the ability to read and interpret
existing code written in other languages. Knowledge of mainframe-style operating
systems (e.g., UNIX) and the ability to create command language scripts
and programs within those operating systems.
D. DECISION MAKING
This position requires decisions about:
- Project design. Design the project or model, estimate availability of resources,
select appropriate programming languages and analytic tools, transform design
into an efficient and effective conveyance of information for public presentation
or further analysis.
- Data selection and presentation. Structure each report according to its
probable use and the sophistication of its audience; decide report content
and level of detail accordingly. Balance urgency of a project with need for
care and thoroughness.
- Information resource management. Evaluate traditional organization of stored
data and computer programs in light of advances in technology; redesign for
improved accessibility, efficiency, and reliability (e.g., conversion of academic
personnel files from sequential storage to a relational database).
E. MAJOR JOB RESPONSIBILITIES
- • Research existing K-12 to higher education reporting practices
in other states and examine best practices for creating and maintaining
a K-20 data system.
- Working with Oregon Department of Education (ODE), Community College
and Workforce Development (CCWD) and OUS staff, coordinate data identification
and transmission to OUS Office of Institutional Research from Oregon high
schools through the Integrated Data Transfer System process.
- Working with other analysts, take active role in the development, maintenance
and dissemination of academic performance reports and high school profiles
of OUS first-time freshmen to be distributed to Oregon high schools and
other interested parties. Assist in the creation and implementation of detailed
performance reports using unit record high school transcript data.
- Attend meetings, interpret needs and propose solutions for the integration
of high school transcript data into a K-20 database as needed. Establish
contacts with pertinent staff at OUS, ODE, and CCWD and maintain familiarity
with agency databases.
- Design and implement standardized web reports using linked educational
data records from Oregon Department of Education and OUS.
- Produce reports, presentations and data models using Excel, Access,
Oracle, SAS and other appropriate applications as requested.
- Assist in the validation of the student and course data sent to us each
term by the OUS institutions; assist in the generation of a series of reports
to be sent back to the OUS schools providing them feedback about data inconsistencies
and errors, primarily high school transcript data.
- Maintain, with other analysts, the content of the SCARF Data Dictionary.
- Assist in the development of a pilot test for the linking of ODE, CCWD,
and OUS data.
- Other duties as assigned.
ADDITIONAL INFORMATION
In order to keep abreast of technological advances and ever-increasing demands
for more and different information by policymakers, this position requires
regular professional growth and the continual acquisition of new knowledge
and skills. Such development comes from many sources: continuing formal education,
participation in professional organizations, attendance at technical workshops
and conferences, and, for such things as learning a new software application
or programming language, experimentation and study on one's own.
APPLICATION PROCEDURE
For immediate consideration submit an Oregon University System employment
application, a cover letter highlighting your qualifications, plus a current
résumé. Employment applications can be obtained by contacting
the Office of Human Resources at (541) 346-5832 or from our website http://www.ous.edu/dept/hr/employment.php,
employment opportunities link.
Send application packet to:
Institutional Research Systems Analyst Search
Attn: Jay Searle
P.O. Box 3175
Eugene, OR 97403-0175
Fax 541-346-5757 or email: jay_searle@ous.edu