Application Analyst II/Cognos Report Writer

Information Technology

REQUISITION #604432085

University Enterprises, Inc. (UEI) at Sacramento State is seeking an Application Analyst II/Cognos Report Writer for the Information Technology Department. The Information Technology (IT) department supports the technological and infrastructure needs of University Enterprises, Inc.  In support of UEI’s mission and goals, IT provides data security, cost-effective access to technology, and assistance and advice in its use.  As part of our high-level service, we administer end user technical support, server and operations management, IT governance and project management, network hardware and software support, financial system support, information security, strategic initiatives and planning, and computer training.

RATE OF PAY:  $6,340 - $9,510 per month

BENEFITS: UEI offers an excellent benefits package that includes:

• Participation in CalPERS Retirement Program
• Paid Vacation Time – starting at 10 hours accrued/month
• Paid Sick Time – 8 hours accrued/month
• Paid Holidays – 14 paid holidays per year including paid time off the week between Christmas Day and New Year’s Day as the CSUS campus is closed
• Excellent medical benefits – 100% employer-paid medical & dental for employee-only coverage and low cost for family coverage
• Educational Assistance Program for employees and/or dependents
• Work from home for up to two days per week with supervisor approval. May require a successful probationary period.
• Child care subsidy
• View a comprehensive list of all of the benefits at https://simplebooklet.com/benefitsataglance.

FILING DEADLINE: This position is open until filled with a priority review date of February 4, 2025. Application review begins after this date.

APPLY ONLINE:  To be considered, all applicants must apply through the UEI website at https://secure6.saashr.com/ta/6158859.careers?ShowJob=604432085. Applicants who apply outside of this link will not be considered.

CONDITIONS OF EMPLOYMENT:

This is a full-time, exempt from overtime, benefited position, covered under the California Public Employees’ Retirement System. Continued employment in this position is dependent upon the mutual consent of University Enterprises, Inc. (UEI) and the employee, and either University Enterprises or the employee can, at any time, terminate the employment relationship at will, with or without cause.

The selected candidate must furnish proof of eligibility to work in the United States. University Enterprises, Inc. is not a sponsoring agency (i.e. H-1B Visa). 

It is strongly recommended that all University Enterprises, Inc. employees follow COVID-19 vaccine recommendations adopted by the U.S. Centers for Disease Control and Prevention (CDC) and the California Department of Public Health (CDPH) applicable to their age, medical condition, and other relevant indications.

MINIMUM QUALIFICATIONS

1. Bachelor’s Degree in Computer Science, MIS, or related area, or equivalent combination of education and/or work experience.
2. Demonstrated extensive experience with Cognos report writing. Demonstrated experience writing complex financial reports using software such as Cognos as well as the ability to train users in the use and development of new reports.
3. Demonstrated experience in user needs analysis and feasibility studies.
4. Demonstrated experience as a project leader. Demonstrated knowledge of project management tools.
5. Demonstrated ability to collaborate effectively with individuals at all levels of an organization.
6. Demonstrated experience with relational databases and client-server concepts. Ability to query databases with tools such as SQL and MS Visual Basic.
7. Excellent oral and written communication skills.
8. Must be fingerprinted and pass a background check. Must continue to meet the established standards.

PREFERRED QUALIFICATIONS

1. Project management certification such as Project Management Professional (PMP) or equivalent.
2. Familiarity with shell script programming.
3. Experience with workflow and security.
4. Experience in developing and maintaining interfaces.
5. Experience with report writing tools such as Click, Drag, and Drill or Crystal Reports.
6. Experience with Financial, Human Resources, and Payroll Software, such as ONESolution/Finance Enterprise/Workforce.

PHYSICAL REQUIREMENTS

With or without a reasonable accommodation: Sit for extended periods; frequently stand and walk; manual dexterity and eye-hand coordination; corrected hearing and vision to normal range; verbal communication; use of office equipment including computers, telephones, scanners, printers, copiers, and fax machines.

