Data Analyst - LifeLong Medical Care

LifeLong Medical Care has an exciting opportunity for a Data Analyst to support data analytic team including reporting development, data validation, and database maintenance, and provide assistance in further development of Tableau and reports in EPIC. 

This is a full time, benefit eligible position, working 40 hours/week. Must be able to work in-person in Berkeley, CA. Out of state applicants will not be considered. 

LifeLong Medical Care is a large, multi-site, Federally Qualified Health Center (FQHC) with a rich history of providing innovative healthcare and social services to a wonderfully diverse patient community. Our patient-centered health home is a dynamic place to work, practice, and grow. We have over 15 primary care health centers and deliver integrated services including psychosocial, referrals, chronic disease management, dental, health education, home visits, and much, much more. LifeLong Medical Care is an equal opportunity employer. We strongly encourage applications from women, people of color, and bilingual and bicultural individuals and members of the lesbian, gay, bisexual, and transgender communities. Applicants shall not be discriminated against because of race, religion, sex, national origin, ethnicity, age, disability, political affiliation, sexual orientation, gender identity, color, marital status, or medical condition.

Benefits

Compensation: $34 - $37/hour. We offer excellent benefits including: medical, dental, vision (including dependent and domestic partner coverage), generous leave benefits including nine paid holidays, Flexible Spending Accounts, 403(b) retirement savings plan.

COVID-19 Vaccine Policy

In accordance with LifeLong Medical Care's commitment to provide and maintain a workplace that is free of known hazards, we have adopted a Mandatory COVID-19 Vaccine Policy to safeguard the health of our employees and their families; our patients and visitors; and the community at large from infectious diseases, that vaccinations may reduce. This policy will comply with all applicable laws and is based on guidance from the Centers for Disease Control and Order of the California State Public Health Officer. Unless a reasonable medical or religious accommodation is approved, all employees must receive COVID-19 vaccinations.

• Supports data analytic team with data reporting and provides assistance to all data reporting tool users in Lifelong Medical Care, including documentation of report requirements and report implementations.
• Provides analytic support to one or multiple departments and develops a variety of complex ad hoc, production and/or trend reports to support business decisions and operational processes for internal and external clients independently
• Assists in maintaining integrity of all databases including troubleshooting measures such as identification of error elements with notification to in-house source or outside vendor
• Assists in arranging project requirements in programming sequence by analyzing requirements, preparing a work flow chart and diagram using knowledge of computer capabilities, subject matter, programming language, and logic.
• Communicates with clients and key stakeholders to develop and create specification analytical applications.
• Develops and maintains internal reporting services platform using Structured Query Language (SQL) Server Reporting Services and Tableau.
• Assists data analytic team in database optimization and maintenance.
• Supports developments of Structured Query Language (SQL) scripts in data conversation for EPIC implementation.
• Protects operations by keeping information confidential and complies with Health Insurance Portability and Accountability Act of 1996 requirements.
• Other duties as assigned.

• Commitment to the provision of primary care services for the underserved with demonstrated ability and sensitivity in working with a variety of people from low-income populations, with diverse educational, lifestyle, ethnic, and cultural origins.
• Be creative and mature with a “can do,” proactive attitude.
• Ability to effectively support and motivate colleagues, encourage and nurture development and growth, to build a strong and productive team.
• Strong organizational, administrative, multi-tasking, prioritization and problem-solving skills.
• Ability to work effectively under pressure in a positive, friendly manner and to be flexible and adaptive to change.
• Ability to take initiative, work independently and make sound judgments within established guidelines.
• Understand and apply oral and written
• Establish and maintain effective working relations with staff, clinical providers, managers and external agencies or organizations.
• Excellent interpersonal, verbal, and written skills and ability to effectively work with people from diverse backgrounds and be culturally sensitive.
• Work in a team-oriented environment with several professionals with different work styles and support needs.
• Conduct oneself in internal and external settings in a way that reflects positively on LifeLong Medical Care as an organization of professional and confident staff.
• Ability to continuously scan the environment, identifying opportunities for improvement and intersections with other departments of LifeLong Medical Care and partner organizations.

Job Requirements          

• Bachelor’s degree in Computer Science or a related field or an equivalent combination of education and/or experience.
• Minimum 2 years’ experience in programming analysis involving duties listed above
• Experience in healthcare related field and/or data reporting related work.
• Proficiency in SQL scripting and knowledge of database development.
• Basic understanding of SQL Server Integration Services.
• Proficiency in Microsoft Office, including Excel, PowerPoint, and Word.

Job Preferences              

• Community Health Center experience.
• Microsoft Certified Solution Associate in SQL database development.
• Experience in data visualization development