SUMMARY
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 :
The duties of the Data Analyst include, but are not limited to :
- 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.
Conduct and analyze queries to a triple tiered (data, application and presentation) database to generate reports.
- 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 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
- General Office Setting, Indoors Temperature Controlled
- All qualified applicants will be considered for this position in accordance with the San Francisco Fair Chance Ordinance.
- Heluna Health is an Affirmative Action,