Data Analyst II

Fair Haven Community Health Care

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.

This position is onsite commuting of New Haven, Connecticut

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).

Duties and responsibilities

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. Typical duties include but are not limited to:

• 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

Qualifications

Bachelor’s degree in business, computer science, data science, engineering, information systems and 5 years’ experience are required. The selected candidate will have:

• 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

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.

$alary: $90,000.00 (salary is commensurate with qualifications & experience)

American with Disabilities Requirements:

External and internal applicants, as well as position incumbents who become disabled, must be able to perform the essential job specific functions (listed within each job specific responsibility) either unaided or with the assistance of a reasonable accommodation to be determined by the organization on a case by case basis.

Fair Haven Community Health Care is an Equal Opportunity Employer. FHCHC does not discriminate on the basis of race, religion, color, sex, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.