Insights Data Analyst - San Francisco Health Plan

Will you help hard working San Franciscans get reimbursed for their health care?

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.

Salary: $82,000 - $91,000/year

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.

WHAT WE OFFER

A competitive and robust compensation package, including:

• Health benefits
  • Medical: You’ll have a choice of medical plans, including options from Kaiser and Blue Shield of California. Employee-only coverage in the HMO plans is currently available at no cost and dependent coverage is heavily subsidized by SFHP.
  • Dental: You’ll have a choice of a basic dental plan or an enhanced dental plan which includes orthodontic coverage.
  • Vision: Employee vision care coverage is available through Vision Service Plan (VSP).
• Retirement – Employer-matched CalPERS Pension and 401(a) plans, 457 Plan
• Time off – 23 days of Paid Time Off (PTO) and 13 paid holidays
• Professional development: Opportunities for tuition reimbursement, professional license/membership.
• An opportunity to work in a vibrant atmosphere with the most amazingly talented people who are shaping the future of healthcare!
• The chance to make a difference in the lives of many San Francisco residents!

Established in 1997, San Francisco Health Plan (SFHP) is an award winning, managed care health plan whose mission is to provide affordable health care coverage to the underserved low and moderate-income residents in San Francisco County. SFHP is chosen by eight out of every ten San Francisco Medi-Cal managed care enrollees and its 175,000+ members have access to a full spectrum of medical services including preventive care, specialty care, hospitalization, prescription drugs, and family planning services. SFHP was designed by and for the residents it serves and takes great pride in its ability to accommodate a diverse population that includes young adults, seniors, and people with disabilities.

San Francisco Health Plan is proud to be an equal opportunity employer. We are committed to a work environment that supports, inspires, and respects all individuals and in which our people processes are applied without discrimination on the basis of race, color, religion, sex, sexual orientation, gender identity, marital status, age, disability, national or ethnic origin, military service status, citizenship, or other protected characteristics.

Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

San Francisco Health Plan is an E-Verify participating employer.

Hiring priority will be given to candidates residing in the San Francisco Bay Area and California.