Link to New Search

Salary: $5,065.00 - $6,466.00
Posted: 07/03/2013

Job Description:


Under the general supervision of the Education Research and Evaluation Administrator I, of the Academic Accountability Unit, the Staff Information Systems Analyst (Specialist) will:

  • Use Structural Query Language (SQL) to design, develop, and maintain custom queries in response to data requests. Design, develop, and implement distinct data file matching algorithms using stored procedures. Design, develop, and implement data redaction schemes depending on the nature and level of the data. Use SQL to review data files to ensure valid data population and redaction schemes are correctly implemented. Use SQL to produce large data sets and write and encrypt data to portable media or secure file transfer protocol servers for transmission to customers per Department standards.
  • Develop new state and federal accountability Web pages to better communicate complex data to parents, community members, school and district staff, and other educational stakeholders. Prepare, submit, and maintain project issue papers, charters, timelines, organizational charts, budgets, requirements, and project reporting documents. Meet with customers, solicit and document content and function requirements. Design, develop, and maintain accountability Internet reporting applications using Microsoft Visual Studio software. Conduct code reviews and application testing with peer developers.
  • Support accountability data reporting by acquiring, transforming, validating, and providing data work in CALPADS. Process data for the state, local educational agency (LEA), and school accountability report cards, and online accountability reports. Review and work with project team members to update system and user requirements documentation and existing reports. Using SQL server tools, write code and queries to acquire, process, and transform data into data files and SQL queries and tables. Validate data.
  • Support the design, development, and testing of CALPADS related data files, file layouts, and reports. Serve as an assessment and accountability expert to assist in diagnosing and correcting CALPADS data issues.


  • Strong Microsoft SQL Server database skills
  • Proficiency in Microsoft Office, specifically Microsoft Word, Access, and Excel
  • Excellent interpersonal skills, including tact, judgment, and independence of action
  • Ability to work independently and on a team to ensure project deadlines are met


Individuals who have eligibility for appointment to the above class (e.g., transfer, list, reinstatement). All applicants must clearly indicate the basis of their eligibility in the “Explanations” section on the Standard Application Form (Std 678). Employment provisions as outlined by the California Department of Human Resources’ State Restriction of Appointments (SROA) policy will prevail. In addition, current or future executive orders relative to filling vacant positions may also affect this process. Applications will be screened and only the most qualified will be interviewed.

Possession of minimum qualifications will be verified prior to interview and/or appointment. If it is determined an applicant does not meet the minimum qualifications, the applicant will be removed from the eligibility list.


Submit a State Application (Form 678) to:
Karen Heiner, Research Analyst
Analysis, Measurement, and Accountability Reporting Division
1430 N Street, Suite 5408
Sacramento, CA 95814


Additional Information:

Working Title Position Number
PC 3220 174 - 530 - 1312 -
Location County
Timebase Tenure
Full Time Permanent   month(s)
Final Filing Date: Department Link:
07/24/2013 None Specified
Contact Unit/Address Contact Name/Phone
Analysis, Measurement, and Accountability
1430 N Street, Suite 5408
Sacramento, 95814
Karen Heiner

Use your browsers "BACK" button to return to your results/listing page.

Start A New Search

Enter your email address to be notified when new STAFF INFORMATION SYSTEMS ANALYST (SPECIALIST) vacancies are posted.

Start A New Search

View in Printer
Friendly Format

Notice: If you are not a current or former State employee, you must first take an examination to obtain list eligibility. This does not apply to Student Assistant vacancies. Learn all about it.

The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.