Analyst Programmer

Job Description:

Analyst Programmer

Description

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

Enrollment Management & Services (EM&S) advances the educational mission of the University by providing leadership for the University's enrollment planning and management efforts. The department is responsible for providing comprehensive services and programs that promote the recruitment, matriculation, financial support and academic success of students. Specific responsibilities include: enrollment management and providing associated services to a variety of stakeholders utilizing the PeopleSoft enterprise system, supplemental software applications, and comprehensive reporting systems which support the enrollment planning process with critical data for student, academic, and financial planning. The Office of Student Systems and Operations (SSO) was formed to provide ongoing coordination and continuity between Enrollment Management & Services and the University’s central enterprise systems support teams. SSO supports EM&S administrative offices, academic departments, faculty, staff, and students in their use of PeopleSoft Campus Solutions and related student systems. SSO objectives are to maximize the benefits of PeopleSoft; interact with the university’s Division of Information Technology and other central systems support organizations; advise and alert other administrative areas on potential impacts; coordinate system usage and changes; manage system upgrades; and create, support, and maintain EM&S ancillary systems.

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 web-publish select university reports over a range of topics including FTES taught, FTEF by type, student/faculty ratios (SFR), major-faculty 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 long-term 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 long-term 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

• In collaboration with the Sr. Analyst Programmer analyze user system and application needs, determine and evaluate alternative solutions and approaches to meeting those needs, and select the optimal technology solution. Develop specifications and requirements for the optimal integration and implementation of systems and equipment.
• Design and support application programs to meet user requirements that optimize the use of available resources. Provide continual support of systems utilized by Academic Affairs including (but not limited to): Catalog and Curriculum Support (Curriculog/Acalog), Expanded Course Outlines (ECO), and other cloud/web based solutions including department websites.

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

To enter this classification, a basic foundation of knowledge and skills in applications programming and

systems analysis and related programming support functions is a prerequisite. This foundation would normally be obtained through a bachelor’s degree, preferably in computer science or business, or equivalent training and applied experience. Foundation knowledge and skills for the Analyst/Programmer, depending on the position assignment, may include working knowledge of a specific industry standard applications programming language and knowledge of standard systems analysis techniques.

The career level is broad and includes intermediate through senior-level positions. Incumbents at this level work relatively independently and possess the experience to be fully proficient in performing most or all of the work assignments defined for their position. Typically, incumbents have acquired the requisite skills and knowledge through a combination of education, training, and progressive work experience to be able to demonstrate competence in independently applying technical judgment to standard and nonstandard applications and systems, solving a wide range of problems and developing practicable and thorough solutions, and using effective communication and listening skills.

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.
  • Career-level proficiency in data retrieval/presentation tools including (but not limited to): SQL, Veera software, Tableau Software, Microsoft Office software, and other dashboard tools.
  • Career-level 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.
  • Self-confidence and interpersonal skills.
  • Analytical and problem solving skills
  • Good communication (both verbal and written) skills.
  • Planning and organizing skills.
  • Good administration management skills.
  • Strong listening skills.
  • Maintains a safe work environment.
  • Communicates with the University community in a civil manner.
  • Demonstrated ability to work with technical and functional peers and to share knowledge is required.

Out of State Work

The California State University (CSU) system is a network of twenty-three public universities providing access to a quality education through the support of California taxpayers. Part of CSU's mission is to prepare educated, responsible individuals to contribute to California's schools, economy, culture, and future. As an agency of the State of California, the CSU's business operations almost exclusively reside within California. The CSU Out-of-State Employment Policy prohibits hiring employees to perform CSU-related work outside California. See policy at https://calstate.policystat.com/v2/policy/10899725/latest/.

Background Check

Cal Poly Pomona will make a conditional offer of employment to final job candidates, pending the satisfactory completion of a background check (including a criminal records check).

The conditional offer of employment may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information.

