Healthcare Data Analyst

Description of Required Duties and Tasks:

Essential duties and responsibilities include the following:

• Write SQL queries, create end-user reports, and apply varying analytical techniques to solve specific business problems.
• Lead or participate in projects: elicit business requirements, complete and update project documentation, manage project scope, determine daily priorities, ensure efficient and on-time delivery of project tasks and milestones, follow proper escalation paths, and manage interdepartmental relationships.
• Research, analyze, present results, and recommend intelligent solutions to solve problems or address business challenges.
• Analyze key trends and performance related to clinical and network performance of programs, practices, and providers of health care to present insight to leadership.
• Assist with implementation and design of data warehouse for reporting, analysis, and applications.
• Produce ad hoc data and reports.
• Perform data scrubbing, trouble-shooting, quality checking, and usability analysis to identify anomalies, which need to be addressed prior to delivery of analytic results.
• Maintain privacy and confidentiality of records, conditions, and other information relating to residents, employees and facility.

Required Skills:

• Exceptional problem solving, organizational, and communication skills.
• Ability to design and develop key performance metrics using Excel, Tableau and MSSQL Server.
• Team player with the ability to collaborate and communicate with diverse cross-functional teams.
• Ability to persuasively present ideas and results.
• Highly self-motivated and self-directed with keen attention to detail.
• Ability to think creatively about how to solve a problem or meet a specific business need, making recommendations and decisions based on the data available.
• Able to work independently, taking full ownership of accuracy and quality of work without detailed instruction or oversight.
• Ability to tell a succinct, meaningful, and actionable story with data using visualization and other techniques.
• Ability to work on multiple projects simultaneously with minimal supervision.
• Ability to produce clear written documentation.

Required Work Experience:

• At minimum two years of progressive data analysis experience; preferably in the Managed Care industry, Medicare Advantage a plus.
• Experience working with health care claims, membership and revenue data.
• Comfortable writing queries, reports, and presenting findings as required.

Required Computer Skills:

• Knowledgeable of Microsoft Suite, use of internet and browser functionality.
• Expertise in MS Excel, with proficiency using formulas, PivotTables, linked worksheets, graphing and other reporting and presentation features.
• Working knowledge of T-SQL; at minimum ability to write Select statements that include joins, filtering, and aggregation.

Education Requirements:

• Bachelor's degree from four-year College or University preferred.