Transform your impact at one of these organizations

Data Warehouse Analyst

San Francisco Health Plan

San Francisco Health Plan

San Francisco, CA, USA
Posted on Tuesday, June 11, 2024

Reporting to the Manager, Data Engineering, the Data Warehouse Analyst is responsible for providing systems analysis support for technology-enabled solutions specifically focused on the organization’s data management and data warehouse programs. You will work closely with business leaders and users, subject matter experts, project managers and IT professionals. You will elicit requirements and provide clear, concise documentation, analyze systems, analyze data, troubleshoot and provide root cause analysis, and contribute to systems-related business process design and improvement.

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. This is a hybrid position, based in our Downtown San Francisco office.

Salary Range: $109,341 to $121,489


  • Work effectively in a team environment, utilizing Agile methodologies
  • Work directly with business partners, project managers, all levels of management, technical staff, architects and vendors to analyze Business Requirements/Need and create clear and concise Functional Specifications (supporting workflows, data analysis, etc.) according to standards and best practices
  • Actively lead and participate in requirements elicitation and apply a combination of business and technical knowledge to solve business problems with cost-effective technical solutions. Provide guidance to the business as to what is available as a technical solution
  • Understand the structure, policies, and operations of SFHP organization, and recommend solutions which enable SFHP to achieve its goals
  • Propose and design practical methods of process standardization, automation and incremental changes to drive efficiencies
  • Possess complete understanding of the SFHP data ecosystem surrounding target requirements, upstream and downstream impacts
  • Intimate knowledge of the organizations data pipelines and warehouse and how they interact with key applications
  • Use creative problem-solving skills to remove barriers and effective communication skills to keep all parties informed of status
  • Become Subject Matter Expert (over time) in MediCal/Medicare data over time
  • Support production system incidents; troubleshoot and provide root cause analysis
  • Work with end-users as needed to develop and execute test plans to verify business systems and processes work as expected
  • Adhere to SFHP’s Change Management/Release Management Policies and Procedures such as submitting appropriate and timely change requests
  • Develop and recommend operational processes and /or process improvements
  • Outline comprehensive action plan to implement said process improvements.
  • Act as an advocate for business users across the organization and support the business with helping to prioritize their requests
  • Provide end-user training for implemented systems/processes as well as accompanying user guides


  • A degree from a four-year college (e. g., BS) in a relevant field or equivalent work experience
  • Prior experience at a healthcare organization, particularly at a managed health plan
  • Experience in Agile Methodology and User Story refinement
  • Minimum 6 years of experience as a Business Systems Analyst, Systems Analyst, Technical Analyst or comparable position in a healthcare environment
  • 2 - 4 years’ experience with relational databases, standard data warehouse concepts (dimensional models, etc) and writing SQL queries
  • Intermediate experience with Microsoft Visio or comparable business process design software preferred.
  • Familiarity in managing requirements and test suites in Azure DevOps preferred
  • Familiarity with HIPAA healthcare EDI transactions and file formats preferred
  • PC literacy required; MSOffice skills (Outlook, Word, Excel, PowerPoint)


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.