Information Systems Analyst

Salary : $120,640.00 - $180,980.80 Annually Location : Camarillo, CA Job Type: Full-Time Job Number: 2026-00001 Department: Administrative Services Division: Information Systems Opening Date: 02/04/2026 Closing Date: 3/4/2026 5:00 PM Pacific SUMMARY DESCRIPTION ABOUT THE CITYNestled in the heart of Ventura County, just minutes from California's scenic coastline, Camarillo offers a unique blend of small-town charm, a vibrant community spirit, and an exceptional quality of life as a forward-thinking and innovative local government, we are dedicated to delivering outstanding service while fostering a dynamic, empowered workforce that reflects the high standard to the community we serve.Discover more about us and our organizational culture here.THE POSITION The City is seeking (2) two exceptional Information Systems Analysts who are highly proficient technical professionals and MS SQL experts who excel at translating complex business needs into innovative and effective technology solutions. The ideal candidate will bring a deep and well-rounded background in database management, with a minimum of five years of combined experience in MS SQL Server, including at least five years of robust development experience and three or more years of proactive database administration (v2014+) is desirable. This individual is skilled across the full stack of database functions, from SSIS/SSRS development and performance tuning to maintaining strong security protocols and supporting smooth change management. In addition to technical expertise, the successful candidate will demonstrate outstanding communication and collaboration skills, working effectively within a team and across multiple City departments. They will be adept at managing and monitoring databases, ensuring system security, and integrating new technologies into existing systems. The ideal candidate thrives when leading critical City initiatives and managing a diverse portfolio of systems including the City's Advanced Metering Infrastructure (AMI), OpenGov permitting platform, Laserfiche Records Management System (RMS), and a new resident identity management solution. You can view our Technology Modernization Plan This role will play a key part in several major upcoming City projects, such as deploying a new Enterprise Asset Management (EAM) system, integrating a new utility payment portal, developing and implementing the City's data governance strategy, and developing enhanced ERP reports and workflows. Strong project management fundamentals, a proactive and solutions-oriented mindset, and a commitment to continuous learning are essential to success. Knowledge of Microsoft platforms including Active Directory, Entra, SharePoint, and Teams is highly desirable. Experience with Microsoft Copilot or Power BI is also considered an asset. The City seeks not just a technical expert, but a collaborative, adaptable, forward-thinking problem solver who is eager to make a meaningful impact on City operations and services. Learn more about the Administrative Services Department here.BENEFITS: To view our benefits page,click here. EMPLOYMENT STANDARDS The following duties are typical for this classification. Incumbents may not perform all of the listed duties and/or may be required to perform additional or different duties from those set forth below to address business needs and changing business practices. Please click on this link to see the entire classification description: Provides ongoing software design, development, testing, and maintenance for online software applications for City departments. Maintains the City intranet for City employees; creates new web pages and expands functionality. Create and maintain geospatial databases; perform basic geo-processing and analytical tasks such as spatial queries and comparisons. Creates and maintains SQL Server Reporting Services reports for users. Performs database administration tasks for SQL Server databases; sets-up job; monitors re-indexing, backups, data import, and statistical reporting; provides user management and security. Maintains eCommerce website; prepares reports; provides user support for online transactions including utility payments; integrates eCommerce website with City website; secures certificate maintenance for City eCommerce applications. Coordinates with ERP vendor in resolving support cases addressing user problems. Coordinates with other information technology staff in resolving software application issues, server, and account configurations. Assists in developing training or conducts training in computer systems and software as needed. Researches new computer technologies for City application and recommends purchase of systems, hardware, software, and peripherals. Maintains a variety of records and prepares special reports; creates and updates written procedures and related documentation. Maintains current knowledge of information technology trends and innovations; attends and participates in job-related seminars and professional group meetings. Performs related duties as required. EXPERIENCE AND TRAINING GUIDELINES The following generally describes the knowledge and ability required to enter the job and/or be learned within a short period of time in order to successfully perform the assigned duties. Knowledge of: Operational characteristics of information services systems, hardware, and software. Principles and practices of computer science and information systems. SQL (Structured Query Language) database design, management, and administration. SQL server technology; SQL Server Reporting Services. Principles and practices of computer programming and systems analysis. Web server applications. Project management principles and practices. Architect software solutions; client/server technology. Methods and techniques of training and instruction. Office procedures, methods, and equipment including computers and various commercially packaged software including word processing, spreadsheet, database, and graphics applications. GIS (Geographic Information System) software and technical applications. Characteristics and limitations of computer systems and related equipment. Ability to: Analyze, design, program, install, and maintain computer systems and software. Read, understand, and follow technical instructions and manuals. Diagnose and resolve network and mid-range computer operational problems. Diagnose common user problems and identify appropriate corrective action. Plan system upgrades and communicate schedules. Monitor network and application security. Create complex queries and ad-hoc reports. Manage and monitor databases. Assemble, install, and maintain computer equipment and peripherals. Conduct research and prepare reports, documents, and correspondence. Analyze data and develop logical solutions to complex computer application problems. Make recommendations in information system selection and software application packages. Operate office equipment including computers and supporting word processing, spreadsheet, and database applications. Adapt to changing technologies and learn functionality of new equipment and systems. Communicate clearly and concisely, both orally and in writing. Establish and maintain effective professional working relationships with those contacted in the course of work. EDUCATION AND EXPERIENCE GUIDELINESAny combination of education and experience that would likely provide the required knowledge and abilities is qualifying. A typical way to obtain the knowledge and abilities would be: Education/Training: A Bachelor's degree from an accredited college or university with major course work in computer science, information systems, or a related field. Experience: Five years of progressively responsible experience in systems or business analysis and design. PHYSICAL DEMANDS AND WORKING ENVIRONMENT The conditions herein are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions. Environment: Work is performed primarily in a standard office setting. Physical: Primary functions require sufficient physical ability and mobility to work in an office setting; to stand or sit for prolonged periods of time; to occasionally stoop, bend, kneel, crouch, reach, and twist; to lift, carry, push, and/or pull moderate to heavy amounts of weight; to operate office equipment requiring repetitive hand movement and fine coordination including use of a computer keyboard; and to verbally communicate to exchange information. Equal Employment Opportunity (EEO) The City of Camarillo is committed to creating a diverse environment and is proud to be an EEO employer. All qualified applicants will receive consideration for employment without regard to race, sex, or other factors. We believe in fostering an inclusive work environment where employees feel valued, respected and empowered. Disaster Services Assignments As public employees, we play an enhanced role in the event of a disaster or other emergency in our community. You will be registered as a disaster services worker, and you will be issued a disaster services identification card. In the event of a disaster or other emergency, make sure that your family is safe and secure first, then report to your assigned emergency location. Temporary employees generally do not receive disaster services assignments. ADDITIONAL INFORMATION There are currently two (2) vacancies within the Administrative Services Department. Communication regarding your application and/or status will be sent to the email address listed on your application. Please check your email and spam regularly throughout the recruitment process. You may also log into your governmentjobs.com account to view these emails. FOR FIRST CONSIDERATION CITY APPLICATION AND RESPONSES TO THE SUPPLEMENTAL QUESTIONNAIRE MUST BE RECEIVED BY 5:00 PM ON WEDNESDAY, MARCH 4, 2026. TENTATIVE FIRST ROUND INTERVIEWS WILL BE HELD THE WEEK OF MARCH 23, 2026, AND FINAL INTERVIEWS THE WEEK OF MARCH 31, 2026. Retirement - All regular employees are enrolled in CalPERS. "Classic" members: 2% @ 55; City pays the employee contribution. "PEPRA" members: 2% @ 62; employee contributes 8.25% of salary. Social Security - The City does not participate in Social Security. Receiving a CalPERS benefit may affect your Social Security upon retirement. For further information contact a Social Security office or Medicare - Employees hired after April 1, 1986 are required to contribute 1.45% of earnings, with an equal amount paid by the City. Defined Contribution - The City contributes 7% of employee's gross salary to a 401a Plan. Deferred Compensation - Employees have the option to contribute to a 457 Plan up to the maximum allowed by law. Health Insurance - The City contributes $162 per month towards a selection of plans. Health insurance is effective the first of the month after date of hire. Flex Benefit/Cafeteria Plan - $3,175 monthly, which may be applied toward health insurance premiums. Unused money may be taken as cash, payable twice a month. Dental/Vision Insurance - City pays premium for employees and dependents. Dental/Vision insurance is effective the first of the month after date of hire. Life Insurance - City-paid term life insurance equal to the employee's annual salary, plus $5,000, rounded up to next $5,000 and dependent life insurance of $2,000 per dependent, is provided. Short/Long Term Disability - City pays premium for employees. Eligibility period: 0 days for injury/hospitalization or 7 days for an illness. Retirement Health Savings (RHS) Plan - Investment vehicle funded by employee contributions to pay for medical benefits upon retirement or separation from the City. Mandatory participation for all employees. Holidays - 11 days (88 hours) plus 3 floating holidays (24 hours) per year. Management Leave - Executive and mid-management exempt employees receive 40-88 hours per year. Vacation - Vacation is determined by number of years of service. (0-4 years = 80 hrs; 5-9 years = 120 hrs; 10-14 years = 160 hrs; 15+ years = 168-200 hrs). Employees are eligible to use vacation after 6 months of employment. Sick Leave - 96 hours per year. Comprehensive Annual Leave (CAL) - Sanitary District Only. Combined vacation, sick and floating holiday leaves. (0-4 yrs = 160 hrs; 5-9 yrs = 200 hrs; 10-14 yrs = 240 hrs; 15+ yrs = 248-288 hrs) Benefits listed may not reflect all benefits offered. Not all benefits apply to all positions. Regular, part-time employees receive pro-rated benefits. Additional information is available by contacting Human Resources. 01 The supplemental questionnaire is part of the examination process for this position and will be used in determining your qualifications. In order to receive every consideration in the selection process you must complete all the questions with concise yet detailed answers and provide all the requested information. The experience you indicate in your response to the supplemental questions must also be described in detail, on the Work Experience section of your Employment Application. Failure to complete the "Work Experience" section of the employment application may result in your application not being considered. The hiring department may review each answer to evaluate your qualifications. Responses such as "See Resume" or "See Application" will result in disqualification and will not be considered further.By continuing in the recruitment process, you are certifying that all information provided in the Supplemental Questionnaire is true to the best of your knowledge. If you are selected to continue in the recruitment process, your qualifications may be evaluated through employment verification, reference checks and written, skill assessment, and oral examinations.Select "Yes" to acknowledge that you have read and understand this statement. Yes No 02 Please describe a complex reporting or data visualization project you led or significantly contributed to, including the business problem it addressed, how you queried and validated data (such as using SQL), the steps you took to ensure data integrity, and how you translated technical information into clear, actionable insights for non-technical stakeholders. 03 Please describe an enterprise-level application you have supported or managed, including your role in its implementation or stabilization, how you handled upgrades or major changes, how you responded to or prevented critical system issues, and how you ensured the system continued to meet evolving business or operational needs over time. 04 The City's Technology Modernization Plan (TMP) is linked in the job posting. After reviewing the plan, which projects or focus areas are you most interested in supporting, and why do these align with your skills, experience, or professional interests? 05 For each system listed below, please indicate your level of experience.Financial ERP No experience Familiar / limited exposure Working knowledge (used regularly) Advanced (primary administrator or lead user) 06 For each system listed below, please indicate your level of experience.Human Resources Information System (HRIS) No experience Familiar / limited exposure Working knowledge (used regularly) Advanced (primary administrator or lead user) 07 For each system listed below, please indicate your level of experience.Data Warehouse / Business Intelligence No experience Familiar / limited exposure Working knowledge (used regularly) Advanced (primary administrator or lead user) 08 For each system listed below, please indicate your level of experience.Land Use / Permitting Systems No experience Familiar / limited exposure Working knowledge (used regularly) Advanced (primary administrator or lead user) 09 For each system listed below, please indicate your level of experience.Project Management Software No experience Familiar / limited exposure Working knowledge (used regularly) Advanced (primary administrator or lead user) 10 For each system listed below, please indicate your level of experience.Document Management Systems (e.g., Laserfiche, SharePoint) No experience Familiar / limited exposure Working knowledge (used regularly) Advanced (primary administrator or lead user) 11 For each system listed below, please indicate your level of experience.Enterprise Asset Management (EAM) Systems No experience Familiar / limited exposure Working knowledge (used regularly) Advanced (primary administrator or lead user) 12 For each system listed below, please indicate your level of experience.Advanced Metering Infrastructure (AMI) Systems No experience Familiar / limited exposure Working knowledge (used regularly) Advanced (primary administrator or lead user) 13 Please select your highest level of completed education: Associate's degree Bachelor's degree Master's degree Doctorate Equivalent combination of education and experience Required Question

Created: 2026-03-04