Prepare for and practice interview questions from University Hospitals.

University Hospitals Interview Questions

University Hospitals 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

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?

University Hospitals Salaries by Position

A Brief Overview The position is visible to the hospital's business service lines and serves as a liaison between IT and those groups. This position also functions as a team member responsible for providing application(s) configuration support to enhance department's operational efficiencies/ workflow needs. Duties include: What You Will Do <ul><li>Supports major enterprise applications and others as assigned.</li><li>Leads design of business workflow in conjunction with the business units and provides guidance to Application Analysts in designing improved efficiencies, solving complex workflow issues and incorporating quality initiatives.</li><li>Leads needs assessment, software design, implementation, support, and reporting.</li><li>Leads unit and integrated testing of the software to ensure that the design objectives are met.</li><li>Identifies complex testing scenarios, develops test scripts, and validates testing results.</li><li>Maintains high degree of understanding of departments' business processes.</li><li>Owns specific functionality and processes; responsible for all configuration, testing, and communication regarding this functionality/process.</li><li>Troubleshoots application issues, without assistance, to resolution.</li><li>Troubleshoots system hardware, as needed.</li><li>Partners with end users to understand workflow and business processes.</li><li>Oversees system security for assigned applications.</li><li>Manages Disaster Recovery and Back Up requirements for assigned systems and provides guidance to Applications Analysts in activities.</li><li>Acts as the team project lead in partnership with the Project Management Office on all phases of a project; from scoping and design through implementation and transition to Operations.</li><li>Mentors Application Analysts.</li><li>Produces and maintains custom reports; maintains knowledge and experience with industry standard report writers such as Crystal Reports.</li><li>Reviews and approves end-user training materials and participates in training efforts.</li><li>Guides other team members to ensure high documentation standards.</li><li>Leads escalation of issues with appropriate resources.</li><li>Develops policies and procedures in collaboration with the business unit, other team members, and IT management team.</li><li>Independently manages components of application upgrades, testing, troubleshooting, and support efforts.</li><li>Supports/troubleshoots inbound/outbound interfaces as appropriate.</li><li>Creates reports as needed and works problem tickets.</li><li>Evaluates and maintains appropriate system documentation.</li><li>Collaborates with other application and clinical analysts to ensure system integrations.</li><li>Serves as primary customer contact for on and off hours application support (rotating schedule).</li><li>Participates in change management activities to support successful system deployments and enhancements.</li><li>Utilizes and maintains appropriate change control procedures and standards.</li><li>Creates reports, dashboards, and other analytical tools to support customer base.</li><li>Prepares detailed flowcharts/diagrams to assist with design decisions and problem analysis.</li><li>Leads the design of business workflow in conjunction with the business departments; workflows will focus on improved efficiencies, as well as incorporating quality initiatives.</li><li>Assists with data collection from business subject matter experts, to facilitate design which will represent an improved business workflow.</li></ul>Additional Responsibilities <ul><li>Performs other duties as assigned.</li><li>Complies with all policies and standards.</li><li>For specific duties and responsibilities, refer to documentation provided by the department during orientation.</li><li>Must abide by all requirements to safely and securely maintain Protected Health Information (PHI) for our patients. Annual training, the UH Code of Conduct and UH policies and procedures are in place to address appropriate use of PHI in the workplace.</li></ul> Qualifications: Education <ul> <li>High School Equivalent / GED (Required) and</li> <li>Bachelor's Degree (Preferred)</li> </ul> Work Experience <ul> <li>3+ years Experience supporting applications (Required) and</li> <li>Experience in a healthcare setting is highly desired (Preferred) and</li> <li>Experience working with business applications such as:Patient Scheduling systemsHospital or Physician Revenue Cycle systemsData WarehousingSQL Server/SSISEnterprise Scanning and workflow management ApplicationsBed Management ApplicationsFinance Applications (Required)</li> <li>Interface build and support, Datahub and/or Boomi experience (Preferred)</li> </ul> Knowledge, Skills, & Abilities <ul> <li>Excellent written and verbal communication skills are. (Required proficiency)</li> <li>Ability to work in a team environment. (Required proficiency)</li> <li>Ability to function independently in a fast-paced environment. (Required proficiency)</li> <li>Ability to work with all levels of the organization. (Required proficiency)</li> <li>Knowledge of MS Office. (Required proficiency)</li> <li>Project management experience/skills. (Preferred proficiency)</li> <li>Business workflow redesign experience. (Preferred proficiency)</li> <li>Knowledge and experience with SQL based applications. (Required proficiency)</li> <li>Knowledge of LAN, DNS, and networking. (Required proficiency)</li> <li>Ability to work with servers and apply software upgrades. (Required proficiency)</li> <li>Knowledge of disaster recovery and backup procedures. (Required proficiency)</li> <li>Knowledge and experience with HL7 Interfaces. (Required proficiency)</li> <li>Knowledge of ITIL standards. (Preferred proficiency)</li> </ul> Physical Demands <ul> <li>Standing Occasionally</li> <li>Walking Occasionally</li> <li>Sitting Constantly</li> <li>Lifting Rarely 20 lbs</li> <li>Carrying Rarely 20 lbs</li> <li>Pushing Rarely 20 lbs</li> <li>Pulling Rarely 20 lbs</li> <li>Climbing Rarely 20 lbs</li> <li>Balancing Rarely</li> <li>Stooping Rarely</li> <li>Kneeling Rarely</li> <li>Crouching Rarely</li> <li>Crawling Rarely</li> <li>Reaching Rarely</li> <li>Handling Occasionally</li> <li>Grasping Occasionally</li> <li>Feeling Rarely</li> <li>Talking Constantly</li> <li>Hearing Constantly</li> <li>Repetitive Motions Frequently</li> <li>Eye/Hand/Foot Coordination Frequently</li> </ul> Travel Requirements <ul> <li>10%</li> </ul>

