Missouri - HMIS Data Analyst

Job Title: Data Analyst Reports to: Manager, Data Analysis and Reporting

Job Class: Analyst

Status: Full Time, Exempt Location: St. Louis City, Missouri

POSITION SUMMARY

The Institute for Community Alliances (ICA) is a nonprofit organization and a national leader in the administration of Homeless Management Information Systems (HMIS). ICA has administered the St. Louis City HMIS since 2017.

Under the direction of the Manager of Data Analysis and Reporting, the St. Louis City Data Analyst is responsible for creating and maintaining customized advanced report templates and conducting data review, interpretation, and analysis to support local and statewide planning, performance evaluation and management, and funding/policy decisions.

The ideal candidate for the St. Louis City Data Analyst is grounded in research, evaluation, and data literacy principles. This candidate loves investigating and solving logical problems, thrives on helping others make meaning from data, and understands how data can serve efforts to end homelessness. This candidate can translate technical concepts to plan language and, conversely, listen to what someone wants to know about a dataset and apply technical concepts to build and display it for them.

Candidates MUST submit a Resume and Cover Letter that explains how their skills fit the requirements for this position.

ESSENTIAL JOB FUNCTIONS

• Evaluation and Analysis

• Conduct data analysis to support local, statewide, or regional planning, and performance and program evaluation

• Create, publish, and provide narrative interpretation for data visualizations

• Product Development

• Create and maintain front-end development of advanced report templates, custom reports, and data visualizations for use by ICA and HMIS stakeholders, including participating agencies, the Continuum of Care, state and local funders, and other partners

  • Respond to requests for advanced custom reporting

  • Ensure compliance with federal and state data standards

• Product Delivery

• Collaborate with project teams and external stakeholders on product design, build, and delivery

ESSENTIAL JOB FUNCTIONS

• Evaluation and Analysis

• Conduct data analysis to support local, statewide, or regional planning, and performance and program evaluation

• Create, publish, and provide narrative interpretation for data visualizations

• Product Development

• Create and maintain front-end development of advanced report templates, custom reports, and data visualizations for use by ICA and HMIS stakeholders, including participating agencies, the Continuum of Care, state and local funders, and other partners

  • Respond to requests for advanced custom reporting

  • Ensure compliance with federal and state data standards

• Product Delivery

• Collaborate with project teams and external stakeholders on product design, build, and delivery

ESSENTIAL JOB FUNCTIONS (cont.'d)

• Engage in all portions of product delivery, including quality assurance and user acceptability testing, develop statements of work, and project proposals, as applicable

• With guidance from project team lead, prioritize potential product flaws, feature enhancements, and custom requests in accordance with product delivery plan

• Community Participation and Presentations

• Represent ICA on various local and statewide workgroups, with an emphasis on increasing data literacy and use of HMIS data at all levels of stakeholder engagement

• Facilitate stakeholder decision-making regarding product design

• Present HMIS data to internal and external groups

• Maintain proficient working knowledge of HUD HMIS guidelines and regulations

• Provide training to HMIS users related to reports created

• Provide support to ICA grant applications, as appropriate

Perform other duties as assigned

MINIMUM QUALIFICATIONS AND REQUIREMENTS

Experience and Education

• Bachelor’s degree from an accredited four-year college or university or equivalent experience or training (Public Policy, Program Evaluation, Urban Planning, Statistics, Social Science)

• Minimum of five years paid experience in a position with a high degree of independence and responsibility

Required Background/Knowledge

• Data visualization software and dashboard software (e.g., Tableau, Power BI)

• Relational and associative database structure

• Programming and analysis languages (e.g., SQL, R, Python)

• Project management principles

• Microsoft Office Suite (Word, Excel, Outlook, PowerPoint, etc.)

• Proficient use of inter- and intra-office communication tools such as email, video conferencing, teleconferencing, GoToMeeting, and similar tools

• Knowledge of basic office equipment and technology; excellent computer skills

Preferred Background/Knowledge

• SAP BusinessObjects Web Intelligence

• Experience in HMIS software, especially with Wellsky's Community Services

• Statistical Analysis software (R, Matlab, SPSS< STATA)

• GIS software

• Previous experience in the social services sector

Demonstrated Skills

• Ability to quickly and accurately define problems, collect/review data and draw valid conclusions

• Excellent analytical, decision-making, problem-solving, organization, and time-management skills

Demonstrated Skills (cont.'d)

• Self-motivated with ability to work independently

• Extraordinary attention to detail and accuracy

• Understanding and use of abstract and concrete variables

• Interpreting professional journals, technical procedures, and/or government regulations

• Understanding the evolving role of data and its importance in efforts to address social problems

• Regular, ongoing collaboration in project teams, including with remote staff

• Cooperatively or independently author training and procedural manuals or guidelines

• Ability to work effectively and professionally with people from diverse backgrounds

• Ability to learn quickly, handle multiple tasks simultaneously, anticipate and meet established deadlines, and regularly produce high-quality work products in a deadline-driven environment

• Team player and collaborator with a positive attitude

Physical Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to successfully perform the essential functions.

• Standing – Approximately less than 1/3 of on-the-job time

• Walking – Approximately less than 1/3 of on-the-job time

• Sitting – Approximately greater than 2/3 of on-the-job time

• Reaching with hands and arms – Approximately between 1/3 and 2/3 of on-the-job time

• Stooping, kneeling, crouching, or crawling – Approximately less than 1/3 of on-the-job time

• Talking or hearing – Approximately greater than 2/3 of on-the-job time

• Weight lifted/force exerted – An average of approximately up to 10 pounds, non- continuously

• Physical requirements listed are primarily applied to ability to lift and move paper supply, files, etc.

• Vision – Close vision (clear vision at 20 inches or less)

• Driving – Approximately less than 1/3 of on-the-job time

Other Requirements

• A valid driver’s license and proof of current automobile insurance

Travel/Work Schedule

• Occasional out-of-state travel for professional conferences/training (generally less than one week for each occurrence)

• Occasional local or in-state travel for community meetings or onsite implementation support

• Schedule may fluctuate based on workload

Expense Reimbursement

• Direct and necessary expenses related to required job-related activities are eligible for reimbursement. The incumbent is responsible for the timely request and submission of complete and accurate reimbursement documentation and form(s). Refer to the Personnel