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.
Please note: this is a full-time in-person position at our offices in downtown San Francisco. Remote work is not available.
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 citys 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 databasesKnowledge of Microsoft Office software including but not limited to Excel and Access.
- 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 Bachelors degree from an accredited college or university in Computer Science / Information Management or Statistics OR public health or other relevant social science combined with three (3) years of experience collecting preparing and analyzing data and three (3) years of project management experience.
- Three (3) years data management experience which includes managing and manipulating Access and SQL databases.
- Five (5) years experience in Open Database Connections (ODBC).
- Five (5) years experience managing data systems in a SAS environment
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.
Required Experience:
IC