JOB TITLE: Data Analyst FLSA STATUS: Exempt
DEPARTMENT: Data Analytics and IT PREPARED DATE: 8/12/2024
REPORTS TO: Program Manager
PAY: $75,000-$105,000
BENEFITS: Medical HMO/PPO, Dental, Vision, Life, LTD, ADD, Supplemental, FSA, Vacation-10 days, 9 Holidays, End of year week off, and 401K Safe Harbor with match.
FUNCTION/GENERAL SCOPE: The Data Analyst gathers requirements, develops and prepares information and analyzes health care discharge data, quality, and financial data from conceptualization through dashboard delivery to our members. The Data Analyst works on data collection, data structuring, querying, and dashboarding.
POSITION SUMMARY: As directed by leadership, this position is responsible for interpreting and providing 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 data analysis and reporting to support Association 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.
- Develop appropriate methodologies for collecting, analyzing, and presenting data.
- Efficiently query and structure the data to be integrated in Tableau dashboards
- Create educational materials and conduct training on understanding data, analysis, and definition of the measures one-on-one and in groups.
- Conduct individual project reviews, as required, to assess overall project quality, efficiency, and compliance with requirements.
- Work with customers to develop and understand product specifications.
- Provide technical support, including troubleshooting with users.
- Support Association executive leadership with data analysis and logistics.
- 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 (if applicable):
This position does not have any supervisory responsibilities.
QUALIFICATIONS:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skills, and/or abilities required.
Education/Experience:
- Bachelor’s degree in related field is required at the time of hire.
- Minimum of one year data analysis experience in a professional office setting or equivalent internship and relevant coursework experience.
- Proficient with database applications (Snowflake, SQL Server, or Redshift, etc).
- Intermediate skills in SQL (T-SQL, MySQL, or PostgreSQL, etc.).
- Intermediate 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.
PHYSICAL DEMANDS AND WORK ENVIRONMENT:
The physical demands and work environment described below represent the activities and surroundings of the positions. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
It requires attendance during core business hours and occasional time beyond the standard business day. Position requires frequent use of computer and exposure to normal physical office environment. The work is typically performed in an office environment, with a moderate noise level. The employee is frequently required to talk and hear on the telephone and in person with individuals and groups. The staff person is required to read and respond to documents in hard copy and electronic form.