Data Analyst

SUMMARY

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.