The Ochin Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Ochin Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Ochin? The Ochin Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Ochin Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Ochin.</li>
<li>Practice real Ochin 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 Ochin Business Intelligence interview.


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

- Know what skills are necessary for Ochin Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Ochin.
- Practice real Ochin 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 Ochin Business Intelligence interview.
        

Overview

Ochin 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.

Ochin 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

Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.

You wish to begin with the age group that is currently generating the most connections (fastest growing).

Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.

Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.

We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.

The result should be rounded to two decimal places.

<h3>Example:</h3>

Input:

<code>friend_requests</code>

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

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<code>requests_accepted</code>

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

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<code>age_groups</code>

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

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

<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

Ochin Business Intelligence Interview Questions

Job Type
Full-time

Description
MAKE A DIFFERENCE AT OCHIN
OCHIN is a rapidly growing national nonprofit health IT organization with over two decades of experience transforming health care delivery to drive health equity. We are hiring for a number of positions to meet increasing demand. When you choose to join OCHIN, you have the opportunity to continuously grow your skills and do meaningful work to help fulfill our mission.
OCHIN provides leading-edge technology, data analytics, research, and support services to nearly 1,000 community health care sites, reaching nearly 6 million patients nationally. We believe that every individual, no matter their race, ethnicity, background, or zip code, should have fair opportunity to achieve their full health potential. Our work addresses differences in health that are systemic, avoidable, and unjust. We partner, learn, innovate, and advocate, in order to close the gap in health for individuals and communities negatively impacted by racism or other structural inequities.
At OCHIN, we value the unique perspectives and experiences of every individual and work hard to maintain a culture of belonging.
Founded in Oregon in 2000, OCHIN employs a growing virtual workforce of more than 1,200 diverse professionals, working remotely across 50 states. We offer a generous compensation package and are committed to supporting our employees' entire well-being by fostering a healthy work-life balance and equitable opportunity for professional advancement. We are curious, collaborative learners who strive to live our values everyday: Learning, Heart, Belonging, and Impact. OCHIN is excited to support our continued national expansion and the increasing demand for our innovative tools and services by welcoming new talent to our growing team.
Position Overview -   Epic Ambulatory Certification is REQUIRED.   Epic Healthy Planet Certification is preferred
The Business Intelligence Analyst supports the mission of OCHIN by designing, developing, testing, documenting, maintaining, and troubleshooting reports across a broad platform of business intelligence tools. As a member of OCHIN's Population Health/Reporting Analytics department, the BIA role supports the full lifecycle of projects particularly the requirements definitions, quality assurance testing and user acceptance testing phases of projects. This role requires an above-average ability and desire to communicate in email, via JIRA tickets, and over the phone, as well as to effectively balance multiple competing priorities.
This position has strong people connection to our Clinic Membership, to our coworkers at OCHIN and other business partners. It demands an above average ability and desire to communicate in email, via JIRA ticketing response or over the phone.
Essential Duties
Participate in requirement gathering, defining scope and objectives of business requirements, including documentation of requirements (i.e. use cases) and relevant translation into system requirement specifications.
Serve as a subject matter expert in assigned reporting system, internally and with members or external customers.
Responsible for the execution of full reporting lifecycle from design, development, testing, documentation, maintenance, and troubleshooting.
Develop and update technical documentation for reporting systems
Perform other duties as assigned

