Senior Data Analyst

WASHINGTON STATE HOSPITAL ASSOCIATION; Seattle (WA); Hybrid; USD 103,000 - 165,000; Full time

Benefits offered by this job

Medical

Dental

Vision

Life Insurance

LTD

ADD

Supplemental Life and ADD

FSA

401K with match

Vacation 2-4 weeks

Wellness Week

Holidays

Personal Holidays

EAP

Transportation

Job summary

Washington State Hospital Association seeks a Senior Data Analyst to interpret and provide complex data analyses, dashboards, and actionable insights for hospitals. The role emphasizes inferential statistics in dashboards and collaboration on product logistics, with content delivered through Tableau Server & Interworks.

The position requires a Bachelor's degree with four years of data analysis experience, advanced SQL and visualization skills, and experience with Snowflake, APIs, and data

Qualifications

• Bachelor’s degree in related field is required at the time of hire.
• Minimum of four years data analysis experience in a professional office setting.
• Proficient with database applications (Snowflake, SQL Server, or Redshift, etc).

Responsibilities

• Perform complex data analysis and reporting to support Association leadership, staff and members.
• Gather requirements from stakeholders and enhance analysis with additional insights.
• Develop, prepare, and present specialized reports and dashboards for dissemination to Association members with the purpose of advancing the work at the state, hospital, and unit level.
• Analyze data and provide various reports for different scenarios to reflect solutions/recommendations in response to anticipated and unanticipated fluctuations for members. Interpret data analysis and develop related communication to provide multiple constituencies an understanding of the analysis.
• Support monthly data collection process, and continuously address and clarify data related inquiries as needed. Perform routine data validation and integrity checks with fully documented processes to ensure highly reliable data accuracy.
• Develop new dashboards and visualizations to help communicate and clarify the data.
• Research new data sources and healthcare trends to continuously develop the Association’s reporting capacity.

Skills

Data analysis

SQL

Tableau

Power BI

Looker

Python

R

APIs

Snowflake

SQL Server

Redshift

Education

Bachelor’s degree in a related field

Tools

Tableau

Power BI

Looker

Snowflake

SQL Server

Redshift

Job description

Job Details

• Job Location: WSHA Legal Address - Seattle, WA 98101-3232, Position Type: Full Time, Salary Range: $102,918.00 - $164,730.00 Salary, Job Category: Information Technology, Job Title: Senior Data Analyst
• Department: Data Analytics & IT
• Reports to: Senior Director, Data Analytics
• Hybrid work opportunity

Benefits

• Medical
• Dental
• Vision
• Life
• LTD
• ADD
• Supplemental Life and ADD
• FSA (Dependent/Health)
• Safe Harbor 401K with Match
• Vacation 2-4 weeks
• End of year Wellness Week from 12/25 and 1/2
• 9 Holidays
• 2 Personal Holidays
• EAP
• Transportation Assistance

Position Summary

As directed by leadership, this position is responsible for interpreting and providing complex data analysis, specialized reports, dashboards, and ensuring highly reliable and accurate data. This position integrates inferential statistics into their dashboards to provide actionable insights for hospitals. Responsibilities include developing visualizations to communicate and clarify the data, collaborate with members on product logistics, delivers content through Tableau Server & Interworks, and creates educational materials to conduct training on understanding data, analysis, and definition of the measures one-on-one and in groups.

Essential Duties and Responsibilities

• Perform complex data analysis and reporting to support Association leadership, staff and members.
• Gather requirements from stakeholders and enhance analysis with additional insights.
• Develop, prepare, and present specialized reports and dashboards for dissemination to Association members with the purpose of advancing the work at the state, hospital, and unit level.
• Analyze data and provide various reports for different scenarios to reflect solutions/recommendations in response to anticipated and unanticipated fluctuations for members. Interpret data analysis and develop related communication to provide multiple constituencies an understanding of the analysis.
• Support monthly data collection process, and continuously address and clarify data related inquiries as needed. Perform routine data validation and integrity checks with fully documented processes to ensure highly reliable data accuracy.
• Develop new dashboards and visualizations to help communicate and clarify the data.
• Research new data sources and healthcare trends to continuously develop the Association’s reporting capacity.
• Develop appropriate methodologies for collecting, analyzing, and presenting data.
• Efficiently query and structure the data to be integrated in Tableau dashboards
• Make recommendations to enhance data structures within Snowflake
• Create educational materials and conduct training on understanding data, analysis, and definition of the measures one-on-one and in groups.
• Engage members and staff through targeted communication, listening sessions, webinars, office hours, and online or in-person trainings to improve utilization of dashboards, reports, and other content
• Conduct individual project reviews, as required, to assess overall project quality, efficiency, and compliance with requirements.
• Advise data analysts on their projects and provide feedback when directed by Senior Director
• Provide technical support, including troubleshooting with users.
• Perform routine maintenance on DASH, including regular upgrades, new page releases, and troubleshooting errors
• Identify opportunities for performance improvement through data analysis and address risks or potential issues that might impact Association members.
• Recommend innovative ideas, processes and/or procedures for enhancements, and modifications to improve existing systems.
• Perform other duties as assigned.

Supervisory Responsibilities

This position does not have supervisory responsibilities.

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily and have a strong desire to learn new skills on an ongoing basis. The requirements listed below are representative of the knowledge, skill, and/or ability required.

Education/Experience

• Bachelor’s degree in related field is required at the time of hire.
• Minimum of four years data analysis experience in a professional office setting.
• Proficient with database applications (Snowflake, SQL Server, or Redshift, etc).
• Advanced Skills in SQL (T-SQL, MySQL, or PostgreSQL, etc).
• Advanced skills in visualization applications (Tableau, PowerBI, Looker, etc).
• Proficiency with open-source coding languages (Python, R, etc).
• Experience working with APIs.

Skills & Abilities

• Proficiency with a variety of information systems and data files, including large and complex files, analyzing file structure, using and creating file layouts, transforming raw data into finished products.
• Ability to work independently, with experience working in a team environment.
• Demonstrates strong conceptual and critical thinking skills.
• Ability to navigate a variety of technological and computer-based tools including printers/copiers, internal database and phone/web conferences.
• Demonstrate analytical and conceptual skills, knowledge of healthcare domain and clinical data sets and the ability to balance theory with practical reality.
• Maintains a high degree of professional excellence characterized by sound independent judgment, initiative, and a high standard of ethics.
• Possess outstanding written and oral communication skills.
• Possess a strong attention to detail and the ability to organize and prioritize assignments.
• Strong customer service orientation, with high degree of professionalism
• Ability to navigate a variety of technological and computer-based tools.
• Comfortable giving and receiving feedback in a constructive manner to colleagues and supervisors.
• Ability to communicate and interact with people from diverse backgrounds in a sensitive and positive manner.
• Ability to deal simultaneously with several issues or problems.
• Ability to appropriately represent WSHA as necessary both verbally and in writing.
• Ability to communicate professionally and effectively both orally and in writing.
• Ability to provide quality customer service.
• Ability to work collaboratively with colleagues, co-workers, and members.

Computer Skills

• Proficiency with computers and software is required, including Microsoft Office Suite (Outlook, Word, Excel, Teams, OneDrive, SharePoint and PowerPoint).
• Experience with Adobe Acrobat is a plus.

Physical Demands & Work Environment

The physical demands and work environment described here represent those typically encountered in this position. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

This position is typically performed in an office environment with a moderate noise level and the use of standard office equipment such as computers, phones, and copiers. The role requires clear communication in person, over the phone, and in writing, as well as the ability to review and respond to documents in electronic and paper formats.