Prepare for and practice interview questions from Hmsa.

Hmsa Interview Questions

Hmsa Interview Guides

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Hmsa Salaries by Position

Utilize project management techniques to coordinate focused medical review projects as assigned. Conduct analysis to understand utilization trends. Document and present relative data and recommendations to management and/or oversight committees. Collaborate to implement strategies to improve quality outcomes and control healthcare cost trend in alignment with corporate initiatives. Collaborate with reporting SMEs to create reports or dashboards to reflect impact of UM programs as demonstrated by direct cost savings and/or changes in provider behavior. Create and maintain requirements documents for each report or dashboard. Identify, research, and resolve issues by making sound decisions in accordance with policies and procedures. Respond to telephone and written inquiries from providers and internal customers. Act as a liaison between Medical Management and internal departments. Build professional relations with various stakeholders Create and maintain policy, procedure, and desktop instruction documentation. Assist with education and training to HMSA staff and providers regarding Medical Management activities/projects and seek input and cooperation for the development of new programs. Support and participate in department and corporate workgroups and projects, as assigned. Performs all other miscellaneous responsibilities and duties as assigned or directed. LI-Hybrid

Business Solution Development: Develop, maintain and coordinate department user requirements, data reporting and application requirements for projects that affect Medicaid Programs. Assist with solution design and development. Participate in and lead teams involved in projects that affect Medicaid programs and collaborate with project leads and team members from other departments. Communicate and collaborate with appropriate staff to ensure suitability of solutions. Develop effective use of advanced analytical methods and tools to enhance the delivery of solutions to meet business requirements. As required, learn new business concepts and methods applicable to Medicaid Programs projects and initiatives. Business Project Analysis: Develop and apply appropriate analytical methods to assigned business projects and tasks. Thoroughly document all aspects of project requirements, methodology, task schedule, and analytical results including interpretation of results, summary findings, and presentation reports. Collaborate with staff and management in own and other departments as required to fully understand business scope, business constraints, and business implications of analytical results. Program Management: In support of and with assistance from the Director and Sr. Manager, assist with: Developing and communicating overall project strategy to ensure that business requirements are fulfilled across all Medicaid Programs activities and projects. Ensuring that all Medicaid Program required reports, data, and activities are completed and delivered accurately and on time. Managing all aspects of the planning, execution, and closure of such projects. Evaluating and directing the development of best practices, project standards, procedures, and quality objectives utilizing established project standards, procedures, and quality objectives. Conducting project kickoff meetings and communicating individual roles and project/program expectations and responsibilities to ensure that all project team members have the tools and training to perform effectively. Providing leadership to project managers, project and business leads, and other staff who are assigned to work on Medicaid Programs activities and projects. Developing and maintaining collaborative relationships with Project Stakeholders, Business Relationship Managers, Project Office Managers, and other management and staff as necessary to provide oversight on Medicaid Programs activities and projects. Identifying and analyzing business needs. Translating business needs into appropriate and effective solutions. Monitoring the design and implementation of solutions. Establishing project baselines and developing project schedules. Monitoring project milestones, timelines, technical deliverables, resource usage, critical dates, scope, costs, and quality to identify potential risks. Identifying and tracking project issues and resolutions. Facilitating the resolution of schedule and project related issues. Assessing variance from project plans and implement measures to ensure projects remain within scope, time, cost, and quality objectives. Tracking and reporting project status. Preparing and presenting project updates to senior management and Executive Steering Committees. Preparing and presenting business justification for tactical business priorities as required. Facilitating the evaluation, selection, and contract negotiations for external vendors. Managing vendor relationships in support of project goals. Acting as a liaison between Medicaid Programs department, other HMSA Departments, subcontractors, and vendors. Continuously providing constructive team feedback as is pertinent to Medicaid Programs projects. Integrating, wherever possible, areas of improvement into the project lifecycle. Coaching and mentoring less experienced department personnel. Maintaining content of project websites to facilitate effective communication. Studies & Reports: Produce concise, structured, and informative data analytic reports summarizing projects, objectives, methods & findings of program significance. Document issues, background, data, methods, problems and alternatives, and results. Other Duties/Functions: Perform all other miscellaneous responsibilities and duties as assigned or directed. LI-Hybrid

Analyzes business problems, including, but not limited to enhancements to add functionality and/or redesigns of systems or processes to improve efficiency. Defines system functionality for systems analysts and programmers, including, but not limited to the definitions of screens, reports, and internal processing, such as edits, calculations, etc. Develops business requirements, performs testing, and interfaces with programmers or vendors. Prepares recommendations for consideration by management based on analysis of project activities. Coordinates implementation with internal and external users, including, but not limited to development of process documentation. Develops, implements and monitors to completion activities that result from assigned project(s) and/or independent analysis. Coordinates implementation within department, including, but not limited to development of processing and procedure documentation, training materials and employee training. Develops, implements and monitors to completion activities that result from assigned project(s) and/or independent analysis. These can include but are not limited to changes in the definition of work-flows and procedures development of reports that result in decreases in claims inventory and aging identification of claims processing issues that can be addressed by development of problem reports, ISSs, coding or system and/or configuration enhancements. supports the definition of system and/or configuration requirements and systems testing for ongoing automation of operational activities and processes Defines acceptance testing criteria and ensure that the criteria are met before system changes or configuration changes are implemented. May assist in unit/system testing. Performs all other miscellaneous responsibilities and duties as assigned or directed. LI-Hybrid

Hmsa Interview Questions

Hmsa Interview Guides

Hmsa Interview Questions

Hmsa Salaries by Position

Hmsa Opening Jobs