Title: STAFF INFORMATION SYSTEMS ANALYST (SPECIALIST) Salary: $5,065.00 - $6,466.00 Posted: 07/03/2013
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
WHO MAY APPLY
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.
PLEASE NOTE: 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.
HOW TO APPLY
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
APPLICATIONS MUST BE RECEIVED BY: July 24, 2013
174 - 530 - 1312 -
Final Filing Date:
Analysis, Measurement, and Accountability 1430 N Street, Suite 5408 Sacramento, 95814
Karen Heiner 916-319-0635
Use your browsers "BACK" button
to return to your results/listing page.
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.