Data Analyst

Job Details: Job Location: Administrative Offices Seventh Street - Berkeley, CA, Position Type: Full Time, Salary Range: $33.11 - $36.94Hourly, Job Category: Finance, LifeLong Medical Care is looking for a Data Analyst to support the data analytic team including reporting development, data validation, and database maintenance, and provide assistance in further development of Tableau and reports in EPIC. The Data Analyst reports directly to the Health IT Applications and Support Manager. This is a Full Time Hybrid/Remote role. Candidate must live in the Bay Area in California and be able to attend New Hire Orientation, employee trainings and meetings in person and then as necessary. About us: As a Federally Qualified Health Center in Northern California with over 50 years of dedicated service to the community, LifeLong serves over 66,000 patients in the East Bay Area's socio-economically underserved regions. We provide medical, dental, behavioral health, and school-based services at more than 15 primary care sites across Oakland, Berkeley, and West Contra Costa County. From opening a residential respite program for homeless persons discharged from hospital to offering free testing to the community, we are innovative and responsive to our times' social and medical needs. We provide an inclusive workplace that promotes and values diversity and with which our patients can identify. To this end, we seek candidates who reflect the diversity of the East Bay communities we serve. Benefits: We offer a competitive pay rate of $33.11 to $36.94 per hour and excellent benefits: medical, dental, vision, Flexible Spending Accounts, dependent and domestic partner coverage, 403(b) retirement savings plan plus paid holidays, vacation and sick leave. JOB DUTIES: 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 HIPAA requirements Other duties as assigned. Qualifications: JOB QUALIFICATIONS: 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 instructions. 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. Ability to continuously scan the environment, identifying opportunities for improvement and intersections with other departments of LifeLong Medical Care and partner organizations. 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. Job Requirements: Bachelor’s degree in Computer Science or a related field or an equivalent combination of education and/or experience. Minimum 3 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. BI tool experience required; Tableau preferred. 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.