Main Function:Analyze healthcare and other related data to support internal staff and member requests. Manage multiple datasets by designing, developing, and maintaining data extractions and transformations using SQL. Develop business intelligence visualization and outputs using Tableau to support requests, projects, and other initiatives.
Outline of Responsibilities:- Design, construct, test, and maintain data warehouse and related functionality including extraction and transformation of data using SQL.
- Gather and analyze healthcare and other related data to identify and interpret trends in support of information requests, business cases, and proposed projects.
- Design, develop, and test business intelligence outputs (including visualization) to ensure useful and insightful information using software including Tableau and/or Excel to support member hospitals and IHA's policy, advocacy, and quality initiatives.
- Test and validate data with the purpose of understanding and making conclusions to support decision-making processes.
- Manage 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.
- Monitor for timely and accurate completion of select datasets.
- Participate in strategic initiatives to enhance data management and reporting to support member hospitals and IHA's policy, advocacy, and quality initiatives.
- Proactively identify issues and opportunities to improve data systems and related policies as an aspect of data governance.
- Other duties as defined.
Qualifications:Bachelor's degree required. Master's degree preferred. Four years' experience may be considered in lieu of education. At least two years' analyst experience with a skill set that includes organizing, analyzing, and disseminating significant amounts of information with attention to detail and accuracy preferred. In addition, at least two years' experience in data management, including extraction, transformation, loading, validation/testing, and structuring of data preferred. Knowledge of hospitals and healthcare is required. Knowledge of healthcare data required that includes patient-level claims with ICD-10 and CPT preferred. Demonstrated proficiency with SQL required, Tableau preferred. A high level of interpretive skills, problem solving, logical reasoning, and decision-making skills are required to identify impactful solutions. Must have excellent communication skills, including the ability to translate technical information to non-technical audiences. Critical thinking as well as multi-tasking skills, ability to manage multiple projects, and time management skills. Must have ability to work independently and in a team environment. Minimal travel.
We offer a competitive compensation package, including excellent benefits. Qualified candidates must apply online: Click here to apply https://www.team-iha.org/our-association/employment-opportunities
Pay Range: $73,942 to $92,428 annually, actual compensation is dependent on job-related factors such as experience, education, skills and qualifications for the role.
IHA offers a full range of benefit programs based on eligibility. Click here to review our Benefit Summary.
