Data Analyst - It Enterprise Applications - Central Services

Yosemite Community College District

Data Analyst - IT Enterprise Applications - Central Services

Salary: Range 52, $7,498 to $9,568 per month (2023-2024 Classified Salary Schedule)

Closing Date: Tuesday, April 2nd, 2024 at 11:59 p.m.

To apply, submit your application and required documents on-line via our applicant system at: http://50.73.55.13/counter.php?id=279226

DEFINITION

Under general administrative direction fulfills mandated state and federal reporting requirements on behalf of the District. Supports and maintains the District Business Intelligence platform. Supports both colleges’ research office personnel by responding to their research requests and performs other duties as assigned.

SUPERVISION RECEIVED AND EXERCISED

Incumbents in this class work under the direction of a manager or senior manager, receiving occasional supervision while working toward a definite objective that requires use of a wide range of procedures. Incumbents plan and/or determine specific procedures or equipment required to meet assigned objectives and solve non-routine problems, referring only unusual matters to a supervisor.

An incumbent in this class does not directly lead or supervise other full-time employees, but may assign, direct and/or monitor the work of subordinate full time, part time, and/or student employees on a project or assignment basis.

MINIMUM QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The Education/Experience, Knowledge and Ability requirements are representative of essential duties. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the position.

Knowledge of:

• Federal and state reporting requirements applicable to assigned work.

• Database software usage and best practices.

• SQL Query language

• Business Intelligence tools and best practices.

• Computer programming with data analysis focused languages such as R and Python

• Data management, classification, retention and security.

• Change Management procedures

• IT Service Management procedures

• Personal computers and related software applications.

• Knowledge of research methodology, principles and procedures.

• Report writing and data visualization techniques.

Ability to:

• Gather and analyze complex data and generate reports.

• Communicate effectively, both orally and in writing.

• Design, propose, collect, analyze and present research.

• Prepare research reports and proposals.

• Design and implement systems necessary to collect, maintain, and analyze data.

• Utilize statistical computer software.

• Utilize Business Intelligence software to build reports and dashboards

• Develop, modify, and implement computer programs in a logical and sequential manner.

• Prepare data flow charts and documentation pertaining to data lifecycle with speed and accuracy

• Collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.

• Think critically and strategically.

• Prioritize workload.

• Work independently and as a member of a team.

• Demonstrate understanding of, sensitivity to and respect for, the diverse academic, socio-economic, race, ethnicity, gender identity, sexual orientation, age, politics, philosophy, disability and religious background of all students, faculty and staff.

Education and Experience:

Pattern I

Experience: Two years equivalent to a Systems and Programming Analyst at YCCD.

OR Pattern II

Experience: Three years of increasingly responsible experience in data analytics or computer science

Education: A Bachelor’s degree from an accredited college or university with major course work in computer information systems, computer science, or closely related field.

ESSENTIAL DUTIES

• Prepares required internal, local, state, and federal reports in a timely, accurate manner using the college administrative software, business intelligence software and other resources while communicating with the colleges to ensure uniformity of required system reports

• Maintains and communicates state reporting requirements to appropriate college and district offices.

• Develop, write, execute, test, debug, implement, modify and support new or existing statistical or mathematical software programs in support of reporting and data analysis projects

• Write documentation of reporting processes and programming changes.

• Primarily responsible for MIS and IPEDS reporting CCCCO reporting such as MIS and SCFF, Federal IPEDS reporting and other regulatory FOIA/CPRA data requests.

• Manage, reformat, enter, edit, merge and maintain data in preparation for analysis

• Conduct validation checks with appropriate college offices.

• Collects, analyzes, interprets, and summarizes data in preparation for generation of statistical and analytical reports.

• Utilize Business Intelligence platforms to build data presentation layer, reports and dashboards.

• Design database structures in accordance to project requirements and stakeholder needs.

• Coordinates with programming staff to ensure programming efforts meet acceptable data standards and project objectives with respect to data.

• Participates in activities surrounding data classification, data retention, and data governance

• Participates in activities surrounding data security and compliance with local, state and federal requirements.

• As an active participant in Change Management, creates detailed change requests as necessary for application and system changes which are submitted for review, approval and execution by other authorized individuals or groups.

• As an active participant in Lifecyle Management, reviews and recommends changes to existing application code, reports and systems.

• Work with the college research offices and Information Technology staff to troubleshoot data errors, as needed.

• Submit a wide variety of state and federally mandated reports, as necessary.

• Review statistical output for consistency and quality.

• Prepare and assemble data sets, corresponding forms and other materials for internal and public use as specified according to policy regulations.

• Maintains appropriate records of research methods and results.

• Utilizes specified statistical software to analyze and interpret research data.

• Designs and/or develops specific databases for collection, tracking, and reporting of data, as appropriate.

• Serves as liaison between IT and departments throughout YCCD.

• Serves on committees as requested.

• Perform other job duties as assigned.

Licenses and Certificates:

• Depending upon assignment, a valid license to drive in California may be required.

• Physical and Mental Standards