WORKING CONDITIONS

Work is primarily conducted in an office environment; frequent interaction with staff, the campus community, and the public.

DUTIES AND RESPONSIBILITIES

The Application Systems Analyst II/Cognos Report Writer plays a critical role in supporting the overall business strategies of University Enterprises, Inc. (UEI) through the evaluation of business processes, user needs analysis, and report development. They will collaborate closely with our customers and other Application Analysts to understand requirements, develop, or modify systems and reports, troubleshoot issues, and ensure data integrity and security. This position requires extensive knowledge of Cognos, including but not limited to report development/conversion, interfaces, automation, and security. Relies on extensive experience and judgment to plan and accomplish goals. May lead and direct the work of others. A wide degree of creativity and latitude is expected. The position reports directly to and receives general direction from the Assistant Manager, Information Technology.

The specific duties and responsibilities are as follows:

1. Reviews, analyzes, and evaluates business processes and systems to identify opportunities for improvement.
2. Recommends modifications to existing systems or proposes innovative solutions aligned with UEI's business strategies.
3. Writes detailed descriptions of user needs, program functions, and steps required for system development or modification.
4. Develops, modifies, and maintains application systems and reporting tools, with a focus on Finance Enterprise and Cognos, ensuring alignment with organizational goals. Maintains and provides support related to Workflow, Security, and Interfaces.
5. Provides end-user support and actively engages with IT and customers to uphold data integrity and security across systems.
6. Collaborates with customers and IT Analysts to understand reporting needs and requirements. Responsible for converting legacy reports (Click, Drag, and Drill) to Cognos Reports. Develops and modifies new Cognos reports.
7. Provides support and guidance to users in navigating, utilizing, and writing their own Cognos reports. Troubleshoots and resolves issues encountered by users working with Cognos reports.
8. Leads project teams in developing integrated project plans and schedules, ensuring alignment with departmental and organizational goals. Provides direction and leadership to project team members, facilitating collaboration and ensuring project completion.
9. Tracks, monitors, and communicates project progress to project team, management, and stakeholders.
10. Develops and delivers comprehensive user training on application systems and reporting tools.
11. Creates and maintains internal and external documentation for system updates and procedures. Maintains user guides and knowledge bases to support self-service for end users.
12. Performs other job-related duties as assigned.

Note:  This position vacancy is with University Enterprises Inc., an auxiliary organization of California State University, Sacramento.  This is not a University position; the incumbent will be an employee of University Enterprises. University Enterprises operates commercial enterprises on the California State University, Sacramento campus; it is responsible for grant and contract management and fiscal services for University research and sponsored programs and provides fiscal services to University related agencies and activities.  University Enterprises is a non-profit corporation governed by a board of directors in conformance with the appropriate State of California codes and policy directives of the Board of Trustees and the campus administration.

University Enterprises is an equal opportunity employer and is committed to an active nondiscrimination program. It is the stated policy of University Enterprises that all employees and applicants shall receive equal consideration and treatment. All recruitment, hiring, placement, and promotions will be on a basis of qualifications of the individual for the position being filled, regardless of race, color, religion, ancestry, national origin, age (over 40 years), sex, sexual orientation, marital status, medical condition (diagnosis or history of cancer)*, citizenship, veteran status, or physical or mental disability.  Any persons who feel that they have been discriminated against in connection with an application for employment should contact University Enterprises' Director of Human Resources at (916) 278-7003. *As defined in Section 12926(F), Government Code 12990.

***AFFIRMATIVE ACTION/EQUAL OPPORTUNITY EMPLOYER***

In compliance with the Jeanne Clery Disclosure of Campus Security Police and Campus Crime Statistics Act, California State University, Sacramento has made crime reporting statistics available on-line at www.csus.edu/police/cleryact.htm. Print copies are available in the CSUS library and by request from the CSUS Office of Public Safety and the Office of the Vice President for Student Affairs,