System and Data Analyst

Vancouver Housing Authority

$85K — $127K *
Real Estate & Construction
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of hands-on experience with Yardi software is mandatory.
  • Bachelor's degree in a computer-related field or equivalent experience is acceptable.
  • Strong proficiency in SQL, including writing queries and optimization techniques.
  • Experience with Microsoft Azure and cloud platforms is highly preferred.
  • Demonstrated ability to manage and execute complex technical projects.
  • Excellent interpersonal and communication skills for both technical and non-technical audiences.
  • Solid understanding of data management and common office technologies.

Responsibilities

  • Develop and implement technical solutions aligning with business strategy.
  • Provide all-tier support for the Yardi system, ensuring smooth operation and issue resolution.
  • Create and maintain operational reports and ensure data accuracy and integrity.
  • Analyze and document business processes and evaluate software efficiency.
  • Manage testing environments and data refresh coordination.
  • Maintain and troubleshoot SQL queries, scripts, and system jobs.
  • Train end users on system best practices and functionalities.

Benefits

  • 100% coverage for employee medical and vision insurance, with 85% for dependents.
  • 100% paid dental coverage for employees.
  • Up to 26 days of accrued paid time off in the first year.
  • 12 paid holidays each year.
  • Participation in Washington Public Employee Retirement Services (PERS).
Full 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
  • 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.

Application Requirements

To be considered for this opportunity you must:
  • Complete the online application in its entirety.
  • Upload a cover letter that addresses how your experience qualifies you to perform the essential functions listed in the job announcement.
  • Upload a detailed resume of all educational and professional experience.

Final candidates must provide contact information for a direct supervisor to serve as a professional reference.

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.

Similar Jobs

More Jobs at Vancouver Housing Authority

More Real Estate & Construction Jobs

Find similar System and Data Analyst jobs: