Data Analyst

SCHEDULE: 40 hours, Monday - Friday, 8:30am – 5:00pm

Pays $62,400 annual DOE

LOCATION: This is a fully remote position with the expectation to come on site occasionally for meetings and/or other work related events.

JOB DESCRIPTION:

SUMMARY OF THE POSITION :

The Data Analyst supports the Department of Program Evaluation in producing meaningful data analytics for operational insights, program evaluation, and strategic reporting. The incumbent interprets department internal and external requests for data analysis into appropriate querying of Pine Street Inn’s HMIS and other related databases, assesses the data in the query results for quality and for informational value, conducts statistical analysis of such data and provides interpretation of results and assists with dissemination. The incumbent also maintains and develops automations to support PSI reporting needs, such as data warehousing.

The Data Analyst supports the Department of Program Evaluation in its data quality improvement efforts and suggests improvements in data collection processes and systems, with the end goal of promoting mission-driven programming.

QUALIFICATIONS:

The person in this position must have a good understanding of data, a clear commitment to the population served and be able to work as part of a team.

REQUIREMENTS:

EDUCATION/TRAINING:

REQUIRED:

• Bachelor’s Degree with two to five (2 – 5) years of database applications and administrative experience, preferably in human services.
• Experience in basic statistics.
• Proficiency in office software and equipment including Microsoft Office Products (Word, Excel, and Outlook), internet use, telephone systems, and copy/scanner machines.
• Advanced knowledge of Microsoft Office Suite (Excel pivot, macros, VLOOKUP/XLOOKUP).
• Ability to deliver results, work independently, and prioritize tasks.

PREFERRED:

• Master’s Degree with at least one (1) year of database applications and administrative experience, preferably in human services, and training in program evaluation, research methods, or program management, or equivalent professional experience.
• Proficiency with SQL, Power BI, Python, or similar analytical tools.
• Experience with Clarity, ClientTrack or other Homeless Management Information Systems; experience with Customer Relationship Management (CRM) software.
• Experience with automation software (such as Power Automate) or Extract, Transform, and Load processes.

KNOWLEDGE/EXPERIENCE:

REQUIRED:

• High level of computer proficiency in database systems, including data entry, maintenance, quality assurance and report-writing.
• Strong verbal and written communication skills.

PREFERRED:

• Experience with outcome-based programming, evaluation, and an ability to analyze data to identify trends and variance from established goals.
• Experience working with homeless individuals with untreated mental illness and addictive disorders.
• Experience with project or workflow management.
• Bilingual/Bicultural (Spanish).

PHYSICAL ABILITIES/SKILLS:

REQUIRED:

• Ability to walk up 6 flights of stairs and access different building locations, if needed.
• Ability to work at a computer for extended periods of time.
• Ability to use a PC, phone, copier, and fax machine frequently.
• Ability to respond safely and quickly in case of emergency situations.

MENTAL ABILITIES/SKILLS:

REQUIRED:

• High standards of accuracy and attention to detail.
• Interest, or experience with, social justice as well as homelessness and housing advocacy.
• High degree of cultural sensitivity and ability to work effectively with diverse people and situations.
• Ability to understand and work on behalf of people with untreated mental health issues, addiction disorders, and poor hygiene.
• The patience and skill to explain technical processes to non-technical staff members.

• Must have highly developed professional ethics to maintain appropriate boundaries with program participants, staff, landlords, management agent staff, etc. and to support the work of a team.
• Skills to gather and compile information and statistics for ad hoc reports to management.

• Demonstrated experience as a self-starter; ability to work independently with limited supervision and as a member of an interagency/interdisciplinary team.

• Ability to contribute to the overall integration and success of the department by being a team player, accepting and offering guidance as appropriate, participating in PSI activities and trainings as requested, and promoting organizational integration based on the mission, vision and values.

ESSENTIAL FUNCTIONS:

Data Management and Reporting:

• Performs data validation and clean up to prepare for analysis and assists in database management.
• Monitors, maintains and develops Extract, Transform, and Load (ETL) processes to maintain data warehouses as needed.
• Produces data reports to assist in meetings on reporting requirements.
• Produces interactive dashboards based on the needs of various audiences.
• Responds to requests for data and special information promptly and as needed.
• Helps in optimizing the HMIS System to produce data for Outcomes and Program Quality Improvement in collaboration with all members of the Department of Program Evaluation.
• Identifies and addresses areas needing improvement regarding data collection workflow/efficiency.
• Inputs data into the Pine Street Inn’s HMIS system if needed.
• Performs any other tasks deemed necessary for maintaining the quality of the HMIS system.
• Provides assistance to staff to ensure accurate data collection.

Research and Modeling:

• Researches and utilizes sources to create more robust internal datasets such as the Boston HMIS Data Warehouse, and other PSI data systems.
• Examines outcomes from various statistical methods to suggest/implement the most scientifically accurate approach.
• Tests results from various analytical methods if they reflect the “real-world”.
• Participates in strategic projects, such as predictive modeling of inventory needs, to inform organizational strategic direction.
• Explores data insights to support improved service delivery, such as service planning data and flows across program areas.
• Assists in the efforts to produce research on Pine Street Inn initiatives, which may be published and utilized in local and national arenas to increase the viability of homeless service programs.

Administrative:

• Consistently seeks to perform at the highest level and is responsible for completing work in a way that upholds core values of PSI.
• Is responsible for one's own work and behavior while at work. Delivers on job responsibilities and assignments. Meets PSI Attendance Policy. Fosters teamwork. Gives credit and acknowledges contributions and efforts of other staff and team members.
• Promotes a safety conscious working environment. Consistently follows PSI and program safety policies and procedures.
• Protects confidential information and adheres to Pine Street Inn’s policies and procedures.
• Collaborates across agency to identify data analytics problems and execute solutions with data-driven insights.
• Analyzes and synthesizes information to understand issues, identify options, and support sound decision making. Demonstrates curiosity, digging for information below the surface. Gets more complete and accurate information by checking multiple sources. Applies broad analysis. Integrates information from diverse sources, often involving large amounts of information. Thinks several steps ahead in deciding on best course of action, anticipating likely outcomes.
• Works in a conscientious, consistent and thorough manner. Demonstrates concern for thoroughness and accuracy.
• Reviews work documentation for accuracy and thoroughness. Follows up to ensure tasks are completed and commitments are met by others. Verifies that work has been done according to procedures and standards.
• Manages well defined projects. Assumes personal responsibility for specific, straightforward components of larger projects.
• Identifies and solves problems. Identifies optimal solutions based on weighing the advantages and disadvantages of alternative approaches. After implementation, evaluates the effectiveness and efficiency of solutions.
• Promotes a professional, welcoming, trauma-informed office environment.
• Serves as a point of contact for staff with data related requests or needs.
• Participates in team meetings and other meetings as assigned and records minutes as appropriate.
• Accepts supervision and guidance and actively participates in efforts to improve quality of performance.
• Upholds the rights of all persons served. Is continually aware of these rights and acts in accordance with these rights.
• Interacts with guests, clients, and tenants in ways which establish a climate of respect for human dignity.
• Creates an environment of customer service where staff has access to ask questions, receive guidance, or address issues with data.
• Works cooperatively with representatives of all PSI departments.
• Represents the Evaluation Department and the whole agency in a professional manner in all contacts with representatives of other agencies.