Data Analyst II

Fair Haven Community Health Care•New Haven, CT

About The Position

For over 54 years, FHCHC has been an innovative and vibrant community health center, catering to multiple generations with over 165,000 office visits across 21 locations. Guided by a Board of Directors, most of whom are patients themselves, we take pride in being a healthcare leader dedicated to delivering high-quality, affordable medical and dental care to everyone, regardless of their insurance status or ability to pay. Our extensive range of primary and specialty care services, along with evidence-based programs, empowers patients to make informed choices about their health. As we expand our reach to underserved areas, our commitment to prioritizing patient needs remains unwavering. FHCHC's mission is to enhance the health and social well-being of the communities we serve through equitable, high-quality, and culturally responsive patient-centered care. Job purpose The Data Analyst II is responsible for gathering, organizing, analyzing and presenting data. The responsibilities include extracting data, maintaining databases and creating reports. The role also identifies trends and patterns in data sets and provides meaningful insights to inform and impact important business decisions that advance the mission of Fair Haven Community Health Care (FHCHC). Reporting to the Data & Analytics Director, the Data Analyst II uses analytical skills and expertise in data processing to provide insightful data analysis for all organizational data needs and requirements. They are responsible for interpreting complex data sets, developing actionable insights, and creating detailed reports and dashboards to enhance decision-making and drive business performance.

Requirements

Bachelor’s degree in business, computer science, data science, engineering, information systems and 5 years’ experience are required.
Ability to work independently, make decisions and provide training
Competence in data quality and data governance with complex healthcare data sets
Demonstrated ability to understand, analyze, document, explain business processes and the data behind them
Excellent data analysis and data management skills
Exceptional communication, interpersonal, organizational and attention to detail skills
Experience with a variety of software and online platforms (e.g. Adobe, Dropbox Sign, FileZilla, Power BI, Electronic Handbook, 340B ESP, Value Set Authority)
Experience with data visualizations, demonstrating correlations, trends, forecast, etc. (e.g. Advanced Excel, Power BI, Tableau)
Experience working with Electronic Health Records (EHR), population health software, medical claims, and other healthcare data and regulations
Experience writing well-formed SQL queries for data reporting, as well as other data management tools (e.g. SQL Server, Tableau, Power BI, Advanced Excel)
Must be flexible and adaptable to change in a fast-paced environment
Superior skills in follow-through, self-directed work and independent problem solving

Nice To Haves

Experience with Federally Qualified Health Centers and Uniform Data System (UDS), and with the Epic EHR system and familiarity with software engineering and coding languages (e.g. HTML, Python, R, C#, cloud software) in addition to SQL, is highly desirable.

Responsibilities

Approves team workflow and processes documentation for the benefit of team and organizational data governance and contributes to the ongoing development of data dictionary, standards and training
Creates and develops the processes of data collection, data analysis, and data review for quality improvement, grants, and other programs
Designs, develops, and manages databases for quality and appropriateness of source data to support the creation, validation, and visualization of reports
Ensures the consistency and maintainability of existing data assets by creating, maintaining, and enforcing standards/procedures for data management
Fulfills ad-hoc requests from staff (e.g. scheduling reporting, changes to metrics, views, and updates to visualizations)
Leads investigations (root cause analysis) and resolution of systems problems
Maintains and improves data pipelines, queries, master datasets, and dashboards
Maintains and manages strict adherence to all deadlines including reporting deadlines and timely completeness of documentation
Oversees and develops the interfaces and systems FHCHC uses to store, display, transfer and report data; including but not limited to coding for data extraction from multiple databases and server combinations
Partners with members of staff to promote the effective use of shared data
Performs other necessary duties as required by FHCHC to achieve the goal of providing high quality services
Recommends solutions with key stakeholders when data issues occur that are likely to impact operations and business outcomes
Supports teams and committees working on quality improvement projects
Works effectively with all levels within the organization and establishes strong relationships at all levels of FHCHC and community connect organizations
Works in collaboration with internal and external stakeholders; providers, directors, department managers, vendors and others, to identify and meet the continuous data and business intelligence requirements of the organization