Computer Software Analyst II - #81-25
Apply NowCompany: Newport Mesa Unified School District
Location: Costa Mesa, CA 92627
Description:
Salary: $9,396.00 - $11,421.00 Monthly
Location : CA 92626, CA
Job Type: Full-Time
Job Number: 81-25
Department: Information Technology
Opening Date: 04/15/2025
Closing Date: 5/6/2025 12:00 PM Pacific
The Vacancy, Basic Function, Minimum Qualifications
THE VACANCY:
This recruitment is open and promotional, meaning that all are welcome to apply and employees in permanent positions are eligible to receive seniority credit and promotional placement once passing all exams.
There is currently one opening located in the Information Technology Department (8 hours per day, 5 days per week, 12 months per year).
Please apply online at .
BASIC FUNCTION:
Under direction of the Director of Information Technology, provide highest level of support for the assigned Student Information Systems (SIS), develop or maintain data interfaces, develop customer reports, extract and manipulate statistical data from SIS, create technical and end-user documentation, provide training on both software and related procedures.
MINIMUM QUALIFICATIONS:EDUCATION AND EXPERIENCE:
Any combination equivalent to: bachelor's degree in computer science or a related field and three years of experience performing duties of increasing responsibilities in a computing environment.
Examination Procedures And Information
THE EXAMINATION:
Exam Weight
Supplemental Questions: Qualifying
Qualifications Appraisal Interview: 100%
The supplemental questions to the application will be reviewed and rated for certification. These questions are required at the time of application and are qualifying.
An eligibility list will be established for successful candidates which will be used to fill open positions during the life of the list.
Examinations and interviews held to create the eligible list will be conducted virtually, using different online/internet platforms that require video recording or conferencing capabilities, as well as access to a computer with internet connection and basic Microsoft Office Suite Software.
The virtual Qualifications Appraisal Interview (Oral Exam) is tentatively scheduled for the week of May 12th. You will be contacted by email, as indicated on your application, regarding your ability to participate in the examination phase of this recruitment.
Applications will be reviewed for minimum requirements. However, Newport-Mesa Unified School District reserves the right to hold a competitive screening based on the number of applications and the needs of the District.
If you elect to have Newport-Mesa Unified School District (hereafter, 'District') contact you via email regarding your application and the hiring process, please be aware that the District is not responsible for any contacts you may have blocked on your email service. Unclaimed emails to applicants are not the responsibility of the District. In an effort to allow our emails through your personal spam filter, you can try to add and domains to your safe senders list.
Job Responsibilities
REPRESENTATIVE DUTIES:
ESSENTIAL DUTIES:
Provide highest level of support for assigned SIS, including both troubleshooting and enhancing functionality.
Develop, test and implement complex custom solutions using standard scripting languages on desktop and server computers. Handle common requests such as automating complex data imports and exports, including creating custom reports.
Create or maintain systems for synchronizing data between the SIS and various other systems (e.g., Active Directory, library systems, and Special Education systems).
Use Structured Query Language (SQL), macros, embedded languages, scripting, or complex formulae in commercial software packages to create custom solutions.
Create and manage user experience and user interface designs for interactive data dashboard systems.
Make decisions on routine security settings in assigned systems. Put those changes into effect via SQL security, Active Directory security groups, and/or application level settings.
Extract, submit and certify data to state or federal agencies (e.g., CALPADS, Civil Rights Data Collection and Perkins Grant Management System).
Work collaboratively with vendors or other agencies to resolve SIS or related problems. Work collaboratively with outside agencies to share SIS data securely. Ensure all data sharing complies with data privacy laws.
Train and provide work direction to staff as required.
Serve as a technical resource to others regarding the more complex and difficult applications issues.
Participate in the review and definition of assigned functional areas, processes and procedures regarding requirements, organization and flow of data, methods and forms.
Provide assistance and support the more common personal computer software applications
Provide training to customers in the use of various Report Writer programs, software and products.
Create technical and write and maintain end-user documentation. The form of this documentation may be written, audio, video or screencast.
Install software packages; data conversion; package maintenance.
Troubleshoot system problems, identify, evaluate and resolve program problems and data problems.
Consult with users to provide support and to determine systems and software requirements and objectives. Assist users with understanding SIS procedures and creating custom queries.
Communicate changes in assigned configuration to customers and related support activities.
Provide recommendations as appropriate for changes or improvements to assigned environments.
OTHER DUTIES:
Perform related duties as assigned.
KNOWLEDGE AND ABILITIES:
KNOWLEDGE OF:
Student Information Systems (e.g., Aeries, Synergy, Destiny, Illuminate, Naviance) operations, troubleshooting and maintenance.
Complex Microsoft T-SQL scripting.
SQL database management, security schema design.
Principles and techniques of business process analysis and design.
Elements of system and procedure analysis.
Scripting and macro languages used on computers.
Database functions and structure.
Principles of training/supporting technology users.
Interpersonal relationship techniques.
Principles of providing work direction and guidance to others.
Methods and procedures of operating mainframe and personal computers and peripheral equipment.
ABILITY TO:
Analyze complex user problems, evaluate alternative and devise efficient cost-effective, user-friendly solutions.
Learn new scripting or macro languages quickly.
Use report design software to create, format and structure custom reports.
Communicate clearly to all levels of staff regarding technical issues both orally and in writing.
Produce professional written documents, using correct formatting, grammar and spelling.
Train and provide work direction to staff.
Extract, manipulate and graph data to meet complex requirements.
Meet schedules and time lines.
Work independently with little direction.
Perform difficult and complex programming duties in the analysis of systems requirements and preparation of automated solutions.
Research, compile, organize and analyze statistical and technical data.
Analyze, review and audit operation procedures and develop recommendations.
Provide technical guidance and recommendations concerning existing computer programs and systems.
Perform analysis and modification of existing programs and operations to meet changing needs and to provide for system enhancements.
Demonstrate proficiency in scripting languages (e.g., SQL, VBScript, Windows Powershell).
Maintain current knowledge of technological advances in the field.
WORKING CONDITIONS:ENVIRONMENT:
Office environment
Constant interruptions
PHYSICAL DEMANDS:
Dexterity of hands and fingers to operate a computer keyboard.
Hearing and speaking to exchange information.
Sitting for extended periods of time.
Bending at the waist, kneeling or crouching to reach computer equipment.
Seeing to view a computer monitor.
Carrying, lifting, pushing or pulling moderately heavy objects.
Personnel Commission April 2016
VACATION - HOLIDAYS - ILLNESS
Employees accumulate twelve (12) days of vacation during the first year of employment, increasing up to twenty-two (22) days beginning the 18th year of service, prorated for part-time, 9, 10, and 11 month assignments. The number of paid holidays per year varies from twelve (12) to fourteen (14) days depending on the work calendar. Employees accumulate twelve (12) days of paid sick leave per year, with unlimited accumulation, prorated for part-time, 9, 10, and 11 month employees.
RETIREMENT
All employees who are in the classified service and work four (4) hours per day or more are members of the Public Employees' Retirement System (CalPERS) and Federal Social Security. If an employee in the classified service works less than four (4) hours per day they are members of an Alternate Retirement System (PARS) and do not contribute to Social Security. Approximately 7% is deducted from your paycheck for PERS retirement.
HEALTH & WELFARE
The District offers a comprehensive health benefits program for employees who work twenty (20) hours or more per week. This includes medical, vision, dental insurance plans and life insurance for employees. For full-time employees the District pays the employee's health, vision, dental, and life insurance premiums with an employee contribution required for some plans. For part-time employees plans are available on a prorated basis. Dependent coverage is available.
PROFESSIONAL GROWTH
The District encourages employees to pursue professional growth. Professional growth points shall be earned by employee participation while in non-paid status in activities which are employment related. Professional growth points are awarded annually and accumulate at $20 per approved Professional Growth Point and/or tuition and textbook reimbursement up to $500 is also available - limited to one per year.
01
Information I provide to the following supplemental questions will be reviewed as part of the application process. Questions that are not fully and completely answered will be considered grounds for disqualification from the examination process. Stating "see resume" in lieu of a complete response to these questions is not acceptable. Select "Yes" to indicate that you have read and understand these instructions.
02
Please check the box that most closely describes your level of proficiency in regards to SQL:
03
Please check the box that most closely describes your level of proficiency in regards to Microsoft T-SQL:
04
Please check the box that most closely describes your level of proficiency in regards to Microsoft SQL Server Reporting Services:
05
Please check the box that most closely describes your level of proficiency in regards to Aeries student information system:
06
Please check the box that most closely describes your level of proficiency in regards to Microsoft Excel:
07
Please check the box that most closely describes your level of proficiency in regards to CALPADS:
08
Please check the box that most closely describes your level of proficiency in regards to the Office of Civil Rights reporting:
09
List any other Aeries add-on products that you've supported (AIR, Summer Reregistration, Analytics, EMT, etc).
10
List any scripting languages you've used (VBScript, PowerShell, etc).
11
List any software packages you've used for creating dashboard interfaces or business intelligence functionality (Tableau, Microsoft Power BI, Domo, etc).
12
List any software packages you've used for designing and implementing customer-accessible reports.
13
List any web or app-based services that you've supported which relate to student learning or assessment.
14
Describe the most complex procedure you've created for extracting or reporting data from a database or creating an interface between to different systems/databases (preferably involving the Aeries Student Information System).
15
Explain the differences in reporting requirements for EL students now that the ELPAC has replaced the CELDT.
Required Question
Location : CA 92626, CA
Job Type: Full-Time
Job Number: 81-25
Department: Information Technology
Opening Date: 04/15/2025
Closing Date: 5/6/2025 12:00 PM Pacific
The Vacancy, Basic Function, Minimum Qualifications
THE VACANCY:
This recruitment is open and promotional, meaning that all are welcome to apply and employees in permanent positions are eligible to receive seniority credit and promotional placement once passing all exams.
There is currently one opening located in the Information Technology Department (8 hours per day, 5 days per week, 12 months per year).
Please apply online at .
BASIC FUNCTION:
Under direction of the Director of Information Technology, provide highest level of support for the assigned Student Information Systems (SIS), develop or maintain data interfaces, develop customer reports, extract and manipulate statistical data from SIS, create technical and end-user documentation, provide training on both software and related procedures.
MINIMUM QUALIFICATIONS:EDUCATION AND EXPERIENCE:
Any combination equivalent to: bachelor's degree in computer science or a related field and three years of experience performing duties of increasing responsibilities in a computing environment.
Examination Procedures And Information
THE EXAMINATION:
Exam Weight
Supplemental Questions: Qualifying
Qualifications Appraisal Interview: 100%
The supplemental questions to the application will be reviewed and rated for certification. These questions are required at the time of application and are qualifying.
An eligibility list will be established for successful candidates which will be used to fill open positions during the life of the list.
Examinations and interviews held to create the eligible list will be conducted virtually, using different online/internet platforms that require video recording or conferencing capabilities, as well as access to a computer with internet connection and basic Microsoft Office Suite Software.
The virtual Qualifications Appraisal Interview (Oral Exam) is tentatively scheduled for the week of May 12th. You will be contacted by email, as indicated on your application, regarding your ability to participate in the examination phase of this recruitment.
Applications will be reviewed for minimum requirements. However, Newport-Mesa Unified School District reserves the right to hold a competitive screening based on the number of applications and the needs of the District.
If you elect to have Newport-Mesa Unified School District (hereafter, 'District') contact you via email regarding your application and the hiring process, please be aware that the District is not responsible for any contacts you may have blocked on your email service. Unclaimed emails to applicants are not the responsibility of the District. In an effort to allow our emails through your personal spam filter, you can try to add and domains to your safe senders list.
Job Responsibilities
REPRESENTATIVE DUTIES:
ESSENTIAL DUTIES:
Provide highest level of support for assigned SIS, including both troubleshooting and enhancing functionality.
Develop, test and implement complex custom solutions using standard scripting languages on desktop and server computers. Handle common requests such as automating complex data imports and exports, including creating custom reports.
Create or maintain systems for synchronizing data between the SIS and various other systems (e.g., Active Directory, library systems, and Special Education systems).
Use Structured Query Language (SQL), macros, embedded languages, scripting, or complex formulae in commercial software packages to create custom solutions.
Create and manage user experience and user interface designs for interactive data dashboard systems.
Make decisions on routine security settings in assigned systems. Put those changes into effect via SQL security, Active Directory security groups, and/or application level settings.
Extract, submit and certify data to state or federal agencies (e.g., CALPADS, Civil Rights Data Collection and Perkins Grant Management System).
Work collaboratively with vendors or other agencies to resolve SIS or related problems. Work collaboratively with outside agencies to share SIS data securely. Ensure all data sharing complies with data privacy laws.
Train and provide work direction to staff as required.
Serve as a technical resource to others regarding the more complex and difficult applications issues.
Participate in the review and definition of assigned functional areas, processes and procedures regarding requirements, organization and flow of data, methods and forms.
Provide assistance and support the more common personal computer software applications
Provide training to customers in the use of various Report Writer programs, software and products.
Create technical and write and maintain end-user documentation. The form of this documentation may be written, audio, video or screencast.
Install software packages; data conversion; package maintenance.
Troubleshoot system problems, identify, evaluate and resolve program problems and data problems.
Consult with users to provide support and to determine systems and software requirements and objectives. Assist users with understanding SIS procedures and creating custom queries.
Communicate changes in assigned configuration to customers and related support activities.
Provide recommendations as appropriate for changes or improvements to assigned environments.
OTHER DUTIES:
Perform related duties as assigned.
KNOWLEDGE AND ABILITIES:
KNOWLEDGE OF:
Student Information Systems (e.g., Aeries, Synergy, Destiny, Illuminate, Naviance) operations, troubleshooting and maintenance.
Complex Microsoft T-SQL scripting.
SQL database management, security schema design.
Principles and techniques of business process analysis and design.
Elements of system and procedure analysis.
Scripting and macro languages used on computers.
Database functions and structure.
Principles of training/supporting technology users.
Interpersonal relationship techniques.
Principles of providing work direction and guidance to others.
Methods and procedures of operating mainframe and personal computers and peripheral equipment.
ABILITY TO:
Analyze complex user problems, evaluate alternative and devise efficient cost-effective, user-friendly solutions.
Learn new scripting or macro languages quickly.
Use report design software to create, format and structure custom reports.
Communicate clearly to all levels of staff regarding technical issues both orally and in writing.
Produce professional written documents, using correct formatting, grammar and spelling.
Train and provide work direction to staff.
Extract, manipulate and graph data to meet complex requirements.
Meet schedules and time lines.
Work independently with little direction.
Perform difficult and complex programming duties in the analysis of systems requirements and preparation of automated solutions.
Research, compile, organize and analyze statistical and technical data.
Analyze, review and audit operation procedures and develop recommendations.
Provide technical guidance and recommendations concerning existing computer programs and systems.
Perform analysis and modification of existing programs and operations to meet changing needs and to provide for system enhancements.
Demonstrate proficiency in scripting languages (e.g., SQL, VBScript, Windows Powershell).
Maintain current knowledge of technological advances in the field.
WORKING CONDITIONS:ENVIRONMENT:
Office environment
Constant interruptions
PHYSICAL DEMANDS:
Dexterity of hands and fingers to operate a computer keyboard.
Hearing and speaking to exchange information.
Sitting for extended periods of time.
Bending at the waist, kneeling or crouching to reach computer equipment.
Seeing to view a computer monitor.
Carrying, lifting, pushing or pulling moderately heavy objects.
Personnel Commission April 2016
VACATION - HOLIDAYS - ILLNESS
Employees accumulate twelve (12) days of vacation during the first year of employment, increasing up to twenty-two (22) days beginning the 18th year of service, prorated for part-time, 9, 10, and 11 month assignments. The number of paid holidays per year varies from twelve (12) to fourteen (14) days depending on the work calendar. Employees accumulate twelve (12) days of paid sick leave per year, with unlimited accumulation, prorated for part-time, 9, 10, and 11 month employees.
RETIREMENT
All employees who are in the classified service and work four (4) hours per day or more are members of the Public Employees' Retirement System (CalPERS) and Federal Social Security. If an employee in the classified service works less than four (4) hours per day they are members of an Alternate Retirement System (PARS) and do not contribute to Social Security. Approximately 7% is deducted from your paycheck for PERS retirement.
HEALTH & WELFARE
The District offers a comprehensive health benefits program for employees who work twenty (20) hours or more per week. This includes medical, vision, dental insurance plans and life insurance for employees. For full-time employees the District pays the employee's health, vision, dental, and life insurance premiums with an employee contribution required for some plans. For part-time employees plans are available on a prorated basis. Dependent coverage is available.
PROFESSIONAL GROWTH
The District encourages employees to pursue professional growth. Professional growth points shall be earned by employee participation while in non-paid status in activities which are employment related. Professional growth points are awarded annually and accumulate at $20 per approved Professional Growth Point and/or tuition and textbook reimbursement up to $500 is also available - limited to one per year.
01
Information I provide to the following supplemental questions will be reviewed as part of the application process. Questions that are not fully and completely answered will be considered grounds for disqualification from the examination process. Stating "see resume" in lieu of a complete response to these questions is not acceptable. Select "Yes" to indicate that you have read and understand these instructions.
- Yes
02
Please check the box that most closely describes your level of proficiency in regards to SQL:
- No Proficiency
- Beginning - SELECT and UPDATE commands, single table, multiples tables joined via different JOIN statements.
- Proficient - plus most commands, use of DISTINCT, GROUP BY, and other aggregate functions.
- Advanced - plus complex subqueries and uses of temporary tables.
- Expert - plus triggers, stored procedures, index management, scalar functions.
03
Please check the box that most closely describes your level of proficiency in regards to Microsoft T-SQL:
- No Proficiency
- Beginning - Declaring variables, IF/ELSE.
- Proficient - Plus defining and using cursors.
- Advanced - Plus defining and calling functions.
- Expert - Plus database triggers, defining and using keys and indexes to maximize performance.
04
Please check the box that most closely describes your level of proficiency in regards to Microsoft SQL Server Reporting Services:
- No Proficiency
- Beginning - Declaring variables, IF/ELSE.
- Proficient - Plus defining and using cursors.
- Advanced - Plus defining and calling functions.
05
Please check the box that most closely describes your level of proficiency in regards to Aeries student information system:
- No Proficiency
- User - Use various forms to add and maintain student information.
- Advanced User - Plus write queries, do scheduling processes.
- Support Staff - Plus do basic troubleshooting, find and correct data issues, write complex queries.
- Expert - Plus use SQL to correct or import data, automate import/export routines.
06
Please check the box that most closely describes your level of proficiency in regards to Microsoft Excel:
- No Proficiency - Rarely or never use this software.
- Beginning - Use software for lists of records, sorting.
- Proficient - Plus use basic functions like SUM.
- Advanced - Plus daily utilizing extra skills to complete advanced tasks, frequently use COUNTIF, SUMIF, and VLOOKUP functions.
- Expert - Plus create templates for recurring data analyses involving cross-worksheet references, the advanced functions listed above, and linking to SQL data sources.
07
Please check the box that most closely describes your level of proficiency in regards to CALPADS:
- No Proficiency
- User - Use various forms to add and maintain student information.
- Advanced User - Plus write queries, export and submit data, develop annual calendars and related processes.
- Support Staff - Plus do advanced troubleshooting, find and correct data issues, write complex queries, develop documentation, and deliver training.
08
Please check the box that most closely describes your level of proficiency in regards to the Office of Civil Rights reporting:
- No Proficiency
- Beginning - SELECT and UPDATE commands, single table.
- Proficient - All commands, with multiple tables joined via INNER or LEFT JOINs.
09
List any other Aeries add-on products that you've supported (AIR, Summer Reregistration, Analytics, EMT, etc).
10
List any scripting languages you've used (VBScript, PowerShell, etc).
11
List any software packages you've used for creating dashboard interfaces or business intelligence functionality (Tableau, Microsoft Power BI, Domo, etc).
12
List any software packages you've used for designing and implementing customer-accessible reports.
13
List any web or app-based services that you've supported which relate to student learning or assessment.
14
Describe the most complex procedure you've created for extracting or reporting data from a database or creating an interface between to different systems/databases (preferably involving the Aeries Student Information System).
15
Explain the differences in reporting requirements for EL students now that the ELPAC has replaced the CELDT.
Required Question