A Brief Overview The position is visible to the hospital's business service lines and serves as a liaison between IT and those groups. This position also functions as a team member responsible for providing application(s) configuration support to enhance department's operational efficiencies/ workflow needs. Duties include: What You Will Do <ul> <li>Supports major enterprise applications and others as assigned. </li><li>Leads design of business workflow in conjunction with the business units and provides guidance to Application Analysts in designing improved efficiencies, solving complex workflow issues and incorporating quality initiatives. </li><li>Leads needs assessment, software design, implementation, support, and reporting. </li><li>Leads unit and integrated testing of the software to ensure that the design objectives are met. </li><li>Identifies complex testing scenarios, develops test scripts, and validates testing results. </li><li>Maintains high degree of understanding of departments' business processes. </li><li>Owns specific functionality and processes; responsible for all configuration, testing, and communication regarding this functionality/process. </li><li>Troubleshoots application issues, without assistance, to resolution. </li><li>Troubleshoots system hardware, as needed. </li><li>Partners with end users to understand workflow and business processes. </li><li>Oversees system security for assigned applications. </li><li>Manages Disaster Recovery and Back Up requirements for assigned systems and provides guidance to Applications Analysts in activities. </li><li>Acts as the team project lead in partnership with the Project Management Office on all phases of a project; from scoping and design through implementation and transition to Operations. </li><li>Mentors Application Analysts. </li><li>Produces and maintains custom reports; maintains knowledge and experience with industry standard report writers such as Crystal Reports. </li><li>Reviews and approves end-user training materials and participates in training efforts. </li><li>Guides other team members to ensure high documentation standards. </li><li>Leads escalation of issues with appropriate resources. </li><li>Develops policies and procedures in collaboration with the business unit, other team members, and IT management team. </li><li>Independently manages components of application upgrades, testing, troubleshooting, and support efforts. </li><li>Supports/troubleshoots inbound/outbound interfaces as appropriate. </li><li>Creates reports as needed and works problem tickets. </li><li>Evaluates and maintains appropriate system documentation. </li><li>Collaborates with other application and clinical analysts to ensure system integrations. </li><li>Serves as primary customer contact for on and off hours application support (rotating schedule). </li><li>Participates in change management activities to support successful system deployments and enhancements. </li><li>Utilizes and maintains appropriate change control procedures and standards. </li><li>Creates reports, dashboards, and other analytical tools to support customer base. </li><li>Prepares detailed flowcharts/diagrams to assist with design decisions and problem analysis. </li><li>Leads the design of business workflow in conjunction with the business departments; workflows will focus on improved efficiencies, as well as incorporating quality initiatives. </li><li>Assists with data collection from business subject matter experts, to facilitate design which will represent an improved business workflow. </li></ul>Additional Responsibilities <ul> <li>Performs other duties as assigned. </li><li>Complies with all policies and standards. </li><li>For specific duties and responsibilities, refer to documentation provided by the department during orientation. </li><li>Must abide by all requirements to safely and securely maintain Protected Health Information (PHI) for our patients. Annual training, the UH Code of Conduct and UH policies and procedures are in place to address appropriate use of PHI in the workplace. </li></ul>Qualifications: Education<ul> <li>High School Equivalent / GED (Required) and</li> <li>Bachelor's Degree (Preferred)</li> </ul>Work Experience<ul> <li>3+ years Experience supporting applications (Required) and</li> <li>Experience in a healthcare setting is highly desired (Preferred) and</li> <li>Experience working with business applications such as:Patient Scheduling systemsHospital or Physician Revenue Cycle systemsData WarehousingSQL Server/SSISEnterprise Scanning and workflow management ApplicationsBed Management ApplicationsFinance Applications (Required)</li> <li>Interface build and support, Datahub and/or Boomi experience (Preferred)</li> </ul>Knowledge, Skills, & Abilities<ul> <li>Excellent written and verbal communication skills are. (Required proficiency)</li> <li>Ability to work in a team environment. (Required proficiency)</li> <li>Ability to function independently in a fast-paced environment. (Required proficiency)</li> <li>Ability to work with all levels of the organization. (Required proficiency)</li> <li>Knowledge of MS Office. (Required proficiency)</li> <li>Project management experience/skills. (Preferred proficiency)</li> <li>Business workflow redesign experience. (Preferred proficiency)</li> <li>Knowledge and experience with SQL based applications. (Required proficiency)</li> <li>Knowledge of LAN, DNS, and networking. (Required proficiency)</li> <li>Ability to work with servers and apply software upgrades. (Required proficiency)</li> <li>Knowledge of disaster recovery and backup procedures. (Required proficiency)</li> <li>Knowledge and experience with HL7 Interfaces. (Required proficiency)</li> <li>Knowledge of ITIL standards. (Preferred proficiency)</li> </ul>Physical Demands<ul> <li>Standing Occasionally</li> <li>Walking Occasionally</li> <li>Sitting Constantly</li> <li>Lifting Rarely 20 lbs</li> <li>Carrying Rarely 20 lbs</li> <li>Pushing Rarely 20 lbs</li> <li>Pulling Rarely 20 lbs</li> <li>Climbing Rarely 20 lbs</li> <li>Balancing Rarely</li> <li>Stooping Rarely</li> <li>Kneeling Rarely</li> <li>Crouching Rarely</li> <li>Crawling Rarely</li> <li>Reaching Rarely</li> <li>Handling Occasionally</li> <li>Grasping Occasionally</li> <li>Feeling Rarely</li> <li>Talking Constantly</li> <li>Hearing Constantly</li> <li>Repetitive Motions Frequently</li> <li>Eye/Hand/Foot Coordination Frequently</li> </ul>Travel Requirements<ul> <li>10%</li> </ul> recblid 0rx04lfc3hi1sth4b1f7s34ylkmk6t

