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

Chenmed Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Chenmed? The Chenmed 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 Chenmed Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Chenmed.</li>
<li>Practice real Chenmed 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 Chenmed Business Intelligence interview.</p>


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

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

Overview

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

Chenmed 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>You’ve been asked to analyze the player’s behaviors at a gaming company.</p>

<p>Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.</p>

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

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

<p><strong><code>players</code></strong> table</p>

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

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

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Obtain count of players based on games played.

Player Analysis

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

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

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

<p><code>transactions</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>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>
<p><code>users</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>
</tbody>
</table>
<p> 
<strong>Output:</strong></p>

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


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


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

Customer Orders

Chenmed Business Intelligence Interview Questions

<p><p>Were unique. You should be, too.</p><p>Were changing lives every day. For both our patients and our team members. Are you innovative and entrepreneurial minded? Is your work ethic and ambition off the charts? Do you inspire others with your kindness and joy?</p><p>Were different than most primary care providers. Were rapidly expanding and we need great people to join our team.</p><p>The Business Intelligence Developer (Data Engineer) will work closely with business units and technical teams to understand, develop, improve, and maintain BI systems. The Business Intelligence Developer-DE will use their skills and expertise to transform data into metrics, automated reports, and dashboards providing actionable insights to improve decision-making at all levels of the business. The Business Intelligence Developer-DE will have strong data management skills and communicate directly with internal clients.</p><p>ESSENTIAL JOB DUTIES/RESPONSIBILITIES:</p><p>Develops a deep familiarity with a variety of data sources including transactional databases, data warehouses, internal tools, and external integrations.</p><p>Develops data programs that extract, transform, and load (ETL) data from the data warehouse, assures that architecture and development follow data warehouse best practices. This individual works with DW architects, data architects, hardware/software engineers, DBAs, application vendors and managed services to ensure enterprise DW solutions are reliable, scalable, flexible and low maintenance.</p><p>Develops reports, dashboards, and tools using SQL, Python, SSRS, and QlikView, as well as other tools.</p><p>Takes ownership of our data and constantly improve its quality and integrity; proactively identifying issues at every step and coordinating the implementation of required fixes.</p><p>Partners with business stakeholders to understand their requirements and assist in the development of dashboards, visualizations and solutions tailored to their needs.</p><p>Documents existing processes, architectures and code.</p><p>Assists, mentors, and instructs lower-level developers and analysts as needed.</p><p>Performs other duties as assigned and modified at managers discretion.</p><p>EDUCATION AND EXPERIENCE CRITERIA:</p><p>BA/BS degree in Computer Science, MIS, Business Administration or related field required OR additional experience above the minimum may be considered in lieu of the required education on a year-for-year basis</p><p>Masters level-education with a combination of technical and business background a plus</p><p>A minimum of 1 year of ETL and/or SQL development experience required</p><p>A minimum of 1 year of RDBMS experience (MySQL, SQL Server, PostgreSQL, etc.) strongly preferred</p><p>A minimum of 1 year of healthcare industry experience (or equivalent educational background) preferred</p><p>Experience programming with a high-level scripting language (Python, Perl, C#, etc.)</p><p>Experience working with a variety of reporting and analytic tools (QlikView and SSRS strongly preferred)</p><p>Proven experience working with business units; gathering their needs and creating solutions</p><p>Experience in query tuning and database engine optimization desired</p><p>Experience in database programming, stored procedures, data imports and exports desired</p><p>Familiar with Medicare Advantage industry desired</p><p>Were ChenMed and were transforming healthcare for seniors and changing Americas healthcare for the better. Family-owned and physician-led, our unique approach allows us to improve the health and well-being of the populations we serve. Were growing rapidly as we seek to rescue more and more seniors from inadequate health care.</p><p>ChenMed is changing lives for the people we serve and the people we hire. With great compensation, comprehensive benefits, career development and advancement opportunities and so much more, our employees enjoy great work-life balance and opportunities to grow. Join our team who make a difference in peoples lives every single day.</p><p>Current Employee apply HERE (https://careers.chenmed.com/i/us/en/homerevisited)</p><p>Current Contingent Worker please see job aid HERE to apply</p></p>

We’re unique. You should be, too.

We’re changing lives every day. For both our patients and our team members. Are you innovative and entrepreneurial minded? Is your work ethic and ambition off the charts? Do you inspire others with your kindness and joy?

We’re different than most primary care providers. We’re rapidly expanding and we need great people to join our team.

The Senior Software Engineer is responsible for application development and coding, unit testing, system support and documentation. The incumbent in this role designs, modifies, develops, writes and implements software programming applications and components; supports and/or installs software applications and components; works from written specifications and pre-established guidelines to perform the functions of the job and maintains documentation of process flow. He/She works closely with other software developers and technical professionals.

ESSENTIAL JOB DUTIES/RESPONSIBILITIES:

Designs, develops, tests and delivers software solutions using one or more commercial languages as well as, open source tools. Develops and delivers software in an Agile/Scrum environment.

Manages projects while accepting responsibility over a specialized area. Provides good clear communications to stakeholders, setting expectations. Relies on own judgment, with feedback from Manager.

Engages with key stakeholders to ensure requirements, schedules and all expectations are understood by the development team and stakeholders for assigned software solutions and software maintenance.

Develops and executes automated unit testing for all assigned software solutions.

Supports infrastructure and network teams in analysis and resolution of issues that are software solution related.

Performs all functions necessary to take software solutions from planning to implementation. Escalates appropriately, if deadlines are in danger of being missed.

Coordinates with management to ensure identification of appropriate schedules, goals, design criteria, methodology, etc.

Shares knowledge, lessons learned and best practices among the team.

Supports and guides the delivery of software solutions. Provides appropriate documentation.

Follows all defined software solution methods, processes, and procedures.

Performs other duties as assigned and modified at manager’s discretion.

KNOWLEDGE, SKILLS AND ABILITIES:

Superb knowledge of the Atlassian suite of products (Bitbucket/JIRA/CONFLUENCE etc.) or similar tools

Expert knowledge in at least 2 domains or technologies. Intermediate competency in most domains or technologies used in teams

Keen ability to anticipate software malfunctions and quickly identify solutions

Largely self-directed. May provide direction to individuals or small teams

Influences associated teams for best practices and decisions

Ability to break multi-week objectives into tasks. Able to decompose tasks and provide definition for others

Ability to improve team productivity. Knowledge to assist with recruitment of associate/junior level positions

Superior ability to manage projects to deadlines while avoiding undue time crunch for self and project team

Well-respected and viewed as a key contributor cross-functionally. Influences and builds consensus across diverse teams

Able to articulate core controls and requirements to business units

Proactive in developing actionable programs that drive improvements and increase productivity/revenue/customer value

Ability to mentor and coach junior team members effectively and create a positive learning environment. Able to set measurable objectives

Ability to work with minimal supervision (Bi-weekly Check-Ins)

Expert skills in Microsoft Office Suite products including Word, Excel, PowerPoint and Outlook, plus a variety of other word-processing, spreadsheet, database, e-mail and presentation software

Ability and willingness to travel locally, regionally and nationwide up to 10% of the time

Spoken and written fluency in English

This job requires use and exercise of independent judgment

EDUCATION AND EXPERIENCE CRITERIA:

Bachelor degree in Computer Science, Computer Information Systems, Software Engineering, Software Development, Mathematics or a related field OR additional experience above the minimum will be considered in lieu of the required education on a year-for-year basis required

A minimum of 5 years’ work experience as a software engineer or similar IT role or related field required

IT certification in Java, C, Objective-C, C++, Perl & Python or similar formats preferred

We’re ChenMed and we’re transforming healthcare for seniors and changing America’s healthcare for the better. Family-owned and physician-led, our unique approach allows us to improve the health and well-being of the populations we serve. We’re growing rapidly as we seek to rescue more and more seniors from inadequate health care.

ChenMed is changing lives for the people we serve and the people we hire. With great compensation, comprehensive benefits, career development and advancement opportunities and so much more, our employees enjoy great work-life balance and opportunities to grow. Join our team who make a difference in people’s lives every single day.

Current Employee apply HERE (https://careers.chenmed.com/i/us/en/homerevisited)

Current Contingent Worker please see job aid HERE to apply

<p>We're unique. You should be, too.</p><p>We're changing lives every day. For both our patients and our team members. Are you innovative and entrepreneurial minded? Is your work ethic and ambition off the charts? Do you inspire others with your kindness and joy?</p><p>We're different than most primary care providers. We're rapidly expanding and we need great people to join our team.</p><p>The Product Manager is a key member of the Analytics organization working to drive the strategy and vision of the products and its features. The incumbent in this role works very closely with all Analytic Teams, development teams, QA engineers, business analysts, clinical stakeholders, and user experience design leads to create the product vision, roadmap, and ensure the final deliverable meets stakeholder needs. Product Managers within Analytics are responsible for both the creation and rollout of the product but also the curated analytic content.</p><p>ESSENTIAL JOB DUTIES/RESPONSIBILITIES:</p><p>* Determines business and customer needs by evaluating feedback and information gathered from multiple sources.</p><p>* Defines strategy and processes for one or more Analytics product areas.</p><p>* Owns the product roadmap and works with stakeholders to prioritize and translate into feature implementation. Manages a long term roadmap and drives a more detailed short term roadmap.</p><p>* Collaborates with various teams including engineering, business analysts, clinical stakeholders, and UX/UI to determine the best technical implementation methods.</p><p>* Collaborates proactively with Analytic teams to understand all KPIs and content areas to ensure the products are maintained and updated at all times.</p><p>* Supports communications, meetings, and other collaborations as appropriate to effectively perform work and to understand, resolve, and/or mitigate risks, obstacles, and conflicts in the performance of functional activities.</p><p>* Prepares and communicates status updates and demonstrations to senior executives and other stakeholders.</p><p>* Performs other duties as assigned and modified at manager's discretion.</p><p>KNOWLEDGE, SKILLS AND ABILITIES:</p><p>* Professional-level business acuity</p><p>* Comprehensive knowledge and understanding of general/core job-related functions, practices, processes, procedures, techniques and methods</p><p>* Knowledge of multiple functional areas such as Product Management, Engineering, UX/UI, Sales, Customer Support, Finance and/or Marketing</p><p>* Passionate problem solver</p><p>* Ability to proactively communicate thoughtfully, leveraging problem-solving skills and a learning mindset to build long-term relationships</p><p>* Great interpersonal skills, as the role will be embedded in a very matrixed organization</p><p>* Proficient in Microsoft Office Suite products including Word, Excel, PowerPoint and Outlook, database, and presentation software</p><p>* Ability and willingness to travel locally, regionally and nationwide up to 10% of the time</p><p>* Spoken and written fluency in English</p><p>* This job requires use and exercise of independent judgment and requires proactive initiative and autonomy</p><p>EDUCATION AND EXPERIENCE CRITERIA:</p><p>* BA/BS degree in Information Technology, Computer Science, Data Science, or business-related field required OR additional experience above the minimum may be considered in lieu of the required education on a year-for-year basis required</p><p>* Master's Degree preferred</p><p>* A minimum of three (3) years' work experience in the product management role; or similar experience having managed programs or projects for businesses that contribute for customers and business partners; or similar experience within an analytics organization</p><p>* Hands-on software product design and/or development experience preferably in an agile software development environment</p><p>* Experience leading design, feature breakdown and projects/products from inception through launch</p><p>* Experience in healthcare domain preferred</p><p>* Experience in analytics domain preferred</p><p>We're ChenMed and we're transforming healthcare for seniors and changing America's healthcare for the better. Family-owned and physician-led, our unique approach allows us to improve the health and well-being of the populations we serve. We're growing rapidly as we seek to rescue more and more seniors from inadequate health care.</p><p>ChenMed is changing lives for the people we serve and the people we hire. With great compensation, comprehensive benefits, career development and advancement opportunities and so much more, our employees enjoy great work-life balance and opportunities to grow. Join our team who make a difference in people's lives every single day.</p><p>Current Employee apply HERE</p><p>Current Contingent Worker please see job aid HERE to apply</p>

Chenmed Business Intelligence Interview Guide

Overview

Chenmed Business Intelligence Salary

Chenmed Business Intelligence Interview Process

Chenmed Business Intelligence Interview Questions

Chenmed Business Intelligence Jobs