St. Petersburg College

Institutional Research Analyst/Programmer [ID: 932]

Position Summary:

This is the third of six levels in the Information Technology series. Incumbents coordinate and implement the maintenance, use and enhancement of software or hardware systems critical to the operation of the College. Responsibilities may include analyzing system capabilities and implementing process and procedure changes to better utilize software or hardware; coordinating with software vendors regarding software support and system enhancements; coordinating projects involving the implementation of new software or hardware, or system changes; and training end users.

Reporting to the Director of Institutional Research, the Analyst/Programmer position provides support for college-wide reporting of student-related data to the Florida Department of Education, Florida College System, CCTCMIS, the Florida Auditor General’s Office, and other agencies. Data submissions are primarily accomplished through file transfers to the Northwest Regional Data Center (NWRDC).

Ensures the fidelity of the data query processes and accuracy of the data to meet the exacting demands of all reports. Documents all new processes and updates the documentation to reflect changes to ongoing processes.

Primary duties:

Prepare and submit the Student Database (SDB) three-times each year to the FCS CCTCMIS. This requires the extraction of student information from PeopleSoft using programs/code written in SQL and delivered through SQRs. SPC’s Student Database extraction program is very complicated with 7,500 lines of code. The SDB is matched with the Lumens Database Personnel Database, the Integrated Database, and the Facilities Database. Modify SQRs to accommodate change in local policy. Work with Assessment Services to extract data for surveys.
Participates in the development of user and operational documentation
Provides and coordinates SQR reports for special data requests
Participates within an integrated team of IR professionals to provide for the data needs of the college

Compensation: $66,640.36 - $83,300.45

Requirements:

Education:

Bachelor’s Degree in Computer Science, Data Informatics, or in a related field

Experience:

Four (4) years of experience working in the Institutional Research field, preferably with knowledge of Florida College System state reporting and/or knowledge of PeopleSoft in the student administration systems.

* An equivalent combination of education and experience sufficient to successfully perform the essential duties of the job may be acceptable in lieu of those requirements listed above.

Knowledge:

Knowledge of Oracle SQR, SQL Server, SQL, PeopleTools, PeopleCode
Knowledge of PeopleSoft student administration systems

Systems analysis and design principles;
Project management principles;
Applicable programming languages;
Process improvement principles;
Operating systems;
Customer service principles;
Training principles;
Computers and related software applications.

Skills:

Strong Project Management Skills
Team player, interpersonal skills as applied to interaction with coworkers, supervisor, and the college family
Attention to detail
Plan, organize, document, and meet deadlines
Work independently to resolve and maintain all aspects of state reporting database
Communicating technical information to a non-technical audience
Interpreting state requirements and translating into system specifications

Physical:

Positions in this class typically require: reaching, standing, walking, grasping, feeling, talking, hearing, seeing and repetitive motions.
Medium Work: Exerting up to 50 pounds of force occasionally, and/or up to 20 pounds of force frequently, and/or up to 10 pounds of force constantly to move objects.

Responsibilities:

These duties are a representative sample; position assignments may vary.		Potential Frequency
1.	Manages multiple systems, applications, and/or functions and related projects which include estimating project costs, identifying system risks and needs, and performing related duties.	Daily 20%
2.	Researches information technology problems and discovers sources of errors; analyzes systems capabilities and implements necessary operational changes; participates in the development and/or review of equipment and/or service specifications.	Daily 30%
3.	Confers with users to determine needs and implement best practice solutions. Provides end-user support and troubleshooting of software problems and issues.	Daily 10%
4.	Designs, writes, and implements interfaces, applications, reports, and web pages; identifies and interprets technical information to develop data solutions.	Daily 30%
5.	Coordinates projects with internal and external parties as necessary.	Daily 10%
6.	Performs other duties of a similar nature or level.	As Required

Equal Access/Equal Opportunity

The Board of Trustees of St. Petersburg College affirms its equal opportunity policy in accordance with the provisions of the Florida Educational Equity Act and all other relevant state and federal laws, rules and regulations. The college will not discriminate on the basis of race, color, ethnicity, religion, sex, age, national origin, marital status, pregnancy, sexual orientation, gender identity, genetic information, or against any qualified individual with disabilities in its employment practices or in the admission and treatment of students. Recognizing that sexual harassment constitutes discrimination on the basis of sex and violates this Rule, the college will not tolerate such conduct. Should you experience such behavior, please contact Dr. Devona Pierre, Executive Director, Organizational Culture and Engagement/Title IX Coordinator at 727-341-3261; by mail at P.O. Box 13489, St. Petersburg, FL 33733-3489; or by email at eaeo_director@spcollege.edu.