Created by the City and County of San Francisco, San Francisco Health Plan (SFHP) is the City's number one choice for Medi-Cal, providing the community with access to award-winning health care for the past 30 years. At SFHP, we are helping shape the future of health care with a focus on improving health outcomes in San Francisco's diverse and most vulnerable communities. Our creative, innovative, and mission-driven team works together to bring equitable access to health care for all San Franciscans.

At SFHP, quality care comes first. We provide our members with a full spectrum of medical services including preventive care, specialty care, hospitalization, prescription drugs, and family planning through the Medi-Cal and Healthy Workers HMO programs. Through strategic community collaborations, we also offer our members access to services beyond traditional health care to ensure their safety and well-being. SFHP's commitment to excellence has been recognized consistently by the state, with the Award for Excellence in Quality Care from the California Department of Health Care Services.

In a continuous partnership with the San Francisco Department of Public Health, we are also the third-party administrator for Healthy San Francisco and the City Option Program.

We're looking for an experienced Insights Data Analyst reporting to the Director of Product Management & Analytics. You will utilize advanced SQL queries and a strong knowledge of databases to extract and report on critical data components and help improve the accuracy of our outreach, answering important business questions for the San Francisco Medical Reimbursement Account (SF MRA) program. You will bring strong SQL skills, a good understanding of relational databases, the ability to develop detailed business requirements and fine-tuned attention to detail to check datasets for accuracy.

Please note that while SFHP supports a hybrid work environment, this role will be required to be onsite and in-office a minimum of 4 days per month.

WHAT YOU WILL DO:

• Collaborate with colleagues with different levels of data literacy on the business side, as well as other Insights & Analytics team members and data engineers, to gather business requirements.
• Learn about the numerous datamart tables and fields that house information on the SF MRA program, and combine this with your understanding of relational databases, so that you can write precise requirements and compare new datasets to existing ones.
• Accurately write moderately sophisticated SQL queries, in a way that is easy for another analyst to understand, so that you can extract and manipulate data to answer business questions quickly. For example,
• Use appropriate joins
• Pivot data from long to wide format
• Simplify complex queries by using temporary tables
• Use date functions
• Convert character variables to dates or dollar amounts and remain engaged with a complex data problem through to resolution.
• Review your own and others’ work to catch obvious and not-so-obvious errors.
• Learn about the SF MRA program, so that you are well placed to understand business needs and recommend appropriate data sources and analysis plans
• Expand on core data analysis skills to take on more challenging work using a broader array of data tools.
• Foster an environment that solicits and enlists diverse and inclusive perspectives and approaches to better serve our staff, our members and our providers.

WHAT YOU WILL BRING

• A degree from a four-year college; bachelors in Computer Science, Informational Technology or similar degrees which may be substituted with equivalent work experience
• 3-5 years of experience as a SQL Data Analyst, ideally in a healthcare environment
• 3 or more years experience using one or more other data tools like MS Excel, Tableau, Power BI, Stata, R or Python
• Strong analytical and problem-solving skills with the ability to formulate and communicate recommendations for improvement.
• Strong SQL skills to support data analysis on a daily basis.
• Understanding of information systems, business processes.
• Ability to produce accurate and precise work, detect discrepancies and resolve discrepancies all while meeting deadlines.
• Ability to work effectively, independently, and as part of a team.
• Strong organization, time management and multi-tasking abilities.