System and Data Analyst

Vancouver Housing Authority; Vancouver; On-site; CAD 119,000 - 179,000; Full time

Benefits offered by this job

Medical and vision coverage

Dental coverage

Paid time off

Paid holidays

Job summary

The Vancouver Housing Authority seeks a Systems and Data Analyst to design, develop, and maintain reports and data workflows, focusing on Yardi-based solutions and data integrity. You will serve as all-tier support for the Yardi system, triage incidents, test updates, and create efficient data imports/exports.

The role requires a Bachelor's in a computer-related field and at least four years of related experience, including Azure, SharePoint, SQL, and cloud platforms; you will work with IT and

Qualifications

• Bachelor’s degree in computer science, MIS, or a closely related field.
• Four years of demonstrated related work experience; extensive Yardi experience is strongly preferred.
• Experience with SQL, Azure Virtual Desktop, Exchange Online, Office 365; SharePoint and cloud services.
• Strong data administration, process improvement, and effective communication skills.

Responsibilities

• Design, develop, and maintain operational and management reports, forms, letters, and statistical outputs; ensure data accuracy through validation.
• Analyze and document business processes and system workflows; evaluate system efficiency and SaaS compatibility.
• Manage test environments and coordinate data refreshes.
• Create, modify, and maintain SQL queries, scripts, reports, and data imports/exports; monitor system jobs and take corrective action.
• Develop and update software applications by translating specifications into code and resolving errors.
• Provide technical support for application and data-related issues; collaborate with IT to troubleshoot system problems.
• Work with end users to identify and resolve root causes of issues and ensure timely solutions.
• Train end users and support staff on system functionality and best practices.

Skills

Data analysis

Problem solving

Project management

Teamwork

Communication

Education

Bachelor’s degree in computer science / MIS

Tools

SQL

Yardi

Azure

SharePoint

Office 365 / Microsoft 365

Windows Server

Job description

Description

Applications must have direct, hands‑on experience with Yardi software to be considered.

The Systems and Data Analyst position performs advanced technical work developing and implementing solutions that support the Authority’s business strategy. This position serves as an all-tier support for the agencies Yardi system, including issue documentation, user account and access management, workflow support, and resolution of technical problems. The Analyst will triage, troubleshoot, and resolve software incident; support testing of updates and system changes; and debug reports, queries, and code.

Other Essential Functions Include But Are Not Limited To

• Designing, developing, and maintaining operational and management reports, forms, letters, and statistical outputs; ensuring data accuracy through research, validation, and quality control.
• Analyze and document business process and system workflows; evaluate system efficiency and ensure compatibility of in‑house and SaaS applications.
• Manage test environments and coordinate date refreshes.
• Create, modify, and maintain SQL queries, scripts, reports, and data imports/exports; monitor system jobs and take corrective action as needed.
• Develop and update software applications by converting specifications into code, compiling programs, and resolving errors.
• Providing technical support for application and data‑related issues; collaborate with IT team members to troubleshoot and resolve software, database, and system problems.
• Work with end users to identify, document, and resolve root causes of system or process issues, ensuring timely and effective solutions.
• Train end users and technical support staff on system functionality, workflow, and best practices.

Pay And Benefits

In compliance with the Equal Pay & Opportunities Act, the full salary range for the Systems and Data Analyst position is $85,020 to $127,530. Starting salary is determined by the required qualifications for the role and the candidate’s relevant experience. This is a full‑time exempt position working primarily in office Monday through Friday.

• 100% paid for employees’ only medical and vision coverage, 85% paid for dependent tier coverage.
• 100% paid for dental.
• Up to 26 days of accrued paid time off annually in the first year (13 vacation/13 sick days), and 12 paid holidays.
• This position is required to participate in Washington PERS (Public Employee Retirement Services).

Requirements

Knowledge and Attributes

• Strong understanding of data administration and management functions, including data collection, analysis, and distribution.
• Ability to improve system business processes using recognized process‑improvement techniques.
• Familiarity with modern database and information‑system technologies.
• Knowledge of program evaluation and outcome‑based assessment methods.
• Ability to work effectively with others, participate as a team member, communicate constructively, and navigate conflict professionally.
• Skill in analyzing problems, identifying solutions, evaluating alternatives, and implementing recommendations aligned with organizational goals.
• Ability to perform highly detailed work accurately and efficiently, organize tasks effectively, and work independently despite frequent interruptions.
• Strong project‑planning and organizational skills, with the ability to meet schedules and timelines and work with minimal direction.
• Proficiency with data‑analysis tools and programming languages such as SQL.
• Experience with database‑management systems.
• Strong analytical and problem‐solving abilities.
• Effective communication skills to explain complex or technical information to non‑technical users.
• Knowledge of modern office procedures, methods, and equipment, including computers and common word‑processing and spreadsheet applications.

Job Skills

Technical skills

• SQL (writing queries, joins, CTWs, optimization)
• Microsoft Windows and Windows Server Operating Systems
• Microsoft Azure
• Cloud Platforms
• Microsoft 365 Suite
• Online Exchange
• Windows Virtual Desktop
• SharePoint
• Networking and Security
• System and Network Configuration
• Virtualization
• Backup and Disaster Recovery
• Technical Documentation
• Troubleshooting and Diagnostics
• Monitoring and Performance Optimization
• Regulatory Knowledge
• Security Best Practices

Interpersonal & Communication Skills

• Customer Service
• Verble and Written Communication
• Collaboration and Teamwork
• Problem Solving and Analytical Skills
• Adaptability
• Project Management and Organizational Skills

Education And Experience

• Bachelor’s degree in a computer‑related field, or MIS, or directly relevant experience can be considered in lieu of the required degree.
• Four years of demonstrated related work experience. Experience with Microsoft with Microsoft Azure Virtual Desktop; Exchange Online, Office 365; SharePoint, Azure Files Services; Azure Active Directory, Windows Service management, and document management and workflow automation software.
• Experience administering local and cloud‑based computer hardware and telecommunications functions is strongly preferred.
• Extensive experience in Yardi required.

A combination of relevant education and experience that demonstrates the ability to perform the essential functions of the role may be considered in place of the stated requirements.

For more information on the Vancouver Housing Authority, please visit our website at www.vhausa.org.

We do not discuss application status during the selection process.

The Vancouver Housing Authority is an equal opportunity employer.

All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, national origin, disability, or veteran status.