In determining the suitability of the candidate for the position, Cal Poly Pomona will give an individualized assessment to any information that the applicant submits for consideration regarding the criminal conviction history such as the nature, gravity and recency of the conviction, the candidate’s conduct, performance or rehabilitation efforts since the conviction and the nature of the job applied for.

For more information, go to https://calstate.policystat.com/policy/13813878/latest/ .

Employment Eligibility Verification

Cal Poly Pomona hires only individuals lawfully authorized to work in the United States. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire. See Form I-9 Acceptable Documents at https://www.uscis.gov/i-9-central/form-i-9-acceptable-documents.

Child Abuse/Neglect Reporting Act (CANRA)

The person holding this position is considered a "mandated reporter" under the California Child Abuse and Neglect Reporting Act and is required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment. See policy at https://calstate.policystat.com/v2/policy/10927154/latest/.

Security & Fire Safety

In compliance with state and federal crime awareness and campus security legislation, including The Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act, California Education Code section 67380, and the Higher Education Opportunity Act (HEOA), Cal Poly Pomona’s Annual Security Report and Annual Fire Safety Report are available for viewing at: https://www.cpp.edu/pdfs/annual_security_report.pdf and https://www.cpp.edu/housing/documents/fire_safety_report.pdf.

Pay Transparency Nondiscrimination

As a federal contractor, Cal Poly Pomona will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. For more information, see the Pay Transparency Nondiscrimination Provision poster .

CSU Classification

This position is part of the CSUEU bargaining unit, the CSU Classification Standards for this position are located on the following site, https://www.calstate.edu/csu-system/careers/compensation/Pages/Classification-Standards.aspx . The CSU Salary Schedule is located on the following site: https://www.calstate.edu/csu-system/careers/compensation/Pages/salary-schedule-documents.aspx . The classification salary range for this position according to the respective skill level is minimum $4,912 and maximum $12,124 per month. Please refer back to the anticipated hiring range for the appropriate salary rate for this particular position.

Reasonable Accommodation

We provide reasonable accommodations to applicants and employees with disabilities. Applicants with questions about access or requiring a reasonable accommodation for any part of the application or hiring process should contact the ADA Coordinator by email at ADACoordinator@cpp.edu. More information is available at: https://www.cpp.edu/eoda/employee-labor//access-accommodations/index.shtml.

EEO

Cal Poly Pomona is an Equal Opportunity Employer. The University subscribes to the pay transparency nondiscrimination provision and all state and federal regulations that prohibit discrimination based on race, color, religion, national origin, sex, gender identity/gender expression, sexual orientation, marital status, pregnancy, age, disability, genetic information, medical condition, and covered veteran status. More information is available at: https://www.dol.gov/sites/dolgov/files/OFCCP/pdf/pay-transp_%20English_formattedESQA508c.pdf and at https://www.cpp.edu/eoda/employee-labor/documents/aa-eeo-doc/policy-statement_2022-aap-for-california-state-polytechnic-university-pomona_confidential_20220127.pdf .

Equity, Diversity, and Inclusion

At Cal Poly Pomona, we are committed to the urgent and ongoing work of creating and sustaining an inclusive campus where all students, faculty, and staff are welcomed, respected and can flourish to achieve their dreams of success.

We believe diversity strengthens community. Cal Poly Pomona proudly holds designations as both a Hispanic-Serving Institution (HSI) and an Asian American and Native American Pacific Islander-Serving Institution (AANAPISI). In 2022, the campus launched the Black Thriving Initiative recognizing that Cal Poly Pomona’s future as a university must be linked to the success of its Black community.

More information about our campus initiatives can be found on the Office of Inclusive Excellence’s website .

Other Notices

For other important employment notices, we invite you to visit Cal Poly Pomona’s Employment Notices web page.

Advertised: Jul 03 2024 Pacific Daylight Time
Applications close: Jul 17 2024 Pacific Daylight Time

Closing Date/Time: