Utah Retirement Systems

  • Health Data Analyst I or II

    Location US-UT-Salt Lake City
    Posted Date 2 weeks ago(6/13/2018 10:13 AM)
    Job ID
    2018-2568
    Category
    Actuarial Underwriting
  • About The Company

    A division of Utah Retirement Systems, PEHP is a non-profit trust with the vital job of providing health benefits to Utah’s public employees and their families.

    Job Description

    HEALTH DATA ANALYST I

    Min: $23.33/hr  Max: $29.16/hr

     

    POSITION SUMMARY

    Performs data analysis on healthcare data using database queries, spreadsheets, and data visualization software. Responsible for highlighting insights, key takeaways and summarizing results from large datasets in a manner that is easy to understand.  Plays an important role in supporting the reporting function for recurring external group reports.

     

     

    ESSENTIAL JOB FUNCTIONS AND DUTIES

    1. Writes SQL queries to pull data (medical, pharmacy and dental claims; eligibility; premium; lab results & biometrics; predictive model outputs like risk scores and risk of hospitalization measures). Optimizes queries for speed and ensures the accuracy of the data.
    2. Defines the scope of the data analytic requests by clarifying and documenting what questions the end-user is trying to answer and how the results of the analysis will be used after it is delivered. After completion of analysis, performs necessary follow-up to ensure analysis meets expectations and that end-user understands how to interpret it.
    3. Builds visually intuitive Tableau dashboards that are easy to use to answer likely questions from the end-user. Optimizes visualization speed with common filter interactions. Sets up automatic data refreshes, trains end-user in any functionality of dashboard, and schedules regular follow-ups with end-users to see if there are questions or feedback.
    4. Uses Excel to perform advanced ad hoc analytical projects that involve text parsing, lookups, pivot tables, and graphs in a timely manner.
    5. Assists in updating recurring reports. Investigates and takes action to correct any discrepancy in the data to ensure the integrity of the reports.  
    6. Presents data and conclusions to department and manager for peer review.
    7. Finds meaningful insights from large data sets and assigned analytical assignments and succinctly summarizes and presents conclusions and key takeaways to others.
    8. Finds ways to automate and streamline projects and reports that are commonly recurring.
    9. Maintains strict confidentiality.
    10. Performs other related duties as required.

     

    HEALTH DATA ANALYST II

    Min: $25.27/hr  Max: $32.22/hr

     

    POSITION SUMMARY

    Performs data and statistical analysis on healthcare data using database queries, spreadsheets, programming languages, statistical software, and data visualization software. Responsible for highlighting insights, key takeaways and summarizing results from large datasets in a manner that is easy to understand and digest for both technical and non-technical audiences within PEHP. Helps build, manage or enhance underwriting models or data analysis that support the underwriting process.

      

    ESSENTIAL JOB FUNCTIONS AND DUTIES

    1. Uses looped queries and/or stored procedures to build extracts to support data visualizations. Writes SQL queries to pull data (medical, pharmacy and dental claims; eligibility; premium; lab results & biometrics; predictive model outputs like risk scores and risk of hospitalization measures). Optimizes queries for speed and ensures the accuracy of the data.
    2. Defines the scope of the data analytic requests by clarifying and documenting what questions the end-user is trying to answer and how the results of the analysis will be used after it is delivered. After completion of analysis, performs necessary follow-up to ensure analysis meets expectations and that the end-user understands how to interpret it.
    3. Uses statistical analysis to create and/or apply predictive analytics that improves the underwriting, clinical/case management, or provider relations contracting/management processes.
    4. Builds and supports advanced Tableau dashboards that are stable tools for other departments within PEHP and are regularly being enhanced based on the end-users’ feedback.
    5. Helps build, manage, and/or enhance UW models (manual rate, risk score, small-group automated and large group stand-alones). Helps build, manage, and/or enhance data analysis that supports the UW process (e.g. trend driver, UW dashboard, etc.).
    6. Presents data and conclusions to other departments within PEHP.
    7. Investigates and takes action to correct any discrepancy in the data to ensure the integrity of the reports.
    8. Finds ways to automate and streamline projects and reports that are commonly recurring.
    9. Maintains strict confidentiality.
    10. Performs other related duties as required.

    Required Experience

    HEALTH DATA ANALYST I

     

    Education and Experience

    Bachelor’s degree in a quantitative or clinical field and one (1) year of data analysis experience; or equivalent combination of education and experience.

     

    Knowledge of Tableau is preferred. Experience related to health care or data formats associated with medical, pharmacy and dental claims is preferred. Extensive knowledge of SQL and/or programming (VBA, Python or similar languages) is preferred.

     

    Knowledge, Skills, and Abilities

    This list contains knowledge, skills, and abilities that are typically associated with the job. It is not all-inclusive and may vary from position to position:

     

    Required technical skills include the working knowledge and ability of:

    • Fundamental understanding of SQL query writing and statistical analysis.
    • Intermediate knowledge of Microsoft Excel, specifically pivot tables and intermediate formulas.
    • Tableau.

     

    Required mathematical skills include working knowledge of:

    • Building and reviewing statistical models.
    • Estimating confidence intervals.
    • Being able to read and apply emerging analytical methods.

     

    Must possess excellent communication skills:

    • Communicate effectively, verbally and in writing.
    • Develop and deliver presentations.

     

    Must have the ability to:

    • Follow written and verbal instructions.
    • Prioritize work.
    • Perform within deadlines.
    • Analyze problems and data.
    • Use sound judgment in decision making and problem solving.
    • Work well in a team environment as well as independently.
    • Multi-task by handling a variety of duties in a timely and efficient manner.
    • Follow through with assignments.
    • Deal effectively with stress caused by workload and time deadlines.

     

    The incumbent must always demonstrate judgment, high integrity, and personal values consistent with the values of URS.

     

    Work Environment

    Incumbent performs in a typical office setting with appropriate climate controls. Tasks require a variety of physical activities which do not generally involve muscular strain, but do require activities related to walking, standing, stooping, sitting, reaching, talking, hearing and seeing. Common eye, hand, finger dexterity required to perform essential functions.

     

    HEALTH DATA ANALYST II

     

    Education and Experience

    Bachelors degree in a quantitative or clinical field and three (3) years of general analytical experience with a minimum of one year health specific experience; or an equivalent combination of education and experience.

     

    Intermediate experience building Tableau dashboards is preferred.

     

    Knowledge, Skills, and Abilities

    This list contains knowledge, skills, and abilities that are typically associated with the job. It is not all-inclusive and may vary from position to position:

     

    Required technical skills include the working knowledge and ability of:

    • Intermediate SQL.
    • Predictive modeling.
    • Advanced Excel experience.
    • Tableau.
    • VBA.
    • Experience with formats associated with medical, pharmacy, and dental claims.

     

     

    Required mathematical skills include working knowledge of:

    • Building and reviewing statistical models.
    • Estimating confidence intervals.
    • Being able to read and apply emerging analytical methods.

     

    Must possess excellent communication skills:

    • Communicate effectively, verbally and in writing
    • Develop and conduct presentations.

     

    Must have the ability to:

    • Follow written and verbal instructions.
    • Prioritize work and perform within deadlines.
    • Analyze problems and data.
    • Use sound judgment in decision making and problem solving.
    • Work well in a team environment as well as independently.
    • Multi-task by handling a variety of duties in a timely and efficient manner.
    • Follow through with assignments.
    • Present to internal/external groups, including the URS Board for renewal approval.
    • Deal effectively with stress caused by workload and time deadlines.

     

    The incumbent must always demonstrate judgment, high integrity, and personal values consistent with the values of URS.

     

    Work Environment

    Incumbent performs in a typical office setting with appropriate climate controls. Tasks require a variety of physical activities which do not generally involve muscular strain, but do require activities related to walking, standing, stooping, sitting, reaching, talking, hearing and seeing. Common eye, hand, finger dexterity required to perform essential functions.

     

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed