Data and IT Analyst | Salesforce Administration (On-Site)

Knowledge, Education for Your Success, Inc.

San Bernardino (CA)

On-site

USD 70,000 - 95,000

Full time

7 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health insurance
Retirement plan

Job summary

Knowledge and Education for Your Success, Inc. (KEYS) seeks a DATA AND IT ANALYST to support housing and homelessness programs by maintaining reliable information systems, ensuring accurate data, and providing technical support to staff.

The role spans cross-department collaboration to improve data quality and reporting. Responsibilities include developing dashboards, automating reports, and advancing workflows through technology and AI-enabled tools.

Qualifications

  • Bachelor's degree in information systems, data analytics, computer science, business technology, or a related field is preferred.
  • Equivalent education and relevant experience may be considered.
  • Three years of experience in data analysis, information systems, reporting, or technical support is required.
  • Strong Microsoft Excel skills (pivot tables, lookups, formulas) and proficiency in Microsoft 365.

Responsibilities

  • Monitor and maintain data accuracy across Salesforce, HMIS, Smartsheet, and other systems.
  • Prepare, reconcile, and validate reports for program operations, funders, and contractual reporting.
  • Develop dashboards and analytical tools to track referrals, enrollments, housing placements, caseloads, and outcomes.
  • Administer Salesforce and Smartsheet functions (reports, dashboards, access, permissions, workflows).
  • Provide day-to-day technical support for Microsoft 365 and software applications.
  • Coordinate complex technical issues with external IT providers.
  • Support onboarding/offboarding by coordinating technology access and accounts.
  • Maintain inventories of IT equipment and software licenses.
  • Identify opportunities to improve data collection and workflows through automation.
  • Develop automated reports and data-quality checks to improve accuracy and timeliness.
  • Evaluate technology solutions including AI-enabled tools and workflow automation.
  • Provide staff training on organizational systems and data-entry standards.
  • Collaborate with Programs, Finance, Grants and Compliance to improve reporting accuracy.

Skills

Data analysis
Analytical skills
Communication
Problem-solving
Confidentiality
Attention to detail
Troubleshooting

Education

Bachelor's degree in information systems, data analytics, computer science, business technology, or related field
Equivalent education and relevant experience may be considered

Tools

Excel
Microsoft 365
Power BI
Power Query
SQL
Salesforce
Smartsheet
HMIS

Job description

Come join our team as a DATA AND IT ANALYST and make a difference in our community!

Founded in 2009 by the Housing Authority of the County of San Bernardino, Knowledge and Education for Your Success (KEYS) is a 501(c)(3) nonprofit organization and public-private partnership dedicated to enhancing access to supportive services for low-income residents in San Bernardino County. KEYS provides an array of services, including housing assistance, case management, and resources that help individuals and families achieve housing stability.

In summary, 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. This position 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.

Key Responsibilities include:
  • 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.
EXPERIENCE/TRAINING/REQUIREMENTS

A bachelor's degree in information systems, data analytics, computer science, business technology, or a related field is preferred. Equivalent education and relevant experience may be considered.

Minimum three years of experience in data analysis, information systems, reporting, application administration, or technical support required.

The ideal candidate will have strong Microsoft Excel skills, including pivot tables, lookup functions, formulas, and data validation, along with proficiency in Microsoft 365. Candidates should demonstrate the ability to troubleshoot technical issues, analyze data, develop reports, and communicate technical concepts to nontechnical users.

Experience with Salesforce, Smartsheet, HMIS, Power BI, Power Query, SQL, data integrations, or automated reporting tools is preferred. Experience in nonprofit organizations, housing or homelessness services, or grant-funded programs is a plus. Familiarity with AI-enabled business applications, low-code automation platforms, or emerging productivity technologies is also desirable.

The successful candidate must demonstrate strong analytical, organizational, communication, and problem-solving skills, maintain strict confidentiality, and work collaboratively with staff across departments.

BENEFITS

KEYS provides 100% employer-paid medical, dental, life/AD&D, and vision insurance options for employee-only coverage. A voluntary 403(b) retirement plan is offered. Employees are eligible for enrollment the first of the month following 30 days of employment. Additional benefits include a cell phone allowance, 12 paid holidays, vacation, and sick time.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Specialist (On-Site)
Data Specialist (On-Site)

Knowledge, Education for Your Success, Inc. • San Bernardino (CA)

On-site
USD 42,000 - 64,000
100% employer-paid medical, dental, .
Life/AD&D and vision insurance
Voluntary 403(b) retirement plan
+1
Data Analyst
Data Analyst

SEARCH Homeless Services • Houston (TX)

On-site
USD 65,000 - 92,000
Data Analyst
Data Analyst

Real HR Hero - Thompson HR Consulting • California

Remote
USD 100,000 - 117,000
401a plan
Medical
Dental
+6
Services Coordinator
Services Coordinator

Knowledge, Education For Your Success • San Bernardino (CA)

On-site
USD 42,000 - 56,000
Medical, dental, life/AD&D, and vision
403(b) retirement plan
Paid holidays, vacation and sick time
+1
Senior Data Analyst
Senior Data Analyst

Real HR Hero - Thompson HR Consulting • California

Remote
USD 115,000 - 143,000
401a Retirement Plan
Medical/Dental/Vision
LTD/Life Insurance
+3
Data and Quality Assurance Specialist
Data and Quality Assurance Specialist

Union Station Homeless Services • Altadena (CA)

On-site
USD 70,000 - 90,000
Data Analyst
Data Analyst

LHH US • California

On-site
USD 65,000 - 79,000
Medical insurance
401(K) with match
Paid holidays & PTO
DATA ANALYTICS AND SYSTEM ADMINISTRATION SPECIALIST
DATA ANALYTICS AND SYSTEM ADMINISTRATION SPECIALIST

Catholic Charities of the Diocese of Rochester, Inc • City of Rochester (NY)

On-site
USD 68,000 - 70,000
Competitive salary and 403b retirement
Generous time off package and work‑lif
Comprehensive benefits package
+1
Data and Program Evaluation Analyst
Data and Program Evaluation Analyst

Christ Church Preservation Trust • Pittsburgh

On-site
USD 65,000 - 85,000
DATA ANALYTICS AND SYSTEM ADMINISTRATION SPECIALIST
DATA ANALYTICS AND SYSTEM ADMINISTRATION SPECIALIST

Catholic Charities • City of Rochester (NY)

On-site
USD 68,000 - 70,000
Competitive salary
403b plan
Generous time off
+3