Business Data Analyst

    • Job Tracking ID: 2021-951
    • Job Location: Petaluma, CA
    • Job Level: Mid Career (2+ years)
    • Level of Education: BA/BS
    • Job Type: Full-Time/Regular
    • Date Updated: September 27, 2021
    • Years of Experience: 2 - 5 Years
    • Starting Date: ASAP
Invite a friend
facebook LinkedIn Twitter Email

Job Description:

Summary:  The Business Data Analyst will analyze and assist with the presentation of the Petaluma Health Center’s clinical, financial, operational, and administrative data. The Business Data Analyst collects, validates, and prepares information to support the organization’s clinical care teams, operational units, directors, managers, and senior management team. The Business Data Analyst will play a key role in building the administrative data systems that will support the ongoing reporting and funding needs of the organization, and deliver ad hoc reporting that supports the organization’s mission and vision. 


Areas of Responsibility:   

  • Work with the Director of Organizational Performance Optimization to collect, validate and prepare information to support the organization’s clinical care teams, operational units, directors and managers, and senior management team
  • Engage with data system “customers” (organizational directors, managers, clinicians, etc.) to ensure that information is accurate and that reports are structured and delivered in a way that promotes data-driven decision making
  • Collaborate with managers, directors, and senior management team in developing data systems that meet the organization’s clinical, administrative, and data needs
  • Support timely collection and reporting of financial, administrative, and HR data to the necessary organizational stakeholders
  • Develop predictive models to forecast key organizational metrics
  • Enter data into spreadsheets and web-based reporting tools as needed
  • Use eClinicalWorks, BridgeIT, Cognos, Paylocity, HappyFox, and other informatics tools to gather, analyze and interpret clinical and operational data
  • Develop tables, graphs, and reports
  • Maintain the inventory of clinical, business, and administrative metrics that are tracked, the reports that display them, and stakeholder requests for this information
  • Perform other duties as assigned 

Experience and Skills:

Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.  


*New employees are mandated to either provide proof of their COVID vaccination or to receive the vaccine, either through PHC or their own provider, with the first dose of a series required before the first day of employment. Exception to this mandate will be considered for those with a medical or religious exemption.



  • Bachelor’s degree in public health, mathematics, information management, computer science or a related field required
  • Minimum two years of experience in quality improvement, health IT, or information management preferred; some experience required


Desired Skills: 

The preferred candidate will demonstrate:

  • Basic database or SQL knowledge  
  • Excellent data management and manipulation abilities in Microsoft Excel or related product
  • Excellent organizational and analytical skills
  • Ability to interpret and present data
  • Strong understanding of quality improvement processes
  • Excellent written and oral communication skills
  • Working knowledge of database software, internet software, and MS Office suite


Language Skills: Ability to effectively present information and respond to questions and requests from patients, co-workers, and others as necessary. Bilingual in English and Spanish, both written and verbal, preferred.


Mathematical Skills:  Ability to add, subtract, multiply, divide in all units of measure, using whole numbers, common fractions, and decimals at a college level.


Reasoning Ability:  Ability to recognize problems, collect data and establish facts.   


Computer Skills:  Experience with Excel, including charts, pivot tables, VLOOKUP, and common functions required.


Physical Demands:  The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

  • Movement within health center complex environment repeatedly throughout the day
  • Ability to write by hand, use phone, use computer keyboard and mouse extensively to perform general office functions
  • Manual wrist and finger dexterity and wrist-finger speed sufficient to perform repetitive actions for extended periods of time
  • Ability to effectively communicate by hearing continuously and speech in a manner which can be understood by a diverse population
  • Ability to give and follow verbal and written instructions with attention to detail and accuracy
  • Must have visual acuity near and far (20 inches to 20 feet), depth perception, field of vision, ability to focus on an object, ability to identify and distinguish colors
  • Ability to sit or stand for extended periods of time (minimum periods of one (1) hour at a time)  
  • Ability to frequently walk, bend, squat, stoop, kneel, twist, crouch, and climb with the use of a step stool
  • Ability to grasp, hold and pick up and reach with hands and arms
  • Ability to frequently lift and or move up to fifteen (15) pounds
  • Ability to occasionally lift and carry up to thirty-five (35) pounds (periodic lifting of supplies or equipment)
  • Ability to coordinate multiple tasks simultaneously
  • Ability to travel to and from other health center sites and community locations