Requirements
****EPIC AMBULATORY CERTIFICATION IS REQUIRED! EPIC HEALTHY PLANET CERTIFICATION IS PREFERRED****
Bachelors degree or 4 years of equivalent work experience preferred
Epic Ambulatory Certification is REQUIRED.
Epic Healthy Planet Certification is highly preferred
A minimum of 2 years of certified Epic Ambulatory and Healthy Planet experience is required
Experience with Compass Rose highly desired
Experience with enhanced care management programs e.g. PACE preferred but not required
Display knowledge of the underlying language of the assigned data system and business intelligence toolset (SQL, Epic Cogito, Business Objects, Crystal Reports, Tableau).
Experience in working with others to identify, define and analyze end user requirements and timelines designed to meet business needs
up to 10% travel
COVID-19 Vaccination Requirement
To keep our colleagues, members, and communities safe, OCHIN requires all employees-including remote employees, contractors, interns, and new hires-to be vaccinated with a COVID-19 vaccine, as supported by state and federal public health officials, as a condition of employment. All new hires are required to provide proof of full vaccination or receive approval for a medical or religious exemption before their hire date.
Work Location and Travel Requirements
OCHIN is a 100% remote organization with no physical corporate office location. Employees work remotely from home and many of our positions also support our member organizations on-site for new software installations. Nationwide travel is determined based on OCHIN business needs. Please inquire during the interview process about travel requirements for this position.
Work from home requirements are:
Ability to work independently and efficiently from a home office environment
High Speed Internet Service
It is a requirement that employees work in a distraction free workplace
We offer a comprehensive range of benefits. See our website for details: https://ochin.org/employment-openings
Equal Opportunity Statement
OCHIN is an equal opportunity employer. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills for the benefit of our staff, our mission, and the communities we serve.
As an equal opportunity and affirmative action employer, OCHIN does not discriminate on the basis of race, ethnicity, sex, gender identity or expression, sexual orientation, religion, marital or civil union status, parental status, age, disability status, veteran status, or any other protected characteristics. All aspects of employment are based on merit, performance, and business needs.
Base Pay Overview
The typical offer range for this role is minimum to midpoint (min-$77,235 mid$96,544 ), with the midpoint representing the average pay in a national market scope for this position. Please keep in mind that this range represents the pay range for all positions in the job grade within which this position falls. The actual salary offer will consider a wide range of factors directly relevant to this position, including, but not limited to, skills, knowledge, training, responsibility, and experience, as well as internal equity and alignment with market data.
#LI-Remote
#Epic Ambulatory Certification
#Healthy Planet Certification
#Compass Rose

Salary Description
min-$77,235 mid$96,544 max-$115,852

