Data Analyst (On-site work required)

POSITION TITLE:        Data Analyst    (entry-to-mid level position)

DEPARTMENT:            Information Systems

REPORTS TO:             Data Analytics & Programmer Manager  

PAY RANGE: $34.28 to $46.55

LOCATION: Primarily remote and occasional on-site work at one of our locations in both Napa and Yolo County as needed:

• North Campus: 1141 Pear Tree Lane Napa, CA 94558
• South Campus: 300 Hartle Court Napa, CA 94559
• Yolo County: 1590 Drew Ave #210, Davis, CA 95618

Please keep in mind, the ability to work and meet on-site as needed is a requirement.

About CommuniCare OLE

Established in 2023, CommuniCare OLE is the result of a union of two health centers with a 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.

JOB SUMMARY: 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 reports. This role is an entry-to-mid level Data Analyst position.

THE TEAM:

Our Data Department consists of our:

• CIO with over 25 years of healthcare information technology who understands how data drives and effects decision making
• Data Analytics & Programmer Manager who manages data-related projects and collaborates with stakeholders to support their department data literacy and development
• Data Analysts who supports departments with routine ad-hoc and recurring reporting development
• Data Programmer who develops software tools to automate and improve workflows

Responsibilities:

• Collaborate with Data Department and stakeholders: Confirm data requests by reviewing objective, input/output requirements, and timeframes to support clinical care teams, quality improvement, and reporting needs of the organization.
• Conduct ongoing data collection: Analyze health information from a variety of sources including eClinicalWorks, BridgeIT, Relevant, Excel, etc. for quality improvement, internal operations, UDS, and other reporting requirements.
• Data reporting development: Write, validate, and document large amounts of SQL code to build data reports and dashboards for end-user usage and functionality.

Expectations:

• Attention to verbal/written detail, manage priorities/workflow, and ability to work independently without supervision or collaborate with a multidisciplinary team
• Critical, creative, and analytical thinker for solving data-related problems and can adapt what is known to what is needed
• Strong interpersonal skills and ability to communicate thoughts and ideas effectively
• Data literacy comprehension: Interpreting results and presenting findings to stakeholders into language stakeholders can understand
• Committed to providing high quality, accurate, and timely data to improve patient care
• Regular attendance and punctuality are necessary
• Demonstrate maturity and understanding to always maintain confidentiality of patient and organizational information

Education:

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

Experience:

• Minimum of one year working as a data analyst, developer, or equivalent strongly preferred
• Minimum of one year directly related experience in healthcare - health information technology, quality improvement, data analytics/data science, or information management strongly preferred

Skills:

• 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 SQL IDE (JetBrains DataGrip, DBeaver, etc.) preferred
• Familiarity with data analytical platforms (Relevant, PowerBI, Tableau, etc..) preferred
• Familiarity with HRSA/UDS, Partnership HealthPlan QIP, CMS, PCMH, etc. reporting preferred
• Familiarity navigating Electronic Health Record (e.g., eClinicalWorks, EPIC) systems preferred
• Proficiency with Microsoft Office 365 applications including Outlook, Word, Excel, PowerPoint, OneDrive, SharePoint, and Teams preferred
• Intermediate to advanced level of knowledge of project management practices and methodologies preferred
• Experience with programming languages (Python or R) for data manipulation and analysis preferred, but not required
• Familiarly with GitHub preferred, but not required

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
• 4% Employer Match for 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