Prepare for and practice interview questions from Unc Health Care.

Unc Health Care Interview Questions

unc health care is an award-winning, not-for-profit integrated health care system that is committed to delivering state-of-the-art health care and outstanding service to patients. from the mountains to the coast, unc health care is there, providing care to north carolinians from all 100 counties and from across the country. at unc health care, we are looking for talented, passionate medical professionals to join our growing community and provide the highest quality care to our patients across north carolina. unc health care provides a variety of career opportunities for professional development and growth for our employees.

unc health care is an award-winning, not-for-profit integrated health care system that is committed to delivering state-of-the-art health care and outstanding service to patients. from the mountains to the coast, unc health care is there, providing care to north carolinians from all 100 counties and from across the country. at unc health care, we are looking for talented, passionate medical professionals to join our growing community and provide the highest quality care to our patients across north carolina. unc health care provides a variety of career opportunities for professional development and growth for our employees.

Overview

Unc Health Care 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

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Unc Health Care Salaries by Position

Become part of an inclusive organization with over 40,000 diverse employees, whose mission is to improve the health and well-being of the unique communities we serve.Summary:Participates in the planning and establishment of budgets and goals and objectives. Develops and implements fiscal strategies to achieve goals and objectives.Healthcare or University campus side experience preferred. Responsibilities:1. Designs, develops or modifies and implements accounting/business systems. Performs unit, systems, and parallel tests of new or redesigned systems and processes.2. May supervise a group of subordinate employees to include selection, training, appraisal, coaching and disciplining in accordance with UNCHCS policies and procedures.3. Monitors and analyzes revenues and actual expenditures in relation to budget and makes changes to plans as appropriate.4. Monitors compliance with policies and procedures and makes recommendations for changes as appropriate. Develops and documents procedures.5. Participates in System-wide initiatives to improve operational efficiencies. May lead Continuous Quality Improvement teams.6. Prepares and maintains accurate accounting records to ensure compliance with state and federal regulatory agencies as well as GAAP, GASB and FASB.7. Prepares financial analyses for departmental and institutional planning.Other InformationEducation Requirements:•Bachelor's degree in Business Administration, Economics, Finance, Public Administration or related field (or equivalent combination of education, training and experience).Licensure/Certification Requirements:•No licensure or certification required.Professional Experience Requirements:•If a Bachelor's degree: Two (2) years of experience in professional accounting, management of an operational unit, business analysis or financial analysis.•If an Associate's degree: Six (6) years of experience in professional accounting, management of an operational unit, business analysis or financial analysis.•If a High School diploma or GED: Ten (10) years of experience in professional accounting, management of an operational unit, business analysis or financial analysis.Knowledge/Skills/and Abilities Requirements:Job DetailsLegal Employer: STATEEntity: UNC Faculty PhysiciansOrganization Unit: SOM Med Admin Work Type: Full TimeStandard Hours Per Week: 40.00Salary Range: $25.94 - $37.29 per hour (Hiring Range)Pay offers are determined by experience and internal equityWork Assignment Type: HybridWork Schedule: Day JobLocation of Job: US:NC:Chapel HillExempt From Overtime: Exempt: YesThis is a State position employed by UNC Health Care System with UNC Health benefits. If, however, you are presently an employee of another North Carolina agency and currently participate in TSERS or the ORP, you will be eligible to continue participating in those plans at UNC Health.Qualified applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.UNC Health makes reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as applicants and employees with disabilities. All interested applicants are invited to apply for career opportunities. Please email applicant.accommodations@unchealth.unc.edu if you need a reasonable accommodation to search and/or to apply for a career opportunity.