Job Type Full-time Description MAKE A DIFFERENCE AT OCHIN OCHIN is a rapidly growing national nonprofit health IT organization with over two decades of experience transforming health care delivery to drive health equity. We are hiring for a number of positions to meet increasing demand. When you choose to join OCHIN, you have the opportunity to continuously grow your skills and do meaningful work to help fulfill our mission. OCHIN provides leading-edge technology, data analytics, research, and support services to nearly 1,000 community health care sites, reaching nearly 6 million patients nationally. We believe that every individual, no matter their race, ethnicity, background, or zip code, should have fair opportunity to achieve their full health potential. Our work addresses differences in health that are systemic, avoidable, and unjust. We partner, learn, innovate, and advocate, in order to close the gap in health for individuals and communities negatively impacted by racism or other structural inequities. At OCHIN, we value the unique perspectives and experiences of every individual and work hard to maintain a culture of belonging. Founded in Oregon in 2000, OCHIN employs a growing virtual workforce of more than 1,200 diverse professionals, working remotely across 50 states. We offer a generous compensation package and are committed to supporting our employees' entire well-being by fostering a healthy work-life balance and equitable opportunity for professional advancement. We are curious, collaborative learners who strive to live our values everyday: Learning, Heart, Belonging, and Impact. OCHIN is excited to support our continued national expansion and the increasing demand for our innovative tools and services by welcoming new talent to our growing team. Position Overview - Epic Ambulatory Certification is REQUIRED. Epic Healthy Planet Certification is preferred The Business Intelligence Analyst supports the mission of OCHIN by designing, developing, testing, documenting, maintaining, and troubleshooting reports across a broad platform of business intelligence tools. As a member of OCHIN's Population Health/Reporting Analytics department, the BIA role supports the full lifecycle of projects particularly the requirements definitions, quality assurance testing and user acceptance testing phases of projects. This role requires an above-average ability and desire to communicate in email, via JIRA tickets, and over the phone, as well as to effectively balance multiple competing priorities. This position has strong people connection to our Clinic Membership, to our coworkers at OCHIN and other business partners. It demands an above average ability and desire to communicate in email, via JIRA ticketing response or over the phone. Essential Duties Participate in requirement gathering, defining scope and objectives of business requirements, including documentation of requirements (i.e. use cases) and relevant translation into system requirement specifications. <ul> <li>Serve as a subject matter expert in assigned reporting system, internally and with members or external customers. </li><li>Responsible for the execution of full reporting lifecycle from design, development, testing, documentation, maintenance, and troubleshooting. </li> <li>Develop and update technical documentation for reporting systems </li><li>Perform other duties as assigned </li></ul>Requirements ****EPIC AMBULATORY CERTIFICATION IS REQUIRED! EPIC HEALTHY PLANET CERTIFICATION IS PREFERRED**** <ul><li>Bachelors degree or 4 years of equivalent work experience preferred </li><li>Epic Ambulatory Certification is REQUIRED. </li><li>Epic Healthy Planet Certification is highly preferred </li><li>A minimum of 2 years of certified Epic Ambulatory and Healthy Planet experience is required </li><li>Experience with Compass Rose highly desired </li><li>Experience with enhanced care management programs e.g. PACE preferred but not required </li><li>Display knowledge of the underlying language of the assigned data system and business intelligence toolset (SQL, Epic Cogito, Business Objects, Crystal Reports, Tableau). </li><li>Experience in working with others to identify, define and analyze end user requirements and timelines designed to meet business needs </li><li>up to 10% travel </li></ul>COVID-19 Vaccination Requirement To keep our colleagues, members, and communities safe, OCHIN requires all employees-including remote employees, contractors, interns, and new hires-to be vaccinated with a COVID-19 vaccine, as supported by state and federal public health officials, as a condition of employment. All new hires are required to provide proof of full vaccination or receive approval for a medical or religious exemption before their hire date. Work Location and Travel Requirements OCHIN is a 100% remote organization with no physical corporate office location. Employees work remotely from home and many of our positions also support our member organizations on-site for new software installations. Nationwide travel is determined based on OCHIN business needs. Please inquire during the interview process about travel requirements for this position. Work from home requirements are: <ul> <li>Ability to work independently and efficiently from a home office environment </li><li>High Speed Internet Service </li><li>It is a requirement that employees work in a distraction free workplace </li></ul> We offer a comprehensive range of benefits. See our website for details: https://ochin.org/employment-openings Equal Opportunity Statement OCHIN is an equal opportunity employer. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills for the benefit of our staff, our mission, and the communities we serve. As an equal opportunity and affirmative action employer, OCHIN does not discriminate on the basis of race, ethnicity, sex, gender identity or expression, sexual orientation, religion, marital or civil union status, parental status, age, disability status, veteran status, or any other protected characteristics. All aspects of employment are based on merit, performance, and business needs. Base Pay Overview The typical offer range for this role is minimum to midpoint (min-$77,235 mid$96,544 ), with the midpoint representing the average pay in a national market scope for this position. Please keep in mind that this range represents the pay range for all positions in the job grade within which this position falls. The actual salary offer will consider a wide range of factors directly relevant to this position, including, but not limited to, skills, knowledge, training, responsibility, and experience, as well as internal equity and alignment with market data. #LI-Remote #Epic Ambulatory Certification #Healthy Planet Certification #Compass Rose Salary Description min-$77,235 mid$96,544 max-$115,852