Position Summary The position is visible to the hospital's business service lines and serves as a liaison between IT and those groups. This position also functions as a team member responsible for providing application(s) configuration support to enhance department's operational efficiencies/ workflow needs. Duties include: Essential Functions<ul><li>Supports major enterprise applications and others as assigned.</li><li>Leads design of business workflow in conjunction with the business units and provides guidance to Application Analysts in designing improved efficiencies, solving complex workflow issues and incorporating quality initiatives.</li><li>Leads needs assessment, software design, implementation, support, and reporting.</li><li>Leads unit and integrated testing of the software to ensure that the design objectives are met.</li><li>Identifies complex testing scenarios, develops test scripts, and validates testing results.</li><li>Maintains high degree of understanding of departments' business processes.</li><li>Owns specific functionality and processes; responsible for all configuration, testing, and communication regarding this functionality/process.</li><li>Troubleshoots application issues, without assistance, to resolution.</li><li>Troubleshoots system hardware, as needed.</li><li>Partners with end users to understand workflow and business processes.</li><li>Oversees system security for assigned applications.</li><li>Manages Disaster Recovery and Back Up requirements for assigned systems and provides guidance to Applications Analysts in activities.</li><li>Acts as the team project lead in partnership with the Project Management Office on all phases of a project; from scoping and design through implementation and transition to Operations.</li><li>Mentors Application Analysts.</li><li>Produces and maintains custom reports; maintains knowledge and experience with industry standard report writers such as Crystal Reports.</li><li>Reviews and approves end-user training materials and participates in training efforts.</li><li>Guides other team members to ensure high documentation standards.</li><li>Leads escalation of issues with appropriate resources.</li><li>Develops policies and procedures in collaboration with the business unit, other team members, and IT management team.</li><li>Independently manages components of application upgrades, testing, troubleshooting, and support efforts.</li><li>Supports/troubleshoots inbound/outbound interfaces as appropriate.</li><li>Creates reports as needed and works problem tickets.</li><li>Evaluates and maintains appropriate system documentation.</li><li>Collaborates with other application and clinical analysts to ensure system integrations.</li><li>Serves as primary customer contact for on and off hours application support (rotating schedule).</li><li>Participates in change management activities to support successful system deployments and enhancements.</li><li>Utilizes and maintains appropriate change control procedures and standards.</li><li>Creates reports, dashboards, and other analytical tools to support customer base.</li><li>Prepares detailed flowcharts/diagrams to assist with design decisions and problem analysis.</li><li>Leads the design of business workflow in conjunction with the business departments; workflows will focus on improved efficiencies, as well as incorporating quality initiatives.</li><li>Assists with data collection from business subject matter experts, to facilitate design which will represent an improved business workflow.</li><li>Performs other duties as assigned.</li></ul>Required For All Jobs<ul><li>Performs other duties as assigned.</li><li>Complies with all policies and standards.</li><li>For specific duties and responsibilities, refer to documentation provided by the department during orientation.</li><li>Must abide by all requirements to safely and securely maintain Protected Health Information (PHI) for our patients. Annual training, the UH Code of Conduct and UH policies and procedures are in place to address appropriate use of PHI in the workplace.</li></ul> Qualifications: Qualifications Education <ul> <li>High School Equivalent / GED Required and</li> <li>Bachelor's Degree Preferred</li> </ul> Work Experience <ul> <li>3+ years Experience supporting applications Required and</li> <li>Experience in a healthcare setting is highly desired Preferred and</li> <li>Epic Professional Billing certification strongly preferred </li> </ul> Knowledge, Skills, & Abilities <ul> <li>Excellent written and verbal communication skills are. Required</li> <li>Ability to work in a team environment. Required</li> <li>Ability to function independently in a fast-paced environment. Required</li> <li>Ability to work with all levels of the organization. Required</li> <li>Knowledge of MS Office. Required</li> <li>Project management experience/skills. Preferred</li> <li>Business workflow redesign experience a desired. Preferred</li> <li>Knowledge and experience with SQL based applications. Required</li> <li>Knowledge of LAN, DNS, and networking. Required</li> <li>Ability to work with servers and apply software upgrades. Required</li> <li>Knowledge of disaster recovery and backup procedures. Required</li> <li>Knowledge and experience with HL7 Interfaces. Required</li> <li>Knowledge of ITIL standards desired. Preferred</li> </ul> Physical Demands <ul> <li>Standing Occasionally</li> <li>Walking Occasionally</li> <li>Sitting Constantly</li> <li>Lifting Rarely 20 lbs</li> <li>Carrying Rarely 20 lbs</li> <li>Pushing Rarely 20 lbs</li> <li>Pulling Rarely 20 lbs</li> <li>Climbing Rarely 20 lbs</li> <li>Balancing Rarely</li> <li>Stooping Rarely</li> <li>Kneeling Rarely</li> <li>Crouching Rarely</li> <li>Crawling Rarely</li> <li>Reaching Rarely</li> <li>Handling Occasionally</li> <li>Grasping Occasionally</li> <li>Feeling Rarely</li> <li>Talking Constantly</li> <li>Hearing Constantly</li> <li>Repetitive Motions Frequently</li> <li>Eye/Hand/Foot Coordination Frequently</li> </ul> recblid ksztqucm09cvtjd3hn6cwxgp8gg63g <img src='https://b.recruitology.com/beacon/view/ksztqucm09cvtjd3hn6cwxgp8gg63g/'/>

