Information Systems Analyst

about the city

nestled 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 city is seeking two exceptional information systems analysts who are highly proficient technical professionals and ms sql experts. They 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 here.

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.

to view our benefits page, .

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: information systems analyst.

• 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…