Data Systems Analyst
Apply NowCompany: Simi Valley Unified School District
Location: Simi Valley, CA 93065
Description:
Salary : $6,675.07 - $8,112.00 Monthly
Location : Simi Valley, CA
Job Type: Full-Time Perm
Job Number: 25-1030-1
Department: Information Technology
Opening Date: 04/17/2025
Closing Date: 5/9/2025 11:59 PM Pacific
PURPOSE
To fill current and future vacancies for the duration of the list, up to one year. The current vacancy is 12-month, full-time (8 hours/day), position located in the Information Technology Department, at the District Office in Simi Valley, California.
FILING DATE: Completed applications must be submitted no later than 11:59 p.m. on May 9, 2025.. Late applications will not be accepted.
TESTING PROCESS:
A) Training and Experience (T&E) Evaluation = Qualifying (pass/fail)
B) Structured Interview/Performance Exercise= 100% weighting on final score
Tentatively scheduled for as early as the week of May 12, 2025.
Applicants must meet the minimum qualifications stated in the job posting by the application deadline in order to move forward in the testing process. Those applicants who meet the minimum qualifications will have their application materials reviewed by a screening committee that will evaluate the training and experience of each applicant as it relates to the areas assessed in the supplemental questions. Those with the highest scores on the T&E will be invited to the structured interview. The testing process is subject to change as needs dictate. All communication regarding this process will be delivered via email.
Class specifications are intended to present a descriptive list of the range of duties performed by employees in the class. Specifications are not intended to reflect all duties performed within the job.
Purpose Statement
Under the general supervision of the Director of Information Technology, the Data Systems Analyst is responsible for supporting the school district's data infrastructure by analyzing data, identifying data integrity issues, and enhancing data systems processes to facilitate efficient and accurate reporting and decision-making processes. Performs a variety of technical and analytical functions within the district's information systems, such as the student information system, library and inventory management system, and other database systems.
This role involves collaborating with stakeholders to collect, analyze, and interpret data to ensure compliance with state and federal reporting requirements, improve instructional practices, and support data-driven decision-making within the district. Additionally, the Data Systems Analyst collaborates with the Data Systems Administrator and Student Data System Specialist and assists in vendor data requests.
Distinguishing Characteristics:
The Data Systems Analyst combines technical expertise with an understanding of educational data systems. This role requires proficiency in managing student information systems, data reporting platforms, and compliance with regulatory requirements. The analyst must have advanced skills in data analysis, complex querying and reporting, transforming raw data into actionable insights for district leadership. This position also fosters interdepartmental collaboration by bridging technical capabilities with educational and operational goals.
In comparison:
ESSENTIAL DUTIES & RESPONSIBILITIES
Data Analysis, Reporting, and Data Collection Configuration
MINIMUM QUALIFICATIONS
A high school diploma or equivalent, along with four years of recent experience working with SQL (preferably within student information systems).
OR,
Associate degree in management information systems, computer science, information technology, or a related field and two years of recent experience working with SQL (preferably within student information systems).
OR,
Bachelor's degree in management information systems, computer science, information technology, or a related field and one year of recent experience working with SQL (preferably within student information systems).
Licenses and Certificates
SUPPLEMENTAL INFORMATION
Skills, Knowledge, and Abilities
Skills to:
Salary: Five step salary range that provides annual increases of approximately five percent until the fifth step is reached. New hire initial step placement (normally up to Step 3) based on qualifying education and experience as outlined in Merit System Rule 7.20.1. An employee who is promoted to a higher class shall be placed on the step of the new salary range that is at least five percent above the current rate, excluding any differential pay.
Vacation: Earned based on assigned hours. Increased vacation allowance based on years of service with the district. Confidential employees receive an additional 3 days vacation allotment, up to a maximum of 22 days. Management employees receive 22 days of vacation (based on 12-month assignment).
Sick Leave: Earned at the rate of one day (based on the number of assigned hours) per month, and is accumulative from year to year.
Holidays: Fourteen paid holidays per year (based on 12-month assignment).
Insurance and Credit Union: The District offers a competitive Health and Welfare plan for employees and dependents, based upon the number of hours worked; employees who are placed in a regular assignment of 20 hours or more per week are eligible for benefits. The Ventura Schools Federal Credit Union offers a variety of services.
Retirement: Employees are covered by Public Employees Retirement System (PERS) Social Security and Medicare. Contributions are made by both the employee and employer. Click to visit website.
01
This supplemental application form may be used by a Training and Experience Rating Committee to evaluate your qualifications for this position. Based on the evaluation, the candidates with the highest scores will be invited to a structured interview. Therefore, it is imperative that you answer the questions as completely and accurately as possible.Describe YOUR EXPERIENCE and YOUR QUALIFICATIONS carefully as this information will help us determine how well you meet the (minimum and relative) employment qualification standards for this classification. All information should be clearly stated - incomplete or vague responses may disqualify your application or reduce the credit given for your qualifications and cause you to be screened out of the process. Respond honestly and truthfully to all questions. Over-evaluating your skill level is considered false and/or misleading information. Applicants found to have provided false or misleading information or over-evaluation of their skills will be disqualified from further employment processing.All information requested in the questions must be indicated on this supplemental application. References to other documents, statements such as "please see resume," biographical sketches, etc. will not be accepted in-lieu of this supplemental application. You may attach your resume in addition to the supplemental application. The general application form must also be completed.Please respond below indicating that you have read and understood these instructions and agree to answer the following questions as completely, accurately, and honestly as possible.
02
Which of the following best describes your highest level of completed education? (Select one)
03
If other degree or field, please specify:
04
How many years of recent experience do you have working with SQL (Structured Query Language)?
05
Does your experience with SQL include use within a student information system (SIS) or a school district setting?
06
If yes, please specify which student information system (SIS) platform(s) you used (e.g., Aeries, PowerSchool, Synergy) and your related duties
07
Describe your experience using Structured Query Language (SQL) for data querying and analysis. Please include:A. The types of the reports and queries you typically prepared or worked with.B. The purpose of the queries (e.g., reporting, troubleshooting, data validation)C. The specific systems or databases you usedD. Your overall comfort level working with Structured Query Language (SQL) (e.g., Beginner, Basic, Intermediate, Advanced, Expert).
08
What does data integrity mean for you? In your response, please describe:(A) in your own words what does data integrity mean (B) how do you identify data integrity issues(C) the actions and rules that you have put in place to secure data integrity in your organization (D) software applications and tools you utilized in the last five years to ensure data integrity and privacy. If you do not have any experience in this area, please indicate "N/A".
09
What is the purpose of primary keys and foreign keys in rational databases? Provide an example of how they are used to establish relationships between tables.
Required Question
Location : Simi Valley, CA
Job Type: Full-Time Perm
Job Number: 25-1030-1
Department: Information Technology
Opening Date: 04/17/2025
Closing Date: 5/9/2025 11:59 PM Pacific
PURPOSE
To fill current and future vacancies for the duration of the list, up to one year. The current vacancy is 12-month, full-time (8 hours/day), position located in the Information Technology Department, at the District Office in Simi Valley, California.
FILING DATE: Completed applications must be submitted no later than 11:59 p.m. on May 9, 2025.. Late applications will not be accepted.
TESTING PROCESS:
A) Training and Experience (T&E) Evaluation = Qualifying (pass/fail)
B) Structured Interview/Performance Exercise= 100% weighting on final score
Tentatively scheduled for as early as the week of May 12, 2025.
Applicants must meet the minimum qualifications stated in the job posting by the application deadline in order to move forward in the testing process. Those applicants who meet the minimum qualifications will have their application materials reviewed by a screening committee that will evaluate the training and experience of each applicant as it relates to the areas assessed in the supplemental questions. Those with the highest scores on the T&E will be invited to the structured interview. The testing process is subject to change as needs dictate. All communication regarding this process will be delivered via email.
Class specifications are intended to present a descriptive list of the range of duties performed by employees in the class. Specifications are not intended to reflect all duties performed within the job.
Purpose Statement
Under the general supervision of the Director of Information Technology, the Data Systems Analyst is responsible for supporting the school district's data infrastructure by analyzing data, identifying data integrity issues, and enhancing data systems processes to facilitate efficient and accurate reporting and decision-making processes. Performs a variety of technical and analytical functions within the district's information systems, such as the student information system, library and inventory management system, and other database systems.
This role involves collaborating with stakeholders to collect, analyze, and interpret data to ensure compliance with state and federal reporting requirements, improve instructional practices, and support data-driven decision-making within the district. Additionally, the Data Systems Analyst collaborates with the Data Systems Administrator and Student Data System Specialist and assists in vendor data requests.
Distinguishing Characteristics:
The Data Systems Analyst combines technical expertise with an understanding of educational data systems. This role requires proficiency in managing student information systems, data reporting platforms, and compliance with regulatory requirements. The analyst must have advanced skills in data analysis, complex querying and reporting, transforming raw data into actionable insights for district leadership. This position also fosters interdepartmental collaboration by bridging technical capabilities with educational and operational goals.
In comparison:
- The Student Data System Specialist focuses on student records, transcripts, and compliance reporting (e.g., CALPADS). This role also includes training school site staff to use data systems effectively.
- The Data Systems Analyst focuses on data analysis, reporting, and optimization of data systems, requiring proficiency in SQL and a deep understanding of compliance regulations.
- The Data Systems Administrator is a more technical, higher-level role, responsible for database security, system configuration, and integration. This position requires expertise in SQL, strong troubleshooting abilities, and coordination with vendors.
ESSENTIAL DUTIES & RESPONSIBILITIES
Data Analysis, Reporting, and Data Collection Configuration
- Designs and utilizes complex database queries for data analysis, reporting, and specific data extraction.
- Develops and maintains custom reports to support data-driven decision-making for administrators, teachers, and other stakeholders.
- Configures data collection processes such as Student Data Confirmation.
- Develops and implements standards, practices, and procedures to ensure data integrity and accuracy.
- Imports and exports data between the Student Information System and various vendor systems.
- Analyzes, troubleshoots, and resolves district-level information system issues.
- Refers server-level issues for the library and inventory management systems to the vendors and serves as the primary liaison for troubleshooting and resolution.
- Assists educational services with digital curriculum.
- Identifies, troubleshoots, and resolves data systems or data quality issues.
- Collaborates with Information Technology (IT) staff to integrate data systems and streamline workflows.
- Maintains up-to-date knowledge of educational data systems to recommend and implement improvements.
- Ensures the privacy and security of student and staff data, adhering to all state and federal regulations.
- Provides training and technical support to staff on the effective use of data systems and tools.
- Designs and produces user guides and other resources for proper utilization of data systems.
- Performs other duties as assigned that support the overall objective of the position.
MINIMUM QUALIFICATIONS
A high school diploma or equivalent, along with four years of recent experience working with SQL (preferably within student information systems).
OR,
Associate degree in management information systems, computer science, information technology, or a related field and two years of recent experience working with SQL (preferably within student information systems).
OR,
Bachelor's degree in management information systems, computer science, information technology, or a related field and one year of recent experience working with SQL (preferably within student information systems).
Licenses and Certificates
- Industry certifications relevant to database management and data analysis are desirable.
SUPPLEMENTAL INFORMATION
Skills, Knowledge, and Abilities
Skills to:
- Analyze and interpret data
- Design complex data queries utilizing Structured Query Language (SQL)
- Ensure data integrity and accuracy
- Generate accurate reports.
- Configure data collection processes.
- Troubleshoot system issues.
- Create user guides and resources.
- Maintain high levels of attention to detail and data security and privacy.
- Collaborate effectively with staff and cross-functional teams to support district goals.
- Data integrity and accuracy standards.
- Student Information Systems (SIS) and related data management tools.
- Data privacy laws and regulations (such as Family Educational Rights and Privacy Act - FERPA.).
- Database structures, queries, and reporting platforms.
- Common troubleshooting practices.
- Data export and import processes across systems
- Educational technology and administrative software systems.
- End-user technical support and training strategies.
- Design and implement complex data queries for detailed reporting and analysis
- Develop and maintain custom reports to support decision-making
- Configure and streamline data collection processes for consistency and accuracy
- Troubleshoot, analyze, and resolve system issues independently and collaboratively
- Collaborate effectively with IT teams to integrate data systems and improve workflows
- Ensure data privacy and security by adhering to regulations and district policies
- Deliver training and provide ongoing support for data system users
- Create user guides and documentation for staff utilization of data tools and systems
- Maintain up-to-date knowledge of emerging data systems and technologies in education
- Ensure smooth communication with vendors to resolve system-level issues
- Work is performed in an indoor office environment with minimal exposure to safety hazards.
- Position requires prolonged periods of sitting, operating a computer, and using standard office equipment.
- Occasional travel within the district may be required to provide on-site support and training.
Salary: Five step salary range that provides annual increases of approximately five percent until the fifth step is reached. New hire initial step placement (normally up to Step 3) based on qualifying education and experience as outlined in Merit System Rule 7.20.1. An employee who is promoted to a higher class shall be placed on the step of the new salary range that is at least five percent above the current rate, excluding any differential pay.
Vacation: Earned based on assigned hours. Increased vacation allowance based on years of service with the district. Confidential employees receive an additional 3 days vacation allotment, up to a maximum of 22 days. Management employees receive 22 days of vacation (based on 12-month assignment).
Sick Leave: Earned at the rate of one day (based on the number of assigned hours) per month, and is accumulative from year to year.
Holidays: Fourteen paid holidays per year (based on 12-month assignment).
Insurance and Credit Union: The District offers a competitive Health and Welfare plan for employees and dependents, based upon the number of hours worked; employees who are placed in a regular assignment of 20 hours or more per week are eligible for benefits. The Ventura Schools Federal Credit Union offers a variety of services.
Retirement: Employees are covered by Public Employees Retirement System (PERS) Social Security and Medicare. Contributions are made by both the employee and employer. Click to visit website.
01
This supplemental application form may be used by a Training and Experience Rating Committee to evaluate your qualifications for this position. Based on the evaluation, the candidates with the highest scores will be invited to a structured interview. Therefore, it is imperative that you answer the questions as completely and accurately as possible.Describe YOUR EXPERIENCE and YOUR QUALIFICATIONS carefully as this information will help us determine how well you meet the (minimum and relative) employment qualification standards for this classification. All information should be clearly stated - incomplete or vague responses may disqualify your application or reduce the credit given for your qualifications and cause you to be screened out of the process. Respond honestly and truthfully to all questions. Over-evaluating your skill level is considered false and/or misleading information. Applicants found to have provided false or misleading information or over-evaluation of their skills will be disqualified from further employment processing.All information requested in the questions must be indicated on this supplemental application. References to other documents, statements such as "please see resume," biographical sketches, etc. will not be accepted in-lieu of this supplemental application. You may attach your resume in addition to the supplemental application. The general application form must also be completed.Please respond below indicating that you have read and understood these instructions and agree to answer the following questions as completely, accurately, and honestly as possible.
- Yes, I agree to answer the following questions as completely, accurately, and honestly as possible
- I do not agree
02
Which of the following best describes your highest level of completed education? (Select one)
- High school diploma or equivalent
- Associate degree in management information systems, computer science, information technology, or a related field
- Bachelor's degree in management information systems, computer science, information technology, or a related field
- Other degree or field
03
If other degree or field, please specify:
04
How many years of recent experience do you have working with SQL (Structured Query Language)?
- Less than 1 year
- 1-2 years
- 3-4 years
- 4 or more years
05
Does your experience with SQL include use within a student information system (SIS) or a school district setting?
- Yes
- No
06
If yes, please specify which student information system (SIS) platform(s) you used (e.g., Aeries, PowerSchool, Synergy) and your related duties
07
Describe your experience using Structured Query Language (SQL) for data querying and analysis. Please include:A. The types of the reports and queries you typically prepared or worked with.B. The purpose of the queries (e.g., reporting, troubleshooting, data validation)C. The specific systems or databases you usedD. Your overall comfort level working with Structured Query Language (SQL) (e.g., Beginner, Basic, Intermediate, Advanced, Expert).
08
What does data integrity mean for you? In your response, please describe:(A) in your own words what does data integrity mean (B) how do you identify data integrity issues(C) the actions and rules that you have put in place to secure data integrity in your organization (D) software applications and tools you utilized in the last five years to ensure data integrity and privacy. If you do not have any experience in this area, please indicate "N/A".
09
What is the purpose of primary keys and foreign keys in rational databases? Provide an example of how they are used to establish relationships between tables.
Required Question