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

Cigna Business Intelligence Interview Guide

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


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

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

Overview

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

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

<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

Cigna Business Intelligence Interview Questions

<p>Design and hands-on development of robust solutions to hard problems considering scale, security, reliability, performance, operational excellence, and cost. Supports other product delivery partners in the successful build, test, and release of solut AWS, Data Engineer, Software Engineer, Engineer, Senior, Behavioral Health, Technology, Insurance</p>

<p>The Provider Data Quality & Accuracy (PDQA) team is seeking a highly skilled and detail-oriented Data Analyst to join our team. This role will help us to ensure the reliability, accuracy and integrity of our data assets and that we meet specific goal Data Analyst, Quality, Analyst, Data Scientist, Data Engineer, Behavioral Health, Technology, Insurance</p>

<b>Description of the Business Unit:</b><br><br>Verity Solutions, a Cigna Company, is an award-winning leader in software and services developed for the pharmaceutical supply chain. Our mission is to simplify the complex process of managing the pharmaceutical supply chain processes for healthcare systems in the US. Our solutions span the breadth of the pharmaceutical supply chain. We were pioneers in simplifying the complex process of maintaining 340B program compliance resulting in critical 340B cost savings for our customers. We value fresh thinking, drive, transparency, and provide agile and proactive solutions to those who serve the most vulnerable in our communities. At Verity Solutions, we foster a collaborative, casual, and technology-driven environment and want to evolve and grow with diverse people who are inspired by progress and delighted by partnering with others.<br><br><b>Job Summary:</b><br><br>The Senior Product Manager will play a crucial role in defining the product vision, strategy, roadmap and backlog for one or more products. An ideal candidate would have successfully led a product from concept to launch and managed the product for continued success. Working closely with cross-functional teams to grow existing products and bring new innovative products to market is an important part of this role. The ideal candidate will have a strong passion for technology, an exceptional ability to understand and articulate the problem space, conceptualize frameworks and develop strategies. <br><br><b>Job Duties: </b><br><br><ul><li>Define and communicate a vision, strategy, roadmap and backlog for new and existing products.</li><li>Deliver detailed product documentation with prioritized features and justification based upon business value, product strategy and roadmap.</li><li>Communicate with customers (internal & external) to gain feedback on user product experiences and opportunities. Ensure correct features are identified, considering customers, operations, sales, finance, related lines of business and others. Prioritize and negotiate to build best possible set of features to be included and developed in the new products.</li><li>Assist/develop/coordinate new idea reviews and recommendations, concept and design development, project management, and market introduction.</li><li>Assist/develop product profiles, competitive analysis, presentations, demos, white papers, and product updates for organizational marketing materials.</li><li>Able to synthesize relevant data to generate insights that inform understanding of problems, product performance, strategy and KPIs.</li><li>Partner with Marketing to coordinate external messaging and expression of product/feature value propositions.</li><li>Partner with Finance on estimating product demand, profitability and establishing pricing.</li><li>Present to the Senior Leadership team as necessary</li><li>Represent Verity Solutions at industry trade group meetings and presentations as requested.</li><li>Support and promote the Verity Solutions values through positive interactions with both internal and external customers on a regular basis</li></ul><br><br><b>Qualifications:</b><br><ul><li>Bachelor's degree business, engineering, computer science, technology or equivalent experience.</li><li>7+ years in software product management experience.</li><li>Deep experience in all phases of product management, from concept to launch and ongoing iterations.</li><li>Experience in healthcare supply chain systems and/or pharmacy is a plus, but not required.</li><li>Solid understanding of product management best practices and methodologies.</li><li>Familiarity with Agile development processes and tools.</li><li>Result-oriented mindset with a focus on delivering high-quality products.</li><li>Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.</li><li>Ability to prioritize and manage multiple projects simultaneously.</li><li>Strong leadership skills and the ability to influence and inspire team members.</li><li>Ability to understand customers, deeply explore and articulate problems and solutions.</li><li>Can think strategically to set a product vision and strategy for long term growth</li></ul><br><br>If you will be working at home occasionally or permanently, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 10Mbps download/5Mbps upload.<br><br>For this position, we anticipate offering an annual salary of 109,900 - 183,100 USD / yearly, depending on relevant factors, including experience and geographic location.<br><br>This role is also anticipated to be eligible to participate in an annual bonus plan.<br><br>We want you to be healthy, balanced, and feel secure. That's why you'll enjoy a comprehensive range of benefits, with a focus on supporting your whole health. Starting on day one of your employment, you'll be offered several health-related benefits including medical, vision, dental, and well-being and behavioral health programs. We also offer 401(k) with company match, company paid life insurance, tuition reimbursement, a minimum of 18 days of paid time off per year and paid holidays. For more details on our employee benefits programs, visit Life at Cigna Group.<br><br><b>About Evernorth Health Services</b><br><br>Evernorth Health Services, a division of The Cigna Group, creates pharmacy, care and benefit solutions to improve health and increase vitality. We relentlessly innovate to make the prediction, prevention and treatment of illness and disease more accessible to millions of people. Join us in driving growth and improving lives.<br><br>Qualified applicants will be considered without regard to race, color, age, disability, sex, childbirth (including pregnancy) or related medical conditions including but not limited to lactation, sexual orientation, gender identity or expression, veteran or military status, religion, national origin, ancestry, marital or familial status, genetic information, status with regard to public assistance, citizenship status or any other characteristic protected by applicable equal employment opportunity laws.<br><br>If you require reasonable accommodation in completing the online application process, please email: SeeYourself@cigna.com for support. Do not email SeeYourself@cigna.com for an update on your application or to provide your resume as you will not receive a response.<br><br>The Cigna Group has a tobacco-free policy and reserves the right not to hire tobacco/nicotine users in states where that is legally permissible. Candidates in such states who use tobacco/nicotine will not be considered for employment unless they enter a qualifying smoking cessation program prior to the start of their employment. These states include: Alabama, Alaska, Arizona, Arkansas, Delaware, Florida, Georgia, Hawaii, Idaho, Iowa, Kansas, Maryland, Massachusetts, Michigan, Nebraska, Ohio, Pennsylvania, Texas, Utah, Vermont, and Washington State.

Cigna Business Intelligence Interview Guide

Overview

Cigna Business Intelligence Salary

Cigna Business Intelligence Interview Process

Cigna Business Intelligence Interview Questions

Cigna Business Intelligence Jobs