Systems Analyst

Salary: $6,840.00 - $8,655.00 Monthly

Job Type: Full Time

Job Number: 202210055

Closing:

11/21/2022 11:59 PM Pacific

Location: Merced, CA

Department:

Range 35

40 hours/week12 months/year

Interview dates to be determined

Merced College is a midsized community college located in California's Central Valley. Founded in 1962, the college serves more than 16,000 students, with room to expand on its 267-acre main campus and 120-acre Los Banos site, as well as at our innovative Business Resource Center in Downtown Merced. The City of Merced, incorporated in 1889, offers historical sites, affordable housing and access to the Bay Area and Sacramento. Merced is known as the Gateway to Yosemite National Park and the Sierra Nevada mountains, and is home to the University of California's newest campus, UC Merced. Our tree-shaded, growing community of just over 80,000 includes multiple biking and walking trails as well as access to several lakes — large and small — throughout the county.

Information Technology Services (ITS) is a friendly team oriented working environment focused on supporting Merced College community. The Systems Analyst positions responsibilities include administration and maintenance of our Ellucian Colleague enterprise resource planning (ERP) system and associated databases our business intelligence platforms and integrated services. The Systems Analyst works closely with our Senior programmer and business Analyst positions to implement, maintain, and enhance the services ITS provides.

Merced College Vision

Merced College will provide transformative and empowering educational experiences to meet student and community needs.

Merced College Mission

Growing our community through education and workforce training:

• lifelong learning

• basic skills

• career technical education

• transfer

• degree/certificate programs

Ensuring student success through equitable access, continuous quality improvement, institutional effectiveness, and student achievement.

General Description:

Under the supervision of the Director of Enterprise Application Services, this position supports enterprise resource planning (ERP) systems, associated databases and business intelligence systems, operating systems, and related software. Values and promotes the mission and vision of the college.

Examples of Duties

Representative Duties:

• Performs administration of the enterprise resource planning (ERP) system and integrated applications. Required duties include system configuration, installation of software upgrades, data refresh clones of supported environments, debug/test all implementations, provision/maintain end user accounts and security roles

• Supports the ERP transactional/operational database as well as the analytical (data warehouse) databases, applications and functions associated with the ERP system, including technical maintenance and upgrades, module installation, as well as being responsible for research and resolution of the day-to-day operating issues that affect processing services

• Provides technical advice and support to end users including troubleshooting issues, creating data extracts, reports, data analysis, and business intelligence dashboards

• Performs systems analysis and design work for functional end users

• Performs data extractions and develops integrations to other systems as required

• Assists other members of the Information Technology Services staff with design, program logic, instruction and database structure

• Debugs programs by preparing test data and evaluating computer output for valid results, satisfying end user requests

• Coordinates with Director or Manager on protocols and security to connect the enterprise resource planning (ERP) system to the infrastructure

• Assists with maintaining and monitoring database systems performance by creating, debugging, and testing various database types including SQL Server and Unidata

• Maintains, creates, debugs, and tests flat file exchange and data extraction in an EDI environment.

• Works with third-party vendors to implement and maintain custom database integrations

• Supports the duties of the Educational Technology Analyst as they pertain to the Learning Management System (LMS) and the integration with the intelligent Learning Platform (ILP) of the ERP System

• Creates, implements and maintains new/existing web-form designs and workflows as it relates to document imaging

• Other related duties as assigned

Knowledge of:

• Server hardware, software and enterprise operating systems such as Microsoft Windows server and Linux

• Database structure (SQL Server, Analysis Services, Unidata, MySQL)

• Relational database concepts, tools and techniques including the use of Structured Query Language (SQL) and Open Database Connectivity (ODBC)

• Fundamentals of data warehouse dimensional design using a star schema or similar approach capable of meeting analytical information needs of the district

• ETL processes such as SQL Server Integration Services

• SQL Server Management Studio and related data tools such as SQL Server Analysis Services, MS Reporting Services, and Excel Services

• Data Analysis Expressions (DAX)

• Principals and techniques of computer programming, basic on-line programming and programming documentation

• Various computer programming languages

• Operating procedures of computer systems and related equipment

• Principles and practices of data base management systems

• Principles and techniques of system analysis and design

Ability to:

• Analyze, design, program, install and maintain complex computer systems

