Prepare for and practice interview questions from Houston Methodist.

Houston Methodist Interview Questions

Houston Methodist Interview Guides

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

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

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?

Houston Methodist Salaries by Position

At Houston Methodist, the Business Analyst is responsible for facilitating within the organization, acting as a bridge between the client, stakeholders and assigned team. The Business Analyst is assigned to projects of intermediate complexity and scope. Responsible for identifying the business needs of clients and stakeholders to determine solutions to business problems. Responsible for requirements development and management. This includes producing, analyzing, validating and documenting business, organizational and/or operational requirements. Analysis includes but is not limited to financial analysis, quality assurance, organizational development, testing, training, and documentation development. The Business Analyst works to ensure that all business requirements are addressed in the implementation of a given product, project or effort.Requirements:PEOPLE ESSENTIAL FUNCTIONS* Communicates (oral and written) effectively with customers, vendors, colleagues, and management about services, contact information, system availability, and information.* Acts as liaison between the customer and the technical team facilitating requirements gathering sessions, set expectations and coordinate team members utilizing teamwork and collaborative skills.* Engages customers and elicits requirements using various methods in design and development in conjunction with developers to document business case/scope/plan, business/functional requirements; including specifications for package solutions, and/or software development.* Partners with assigned Project Manager to support all phases of project implementation.SERVICE ESSENTIAL FUNCTIONS* Facilitates gathering and documenting requirements, business rules and other related documentation.* Decomposes business and user requirements into complete, concise and consistent functional requirements suitable for use by the developer.* Develops clear messaging to customers and management on plans for issue resolution, status updates and their effect on the department to customers.* Coordinates discovery, planning and follow up sessions with key customers.* Participates in resolving system outages, disaster management and change control.QUALITY/SAFETY ESSENTIAL FUNCTIONS* Ensures the quality and integrity of data collected for decision making and works with the other areas of the organization to ensure consistency as applicable. Ensures information is consistent, accurate, relevant and timely.* Performs required testing and quality assurance to ensure solutions delivered are defect free and of high quality.* Participates in setting, monitoring, and meeting SLAs with customers. Develops detailed system test plans, execute system test cases and provide issue tracking and consolidation. Manage a coordinated User Acceptance Test (UAT) effort.FINANCE ESSENTIAL FUNCTIONS* Utilizes department resources and supplies effectively and practices good time management. Helps minimize excess cost(s) by assisting and recommending solutions in achieving organizational objectives.GROWTH/INNOVATION ESSENTIAL FUNCTIONS* Proposes solutions to facilitate constructive discussion within the team to arrive at the most optimal solution. Uses internal and external resources to stay up to date with new technologies and trends.* Proactively manages own professional development. Completes Individual Development Plan (IDP).This job description is not intended to be all-inclusive; the employee will also perform other reasonably related business/job duties as assigned. Houston Methodist reserves the right to revise job duties and responsibilities as the need arises.Qualifications:EDUCATION* Bachelor's degree required, preferably in Computer Science, Business Administration, or related disciplineWORK EXPERIENCE* Three years experience supporting IT projects in an IT analyst role or similar function* Experience performing requirement gathering and documentation* Healthcare experience preferred* Experience in clinical, business or financial operations preferredLICENSES AND CERTIFICATIONS - REQUIRED* N/AKNOWLEDGE, SKILLS, AND ABILITIES* Demonstrates the skills and competencies necessary to safely perform the assigned job, determined through on-going skills, competency assessments, and performance evaluations* Sufficient proficiency in speaking, reading, and writing the English language necessary to perform the essential functions of this job, especially with regard to activities impacting patient or employee safety or security* Ability to effectively communicate with patients, physicians, family members and co-workers in a manner consistent with a customer service focus and application of positive language principles* Ability to talk with individuals and groups about their needs and ask the right questions to surface essential requirements information.* Ability to critically evaluate the information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a more general understanding, distinguish presented user requests from the underlying true needs, and distinguish solution ideas from requirements.* Ability to engage customers and technicians for the purpose of extracting discussion, ideas, opinions, and general contribution in individual settings, meetings, or to lead requirements elicitation workshops.* Ability to validate data obtained via other techniques and expose new areas for elicitation.* The ability to communicate information effectively to customers,vendors, managers, and technical staff.* Ability to work with a vast array of information gathered during elicitation and analysis and to cope with rapidly changing information and priorities.* Ability to help negotiate priorities and to resolve conflicts among customers, technologists, and management. Strong teamwork skills at all levels are critical.* Ability to evaluate, prioritize and problem solve a variety and multiplicity of tasks and ensure their timely and accurate completion. Also, the ability to work independently and take initiative in areas of responsibility.* General knowledge of health care operations desired. Knowledge and appreciation of business concepts and requirements as applicable to a large academic, research, and/or healthcare facility a plus.* Knowledge of project management tools preferredSUPPLEMENTAL REQUIREMENTSWORK ATTIRE* Uniform No* Scrubs No* Business professional Yes* Other (department approved) NoON-CALL** Note that employees may be required to be on-call during emergencies (ie. DIsaster, Severe Weather Events, etc) regardless of selection below.* On Call* YesTRAVELTravel specifications may vary by department* May require travel within the Houston Metropolitan area Yes* May require travel outside Houston Metropolitan area YesCompany Profile:Houston Methodist is one of the nation's leading health systems and academic medical centers. Houston Methodist consists of eight hospitals: Houston Methodist Hospital, its flagship academic hospital in the heart of the Texas Medical Center, and seven community hospitals throughout the greater Houston area. Houston Methodist also includes an academic institute, a comprehensive residency program, a global business division, numerous physician practices and several free-standing emergency rooms and outpatient facilities. Overall, Houston Methodist employs more than 27,000 employees and is supported by a wide variety of business functions that operate at the system level to help enable clinical departments to provide high quality patient care.Equal Employment OpportunityHouston Methodist is an Equal Opportunity Employer.Equal employment opportunity is a sound and just concept to which Houston Methodist is firmly bound. Houston Methodist will not engage in discrimination against or harassment of any person employed or seeking employment with Houston Methodist on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, status as a protected veteran or other characteristics protected by law. VEVRAA Federal Contractor - priority referral Protected Veterans requested.

Houston Methodist Interview Questions

Houston Methodist Interview Guides

Houston Methodist Interview Questions

Houston Methodist Salaries by Position

Houston Methodist Opening Jobs