Business Systems Analyst

POSITION TITLE: Business Systems Analyst
DEPARTMENT: Corporate Services
UNION: Excluded
SALARY: $64,400- $68,400 per annum
BENEFITS: Benefit package including dental, extended health and pension
FTE: Permanent Full-Time, 40 hours per week
REPORTS TO: Manager, Information Systems
START DATE: As soon as possible
LOCATION: Vancouver

to apply, please email resume and cover letter to Sean Brophy, Manager Information Systems at

DIVERSITY RainCity Housing serves a diverse group of people and we need a staff group that reflects the diversity. People of diverse backgrounds and cultures are encouraged to apply.


The role of the Business Systems Analyst is to provide support to RainCity Housing’s strategic and operational goals by applying expert knowledge in business analytics, project management, process engineering and information technology.  The Business Systems Analyst supports Continuous Quality Improvement (CQI) activities by using these skills to advise on supportive housing practices and processes that support high quality operational decision making.

Reporting to the Manager, Information Systems, the Business Systems Analyst identifies key reporting requirements and develops data gathering and reporting mechanisms using financial, human resources and organizational data for strategic and operational business cases.  The Business Systems Analyst provides project management and analyst support for all phases of assigned systems development and implementation projects, including preparation of supporting documents, briefing papers, strategic and tactical reports for submission to RainCity Housing Executives, funding organizations, and other stakeholders.  This role ensures the organization’s mission and values are integrated into the design, development and implementation of business systems solutions


  • Office environment, periodic work-from-home is an option
  • Permanent, full-time, salaried position; expected hours are 8 hours/day, 5 days/week; participation in an on-call rotation


  • Performs systems analysis by establishing scope and objectives, conducting feasibility studies, planning or modifying procedures to solve system problems, and preparing detailed specifications for redesign or development work
  • Liaises with stakeholders to understand system structures, policies, workflows, requirements and operations to identify, model and document business, process and data requirements
  • Gathers requirements for the development of RainCity’s client records systems
  • Performs workflow analysis, developing organizational information requirements and models
  • Identifies, develops and documents business situations that require technological solutions
  • Analyzes how proposed systems solutions impact other systems and organizational processes
  • Identify system deficiencies, user department operational inefficiencies and ways of improving business efficiency functions
  • Documents and analyses existing processes, performing best practice reviews and internal gap analysis
  • Analyzes and determines best method of modifying or integrating enhancement to existing applications
  • Solves existing systems logic difficulties, as required
  • Supports the redesign, implementation or Continuous Quality Improvement (CQI) of programs through process engineering, including related knowledge transfer and job aids, and identifying policy gaps
  • Supports CQI activities through information systems (re)design and data analysis
  • Provides significant project management and analyst support to coordinate and monitor projects and key deliverables
  • Recommends and implements process improvements affecting multiple teams, technologies, systems or business areas to increase efficiency
  • Promotes knowledge sharing through the organization’s operational business processes and systems by, among others, strengthening links between knowledge sharing and the information systems
  • Works with knowledge management consultants as needed to capture and share knowledge across the organization, with particular focus on consistent application of key processes and systems
  • Works with stakeholders to create consistent processes across programs that ensure staff have easy access to the right information at the right time and in the right place
  • Provides guidance for the definition and adoption of new guidelines, policies, processes, procedures and metrics
  • Ensures maintenance of documentation for systems, processes, procedures and infrastructure configuration
  • Serves on a variety of RainCity Housing departmental committees, task groups, internal working teams and corporate projects
  • Maintains a current awareness of information technology industry standards and developments
  • Establishes and maintains effective working relationships with all levels of RainCity Housing management, employees, clients and the public
  • Performs other related projects or duties, as assigned


  • Graduation from a recognized diploma or degree program in Computer Science, Mathematics, Physics, Engineering, or a related field of study
  • Expertise in Transact-SQL or another relational query language
  • Experience with software analytics tools such as PowerBI
  • An equivalent combination of education, training and experience will be considered
  • A minimum of 4 years of related work experience
  • Experience in a non-profit organization preferred
  • Ability to understand, communicate and support the mission and values of RainCity Housing, and the models/methods of supporting clients including the principles of Housing First and Harm Reduction


  • Ability to interpret and present data to provide meaningful metrics and drive evidence-based decision making
  • Strong math background, including statistics and linear algebra
  • Good understanding of the software development life-cycle
  • Good understanding of the Relational Model for database management
  • Good understanding of both functional, and object oriented programming

Special consideration will be given to candidates with experience in the following:

  • Working knowledge of the Azure / Microsoft ecosystem, or other equivalent cloud ecosystems (AWS, Google Cloud, etc.)
  • Knowledge of relational database optimization strategies and common DB performance pitfalls
  • Experience with NoSQL and Document Oriented Databases, especially MongoDB
  • Programming experience with C#.NET, Javascript, or R
  • Programming experience in Asp.Net, Asp.Net Core, or Node.js
  • Experience with Microsoft Azure Functions
  • Experience with Machine Learning or other tools for predictive analytics
  • Familiarity with Software Engineering best practices and design patterns