Data Analyst

As part of our San Francisco Homeless Outreach Team (SFHOT) program, the Data Analyst will be responsible for the management of multiple data sources, including the management of a Department of Homelessness and Supportive Housing (DHS) data collection system, which includes, but is not limited to, the tasks outlined below. Duties, tasks, and responsibilities of the Data Analyst are subject to change based on the needs of the program.ESSENTIAL FUNCTIONS:Manage and manipulate multiple Access/SQL tables, and merge to create a single dataset for analysis and evaluation activities.Manage DHSH data collection system, including batch data processing. Validate data files against data validation tools to ensure compatibility.Upload data to the city’s secure data network (SDN).Work with the City and County of San Francisco counterparts to verify data transmissions.Modify data files, as needed, based on feedback from the City and County of San Francisco.Develop database to support distribution to the Cloud, interoperability, accessibility to the public and flexible system design.Provide quality control and maintenance requirements include an updating schedule for data sets, documented metadata, internal database checks and a reporting system.Conduct complex data analysis, including spatial analysis and data quality control on complex datasets, appropriate methodological techniques and computer software and mapping software (such as SAS and GIS) to support identification, impacts analysis, monitoring, and evaluation of targeted interventions and investments.Manage data collection efforts and analyze data for interpretation.Prepare publication-ready presentations, mapping, infographics, charts and tables to support project/program reporting to Heluna Health and DHSH.Assist various internal and external parties in data collection, interpretation, and application of data for decision making.Produce high-quality written documents and communications in adherence with policies and protocols and in alignment with Heluna Health and DHSH policy, regulation, and guidance. Review work products for compliance with standards.JOB QUALIFICATIONS:Working with data collection systems.Working with healthcare – homeless and housing data.Data management experience which includes managing and manipulating Access and SQL databases. Knowledge of Microsoft Office software including, but not limited to, Excel, Access, and Power BI.Ability to work independently and manage data collection efforts.Experience with project life cycle including documentation, working with advisory groups, acceptance testing, implementation support, troubleshooting, and problem resolution.Rigorous statistical analysis capabilities.Presentation development, technical report preparation, and excellent communication skills.Experience preparing and maintaining workshop training materials and documentation.Able to work effectively within a team.EDUCATION/EXPERIENCE:A Bachelor’s degree from an accredited college or university in Computer Science / Information Management or Statistics, OR public health or other relevant social science, combined with two (2) years of experience collecting, preparing, and analyzing data and two (2) years of project management experience.Two (2) years data management experience which includes managing and manipulating Access and SQL databases.Two (2) years’ experience in Open Database Connections (ODBC).OTHER SKILLS, KNOWLEDGE, AND ABILITIES:Knowledgeable and/or certified in Health Insurance Portability and Accountability Act (HIPAA) compliance, rules and regulations within the last five years.WORK ENVIRONMENT:All qualified applicants will be considered for this position in accordance with the San Francisco Fair Chance Ordinance.Heluna Health is an Affirmative Action, Equal Opportunity Employer that encourages minorities, women, veterans, and disabled to apply.PHYSICAL DEMANDS:Stand FrequentlyWalk FrequentlySit FrequentlyHandling / Fingering OccasionallyReach Outward OccasionallyReach Above Shoulder OccasionallyClimb, Crawl, Kneel, Bend OccasionallyLift / Carry Occasionally - Up to 50 lbsPush/Pull Occasionally - Up to 50 lbsSee ConstantlyTaste/ Smell Not ApplicableIf hired for this position, you will be required to provide proof that you are fully vaccinated for COVID-19 prior to your start date or have a valid religious or medical reason qualifying you for an exemption (that may or may not require accommodation).Heluna Health reserves the right to revise job descriptions or work hours as required.The above statements are intended to describe the general nature and level of work being performed by the person assigned to this position. Essential job duties are intended to describe those functions that are primary to the performance of this job. Other job duties include those that are considered secondary to the overall purpose of this position.

#J-18808-Ljbffr