Data Analyst - Denver

Overview

HMA is seeking a Data Analyst to join our rapidly growing Data Analytics Resources Team (DART).  Our DART team is primarily structured as Hybrid or WFH and we do prefer that candidates are commutable to our Denver, CO office location for as needed meetings from time to time. 

Job Summary

Under general supervision, responsibilities are focused on interpreting and analyzing large health care claims data sets and financial data from health care providers. The Data Analyst will operate in both a team situation and with minimal supervision in a variety of projects to organize and analyze data for patterns, trends and strategic insights in support of the firm’s consulting engagements. The Data Analyst will assist with all phases of quantitative research including programming, data management and the interpretation and presentation of results.

Responsibilities

Work Performed

• Perform data extraction, uploading data, manipulation, cleaning, quality checking and analysis.
• Interpret findings and prepare materials to clearly communicate analytical findings to management.
• Analyze and create reports to summarize data findings for clients. Create data visualizations using software platforms.
• Process large datasets to identify enrollment, utilization, and spending trends.
• Model the fiscal impact of changes to provider payment rates, billing rules, and modifications to service arrays.
• Design surveys to collect information from providers, service users, and other stakeholders.
• Perform quality reviews on provider cost reports and provider survey data; write visual basic scripts.
• Research and compare Medicaid payment rates and service definitions across states.
• Develop payment rate models, benchmark payment rates to other sources of cost data.
• Assist in the development of audience-appropriate reports ad presentations to summarize findings from research and analysis tasks.
• All other job duties as assigned.

Qualifications

Education/Training

Bachelor’s degree in economics, finance, accounting, computer science or related field is preferred. Equivalent work experience equivalent will be considered. Master’s degree is ideal.

Experience

• A minimum of three years of experience working with health care data.
• Intermediate Microsoft Office applications skills including MS Excel, Word, PowerPoint and Access.
• Familiarity with MySQL, Tableau, Project and Visio.

Knowledge, Skills and Abilities

• Experience in the manipulation and evaluation of large data sets of health care claims, managed care encounters and financial information.
• Knowledge of financial analysis techniques
• Knowledge of health care policy and data.
• Skilled with MySQL, Tableau, Project, and Visio.
• Understanding of computer languages used within database.
• Creative problem solving.
• Strong analytical and statistical skills.
• Excellent attention to detail.
• Strong communication skills
• Superior interpersonal skills.
• Highly organized and able to work under tight deadlines.

Work Aids and Equipment Used

Computer, printer, copier, scanner, fax, telephone, web conferencing, Internet, video conferencing.

Working Conditions

Work is sedentary in nature and performed in an office environment. Involves frequent contact with staff and clients. Work may be stressful at times. May require travel at times (~5%).

Physical/Mental Demands

Work requires hand dexterity for office machine operation; stooping, climbing, and bending to files and supplies; mobility to complete errands; stand/sit for up to eight hours each day; ability to communicate clearly when using the telephone; requires sitting, standing, walking, reaching, bending, lifting, and twisting at times; moderate levels of stress. Ability to lift up to 20 pounds at times.

EEO

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

Additional Info

The posted salary range for this role at HMA includes a range of factors that we consider when making compensation decisions. These factors include but are not limited to experience, education, training, skills, licensures, and certifications, along with other business and organizational needs. HMA may adjust the posted salary range estimate for applicable geographic differentials associated with the location where we may fill the position. At HMA, we generally do not hire an individual at or near the top of the range for their role. All compensation decisions are dependent on the variables of each case. A reasonable estimate of the existing salary range for this position is $70,000 to $100,000.

HMA offers a robust benefits package for full-time colleagues. Benefits include health, dental, vision, group life/AD&D, voluntary life/AD&D, short-term disability, long-term disability, paid parental leave, paid time off, paid holidays, 401(k) employer match and safe harbor contribution, and our long-term equity incentive plan.

#LI-BR1