The Unc Health Care Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Unc Health Care Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Unc Health Care? The Unc Health Care Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Unc Health Care Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Unc Health Care.</li>
<li>Practice real Unc Health Care Business Intelligence interview questions.</li>
</ul>
Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Unc Health Care Business Intelligence interview.


Getting ready for an Business Intelligence interview at Unc Health Care? The Unc Health Care Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Unc Health Care Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Unc Health Care.
- Practice real Unc Health Care Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Unc Health Care Business Intelligence interview.
        

Overview

Unc Health Care Business Intelligence Salary

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Unc Health Care Business Intelligence Interview Process

We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout

Example:

Input:

<code>bank_transactions</code> table

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

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

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Rolling Bank Transactions

Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.

Example:

Input:

<code>transactions</code> table

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

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

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>users</code> table

<table>
<thead>
<tr>
<th>Column</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>
 
Output:

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

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

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

Write a query to identify the manager with the biggest team size.

You may assume there is only one manager with the largest team size.

Example:

Input:

<code>employees</code> table

<table>
<thead>
<tr>
<th>Column</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>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>managers</code> table

<table>
<thead>
<tr>
<th>Column</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>

<tr>
<td><code>team</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td><code>manager</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team_size</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Manager Team Sizes

Unc Health Care Business Intelligence Interview Questions

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: Our Infection Prevention team's mission is to promote a safe and healthy environment through the prevention of healthcare-associated infections in patients and the transmission of infectious diseases among patients, staff, and visitors, and to contribute to infection prevention research to guide evidence-based practices. We approach all infection prevention activities using a multidisciplinary approach through our integrated team that has expertise in hospital epidemiology, infection prevention, quality improvement, informatics, advanced epidemiologic and statistical methods, advanced microbiologic methods, and compliance monitoring and coaching. We believe success in our mission starts with an amazing team. Infection prevention teammates demonstrate our values every day. We learn a lot from our healthcare personnel, patients and each other and are committed to treating everyone with dignity and respect. Why work at UNCMC Infection Prevention? We impact people and care about people everyday We are committed to an equitable and inclusive workplace We are a community that builds camaraderie across the departments we support Teammate feedback has led to improved workflows and an inclusive workplace environment We have FUN - including during and after work-sponsored social events Job Summary: The Data Analyst II (DAII) is an experienced professional who will be responsible for conducting community surveillance and participating in communicable disease and outbreak reporting and investigation. This position will help support and expand upon existing data analysis and quality improvement work within the Infection Prevention Department. The DAII should have a working knowledge of relational databases and some proficiency with SQL and data analysis programs (e.g. SAS, Access, STATA, etc.) Description of Job Responsibilities: •Performs community surveillance activities. Reviews medical records to determine community infections that meet case definitions. Forwards required reports to State Health Department. Coordinates submission of lab isolates/samples from hospital to the State Laboratory of Public Health. •Conducts active surveillance of defined diseases and conditions by NC State Health Department. Routinely submits information and case counts through the NC State syndromic surveillance (NCDETECT) system. •Participates in public health investigations among hospitalized populations. Serves as liaison between Hospitals and public health agencies for bioterrorism and new and emerging diseases. Assists with health care-associated infection outbreaks and investigations. •Works as liaison with public health departments to ensure implementation of appropriate control measures of diseases of public health concern. •Participates and initiates projects related to prevention of infections in hospital and community settings. Maintains current knowledge of trends and issues with outcomes measurement/management, healthcare informatic systems, infection control practice and theory. •Prepares statistical analysis and presentations regarding surveillance efforts. •Provide innovative analytical insights with large data sets. •Conduct detailed data analysis on surveillance data used across the hospital to evaluate and improve processes. •Respond to data and product related inquiries in real-time to support stakeholders. •Perform various data analytics in SQL, MS Excel, and other data tools, using statistical models or industry accepted tools. •Provide relational database expertise to construct and execute SQL queries to be used in data analysis activities. •Provide expertise and translate the business needs to design; and develop tools, techniques, and metrics, and dashboards for insights and data visualization. Other Information Other information: Education Requirements: •Requires Bachelors degree or equivalent combination of education and experience Licensure/Certification Requirements: •None required Professional Experience Requirements: •If Bachelors degree in general field, requires two (2) years of experience. •If Bachelor's Degree in a STEM field (i.e. Engineering, Math, Computer Science, Analytics, etc.), then no years of experience is required. •If Master's degree, requires no years of experience. •If Associate's degree, requires eight (8) years of experience •If High School degree, requires ten (10) years of experience Knowledge/Skills/and Abilities Requirements: •NOVICE- Limited Proficiency: You have the level of experience gained in a classroom and/or experimental scenarios or as a trainee on-the-job. You are expected to need help when performing this skill. - SQL limited proficiency - Working knowledge (limited proficiency) of relational databases - Understands the importance and has limited proficiencey with leveraging existing reusable data sources for visualizations and analytics before creating their own. When creating new assets they have the ability to make it reusable, with help. Job Details Legal Employer: STATE Entity: UNC Medical Center Organization Unit: OQE - Infection Prevention Work Type: Full Time Standard Hours Per Week: 40.00 Salary Range: $32.23 - $46.33 per hour (Hiring Range) Pay offers are determined by experience and internal equity Work Assignment Type: Onsite Work Schedule: Day Job Location of Job: US:NC:Chapel Hill Exempt From Overtime: Exempt: Yes This 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: 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 Other information: Education Requirements: •Requires Bachelor's degree or equivalent combination of education and experience Licensure/Certification Requirements: Professional Experience Requirements: •If Bachelor's degree in general degree, six (6) years of experience If a Bachelor's Degree in a STEM field (i.e. Engineering, Math, Computer Science, Analytics, etc.), then requires four (4) years of experience If Master's degree, requires four (4) years of experience If PhD, requires two (2) years of experience If Associates, requires twelve (12) years of experience If High School degree, requires fourteen (14) years of experience Knowledge/Skills/and Abilities Requirements: •SQL expertise Data visualization software and UI design expert proficiency 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 analyticsAdvanced proficiency of optimizing reusable data sources for visualization and analytics Intermediate proficiency in data architecture R/Python (other stat software) intermediate proficiency is preferred Stakeholder requirements gathering and presentation skills required Analytics or multidisciplinary team facilitation or project management at an advanced proficiency level is preferred Exemplifies UNC Health System Values Job Details Legal Employer: NCHEALTH Entity: Shared Services Organization Unit: Care Access - Sustainment 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: Remote 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.

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.

Unc Health Care Business Intelligence Interview Guide

Overview

Unc Health Care Business Intelligence Salary

Unc Health Care Business Intelligence Interview Process

Unc Health Care Business Intelligence Interview Questions

Unc Health Care Business Intelligence Jobs