Under the general direction of the Director of Continuous Improvement, the Systems and Procedures Analyst performs complex technical and analytical work assisting the District in the development of standard operating procedures (SOP's) to ensure data integrity and accuracy that forms a foundation for data-driven management decisions District-wide; develops and delivers trainings to departmental and site staff in the application of the SOP's; creates and maintains a library of data quality rules and other assets for alerting and reporting data exceptions.
The incumbents in this classification provide the school community with accurate, extensive, and reliable data about students and programs which directly support student learning and achievement.
The following alphabetical list of functions, duties and tasks is typical for this classification.
Incumbents may not perform all of the listed duties and/or may be required to perform other closely related or department-specific functions, duties and tasks from those set forth below to address business needs and changing business practices.
- Assists as assigned in compiling data for schools/departments for grant writing.
- Assists in determining methods for carrying out the broad overall policies (such as those from California Department of Education (CDE)) applicable to the department and provides lead expertise to school site staff to assist them in completing their work within compliance standards.
- Attends conferences and training events to keep up to date on trends and developments in assigned areas.
- Attends workshops, meetings, and other gatherings including online platforms related to assigned area.
- Conducts quality review audits to determine adherence to SOPs and policies.
- Confers with and advises the department head and other management personnel on general departmental administrative policies and procedures.
- Creates training materials related to the student information system that comply with District, State and Federal policies to ensure that staff correctly identify and enter student data accurately and efficiently.
- Develops and maintains a library of District SOPs for data entry and retrieval for student and other information systems (e.g., LCAP, CALPADS, CBEDS, discipline and attendance).
- Develops standard operating procedures and updates user manuals and guides to assist departments and school sites to accurately use the knowledge-based gallery for data storage and retrieval processes.
- Develops, reviews, updates, and evaluates standard operating policies and procedures which include adherence to data entry protocols; discovers new requirements for additional standard operating procedures by creation and inspection of exception reports and data sources that include but are not limited to the student information system and closely related systems (currently Aeries, ParentSquare, Salesforce, or others that may be installed in future).
- Leads the deployment of system requirements and new District-wide programs as assigned (such as Parent Square) including understanding and learning the new application in order to assist other users.
- Leads the program of student data collection specifically required for CALPADS and similar systems for mandated reporting.
- May be assigned to compile and complete data for a variety of Federal and State reports.
- Operates and understands various computer software programs, tools and systems including SQL Server, SQL reporting services, Excel, Access and other District-standard software applications.
- Prepares technical documents/SOPs and reviews for data accuracy to ensure the integrity and credibility of the District reports and dashboards; coordinates the structuring, collection, and dissemination of data through computer-generated methods; composes correspondence and maintain records.
- Trains departmental and non-departmental personnel on specific issues related to assigned areas and in coordination with the Technology Trainer in Information Technology Support Services Department.
- Performs other related duties as assigned for the purpose of ensuring the efficient and effective functioning of the work unit and the District, including various mandatory District trainings.
KNOWLEDGE, SKILLS, AND ABILITIES(At time of application)
Knowledge of:- Computer hardware systems, software applications, and languages utilized by the District (currently including the apps bundled into Google Suites)
- Interpersonal skills using tact, patience and courtesy
- Basic statistics and analytical and problem-solving techniques
- Oral and written communication skills
- Principles and practices of management
- Applicable laws, codes, regulations, policies, and procedures
- District organization, operations, policies, objectives, and goals
Skills and Abilities to:- Update continually current knowledge of trends in the assigned field
- Operate computers and peripheral equipment properly and efficiently
- Establish and maintain effective and productive working relationships with a diverse range of people
- Think outside the box and develop new methods or solutions inspiring others to reach a common goal
- Communicate, understand, and follow both oral and written directions effectively
- Interpret, comprehend, apply and explain rules, regulations, policies and procedures
- Analyze situations accurately and adopt an effective course of action
- Learn independently in self-teaching mode a variety of new or updated computer systems and/or software programs to apply to current work
- Work independently and effectively with minimum direction
- Prepare comprehensive narrative and statistical reports
- Write queries using SQL and other query languages to support ongoing and one-time report needs
- Plan and organize work to meet schedules and timelines
- Communicate effectively using patience and courtesy in a manner that reflects positively on the organization
- Actively participate in meeting District goals and outcomes
RESPONSIBILITY:Responsibilities include working under direct supervision using standardized routines; leading, guiding, and/or coordinating others; and operating within a defined budget. Utilization of resources from other work units is often required to perform the job's functions. There is a continual opportunity to have some impact on the organization's services.
EDUCATION REQUIRED:Bachelor's degree in Computer Information Systems, Business Administration, Organizational Management, Communications (with significant coursework in Computer Information Systems and Information Management), or a closely related field.
EXPERIENCE REQUIRED:Four (4) years of increasingly responsible professional experience in the development of operational policies and procedures, analyzing operational needs, and/or recommending organizational improvements.
LICENSE(S) REQUIRED:- Valid, current California Driver's License or ability to provide transportation to meetings, events, and trainings associated with essential functions, duties, and tasks.
CERTIFICATIONS AND TESTING REQUIRED:- Pass the District's applicable proficiency exam for the job class with a satisfactory score
- After the offer of employment, obtain:
- Criminal Justice and FBI Fingerprint Clearance
- Negative TB test result plus periodic post-employment retest as required (currently every four years)
- Pre-employment physical exam through the District's provider
SALARY SCHEDULE: Classified Salary Range: 40
Work Calendar: 261 Days
Work hours: 8:00 am to 5:00 pm
An Eligibility list will be used to fill future Student Data Systems and Procedures Analyst openings.TENTATIVE DATE & LOCATION FOR EXAMINATION - Tuesday, July 1, 2025, at 9:00 am at Madera Adult School1. Completed application
2. A copy of official college transcript showing proof of completion of a bachelor's degree in Computer Information Systems, Business Administration, Organizational Management, Communications (with significant coursework in Computer Information Systems and Information Management), or a closely related field.
3. Resume
*PC RULES 5.2.1.2 5.2.1.2 - In-house employees will have first consideration for the position. If sufficient candidates are not available to complete the three ranks, the Personnel Commission will move to include outside candidates.
The examination process will include screening to ensure applications are complete and meet all minimum qualifications. No additional information will be accepted from applicants once the application has been submitted.
Only the most qualified applicants, who pass the minimum qualifications review, will be invited to the examination process.The examination process will include a multiple-choice competency exam weighted at 50% and a data analysis performance exam weighted at 50% for a total exam weight of 100%. Those candidates achieving a minimum passing score of 70% on each examination will be placed on the eligibility list, and the top three ranks will be forwarded to the hiring authority.
The Eligibility List is valid for one (1) year from the certified date.
To move forward in the selection process, you must complete an online application through this website.
Resumes may be uploaded but cannot be used in place of a completed application.The examination process/examination date is subject to change as needs dictate due to the COVID-19 situation. All communication regarding this process will be delivered via email to the email address listed on your application.
SUBMISSION OF APPLICATION: ONCE YOU HAVE SUBMITTED YOUR APPLICATION, YOU WILL NOT BE ABLE TO MAKE REVISIONS TO YOUR APPLICATION MATERIALS.When completing the application, please make sure you include
ALL current and previous employment in the Work Experience section of the application and complete
ALL fields, including the name and contact information of your supervisors. The experience that is included in the resume but not in the Work Experience section of the application
may not be considered for the purpose of determining whether you meet the minimum qualifications.All required documents must be submitted by the applicant. Personnel Commission staff will not upload your documents for you.
If you have any questions regarding the recruitment process, please contact Personnel Specialist Lead, Mary Siegl, at (559) 675-4500 Ext 295 or email marysiegl@maderausd.org
ACCOMMODATIONS: Individuals with disabilities requiring reasonable accommodation in the selection process must inform the Madera Unified School District Personnel Commission Department in writing no later than the filing date stated on the announcement. Those applicants needing such accommodations should document this request, including an explanation as to the type and extent of accommodation needed to participate in the selection process.
The Governing Board desires to provide a positive work environment where employees and job applicants are assured of equal access and opportunities and are free from harassment in accordance with the law. The Board prohibits district employees from discriminating against or harassing any other district employees and job applicants on the basis of the person's actual or perceived race, religious creed, color, national origin, ancestry, age, marital status, pregnancy, physical or mental disability, medical condition, genetic information, veteran status, gender, gender identity, gender expression, sex, or sexual orientation. The following person is designated as the Title IX Coordinator.
Prince Marshall, Executive Director of Student and Family Support Services
1820 Howard Road
Madera, CA 93637
559-416-5826Closing Date/Time: Mon, 23 Jun 2025