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 who excel at translating complex business needs into innovative and effective technology solutions. The ideal candidate will have 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, .

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