City of Fullerton-IT Systems Analyst

11/30/2021 5:46:51 AM 647


$38.00 - $40.00 Hourly


CA 92831, CA

Job Type



Information Technology

Job Number


Closing date and time

12/31/2021 at 11:59 PM Pacific Time (US & Canada); Tijuana

click to apply

Reporting to the ASC IT Director, this position will serve the business analysis needs of the corporation's administrative and operational units as they pertain to information technology related design, configuration, and maintenance of the corporation's business systems and related databases.

Essential Duties

  • Generate and edit reports for finance and human resources
  • Integrate various business systems 
  • Generate and edit business analytics to assist the company processes, operations, and improve financial visibility
  • Improve business processes 
  • Provide training for new reports, integrations, analytics, and processes
  • Assist in the upgrade and testing of software releases
  • Support software security changes as needed


  • Ability build workflows in accounting system such as OneSolution 16.2+. 
  • Ability to build workflow items to, including scripts to import data. 
  • Knowledge and experience in designing reports and familiarity with database schema / fields. Ability to modify existing reports & modify information categories to meet organizational needs. 
  • Knowledge of basic SQL administration. Ability to write basic SQL statements in order to query data from multiple joined tables. 
  • Microsoft Windows experience with Windows current desktop and server versions, system administration, including the management of servers, roles, and resources in a Microsoft client/server environment. 
  • Demonstrated experience in automating tasks on Windows and/or Linux servers using scripting tools
  • Computer communications and networking foundational understanding and ability to troubleshoot networking issues from desktop to server / service.
  • Basic understanding and previous experience adding computers to Active Directory.
  • Basic understanding of computer networking stacks: IP, TCP, UDP
  • Basic HTML understanding and application
  • Ability to support desktop end-user needs including:
  • Assist reporting users on the web as they experience issues or trouble using reports
  • Setup security for reporting and Finance users
  • Able to setup desktop software environment and installation to support application systems such as OneSolution, myMicros labor and inventory, NetSuite user access
  • Support of operational areas file import needs and assistance to the operational administrative staff in Finance & Accounting, Human Resources & Payroll, Sponsored Programs, Executive offices, and Commercial Operations
  • Experience with Cognos 10 and 11 reporting and analytics. Ability to build reports in Cognos, such as financial, HR, and other list-based reports and data extracts, as well as understand and be able to write custom queries including conditional statements and user defined fields. 
  • Working knowledge and ability to learn backup and recovery for Microsoft SQL
  • Knowledge of Active Directory Group Policy Objects and OUs
  • Understanding and creation of SPSOne roles, and modification of security permissions in OneSolution to meet business needs
  • Experience with testing and upgrades of application software such as OneSolution and NetSuite ERP. 
  • Ability and experience supporting:
  • Multiple Point of Sale equipment, setup, and menu systems
  • Order taking and fulfillment systems including handheld scanner setups
    • NetSuite POS / Retail Anywhere POS
    • Tapingo mobile ordering and printing
    • Micros Simphony POS registers and kitchen system
    • Web ordering and fulfillment
  • Experience working with vendors to support of Point of Sale payments and tender systems (such as FreedomPay or Shift4) and gift carding systems including credit, debit, and stored value (such as CBORD and Givex)
  • Understanding and experience with web server applications and experience customizing web applications
  • Experience with and knowledge of backup and recovery best practices, and policy and procedure surrounding disaster recovery
Communication skills:
  • Excellent oral and written communication skills, ability to work well with people of diverse technical skill levels.  
  • Demonstrated ability to assist others through periods of technological transition
  • Support training needs in administrative, sponsored programs, commercial operations areas.  As needed/directed,
  1. Generate adhoc training and build documentation for internal use and for end-user uses
  2. Generate web-based short video clips to train users on aspects of reporting, logon, etc.
  3. Ability to train others on how to use a computer system/POS/web interface
  4. Assist users in NetSuite ERP, NetSuite web, and NetSuite POS issues
  • Bachelor's Degree in Accounting or a related field or 5-7 years of work experience.


  • Able to lift up to 25 pounds
  • Sit for extended periods of time
  • Frequently stand and walk
  • Manual dexterity and eye-hand coordination
  • Corrected hearing and vision to normal range
  • Verbal communication
  • Use of office equipment including computer terminals/computer workstations, telephones and electronic office equipment
  • Able to type/keyboard 40 wpm and use computer mouse and touch screens
  • Work is performed in an office environment, continuous contact with staff, frequent contact with the campus community and the public
  • Must pass a background check, which may include fingerprinting
         To be considered an applicant; you must apply through our online applicant portal found on the following site:  https://www.governmentjobs.com/careers/csufasc
        If you are a qualified individual with a disability or a disabled veteran, you have the right to request an accommodation if you are unable or limited in your ability to use or access our career center as a result of your disability. To request an accommodation, contact a Human Resources Representative at ascemployment@fullerton.edu or (657) 278-4117.
        A background check (including a criminal records check) must be completed satisfactorily before any candidate can be offered a position with the ASC. Failure to satisfactorily complete the background check may affect the application status of applicants or continued employment of current ASC employees who apply for the position.
        CSU Fullerton Auxiliary Services Corporation is an Equal Opportunity/Affirmative Action employer.  All qualified applicants will receive consideration for employment without regard to race, color, religion, sex including sexual orientation and gender identity, national origin, disability, protected Veteran Status, or any other characteristic protected by applicable federal, state, or local law.

 Note: CSUF/ASC follows the direction of the CSU Policy related to COVID-19 vaccination. See FAQ Vaccines for more information.  

CSU Fullerton Auxiliary Services Corporation ("ASC")
(657) 278-4120
1121 North State College Blvd.

Fullerton, California, 92831