Data Analyst

Communicare+OLE; Napa (CA); On-site; USD 85,000 - 104,000; Full time

Benefits offered by this job

Medical, Dental, Vision Coverage

PTO 18 days

Holidays + Float Day

403(b) retirement plan

Tuition Reimbursement

Job summary

CommuniCare+OLE is seeking a Data Analyst in IT to support clinical and operations teams by developing ad-hoc and recurring reports. The role reports to the Business Intelligence Supervisor and is an exempt/salaried position based in West Sacramento, Fairfield, or Napa, CA.

Ideal candidates will have strong SQL, Excel, and experience with relational databases (MSSQL/PostgreSQL) and BI tools (PowerBI/Tableau). The organization values diversity and provides comprehensive benefits.

Qualifications

• Bachelor’s degree in health informatics, computer science, statistics, data analytics, or related field.
• At least 1 year as data analyst or similar role preferred.
• Healthcare data/IT experience preferred; data analytics background favorable.
• Strong SQL skills and Excel proficiency required.

Responsibilities

• Collaborate with Data Department and stakeholders to confirm data requests and timelines.
• Analyze health information from multiple sources for quality improvement and reporting.
• Write, validate and document extensive SQL for reports and dashboards.
• Perform other duties as assigned.

Skills

SQL

Excel

PowerBI

Tableau

Relational DBs

Education

Bachelor’s degree

Tools

MSSQL

PostgreSQL

PowerBI

Tableau

Job description

Position Title

Data Analyst

Department

IT

Reports To Title

Business Intelligence Supervisor

DLSE/FLSA STATUS

Exempt/Salaried position

SUPERVISORY RESPONSIBILITIES

( does this position have direct reports ):
YES
NO

SCHEDULE

Full Time; Monday- Friday 8am-5pm

LOCATION

West Sacramento, Fairfield or Napa, CA

PAY RANGE

$41.08 to $50.20 hourly

About CommuniCare+OLE

Established in 2023, CommuniCare+OLE is the result of a union of two health centers with deep roots in their respective communities and reputations for providing high-quality primary care to all, regardless of insurance or ability to pay: OLE Health of Napa and Solano Counties and CommuniCare Health Centers of Yolo County. Building on a legacy established by both organizations in 1972, CommuniCare+OLE is a network of federally-qualified health centers with 17 sites across Napa, Solano, and Yolo Counties. It offers comprehensive care, including medical, dental, behavioral health and substance use treatment, nutrition, optometry, pharmacy, care coordination, referrals, and enrollment assistance to more than 70,000 individuals, and no one is turned away due to lack of insurance, immigration status, or ability to pay. Many services are offered outside of its sites, including mobile health, home visiting, and community and school-based programs.

Benefits

• Medical, Dental, Vision Coverage
• Employer covers 90% of employee medical, dental and vision premium and 50% of dependent premium
• 18 days of PTO (Vacation & Sick)
• 10 Paid Holidays + 1 Float Holiday
• 2% employer match with employee 4% Contribution 403(b) retirement plan
• Tuition Reimbursement of up to $2,000 per Calendar Year for part-time and full-time employees (prorated per Full-Time Equivalent)
• Life & Accidental Insurance Coverage
• Employer contribution for Health Savings Account
• Flexible Spending Account (FSA) and Limited FSA Options

JOB SUMMARY/OVERVIEW

Under the supervision of the Data Analytics & Programmer Manager, the Data Analyst collaborates with multidisciplinary teams to support the organization’s data needs by developing ad-hoc and recurring report s.

CommuniCare+OLE provides an inclusive workplace that promotes and values diversity and life experience.

CommuniCare+OLE encourages people of all backgrounds to apply including, but not limited to, Black, Indigenous Peoples, people of color, immigrants, refugees, women, LGBTQIA+, people with disabilities, veterans, individuals of all ages and religions, and individuals who have been affected by the legal system.

YOU ARE WELCOME HERE

***The following reflects requirements and essential functions of this position but does not restrict tasks that may be assigned. Essential functions include basic job duties, core elements, or fundamental responsibilities that an employee must perform to hold the position. Employees must be able to perform these essential functions with or without reasonable accommodation (accommodation may be requested). Duties and responsibilities are not all-inclusive, and they may be assigned or reassigned to this job at any time, due to reasonable accommodation or any other reason. ***

MINIMUM POSITION REQUIREMENTS: EDUCATION, EXPERIENCE, SKILLS/TRAINING

• Education:

Preferred bachelor’s degree in health-related informatics, computer science, statistics, data analytics/data science, engineering, public health, or other related fields

• Experience/Lived Experience:
• A minimum of one year of experience working as a data analyst, developer, or equivalent is strongly preferred.
• Minimum of one year of directly related experience in healthcare - health information technology, quality improvement, data analytics/data science, or information management strongly preferred.
• Special Skills/Training:
• Intermediate to advanced SQL comprehension and querying required.
• Intermediate to advanced competency in Excel (Functions, Vlookups, Pivot Tables, etc.) required.
• Familiarity with Relational Database Management Systems (MSSQL and PostgreSQL) preferred.
• Familiarity with data analytical platforms (Relevant, PowerBI, Tableau, etc..) preferred.

Essential Functions And Responsibilities

Collaborate with the Data Department and stakeholders to confirm data requests by reviewing objectives, input/output requirements, and timeframes that support clinical care teams, quality improvement, and the organization's reporting needs .

Conduct ongoing data collection by analyzing health information from various sources, including Epic, BridgeIT, Relevant, and Excel, for quality improvement, internal operations, UDS, and other reporting requirements.

Data reporting development: Write, validate, and document extensive SQL code to create data reports and dashboards for end-user use and functionality.

Performs other duties as assigned.