Analyst Programmer - Pomona, United States - California State University

California State University

Verified Company

Pomona, United States

3 weeks ago

Posted by:

Mark Lane

beBee recruiter

Description

Job no: 538120

Work type:
Staff

Location:
Pomona

Categories:
Unit - CSUEU - Technical Support Services, Probationary, Full Time, Information Systems & Technology, On-site (work in-person at business location)

Type of Appointment:
Full-Time, Probationary

Collective Bargaining Unit:
California State University Employees Union - Unit 9

Job Classification:
Analyst/ Programmer

Anticipated Hiring Amount:
$4,912 - $6,200 per month

Work Hours:
Monday - Friday 8:00am-5:00pm

THE DEPARTMENT

DUTIES AND RESPONSIBILITIES

Division and University Reports and Data Sets:

Provide assistance and support to the Sr. Analyst Programmer. Develop proficiency in understanding student data elements and reporting tools (including PeopleSoft queries and reports). Write PeopleSoft queries as needed. Develop proficiency in data warehouse data tables. Perform data validation across a variety of key metrics.
Analyze and verify reports to ensure data integrity. Create data sets for use by others. Plan, extract, generate and webpublish select university reports over a range of topics including FTES taught, FTEF by type, student/faculty ratios (SFR), majorfaculty ratios (MFR), demographic profiles, and others. Develop data project specifications and seek to improve information delivery systems as well as delivery based on specified reporting schedules.
Develop validated data models and reports for class schedule; faculty workload, diversity, salary, and tenure density; and instructional productivity and efficiency.
Develop data models, validation methods, reporting templates, automated data delivery methods, and standard operating procedures for longterm sustainability and consistency of data and reports. Working from often vague specifications provided by users unfamiliar with the wide range of data possibilities, analyze reporting requirements, timeframe, complexity, and priority. Consult as needed to clarify requirements, supporting users with knowledge of data elements and typical reporting standards.
Determine the appropriate data extraction and information delivery methodology. Meet immediate needs and leverage work to improve longterm ability to address future requests. Utilize multiple platforms in data work including (but not limited to): Oracle databases, SQL, Tableau, and Data warehouses.

Dashboard development and Maintenance:

Collaborate in the development of standard data models with report developers, programmers, and data architects in Institutional Research, Planning and Analytics (IRPA) and Business Intelligence.
Provide knowledge transfer from other standard reporting to dashboard efforts. Make recommendations on method and source of data extraction.
Coordinate with senior programmers in conversions of existing static reports to appropriate data dashboard presentations through independent and collaborative dashboard programming projects. Work with data end users to develop established and understood schedules for automated data delivery and notifications.
Develop new and enhance existing dashboards utilizing the Tableau platform. Coordinate on the development of a roadmap for data dashboard development and deployment in alignment with University Strategic Plan and Academic Master Plan.
Respond to dashboard maintenance requests and develop timetable and methodology for regular updates or improvements to existing dashboards.

Systems Design and Support

CSU APDB Reporting:

In collaboration with Sr. Analyst Programmer, Academic Programs scheduling team and Research Analyst, support reporting of information to the CSU Academic Planning Database (APDB). For each term, collaborate in the execution of the APDB and Faculty Workload reporting processes. Generate reports from PeopleSoft, make edits to the generated flat files, ensure accuracy of the data, and submit in a timely manner an error free report that complies with the guidelines and requirements of the CSU Chancellor's Office.

QUALIFICATIONS

Preferred Qualifications

Master's degree in computer science, data analytics, or related field.
Technical Skills:
Working knowledge of student data.
Functional understanding of one or more Campus Solutions modules including: Admissions, Student Records, Financial Aid, Campus Community, and/or Academic Advising.
Careerlevel proficiency in data retrieval/presentation tools including (but not limited to): SQL, Veera software, Tableau Software, Microsoft Office software, and other dashboard tools.
Careerlevel proficiency in report programming and SQL scripts.
Web design tools such as Cascade.
Programming language platforms such as.

NET, Python, and/or Java.

Customer Service Skills:
Treats all customers (students, faculty and staff colleagues) with dignity and respect, empathy, fairness and professionalism, consistent with the university mission, values and strategic vision.
Selfconfidence and interpersonal skills.
Analy