Become part of an inclusive organization with over 40,000 diverse employees, whose mission is to improve the health and well-being of the unique communities we serve. Summary: Serves as a liaison between the business community and the IT organization in order to provide technical solutions to meet user needs. Analyzes business unit(s) operations to understand their strengths and weaknesses to determine opportunities to automate processes and functions. Possesses expertise in the business unit(s) they support, as well as, an understanding of the IT organization's systems and capabilities. Enhances the organization by driving the evolution of customer-oriented, cost effective, and integrated business solutions. This position works on site in Lumberton, North Carolina. Responsibilities: 1. Actively participates in the evaluation of systems to ensure standardization across the health system based on best practices and regulatory compliance. Participates in designated committees to develop an understanding of and facilitate business and clinical needs for technology. Collaborates with organizational project teams to ensure system development and implementation supports best department practices and workflow efficiency. 2. Analyzes user requirements, procedures, system capabilities and issues to automate processing or to improve existing system flow by working directly with departments within the organization to understand business processes, analyze current operational procedures, identify and resolve issues, and learn specific system requirements and specifications. 3. Collaborates with IT support to provide exemplary customer service to all business units. 4. Ensures that new/revised software produces desired results by testing its functionality, directing end-user involvement in testing and piloting with end-users to include the creation/revision of test scripts. 5. Interfaces with external vendors to support the implementation and development and delivery process. 6. Maintains solid technical competence of assigned customer systems while understanding the integration and interaction of all supported systems. Improves work processes by applying standard methodologies for business and clinical. Possesses an understanding of technological trends and uses this knowledge to bring solutions to business unit(s) supported to enhance the enterprise's competitive edge. 7. Participates in implementation of new and updated technology projects throughout the organization. 8. Participates in the problem management process to include reporting defects/problems, performing simple diagnostics to either resolve issues or obtain diagnostics to assist in investigating and resolving problems. 9. Reviews computer system capabilities and workflow to determine if requested application or modification is possible within existing systems. 10. Translates high level business requirements into functional specifications and educates the IT organization on the direction of the business. Assists in the business process redesign and documentation as needed for new technology. Prepares educational/ instructional materials (system documentation, workflow/ program flowcharts) to document business processes and system information. Other Information Other information: Education Requirements: •Bachelor's degree in Computer Science, Information Systems Management or related field (or equivalent combination of education, training and experience). Licensure/Certification Requirements: •No licensure or certification required. Professional Experience Requirements: •If a Bachelor's degree: Two (2) years of experience as a business analyst or project manager. •If an Associate's degree: Four (4) years of experience as a business analyst or project manager. •If a High School diploma or GED: Six (6) years of experience as a business analyst or project manager. Knowledge/Skills/and Abilities Requirements: •Excellent analytical and communication skills. Ability to work well in a team environment. Demonstrated ability to successfully manage multiple tasks simultaneously. Highly responsive to internal customers. Job Details Legal Employer: NCHEALTH Entity: Shared Services Organization Unit: ISD Affiliate Support Work Type: Full Time Standard Hours Per Week: 40.00 Salary Range: $27.89 - $40.09 per hour (Hiring Range) Pay offers are determined by experience and internal equity Work Assignment Type: Hybrid Work Schedule: Day Job Location of Job: US:NC:Lumberton Exempt From Overtime: Exempt: Yes This position is employed by NC Health (Rex Healthcare, Inc., d/b/a NC Health), a private, fully-owned subsidiary of UNC Health Care System, in a department that provides shared services to operations across UNC Health Care; except that, if you are currently a UNCHCS State employee already working in a designated shared services department, you may remain a UNCHCS State employee if selected for this job. Qualified applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. UNC Health makes reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as applicants and employees with disabilities. All interested applicants are invited to apply for career opportunities. Please email applicant.accommodations@unchealth.unc.edu if you need a reasonable accommodation to search and/or to apply for a career opportunity.

