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

Resmed Business Intelligence Interview Guide

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


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

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

Overview

Resmed Business Intelligence Salary

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

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

Resmed Business Intelligence Interview Process

<p>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.</p>

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

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

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>bank_transactions</code> table</p>

<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>
<p><strong>Output:</strong></p>

<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

<p>Write a query to identify the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>employees</code> table</p>

<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>
<p><code>managers</code> table</p>

<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>
<p><strong>Output:</strong></p>

<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

<p>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.</p>

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

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

<p><em>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.</em></p>

<p><em>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.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

<p><strong>Input:</strong></p>

<p><strong><code>friend_requests</code></strong></p>

<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>
<p><strong><code>requests_accepted</code></strong></p>

<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>
<p><strong><code>age_groups</code></strong></p>

<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>
<p><strong>Output:</strong></p>

<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

Resmed Business Intelligence Interview Questions

<p>Digital Health Technology team powers digital experiences and engagement to enhance the lives of millions of people every day through connected care. We build, deliver and manage a portfolio of data management platforms and mobile offerings in support of our core businesses. We thrive on simple and elegant architecture and agility. You’ll be immersed in a dynamic high-growth environment and empowered to excel, take informed risks, and drive ingenuity across the enterprise.

As a Full Stack Software Engineer, you'll be responsible for creating web experiences that allow ResMed's internal operational portal and status page to manage and present operational metrics and telemetry data. You will focus on enhancing our customer experiences, including leveraging the visualizations, notifications, and machine learning capabilities that delight our customers by providing actionable insights into our products, platforms and services. You will collaborate closely with cross-functional teams to ship features from design to release, as well as optimize tools and processes to improve operational excellence for both your team and our integrators.

Location: Toronto, Montreal, Calgary or Vancouver

Let’s Talk About Responsibilities
We're looking for a Full Stack Software Engineer who shares our passion for constantly improving the customer experience, is inspired by problem statements, and enjoys writing great code.

We'd like to speak with you if you're curious, technical, innovative, know how to deliver, and want to create pioneering solutions to challenging problems.

Let’s Talk About Qualifications And Experience
Required:
BS/MS in Computer Science or equivalent experience
4+ years of full-stack software development experience (Python and client-side languages like JavaScript)
Experience in developing user interfaces for complex applications, including responsiveness and accessibility considerations
Strong grasp of DevOps principles, including CI/CD and infrastructure
Knowledge of RESTful API design and microservices architecture
Strongly held test practices regardless of language or tools
Deep knowledge of source control, branching & release strategies, pull requests, and automated quality gates using tools like GitHub or Bitbucket

Preferred:
Experience in the public cloud (AWS) in building services using cloud-native technologies, including Kubernetes, Docker, Serverless, etc.
Experience with SQL and databases in general
Experience working in an Agile SCRUM environment

Joining us is more than saying “yes” to making the world a healthier place. It’s discovering a career that’s challenging, supportive and inspiring. Where a culture driven by excellence helps you not only meet your goals, but also create new ones. We focus on creating a diverse and inclusive culture, encouraging individual expression in the workplace and thrive on the innovative ideas this generates. If this sounds like the workplace for you, apply now! We commit to respond to every applicant.

#J-18808-Ljbffr</p>