• Identify, evaluate and solve program problems

• Operate a variety of computer software applications and peripheral equipment

• Read, interpret and apply complex technical publications, manuals and other documents

• Analyze data and develop logical solutions to complex data processing application programming problems

• Prepare clear and concise computerized reports

• Understand and follow oral and written instructions

• Communicate clearly and concisely, both orally and in writing

• Establish and maintain effective working relationships with those contacted in the course of work

• Meet project schedule and timelines

• Plan and organize work schedule

• Demonstrate sensitivity to and understanding of the diverse academic, socioeconomic, cultural, disability, gender identity, sexual orientation, and ethnic backgrounds of community college students

Typical Qualifications

MINIMUM QUALIFICATIONS

Required:

• Bachelor's degree AND five (5) years of applicable experience

OR

• The equivalent education and experience

• Sensitivity to and understanding of the diverse academic, socioeconomic, cultural, disability, gender identity, sexual orientation, and ethnic backgrounds of community college students

PHYSICAL DEMAND AND WORKING ENVIRONMENT

The conditions herein are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individual with disabilities to perform the essential job functions.

Environment:

Work is performed primarily in an office environment with some travel to different sites; incumbents may be required to work extended hours including evenings and weekends.

Physical Ability to:

• Hear and understand speech at normal levels

• Communicate so others will be able to clearly understand normal conversation

• Read printed matter and computer screens

• Stand or sit for prolonged periods of time

• Bend and twist, stoop, kneel, crawl, push, pull

• Reach in all directions

• Work at a desk, conference table or in meetings of various configurations

• Operate office equipment requiring repetitive hand movement and fine coordination including use of a computer keyboard

Vision

See in the normal visual range with or without correction.

Hearing

Hear in the normal audio range with or without correction.

Supplemental Information

How to Apply:

• Submit a complete application by the closing date/time on the Merced College career pages at https://www.governmentjobs.com/careers/mccd/transferjobs

Required Documentation:

• Letter of interest addressing your qualifications for the position (cover letter)

• Resume

• Legible unofficial college transcripts; transcripts must include the degree major and date the institution granted the degree; official copies are not required unless applicant is hired

• List of three professional references (no reference letters permitted)

If Applicable:

• Foreign transcripts must include a U.S. evaluation and translation completed by an approved organization per the State of California Commission on Teacher Credentialing. http://www.ctc.ca.gov/credentials/leaflets/cl635.pdf https://get.adobe.com/reader/

• Equivalency Review Form (Required for applicants who do not possess the stated minimum educational qualifications and are seeking consideration on the basis of equivalency). http://www.mccd.edu/offices/hr/jobs/eqforms.html

Only the required documentation as listed above will be accepted for this recruitment. Any additional documentation will be removed from your application profile.

Interview Information:

Those applicants deemed highly qualified for the position will be invited to appear for oral interviews before a screening committee. A limited number of candidates will be invited to interviews. Interviews may be scheduled onsite or via Zoom. Applicants are required to ensure access to the necessary technology to participate in a Zoom interview and will be responsible for their travel expenses, if necessary.

Employee Benefits:

Employee Benefits: Health benefits for the employee and all their eligible dependents cost employee's only $12 per month and provide access to PPO medical coverage, PPO dental coverage, VSP Vision coverage, and more! Please visit our https://www.mccd.edu/offices/hr/benefits/index.html for more details about our incredible employee benefits. In addition, sick leave and retirement benefits are also provided.

Condition of Employment:

The selected candidate must be fingerprinted and tested for tuberculosis at his/her own expense prior to the start of employment. In compliance with the Immigration Reform Act of 1986, all new employees are required to verify their identity and the right to work in the United States. Merced College does not sponsor visas. All offers of employment are subject to approval by the Board of Trustees. The applicant must be able to perform the essential functions of the position with or without reasonable accommodations.

Individuals with disabilities may request any needed accommodation to participate in the application process. Please submit your request with your application to the Human Resources Office.

Merced Community College District is an Equal Opportunity Employer

To apply, visit https://apptrkr.com/3603513

Copyright ©2022 Jobelephant.com Inc. All rights reserved.

https://www.jobelephant.com/

jeid-bff4fcb032cc9e47a409c30a630a25bf