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 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>Write a query to show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</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>products</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>price</code></td>
<td>FLOAT</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>

<tr>
<td><code>sex</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>month</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

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


Monthly Customer Report

Cigna Business Intelligence Interview Questions

<p>The Software Engineer Advisor provides expert content/professional leadership on complex Engineering assignments/projects. Designs and develops a consolidated, conformed enterprise data warehouse and data lake which store all critical data across Cus Data Engineer, AWS, Software Engineer, Engineer, Technology, Insurance, Data, Design</p>

<b>Summary</b> <br><br>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 goals and metrics, as defined by business and regulatory requirements. <br><br><b>Essential Functions and Responsibilities</b> <br><br><ul><li>Perform thorough data analysis to detect anomalies, inconsistencies, and inaccuracies.</li></ul><br><br><ul><li>Collaborate with data engineers and analysts to validate data sources and ensure data integrity.</li></ul><br><br><ul><li>Design and develop data cleansing algorithms and processes.</li></ul><br><br><ul><li>Communicate data quality findings and recommendations to both technical and non-technical audiences.</li></ul><br><br><b>Qualifications</b> <br><br>Candidates should model our team's core values - Communicate Effectively and Instills Trust. They should also have the following skillset and characteristics. <br><br><b>Preferred Qualifications:</b> <br><br><ul><li>Bachelor's or Master's degree in Computer Science, Data Science, Statistics, or a related field.</li></ul><br><br><ul><li>At least 5 years of proven experience as a Data Scientist or in a similar role focused on data quality and accuracy.</li></ul><br><br><ul><li>Strong proficiency in data analysis tools and programming languages such as Python, R, Spark and SQL.</li></ul><br><br><ul><li>Experience with data quality tools and platforms (e.g. Informatica, Talend, Trifacta).</li></ul><br><br><ul><li>Excellent analytical and problem-solving skills with a keen attention to detail.</li></ul><br><br><ul><li>Strong communication and collaboration skills, with the ability to work effectively in a team-oriented environment.</li></ul><br><br><ul><li>Knowledge of data governance and data management principles is a plus.</li></ul><br><br><ul><li>Willingness to share opinions and take risks.</li></ul><br><br><ul><li>Creative thinker with ability to think outside the box & translate strategies into actions.</li></ul><br><br><ul><li>Must possess strong organizational skills with ability to manage multiple priorities simultaneously.</li></ul><br><br><ul><li>Strong, clear, concise, and analytical written and oral communication skills</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,100 - 181,800 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 The Cigna Group </b><br><br>Doing something meaningful starts with a simple decision, a commitment to changing lives. At The Cigna Group, we're dedicated to improving the health and vitality of those we serve. Through our divisions Cigna Healthcare and Evernorth Health Services, we are committed to enhancing the lives of our clients, customers and patients. 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