<p>Brightree is a wholly owned subsidiary of ResMed (NYSE: RMD, ASX: RMD).</p><p>When you work at Brightree, it's more than just a job. You'll be part of a team that's driving innovation and leading the way in cloud-based patient management software.</p><p>The technology allows us to provide the tools for better outcomes but at our heart, we're really about people. We strive to positively impact our customers' businesses and the lives of patients every single day.</p><p>The Clinical Product Manager leads all phases of the product life cycle, from inception to marketplace availability. The product should meet and exceed customer requirements and be measurable through success outcomes. The Clinical Product Manager will monitor the success of the product by using customer feedback and will iterate the product to drive widespread adoption. This role serves as the industry expert and thought leader in Home Infusion Pharmacy for Brightree products and solutions. This role requires the ability to lead and motivate people, encourage teamwork, communicate effectively with senior leadership, and possesses a clear vision of how the product will solve complex problems from the industry.</p><p>Let's talk about Responsibilities</p><p>* Work with key stakeholders in building out complete end-to-end innovative solutions that solve customers' clinical problems.</p><p>* Gathers and write system requirements and design solutions to business needs to translate to the product and development team.</p><p>* Serves as a subject matter expert to internal and external teams to promote product refinement and adoption.</p><p>* Collaborates with customer support, professional services, development, and marketing teams to sustain strong partnerships to support product lifecycle.</p><p>* Manages and prioritizes product roadmap to meet customer and prospects needs.</p><p>* Researches and assesses market to proactively identify opportunities to add value and solve complex problems</p><p>* Assists sales team during opportunity assessment and proposal phases of the product particularly as it relates to clinical and operational workflows.</p><p>* Prepare and deliver product/feature presentations for customers and internal stakeholders.</p><p>Let's talk about Qualifications and Experience</p><p>Required:</p><p>* Deep industry knowledge of Home Infusion Pharmacy, Outpatient Infusion Pharmacy, or Specialty Pharmacy</p><p>* At least 5+ years of clinical experience in Home Infusion, Hospital, Specialty, or Outpatient Infusion Pharmacy with deep knowledge on how clinical initiatives affect other areas, like operations and financial touchpoints</p><p>* Must be a quick learner, self-directed, motivated, and have strong dedication and commitment level to the tasks at hand</p><p>* Ability to manage multiple, complex projects through cross-functional teams working within a SaaS environment.</p><p>* Very strong written and verbal communication skills with the ability to translate complex clinical concepts for consumption by non-clinical stakeholders</p><p>* Proficient in MS Office Tools: SharePoint, MS Power Point, MS Word, and MS Excel</p><p>* Ability to travel up to 15%, as needed</p><p>Preferred:</p><p>* Pharmacy related degree or certification</p><p>* Existing knowledge in Brightree products and/or infusion software systems</p><p>* Proficient in product management software (Aha, JIRA) and Salesforce</p><p>We are shaping the future at ResMed, and we recognize the need to build on and broaden our existing skills and continue to attract and retain the world's best talent. We work hard to offer holistic benefits packages, provide flexible work arrangements, cultivate a workforce culture that allows employees to grow personally and professionally, and deliver competitive salaries to our team members. Employees scheduled to work 30 or more hours per week are eligible for benefits. This position qualifies for the following benefits package: comprehensive medical, vision, dental, and life, AD&D, short-term and long-term disability insurance, sleep care management, Health Savings Account (HSA), Flexible Spending Account (FSA), commuter benefits, 401(k), Employee Stock Purchase Plan (ESPP), Employee Assistance Program (EAP), and tuition assistance. Employees receive fifteen days Paid Time Off (PTO) in their first year of employment, receive 11 paid holidays plus 3 floating days and are eligible for 14 weeks of primary caregiver or two weeks of secondary caregiver leave when welcoming new family members.</p><p>Individual pay decisions are based on a variety of factors, such as the candidate's geographic work location, relevant qualifications, work experience, and skills.</p><p>At ResMed, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current base range for this position is: $123,000 - $160,000 USD.</p><p>Joining us is more than saying "yes" to making the world a healthier place. It's discovering a career that's challenging, supportive and inspiring. Where a culture driven by excellence helps you not only meet your goals, but also create new ones. We focus on creating a diverse and inclusive culture, encouraging individual expression in the workplace and thrive on the innovative ideas this generates. If this sounds like the workplace for you, apply now! We commit to respond to every applicant.</p>

Resmed Business Intelligence Interview Guide

Overview

Resmed Business Intelligence Salary

Resmed Business Intelligence Interview Process

Resmed Business Intelligence Interview Questions

Resmed Business Intelligence Jobs