Data Analyst - It Enterprise Applications - Central Services

Data Analyst - IT Enterprise Applications - Central Services

Yosemite Community College District/Central Services

Range 52, $7,498 to $9,568 per month (2023-2024 Classified Salary Schedule)
Worksite: Central Services/Modesto Junior College
40 hours per week, 12 months per year.
Monday through Friday: 8:00am – 5:00pm
8 hours per day, 5 days per week
(May include some evenings & weekends)

Appointments are hired at the first step of the range. The second step is paid after the first year of satisfactory service with subsequent steps annually thereafter to a maximum sixth step.

The District currently pays for a health options for the employee and dependents. Employees may elect to pay a premium for a higher health option. Vision care and dental insurance premiums for the employee and dependents is District paid. Income protection and life insurance premiums for the employee are also District paid. The estimated cost of District provided benefits (health, dental, vision, and life) is $24,408 annually.

DEFINITIONUnder 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 EXERCISEDIncumbents 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.

• 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.

• 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:

• Mobility: ability to sit for long periods, move about an office, stand occasionally, and reach above and below desk level.
• Dexterity: fine manipulation sufficient to operate a computer keyboard, handle individual papers, write and take notes.
• Lifting: frequent lifting of papers, files, equipment and material weighing up to 50 pounds.
• Visual Requirements: close vision sufficient to read files, documents, and computer screens and do close-up work; ability to adjust focus frequently.
• Hearing/Talking: ability to hear normal speech, speak and hear on the telephone, and speak in person.
• Emotional/Psychological Factors: ability to make decisions and concentrate; frequent contact with others including some public contact; frequent deadlines and time-limited assignments.

• Work is generally performed in a standard office environment.
• Work may require long periods of standing or sitting in an office environment.
• Work may require occasional evening and weekend hours.

Applications are accepted online only at:
https://www.yosemite.edu/recruitment/employmentopportunities/
Select Job Openings, Select Search Jobs, Select Job Title, Create an account and Apply to this job.
Classified:
This is a classified bargaining unit position.
Applications will be reviewed by a screening committee which will select candidates to be interviewed.
Those applicants selected for personal interview will be notified by email or phone. In accordance with Board policy official offers of employment will be made only by the Chancellor or Vice Chancellor/Human Resources, YCCD. Final appointment is subject to confirmation by the Board of Trustees.
Federal law requires the District employ only US citizens and aliens authorized to work in the United States. Written verification of employment eligibility is required.
BACKGROUND CHECK: A background investigation of new employees is required, including reference checks and a state criminal history report. Employment will not begin until the history check has been cleared by Human Resources. The cost for the criminal history report will be the responsibility of the successful candidate.
The District may hire more than one applicant from this applicant pool.
Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the position.
The Yosemite Community College District is an Equal Opportunity Employer.
It is the policy of Yosemite Community College District (Modesto Junior College and Columbia College) not to discriminate on the basis of race, color, national origin, sex or disability in its educational programs and its employment practices. YCCD BP 3410 Nondiscrimination can be found at: https://www.yosemite.edu/trustees/board_policy/3410%20Nondiscrimination.pdf
Title IX Sexual Harassment regulations define Title IX Sexual Harassment to include four terms “as defined in” the Clery Act and the Violence Against Women Act (VAWA): Sexual Assault, Dating Violence, Domestic Violence, and Stalking.
In accordance with 34 C.F.R. §§ 100.6(d), 104.8, and 106.9; and 28 C.F.R. § 35.106, the following person has been designated to handle inquiries regarding Title IX, Section 504/Title II policies:
District Title IX/Civil Rights Compliance Coordinator
Yosemite Community College District
2201 Blue Gum Ave., Modesto, CA 95358

03/12/2024

04/02/2024

No