Become part of an inclusive organization with over 40,000 diverse employees, whose mission is to improve the health and well-being of the unique communities we serve. Summary: The Senior Business Intelligence Analyst (BIA, Sr.) delivers expert-level analyses and insights that enhance organizational decision-making with a high degree of impact. The Senior Business Intelligence Analyst leads innovative reporting and data visualization development in partnership with stakeholders and analytics teams. The Senior Business Intelligence Analyst serves as a liaison between clinical / business units and central analytics. Data Governance Stewardship role commitments are expected. The Senior Business Intelligence Analyst has expert proficiency in SQL, data visualization software, and UI design. Primary responsibilities for the role include leading stakeholder groups and analytics teams, healthcare analytics, scorecard & dashboard development, data development, project management for key initiatives, stakeholder requirements gathering, communications and presentations, mentorship, and training. Responsibilities: Communication, presentations, requirements gathering, and relationships - The BIA, Sr. acts as a key Business Intelligence & Analytics leader and liaison between hospital leadership, physician leadership, other clinical leaders, ISD, and other stakeholders. They ensure a tight linkage between the department's efforts and the organizational goals. The BIA, Sr. serves as a guide of the organization's business intelligence and data development priorities to internal constituents through formal and informal communications. The BIA, Sr. develops concise, insightful, and politically savvy communications. These are often in PowerPoint, but also in email and verbally via committee meetings, staff meetings, and working sessions. The BIA, Sr. also gathers, synthesizes, and conveys details of stakeholder requirements into a well-thought-out and effective end product which meets the end users' need. Dashboard, data, and scorecard development - The BIA, Sr. leads the development of effective key performance indicators, management dashboards, and balanced scorecards that provide enhanced insight and improve organizational decision-making. The BIA, Sr. also ensures that proper data development principles and practices are followed in compliance with the HCS standards. Data security, availability, and reusability should be the top focuses for this position. Healthcare analytics - The BIA, Sr. provides expertise in healthcare analytics support (financial, clinical & operational analytics) to generate insights that can be transformed into action and include a broad set of tools, processes, technologies, and stakeholders for collecting, integrating, accessing, and analyzing information. There may be fulfillment expectations of reporting and analytics requests. Mentorship, training, and liaison to Central Analytics - The BIA, Sr. provides mentorship and training in both the analytical technique and quality of work by junior analysts. They will also be a trusted business intelligence advisor and support ad hoc training for other analysts throughout the organization. The BIA, Sr. may have direct reports and perform necessary HR functions associated with managing staff such as time and attendance, corrective action, and performance reviews. Additionally, the BIA, Sr. is a liaison to central analytics, ensuring that he or she follows necessary protocols, contributes feedback to enhancements, and engages consistently to ensure minimal duplication of effort. Project management - The BIA, Sr. demonstrates efficient project management to clearly define projects, develop project plans, and set priorities for working teams. Other Information Education Requirements: <ul><li>Requires Bachelor's degree or equivalent combination of education and experience</li></ul> Professional Experience Requirements: <ul><li>If Bachelor's degree in general degree, six (6) years of experience</li><li>If a Bachelor's Degree in a STEM field (i.e. Engineering, Math, Computer Science, Analytics, etc.), then requires four (4) years of experience</li><li>If Master's degree, requires four (4) years of experience</li><li>If PhD, requires two (2) years of experience</li><li>If Associates, requires twelve (12) years of experience</li><li>If High School degree, requires fourteen (14) years of experience</li></ul> Knowledge/Skills/and Abilities Requirements: <ul><li>SQL expertise</li><li>Data visualization software and UI design expert proficiency</li><li>Understands the importance and is capable of leveraging existing reusable data sources for visualizations and analytics before creating their own. When creating new assets they are expected to make them reusable. Advanced proficiency in optimizing reusable data sources for visualization and analytics</li><li>Advanced proficiency of optimizing reusable data sources for visualization and analytics</li><li>Intermediate proficiency in data architecture</li><li>R/Python (other stat software) intermediate proficiency is preferred</li><li>Stakeholder requirements gathering and presentation skills required</li><li>Analytics or multidisciplinary team facilitation or project management at an advanced proficiency level is preferred</li><li>Exemplifies UNC Health System Values</li></ul>Job Details Legal Employer: NCHEALTH Entity: Health Alliance Organization Unit: Analytics and Collaboratives Work Type: Full Time Standard Hours Per Week: 40.00 Salary Range: $43.04 - $61.87 per hour (Hiring Range) Pay offers are determined by experience and internal equity Work Assignment Type: Hybrid Work Schedule: Day Job Location of Job: US:NC:Morrisville Exempt From Overtime: Exempt: Yes This position is employed by NC Health (Rex Healthcare, Inc., d/b/a NC Health), a private, fully-owned subsidiary of UNC Health Care System, in a department that provides shared services to operations across UNC Health Care; except that, if you are currently a UNCHCS State employee already working in a designated shared services department, you may remain a UNCHCS State employee if selected for this job. Qualified applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. UNC Health makes reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as applicants and employees with disabilities. All interested applicants are invited to apply for career opportunities. Please email applicant.accommodations@unchealth.unc.edu if you need a reasonable accommodation to search and/or to apply for a career opportunity.

