Data Analyst (Personal Services)

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, Equal Opportunity Employer that encourages minorities, women, veterans, and disabled to apply.

PHYSICAL DEMANDS

• Stand                                              Frequently
• Walk                                               Frequently
• Sit                                                   Frequently
• Handling / Fingering                      Occasionally
• Reach Outward                              Occasionally
• Reach Above Shoulder                  Occasionally
• Climb, Crawl, Kneel, Bend Occasionally
• Lift / Carry                                      Occasionally - Up to 50 lbs
• Push/Pull                                        Occasionally - Up to 50 lbs
• See                                                 Constantly
• Taste/ Smell                                    Not Applicable

 Not Applicable                                     Not required for essential functions

• Occasionally                                  (0 - 2 hrs/day)
• Frequently                                     (2 - 5 hrs/day)
• Constantly                                     (5+ hrs/day)

 

If 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.

This position description does not state or imply that the above are the only duties and responsibilities assigned to this position. Employees holding this position will be required to perform any other job-related duties as requested by the supervisor and management.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

See job description