The Oracle Business Analyst II is responsible for the maintenance and support of the Oracle eBusiness Suite and ancillary applications while working directly with peers, application developers, database administrators, and business stakeholders to meet the operational needs of the organization. In addition, this role acts as a liaison between the organization, application vendors, and their technology staff to ensure the environment meets application, organization, and regulatory requirements. Business areas may include F inance, Payroll, Human Resources, and Supply Chain. Essential Duties : • Assist application users and resolve support requests within established service levels, leveraging vendor support tools and portals as appropriate. • Troubleshoot application issues, with minimal assistance, to resolution including root cause analysis and recommendations for permanent resolution. • Lead all phases of low to medium complexity initiatives. • Participate in high complexity initiatives as assigned. • Partner with IT leaders, business stakeholders, and vendors to implement solutions that meet organization, application, and regulatory requirements. • Perform needs assessment, software design, implementation, support, and reporting duties. • Lead design of business processes and IT solutions in collaboration with business partners with a focus on improving efficiencies, solving complex workflow issues and incorporating quality initiatives when appropriate. • Perform thorough testing of solutions to ensure design objectives are met. • Lead components of development of end-user training materials and participate in training efforts. • Create and maintain appropriate system documentation including functional specifications, test scripts, and process documents. • Assist other team members in upholding documentation standards. • Own specific functionality and processes, responsible for configuration, testing, and communication regarding this functionality/process. • Independently manage components of application patching and upgrades, testing, troubleshooting, and support efforts. • Escalate issues as appropriate to internal resources. • Provide input to policies and procedures in collaboration with business units, other analyst team members, and IT Applications Manager. • Collaborate with other application analysts and other IT teams to ensure system integration integrity. • Conduct effective meetings and appropriately communicate with business partners, peers, and IT leadership. • Participate in change management activities to support successful system deployments and enhancements. • Utilize appropriate change control procedures and standards. • Perform on-call rotation duties in a 24x7 environment and other duties as required. Qualifications: Experience & Knowledge: <ul> <li>High School diploma or GED required. </li> <li>Bachelor's degree in IT, Business or related field, or equivalent experience required.</li> <li>Minimum 3 years of experience as an application analyst required. </li> </ul> Special Skills & Equipment Knowledge: • Functional experience supporting Oracle eBusiness Suite R12 application in an enterprise environment required. Modules include but not limited to: Payables, Receivables, General Ledger, Fixed Assets, Internet Expenses, Grants, Purchasing, Order Management, Inventory, iProcurement, Sourcing, Procurement Contracts, Human Resources, Payroll, Compensation Workbench, Manager Self Service, and Employee Self Service • Experience supporting Kofax for Accounts Payable, Stratajazz, Cornerstone, Taleo preferred. • Experience supporting the following technologies preferred: SplashBI, Web ADI, Workflow, AME. • Experience with Oracle utilities and development tools preferred: Oracle TOAD, SQL/PL-SQL. • Technical understanding of Oracle eBusiness Suite preferred. • Experience performing controlled code migrations through development environments to production environments required. • Experience working with Oracle Support to analyze and resolve technical issues required. • Practical application of project management methodology required. • Strong problem solving skills with ability to research and analyze information required. • Knowledge of MS Office required. • Ability to function independently and as a team player in a fast-paced environment required. Strong written and verbal communication skills with ability to organize and communicate thoughts in a user-friendly manner required. Physical Demands <ul> <li>Standing Occasionally</li> <li>Walking Occasionally</li> <li>Sitting Constantly</li> <li>Lifting Rarely 20 lbs</li> <li>Carrying Rarely 20 lbs</li> <li>Pushing Rarely 20 lbs</li> <li>Pulling Rarely 20 lbs</li> <li>Climbing Rarely 20 lbs</li> <li>Balancing Rarely</li> <li>Stooping Rarely</li> <li>Kneeling Rarely</li> <li>Crouching Rarely</li> <li>Crawling Rarely</li> <li>Reaching Rarely</li> <li>Handling Occasionally</li> <li>Grasping Occasionally</li> <li>Feeling Rarely</li> <li>Talking Constantly</li> <li>Hearing Constantly</li> <li>Repetitive Motions Frequently</li> <li>Eye/Hand/Foot Coordination Frequently</li> </ul> Travel Requirements <ul> <li>10%</li> </ul> recblid y2occrf7iouh6n1r6e6wpiaprt509g <img src='https://b.recruitology.com/beacon/view/y2occrf7iouh6n1r6e6wpiaprt509g/'/>

University Hospitals Interview Questions

University Hospitals Interview Guides

University Hospitals Interview Questions

University Hospitals Salaries by Position

University Hospitals Opening Jobs