<h5>Job Description</h5>
 Description Become part of an inclusive organization with over 40,000 diverse employees, whose mission is to improve the health and well-being of the unique communities we serve. Summary: Serves as a liaison between the business community and the IT organization in order to provide technical solutions to meet user needs. Analyzes business unit(s) operations to understand their strengths and weaknesses to determine opportunities to automate processes and functions. Possesses expertise in the business unit(s) they support, as well as, an understanding of the IT organization's systems and capabilities. Enhances the organization by driving the evolution of customer-oriented, cost effective, and integrated business solutions. This position works on site in Lumberton, North Carolina. Responsibilities: 1. Actively participates in the evaluation of systems to ensure standardization across the health system based on best practices and regulatory compliance. Participates in designated committees to develop an understanding of and facilitate business and clinical needs for technology. Collaborates with organizational project teams to ensure system development and implementation supports best department practices and workflow efficiency. 2. Analyzes user requirements, procedures, system capabilities and issues to automate processing or to improve existing system flow by working directly with departments within the organization to understand business processes, analyze current operational procedures, identify and resolve issues, and learn specific system requirements and specifications. 3. Collaborates with IT support to provide exemplary customer service to all business units. 4. Ensures that new/revised software produces desired results by testing its functionality, directing end-user involvement in testing and piloting with end-users to include the creation/revision of test scripts. 5. Interfaces with external vendors to support the implementation and development and delivery process. 6. Maintains solid technical competence of assigned customer systems while understanding the integration and interaction of all supported systems. Improves work processes by applying standard methodologies for business and clinical. Possesses an understanding of technological trends and uses this knowledge to bring solutions to business unit(s) supported to enhance the enterprise's competitive edge. 7. Participates in implementation of new and updated technology projects throughout the organization. 8. Participates in the problem management process to include reporting defects/problems, performing simple diagnostics to either resolve issues or obtain diagnostics to assist in investigating and resolving problems. 9. Reviews computer system capabilities and workflow to determine if requested application or modification is possible within existing systems. 10. Translates high level business requirements into functional specifications and educates the IT organization on the direction of the business. Assists in the business process redesign and documentation as needed for new technology. Prepares educational/ instructional materials (system documentation, workflow/ program flowcharts) to document business processes and system information. <h5>Other Information </h5>Other information: Education Requirements: * Bachelor's degree in Computer Science, Information Systems Management or related field (or equivalent combination of education, training and experience). Licensure/Certification Requirements: * No licensure or certification required. Professional Experience Requirements: * If a Bachelor's degree: Two (2) years of experience as a business analyst or project manager. * If an Associate's degree: Four (4) years of experience as a business analyst or project manager. * If a High School diploma or GED: Six (6) years of experience as a business analyst or project manager. Knowledge/Skills/and Abilities Requirements: * Excellent analytical and communication skills. Ability to work well in a team environment. Demonstrated ability to successfully manage multiple tasks simultaneously. Highly responsive to internal customers. <h5>Job Details </h5>Legal Employer: NCHEALTH Entity: Shared Services Organization Unit: ISD Affiliate Support Work Type: Full Time Standard Hours Per Week: 40.00 Salary Range: $27.89 - $40.09 per hour (Hiring Range) Pay offers are determined by experience and internal equity Work Assignment Type: Hybrid Work Schedule: Day Job Location of Job: US:NC:Lumberton Exempt From Overtime: Exempt: Yes This position is employed by NC Health (Rex Healthcare, Inc., d/b/a NC Health), a private, fully-owned subsidiary of UNC Health Care System, in a department that provides shared services to operations across UNC Health Care; except that, if you are currently a UNCHCS State employee already working in a designated shared services department, you may remain a UNCHCS State employee if selected for this job. Qualified applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. UNC Health makes reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as applicants and employees with disabilities. All interested applicants are invited to apply for career opportunities. Please email applicant.accommodations@unchealth.unc.edu if you need a reasonable accommodation to search and/or to apply for a career opportunity.

Unc Health Care Interview Questions

Overview

Unc Health Care Interview Guides

Unc Health Care Interview Questions

Unc Health Care Salaries by Position

Unc Health Care Opening Jobs