Job Type
 Full-time
 
 Description
 MAKE A DIFFERENCE AT OCHIN OCHIN is a rapidly growing national nonprofit health IT organization with over two decades of experience transforming health care delivery to drive health equity. We are hiring for a number of positions to meet increasing demand. When you choose to join OCHIN, you have the opportunity to continuously grow your skills and do meaningful work to help fulfill our mission. OCHIN provides leading-edge technology, data analytics, research, and support services to nearly 1,000 community health care sites, reaching nearly 6 million patients nationally. We believe that every individual, no matter their race, ethnicity, background, or zip code, should have fair opportunity to achieve their full health potential. Our work addresses differences in health that are systemic, avoidable, and unjust. We partner, learn, innovate, and advocate, in order to close the gap in health for individuals and communities negatively impacted by racism or other structural inequities. At OCHIN, we value the unique perspectives and experiences of every individual and work hard to maintain a culture of belonging. Founded in Oregon in 2000, OCHIN employs a growing virtual workforce of more than 1,200 diverse professionals, working remotely across 50 states. We offer a generous compensation package and are committed to supporting our employees' entire well-being by fostering a healthy work-life balance and equitable opportunity for professional advancement. We are curious, collaborative learners who strive to live our values everyday: Learning, Heart, Belonging, and Impact. OCHIN is excited to support our continued national expansion and the increasing demand for our innovative tools and services by welcoming new talent to our growing team. Position Overview The Business Intelligence Analyst supports the mission of OCHIN by designing, developing, testing, documenting, maintaining, and troubleshooting reports across a broad platform of business intelligence tools. As a member of OCHIN's Population Health/Reporting Analytics department, the BIA role supports the full lifecycle of projects particularly the requirements definitions, quality assurance testing and user acceptance testing phases of projects. This role requires an above-average ability and desire to communicate in email, via JIRA tickets, and over the phone, as well as to effectively balance multiple competing priorities. This position has strong people connection to our Clinic Membership, to our coworkers at OCHIN and other business partners. It demands an above average ability and desire to communicate in email, via JIRA ticketing response or over the phone. Essential Duties Participate in requirement gathering, defining scope and objectives of business requirements, including documentation of requirements (i.e. use cases) and relevant translation into system requirement specifications. <ul> <li>Serve as a subject matter expert in assigned reporting system, internally and with members or external customers. </li><li>Responsible for the execution of full reporting lifecycle from design, development, testing, documentation, maintenance, and troubleshooting. </li> <li>Develop and update technical documentation for reporting systems </li><li>Perform other duties as assigned </li></ul>
 Requirements
 ****EPIC AMBULATORY CERTIFICATION IS REQUIRED! EPIC HEALTHY PLANET CERTIFICATION IS PREFERRED**** <ul> <li>Bachelors degree or 4 years of equivalent work experience preferred </li><li>Epic Ambulatory and Healthy Planet certifications required for External Applicants </li></ul> * (Epic Ambulatory Certification required for internal applicants. Healthy Planet Certification preferred or must attain in 6 mos) <ul> <li>A minimum of 2 years of certified Epic Ambulatory and Healthy Planet experience is required </li><li>Experience with Compass Rose highly desired </li><li>Experience with enhanced care management programs e.g. PACE preferred but not required </li><li>Display knowledge of the underlying language of the assigned data system and business intelligence toolset (SQL, Epic Cogito, Business Objects, Crystal Reports, Tableau). </li><li>Experience in working with others to identify, define and analyze end user requirements and timelines designed to meet business needs </li><li>up to 10% travel </li></ul> COVID-19 Vaccination Requirement To keep our colleagues, members, and communities safe, OCHIN requires all employees-including remote employees, contractors, interns, and new hires-to be vaccinated with a COVID-19 vaccine, as supported by state and federal public health officials, as a condition of employment. All new hires are required to provide proof of full vaccination or receive approval for a medical or religious exemption before their hire date. Work Location and Travel Requirements OCHIN is a 100% remote organization with no physical corporate office location. Employees work remotely from home and many of our positions also support our member organizations on-site for new software installations. Nationwide travel is determined based on OCHIN business needs. Please inquire during the interview process about travel requirements for this position. Work from home requirements are: <ul> <li>Ability to work independently and efficiently from a home office environment </li><li>High Speed Internet Service </li><li>It is a requirement that employees work in a distraction free workplace </li></ul> We offer a comprehensive range of benefits. See our website for details: https://ochin.org/employment-openings Equal Opportunity Statement OCHIN is an equal opportunity employer. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills for the benefit of our staff, our mission, and the communities we serve. As an equal opportunity and affirmative action employer, OCHIN does not discriminate on the basis of race, ethnicity, sex, gender identity or expression, sexual orientation, religion, marital or civil union status, parental status, age, disability status, veteran status, or any other protected characteristics. All aspects of employment are based on merit, performance, and business needs. Base Pay Overview The typical offer range for this role is minimum to midpoint, with the midpoint representing the average pay in a national market scope for this position. Please keep in mind that this range represents the pay range for all positions in the job grade within which this position falls. The actual salary offer will consider a wide range of factors directly relevant to this position, including, but not limited to, skills, knowledge, training, responsibility, and experience, as well as internal equity and alignment with market data. #LI-Remote #Epic Ambulatory Certification #Healthy Planet Certification #Compass Rose 
 Salary Description
 min-$77,235 mid$96,544 max-$115,852

Ochin Business Intelligence Interview Guide

Overview

Ochin Business Intelligence Salary

Ochin Business Intelligence Interview Process

Ochin Business Intelligence Interview Questions

Ochin Business Intelligence Jobs