Information Analyst
Apply NowCompany: Solano Community College
Location: Fairfield, CA 94533
Description:
Salary: $6,935.06 Monthly
Location : Fairfield, CA
Job Type: Full Time Classified
Job Number: CSEA_SP25_Info Analyst
Department: Technology Services & Support
Opening Date: 03/03/2025
Closing Date: 3/18/2025 11:59 PM Pacific
Description
Under the direction of an assigned supervisor provide technical advice and support to users including troubleshooting issues, creating reports and data extracts and data analysis. Primarily, the position supports the applications and functions associated with the District Enterprise Resource Planning (ERP) system which includes technical maintenance and upgrades for the system, performing module installation and maintenance, and being responsible for research and resolution of day-to-day operating issues that impact correct and efficient processing services. Additionally,under general supervision of the lead this position will provide database administration services such as maintaining the function, integrity, and security of the campus databases.
Responsibilities
Perform and coordinate complex computer systems analysis to determine system requirements and desired outputs; communicate with users to identify system requirements; develop statement of system scope and objectives based on functional requirements.
Interact with District faculty and staff to determine requirements, needs and desired output; evaluate, install and maintain various software applications; review and evaluate computer software and hardware and provide technical support, information and recommendations.
Assess staffing and workload implications and feasibility of new system requirements; analyze existing systems performance in relation to specified requirements to assure proper integration to existing data structures.
Utilize appropriate current technology tools to develop a logical design from information systems requirements; develop a logical data model using entity relationship and data flow diagrams; identify new data elements needed within the system's data dictionary and the relationship to existing data structures.
As project leader, assure projects are completed in a professional and timely manner, according to District standards and methodology; plan, schedule, monitor and coordinate project activities; report on project status and progress as required.
Coordinate and perform database modifications and complex applications programming to develop new information system modules; write on-line, interactive problem-solving programs without assistance; evaluate the products of outside vendors to assess the use of third-party software within the District's information systems. Write, code, test, install and maintain computer applications; prototype applications to assure production of desired outputs; prepare documentation of computer systems and programs.
Communicate with users and other staff to develop a thorough and rigorous testing of software and database performance before new applications are released into production; assure that systems requirements are fully tested and that data validation and integrity rules and standards are enforced.
Develop detailed implementation plans for systems and modifications; coordinate with computer operations staff to move new systems into on-line production; monitor the impact of new systems on overall system performance and data integrity; complete post-implementation records and reports for new systems.
Coordinate unit activities with District user services and technical services staff to assure user information needs are met; assist faculty, staff and operational staff with operational difficulties and malfunctions encountered in existing programs; identify and resolve malfunctions, enhancing applications as required.
Attend a variety of committee meetings, conferences and workshops to maintain current knowledge in the programming field; train users.
Assist in the evaluation and recommendation for new hardware and software acquisitions and upgrades; revise and enhance existing applications as appropriate to assure proper systems operations and output production; adapt purchased software as needed to assure compatibility and proper interaction with existing systems and applications.
Assist with the design, programming, coordination, implementation and maintenance of the district internet and intranet web sites and services offered via the sites.
Prepare and maintain a variety of logs, documentation and records related to system analysis, design and programming projects.
Assist with general database administration duties and act as a backup to the Database Administrator.
Secondary Functions:
Perform job-related duties as assigned.
Act on behalf of the lead in his/her absence (i.e. perform DBA duties).
Minimum Qualifications
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
EDUCATION AND EXPERIENCE:
1. A Bachelor's degree in Management Information Systems, Computer Science or closely related field AND
2. Two years increasingly responsible systems analysis, design and application programming experience OR
3. Any combination or training, experience, and/or education that provides the required knowledge, skills and abilities.
Knowledge, Skills and Abilities
Knowledge of:
Advanced principles, practices and techniques of computer systems analysis, design, and applications programming.
Advanced database design concepts.
Computer hardware systems, software applications and programming languages utilized by the District (examples: including COBOL, SQL, PL/SQL, Visual Basic, HTML, XML, ASP or similar products)
District organization, operations, policies and objectives.
Basic theory, operation and use of communications systems, LAN hardware and software and tasks associated with LAN administration.
Various computer operating systems and application software and the operations of various computers and their associated components
Commonly used computer networks , to include the installation, maintenance, troubleshooting and repair of such networks.
NOTE: Hardware, software, programming languages, operating systems, and computer networks may change from time to time based on District needs.
Ability to:
Design, develop, test, install, maintain and enhance computer systems to support District operation. Perform and coordinate complex computer systems and database analysis and design. Perform a variety of difficult and complex applications programming duties. Serve as project leader on various assignments. Interact effectively with District faculty and staff to determine requirements, needs and desired outcome. Detect and resolve errors in data and program structure, logic and coding. Use logical methods to evaluate varying technologies. Establish and maintain cooperative working relationships. Remain informed of latest hardware, software, and maintenance developments. Write, clear, concise instructions and explanations and keep accurate records. Work independently with minimum supervision. Demonstrate a sensitivity to relate to persons with diverse socio-economic, cultural, and ethic backgrounds, including the disabled.
LANGUAGE SKILLS: Ability to read, analyze and interpret common scientific and technical journals, financial reports and legal documents.
Ability to write original material for publication that conforms to prescribed style and format, such as user documentation and procedures.
Ability to prepare clear, concise and complete statistical reports.
Ability to communicate with district faculty, staff and students as well as outside vendors to define and clarity the requirements for telecommunications, networking and data communications hardware and software and problem resolution.
MATHEMATICAL SKILLS:
Ability to demonstrate knowledge of algebra and discrete mathematics.
Ability to apply concepts such as fractions, percentages, ratios and proportions to practical situations.
REASONING ABILITY:
Ability to define problems, collect data, establish facts and draw valid conclusions.
Ability to understand and analyze user requirements.
Ability to design, plan, develop and recommend appropriate solutions to district computer needs and to provide technical expertise.
CERTIFICATES, LICENSES, REGISTRATION:
Valid California driver's license.
Summary of Benefits
CSEA/Full-Time Classified
*New hires have 30 days from date of hire to enroll in benefit plans, benefits start the first of the month following date of hire.
Health/Medical
$65 per month (12 months) Employee + 1,
$70 per month (12 moths) family.
Dental
Vision
Life Insurance
Employment Assistance Program
(EAP)
Optum is our EAP provider.To log in and view services provided to you, please visit: www.liveandworkwell.com (company code - wise) 24/7/365 access to support 1-866-248-4096
Additional Retirement Savings
(Voluntary)
Other Voluntary Options
CSEA Classified earn 8 hours of sick leave per month(Unused sick leave rolls over each year.)
Vacation Accruals
Full-Time Employees
(12-month/8 hours/day)Days AccruedMonthly Accrual
Location : Fairfield, CA
Job Type: Full Time Classified
Job Number: CSEA_SP25_Info Analyst
Department: Technology Services & Support
Opening Date: 03/03/2025
Closing Date: 3/18/2025 11:59 PM Pacific
Description
Under the direction of an assigned supervisor provide technical advice and support to users including troubleshooting issues, creating reports and data extracts and data analysis. Primarily, the position supports the applications and functions associated with the District Enterprise Resource Planning (ERP) system which includes technical maintenance and upgrades for the system, performing module installation and maintenance, and being responsible for research and resolution of day-to-day operating issues that impact correct and efficient processing services. Additionally,under general supervision of the lead this position will provide database administration services such as maintaining the function, integrity, and security of the campus databases.
Responsibilities
Perform and coordinate complex computer systems analysis to determine system requirements and desired outputs; communicate with users to identify system requirements; develop statement of system scope and objectives based on functional requirements.
Interact with District faculty and staff to determine requirements, needs and desired output; evaluate, install and maintain various software applications; review and evaluate computer software and hardware and provide technical support, information and recommendations.
Assess staffing and workload implications and feasibility of new system requirements; analyze existing systems performance in relation to specified requirements to assure proper integration to existing data structures.
Utilize appropriate current technology tools to develop a logical design from information systems requirements; develop a logical data model using entity relationship and data flow diagrams; identify new data elements needed within the system's data dictionary and the relationship to existing data structures.
As project leader, assure projects are completed in a professional and timely manner, according to District standards and methodology; plan, schedule, monitor and coordinate project activities; report on project status and progress as required.
Coordinate and perform database modifications and complex applications programming to develop new information system modules; write on-line, interactive problem-solving programs without assistance; evaluate the products of outside vendors to assess the use of third-party software within the District's information systems. Write, code, test, install and maintain computer applications; prototype applications to assure production of desired outputs; prepare documentation of computer systems and programs.
Communicate with users and other staff to develop a thorough and rigorous testing of software and database performance before new applications are released into production; assure that systems requirements are fully tested and that data validation and integrity rules and standards are enforced.
Develop detailed implementation plans for systems and modifications; coordinate with computer operations staff to move new systems into on-line production; monitor the impact of new systems on overall system performance and data integrity; complete post-implementation records and reports for new systems.
Coordinate unit activities with District user services and technical services staff to assure user information needs are met; assist faculty, staff and operational staff with operational difficulties and malfunctions encountered in existing programs; identify and resolve malfunctions, enhancing applications as required.
Attend a variety of committee meetings, conferences and workshops to maintain current knowledge in the programming field; train users.
Assist in the evaluation and recommendation for new hardware and software acquisitions and upgrades; revise and enhance existing applications as appropriate to assure proper systems operations and output production; adapt purchased software as needed to assure compatibility and proper interaction with existing systems and applications.
Assist with the design, programming, coordination, implementation and maintenance of the district internet and intranet web sites and services offered via the sites.
Prepare and maintain a variety of logs, documentation and records related to system analysis, design and programming projects.
Assist with general database administration duties and act as a backup to the Database Administrator.
Secondary Functions:
Perform job-related duties as assigned.
Act on behalf of the lead in his/her absence (i.e. perform DBA duties).
Minimum Qualifications
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
EDUCATION AND EXPERIENCE:
1. A Bachelor's degree in Management Information Systems, Computer Science or closely related field AND
2. Two years increasingly responsible systems analysis, design and application programming experience OR
3. Any combination or training, experience, and/or education that provides the required knowledge, skills and abilities.
Knowledge, Skills and Abilities
Knowledge of:
Advanced principles, practices and techniques of computer systems analysis, design, and applications programming.
Advanced database design concepts.
Computer hardware systems, software applications and programming languages utilized by the District (examples: including COBOL, SQL, PL/SQL, Visual Basic, HTML, XML, ASP or similar products)
District organization, operations, policies and objectives.
Basic theory, operation and use of communications systems, LAN hardware and software and tasks associated with LAN administration.
Various computer operating systems and application software and the operations of various computers and their associated components
Commonly used computer networks , to include the installation, maintenance, troubleshooting and repair of such networks.
NOTE: Hardware, software, programming languages, operating systems, and computer networks may change from time to time based on District needs.
Ability to:
Design, develop, test, install, maintain and enhance computer systems to support District operation. Perform and coordinate complex computer systems and database analysis and design. Perform a variety of difficult and complex applications programming duties. Serve as project leader on various assignments. Interact effectively with District faculty and staff to determine requirements, needs and desired outcome. Detect and resolve errors in data and program structure, logic and coding. Use logical methods to evaluate varying technologies. Establish and maintain cooperative working relationships. Remain informed of latest hardware, software, and maintenance developments. Write, clear, concise instructions and explanations and keep accurate records. Work independently with minimum supervision. Demonstrate a sensitivity to relate to persons with diverse socio-economic, cultural, and ethic backgrounds, including the disabled.
LANGUAGE SKILLS: Ability to read, analyze and interpret common scientific and technical journals, financial reports and legal documents.
Ability to write original material for publication that conforms to prescribed style and format, such as user documentation and procedures.
Ability to prepare clear, concise and complete statistical reports.
Ability to communicate with district faculty, staff and students as well as outside vendors to define and clarity the requirements for telecommunications, networking and data communications hardware and software and problem resolution.
MATHEMATICAL SKILLS:
Ability to demonstrate knowledge of algebra and discrete mathematics.
Ability to apply concepts such as fractions, percentages, ratios and proportions to practical situations.
REASONING ABILITY:
Ability to define problems, collect data, establish facts and draw valid conclusions.
Ability to understand and analyze user requirements.
Ability to design, plan, develop and recommend appropriate solutions to district computer needs and to provide technical expertise.
CERTIFICATES, LICENSES, REGISTRATION:
Valid California driver's license.
Summary of Benefits
CSEA/Full-Time Classified
*New hires have 30 days from date of hire to enroll in benefit plans, benefits start the first of the month following date of hire.
Health/Medical
- CalPERS is our health insurance (medical) provider.
- CSEA Classified Employees pay a tiered amount towards the premium based on the following. The District pays remaining premium.
$65 per month (12 months) Employee + 1,
$70 per month (12 moths) family.
- To view Health Plans and other information, please visit:
Dental
- Delta Dental is our dental insurance provider.
- District covers 100%
- Employee only, employee + 1, or family
- PPO plan (to obtain a copy of the SCC policy, please contact HR)
- $2,700 annual maximum (in-network); $2,500 annual maximum (out-of-network)
- To find a Delta Dental provider, please visit:
- It is strongly recommended to set up an account to print cards, view benefits/claims. It will ask for "Enrollee ID." Enter your SSN.
Vision
- VSP is our vision insurance provider.
- District covers 100%
- Employee only, employee + 1, or family
- To find an eye care provider, please visit:
- It is strongly recommended to set up an account to view benefits/claims and other eye care information.
- At your appointment, there is no ID card necessary. Tell them you have VSP and give them your SSN. Dependents are covered under your name.
Life Insurance
- The Hartford is our group term life insurance provider.
- District covers 100%
- $10,000 Basic Term Life & Accidental Death and Dismemberment (to obtain a copy of the SCC policy, please contact HR)
- Benefit available to current/active employees only
- Additional life insurance can be purchased directly through The Hartford (employee paid)
Employment Assistance Program
(EAP)
Optum is our EAP provider.
- District covers 100%
- Available to all employees; 24 hours a day, 7 days a week.
- Services are confidential and include, but are not limited to:
- Face to Face Counseling & Virtual Visits
- Self Care - On demand help for stress, anxiety, and depression
- Work Life Services
- Financial, Legal & ID Theft Services
Additional Retirement Savings
(Voluntary)
- Envoy Plan Services is a third-party company we use to help link our employees to a list of investment providers; company works with the payroll department to set up employee contributions directly from paycheck
- 403(b) TSA plans
- To find a list of investment providers and to access forms, please visit:
- Select your employer at the top, then you will see the list of authorized investment providers; scroll down to the bottom for forms
- You can also visit (click on Client Resource Center)
- Forms can be filled out online
- CalPERS offers a 457 plan
- For more information, please visit:
Other Voluntary Options
- American Fidelity is our assurance company provider.
- Flexible spending accounts (Section 125 plans) - allows you to deduct the cost of eligible benefits from gross earnings before taxes.
- Short-term and long-term disability insurance - SCC employees do not pay into state disability
- Other insurance options available
- SCC has an American Fidelity representative
- If interested in any insurance options provided by American Fidelity, please let HR know and we will ask our rep to contact you.
CSEA Classified earn 8 hours of sick leave per month(Unused sick leave rolls over each year.)
- CSEA Classified earn 8 hours of emergency leave per year; 8 hours accrued at beginning of academic year (July)
Vacation Accruals
Full-Time Employees
(12-month/8 hours/day)Days AccruedMonthly Accrual
- 1 month through 9 years: 15 days 10.00 hours
- 10 years through 14 years: 20 days: 13.34 hours
- 15 years & above: 25 days 16.67 hours