System and Data Analyst

Council for the Homeless; Vancouver, Northern (WA, KY); Hybrid; USD 85,000 - 128,000; Full time

Job summary

Vancouver Housing Authority is seeking a Systems and Data Analyst to develop and implement solutions that support business strategy. You will serve as all-tier support for the Yardi system, triage incidents, run tests, and debug reports and queries.

The role includes creating reports, documenting processes, optimizing workflows, and collaborating with IT to resolve issues. A bachelor’s degree or equivalent experience and 4+ years in related roles are expected.

Qualifications

• Bachelor’s degree in a computer-related field, MIS, or equivalent.
• Four years of related work experience in IT/Data/Systems roles.
• Experience with Microsoft Azure Virtual Desktop; Exchange Online, Office 365; SharePoint and Azure AD.

Responsibilities

• Designing, developing, and maintaining reports and outputs with data accuracy checks.
• Analyze and document business processes and system workflows.
• Manage test environments and coordinate data refreshes.
• Create and maintain SQL queries, scripts, and data imports/exports.
• Develop and update software applications from specifications and resolve errors.
• Provide technical support for application and data issues with IT team.
• Identify root causes with end users and implement solutions.
• Train end users and support staff on system functionality and best practices.

Skills

Data governance

Process improvement

DBMS

Analytical thinking

Project planning

SQL

Communication

Microsoft Office

Education

Bachelor’s degree in a computer-related field

Four years of related work experience

Tools

SharePoint

Azure Active Directory

Azure Virtual Desktop

Exchange Online

Office 365

Job description

This position is open until filled. To ensure consideration, applications should be received by Monday, August 24.

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.

We offer a generous contribution toward health care: 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

• Microsoft Windows and Windows Server Operating Systems
• Microsoft 365 Suite
• Online Exchange
• Windows Virtual Desktop
• SharePoint
• Networking and Security
• System and Network Configuration
• 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
• 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.

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 . Please note, those candidates deemed to best meet our requirements will be contacted for an interview.

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.