Information Systems Analyst - Housing Department

Job Description

The City of San José Housing Department is a leader in the development of affordable housing. Its mission is to strengthen and revitalize the community through housing and neighborhood investment. With a Fiscal Year 2024-2025 operating budget of approximately $247 million and 112 employees, the Department administers multiple local, state, and federal funds. We are committed to fostering a diverse, inclusive work environment prioritizing social & racial equity and inclusion.
In Fiscal Year 2024-2025, the Housing Department underwent a significant reorganization to better align with the City's strategy of strengthening the housing continuum and addressing the needs of unhoused and unsheltered residents. As part of this effort, the Department has placed greater emphasis on using data and technology to support housing programs, guide decision-making, and expand cross-departmental collaboration.

About the Data Operations & Project Support Team
The Housing Department's former Data Support Division has transitioned into the Data Operations and Project Support Team, reflecting an expanded scope and growing role within the City. The team provides technical, analytical, and project management support across a wide range of housing and homelessness initiatives. This includes data integration with County partners, coordination for CalAIM, and administration of Salesforce systems such as Encampment Response Coordination System, the Rent Registry, and the Rent Stabilization Program. The team also develops and maintains the data feeds that inform the City Manager's Office Focus Area Scorecards, which track progress on reducing unsheltered homelessness.

Future Direction of the Team
The Data Operations & Project Support Team is actively building capacity to meet the City's increasing demand for high-quality data and systems support. Looking forward, the team will expand its role in integrating systems, strengthening data quality, and developing analytics and forecasting tools that inform both policy and operational decision-making. The team is also exploring opportunities to leverage artificial intelligence (AI) to enhance efficiency and expand analytical capabilities.
Team members thrive in a dynamic environment that values flexibility, agility, and collaboration. By joining this team, new staff will contribute to an evolving mission that is shaping how data is used across the Housing Department and City to improve services, support residents, and drive citywide impact.The Housing Department is currently seeking to fill one (1) full-time Information Systems Analyst vacancy in the Data Management Division.

Salary range for this classification is $141,894.48 - $172,885.44. This salary range includes an approximate five percent (5%) ongoing non-pensionable compensation. Actual salary shall be determined by the final candidates' qualifications and experience.

Currently this position is primarily on-site with limited telework. In accordance with City policy, employees are required to work on-site a minimum of four (4) days per week (at least 32 hours) at the assigned work location in San José. Up to one (1) day per week may be worked remotely, subject to operational needs and supervisor approval. Remote work from outside of the United States is not permitted.

The Information Systems Analyst (ISA) will support the Department's technology ecosystem that powers affordable housing production, asset management, compliance, homelessness response, and public-facing services. The ISA will perform systems and business analysis, administer critical applications, develop integrations and reports, and provide responsive customer support to staff while following City standards for security and data management. Representative duties include:

Application Development & Customization : Gather and document business requirements; translate program needs into functional and technical specifications. Design and develop highly usable, accessible solutions by customizing platforms and leveraging modern programming languages. Contribute to the full software development lifecycle, including design, development, testing, implementation, upgrades, and ongoing improvements. Build custom applications, features, and integrations within the Salesforce platform to meet evolving business needs.
System Administration & Operations : Configure, administer, and support departmental applications (e.g., case management, grants/loans, document management, reporting tools). Provide ongoing support and maintenance for the Salesforce CRM and other core systems, including troubleshooting, resolving issues, and ensuring optimal performance. Stay current with platform updates, best practices, and industry trends to proactively identify opportunities for improvement.
Data & Integrations : Design and maintain integrations and data pipelines; develop SQL queries, datasets, and dashboards; perform data quality checks and controls. Plan and execute system changes and enhancements, coordinating testing, migration, and release documentation.
Quality Assurance & Documentation : Execute structured testing and validation processes; ensure compliance with City standards for security and data management. Prepare and maintain technical documentation, SOPs, architecture diagrams, and user guides to support consistency and knowledge transfer.
End-User Support & Training: Provide responsive user support, including ticket triage, troubleshooting, and service-level communication. Prepare job aids and training materials; conduct training sessions to build staff proficiency in using applications and data tools.
Security & Compliance: Maintain role-based access controls, audit trails, backup/recovery processes, and incident response procedures to safeguard systems and data.
Evaluation & Procurement: Evaluate software and hardware options; prepare recommendations considering cost, security, and fit; assist with procurement processes and vendor deliverables.
Other Duties as Assigned: Perform related work as required.
Key Focus Areas for Housing Case management and program systems (loans/grants, compliance, inspections, outreach).
Data integrations and reporting for Council, funders, and internal dashboards.
Secure constituent data collection (e-forms, approvals, digital signatures, auditability).
Vendor coordination for SaaS implementations and support.
Desired Qualifications
Desired qualifications for the ISA position are listed below: Experience administering or integrating enterprise/business applications (customer relationship management, grants/loans, permitting, document management, data warehouse/BI).
Proficiency with Structured Query Language (SQL), APIs, ETL, integration tools, and report/dashboard development.
Familiarity with security best practices (authentication, role-based access control, encryption, logging).
Experience writing technical documentation, user guides, and training materials.
Ability to coordinate small workgroups, vendors, and stakeholders to meet deadlines.
Knowledge of Agile/iterative project practices helpful.
Experience in administration, configuration, development, implementation, and support of the Salesforce (SFDC) platform.
Experience with Salesforce low-code/no-code solutions such as Flows.
Experience developing Salesforce custom coded solutions using APEX, Lightning Web Components, and JavaScript.
Experience with data integration tools such as MuleSoft.
Experience with GIS integration using Esri's JavaScript and REST APIs.
Salesforce Certified Administrator and Platform Developer.
This is a hands-on technical role, where the ideal candidate must demonstrate substantial experience in four core areas : Salesforce administration and development;
Integrating disparate applications and systems using Application Programming Interfaces (API) or Extract, Transform, Load (ETL), and;
Retrieving, transforming, and presenting data in dashboards and reports.
Working directly with customers to understand business requirements, translate into technical specifications, select and implement appropriate solutions, engineer workflows, and provide user training and support, while demonstrating a focus on customer service.
Education: A Bachelor's Degree from an accredited college or university in Management Information Systems (MIS), Information Technology (IT), Information Science/Informatics, Computer Science, Software Engineering, Computer Engineering, Information Management, Data Science/Analytics, Business Analytics, Statistics/Applied Mathematics, or a relevant field.

Experience: Four (4) years of progressively responsible professional/journey level experience, of which at least two (2) years of experience include lead technical work in development, implementation and maintenance of computer systems, or application development and/or support.

Acceptable Substitution: Additional years of increasingly responsible directly related work experience may be substituted for education on a year-for-year basis.
Completion of a Master's Degree in a relevant field from an accredited college or university may be substituted for one (1) year of the required two (2) years of experience which include lead technical work in development, implementation and maintenance of computer sy