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.
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
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,
Generate adhoc training and build documentation for internal use and for end-user uses
Generate web-based short video clips to train users on aspects of reporting, logon, etc.
Ability to train others on how to use a computer system/POS/web interface
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
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
APPLICATION PROCEDURE: 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 email@example.com 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.