Data and IT Analyst

Knowledge, Education For Your Success•San Bernardino, CA

1d•$31 - $34

About The Position

The Data and IT Analyst supports KEYS’ housing and homelessness programs by maintaining reliable information systems, ensuring accurate data and reporting, and providing technical support to staff. The role works across departments to improve data quality, develop reports and dashboards, troubleshoot technical issues, and identify opportunities to streamline operations through technology, automation, and innovative solutions. The analyst administers and supports organizational systems, including Salesforce, HMIS, Smartsheet, and Microsoft 365; prepares reports and analytical tools for program operations and performance monitoring; and helps maintain system security, continuity, and documentation. The position also provides staff training and technical guidance and collaborates with Programs, Finance, and Grants and Compliance to improve reporting accuracy and support informed decision-making.

Requirements

At least three years of experience in data analysis, information systems, reporting, application administration, or technical support.
Strong Microsoft Excel skills, including pivot tables, lookup functions, formulas, and data validation.
Proficiency in Microsoft 365.
Ability to troubleshoot technical issues, analyze data, develop reports, and communicate technical concepts to nontechnical users.
Strong analytical, organizational, communication, and problem-solving skills.
Ability to maintain strict confidentiality and work collaboratively with staff across departments.

Nice To Haves

A bachelor’s degree in information systems, data analytics, computer science, business technology, or a related field; equivalent education and relevant experience may be considered.
Experience with Salesforce, Smartsheet, HMIS, Power BI, Power Query, SQL, data integrations, or automated reporting tools.
Experience in nonprofit organizations, housing or homelessness services, or grant-funded programs.
Familiarity with AI-enabled business applications, low-code automation platforms, or emerging productivity technologies.

Responsibilities

Monitor and maintain data accuracy, completeness, and consistency across Salesforce, HMIS, Smartsheet, and other organizational systems.
Prepare, reconcile, and validate routine and special reports for program operations, management, funders, and contractual reporting requirements.
Develop dashboards and analytical tools to track referrals, enrollments, housing placements, caseloads, program outcomes, and performance goals.
Administer assigned Salesforce and Smartsheet functions, including user access, permissions, reports, dashboards, forms, workflows, and automations.
Provide day-to-day technical support for Microsoft 365, software applications, user accounts, computers, and routine connectivity issues.
Coordinate complex technical issues, system maintenance, and cybersecurity concerns with external IT providers.
Support employee onboarding and offboarding by coordinating technology access, equipment assignments, and account setup or deactivation.
Maintain IT equipment, software license, and user-access inventories while supporting data security, confidentiality, and system continuity.
Identify opportunities to improve data collection, reporting, and organizational workflows through automation and technology solutions.
Develop automated reports, data-quality checks, and performance alerts to improve the accuracy and timeliness of information.
Evaluate and support approved technology solutions, including AI-enabled tools and workflow automation platforms.
Provide staff training, job aids, and technical guidance on organizational systems, data-entry standards, and technology best practices.
Collaborate with Programs, Finance, and Grants and Compliance to improve reporting accuracy, investigate discrepancies, and support informed decision-making.
Analyze operational trends, communicate recommendations to management, and maintain documentation of systems, procedures, and improvements.