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

Stantec Business Intelligence Interview Guide

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


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

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

Overview

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

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

Stantec Business Intelligence Interview Questions

Data Scientist - ( 240003C6 )<br> <br><strong>Description</strong><br> <br>We are strategizing, planning, and implementing projects that help clients achieve their organization's objectives. Join our award-winning program management team and bring transformational project solutions to life.<br> <br>By managing capital programs and projects as if they were our own, our project management business, and technical experts work with clients to strategize, plan, and implement projects that help them achieve their organization's objectives. Our award-winning team has managed thousands of projects across all sectors - hospitals, airports, and entire university campuses; infrastructure like mass transit and water-treatment facilities; and energy and resource assignments, from mines to wind farms.<br> <br><strong>Your Opportunity</strong><br> <br>We are seeking a talented and detail-oriented Data Scientist to join our dynamic team. In this role, you will be working closely with Controls Specialists and Controls Managers to collect, analyze, and interpret large datasets by developing dashboards and reports to help inform business decisions. Working in partnership with Controls Leadership, you will develop and implement standards for technology usage within the group and linking component subsystems to work together as a coherent unit for program management.<br> <br><strong>Your Key Responsibilities</strong><br> <ul> <li>Collect and analyze large datasets to derive actionable insights.</li> <li>Use statistical methods to interpret data and generate useful business reports.</li> <li>Identify trends, patterns, and anomalies in data.</li> <li>Ensure data accuracy and integrity through validation and cleaning processes.</li> <li>Interpret program data for continuous improvement.</li> <li>Collaborate with the Controls team and other teams to resolve data-related issues.</li> <li>Design and develop comprehensive and visually appealing reports and dashboards in Microsoft Power BI.</li> <li>Prepare project performance reports on a portfolio of projects including variance reporting.</li> <li>Communicate findings to non-technical stakeholders effectively.</li> <li>Assist with Business Process development regarding data gathering and analysis.</li> <li>Communicate and coordinate with other team members to complete project tasks to meet specific deadlines.</li> <li>Participate and collaborate in project team setting and to engage in creative and critical thought.</li> </ul> <br><strong>Qualifications</strong><br> <br><strong>Your Capabilities and Credentials</strong><br> <ul> <li>Strong analytical and problem-solving skills.</li> <li>Organized, self-motivated, and enjoy finding solutions to problems.</li> <li>Excellent written/verbal communication and collaboration abilities.</li> <li>Attention to detail and a commitment to producing high-quality work.</li> <li>Knowledge of database design and theories.</li> <li>Ability to work independently and as part of a team.</li> <li>Ability to multi-task, manage time, organize, and set priorities and make timely decisions.</li> <li>Proficient in data analysis tools and programming languages (e.g., SQL, Python, R).</li> <li>Experience with data visualization tools (e.g., Tableau, Power BI).</li> <li>Familiarity with data warehousing and ETL processes.</li> <li>Experience with API calls and management (e.g., REST, JSON or XML objects).</li> <li>Experience working with location data and maps is preferred.</li> </ul> <br><strong>Education and Experience</strong><br> <ul> <li>Bachelor's degree in a relevant field (e.g., Data Science, Statistics, Computer Science).</li> <li>5-7 years' experience as a Data Scientist, or in a similar role.</li> <li>Industry-specific knowledge and experience (e.g., Architecture, Engineering, Construction) is preferred.</li> <li>Prior work in project controls would be considered an asset.</li> </ul> <br>This description is not a comprehensive listing of activities, duties or responsibilities that may be required of the employee and other duties, responsibilities and activities may be assigned or may be changed at any time with or without notice.<br> <br>Stantec is a place where the best and brightest come to build on each other's talents, do exciting work, and make an impact on the world around us. Join us and redefine your personal best.<br> <br>Pay transparency laws require employers to provide the following information for positions that may be in the following jurisdiction(s):<br> <br><strong>Salary Range(s):</strong><br> <ul> <li>SF Area $117,700/CA Other Areas $102,700 - SF Area $170,600/ CA Other Areas $148,900 Min/Max Pay Range for postings located in CA (SF Area includes SF, SJS & WLC)</li> </ul> <br>The final agreed upon compensation is based on individual education, qualifications, experience, and work location. At Stantec certain roles are bonus eligible.<br> <br><strong>Benefits Summary:</strong> Regular full-time and part-time employees have access to medical, dental, and vision plans, a wellness program, health saving accounts, flexible spending accounts, 401(k) plan, employee stock purchase program, life and accidental death & dismemberment (AD&D) insurance, short-term/long-term disability plans, emergency travel benefits, tuition reimbursement, professional membership fee coverage and paid family leave. Regular full-time and part-time employees will receive ten paid holidays in each calendar year. In addition, employees will be eligible to accrue vacation between 10 and 20 days per year and eligible for paid sick leave (and if more generous, in accordance with state and local law).<br> <br>Temporary/casual employees have access to 401(k) plans, employee stock purchase program, and paid leave, in accordance with state and local law.<br> <br>The benefits information listed above may not apply to union positions because benefits for such positions are governed by applicable collective bargaining agreements.<br> <br><strong>Primary Location</strong> : United States-California-San Diego<br> <br><strong>Other Locations</strong> : United States-Georgia-Atlanta, United States-Texas-Fort Worth, United States-Nevada-Las Vegas, United States-Texas-Austin, United States-Illinois-Chicago, United States-California-San Francisco, United States-Tennessee-Knoxville<br> <br><strong>Organization</strong> : BC-2249 Water-US PMCM<br> <br><strong>Employee Status</strong> : Regular<br> <br><strong>Job Level</strong> : Individual Contributor<br> <br><strong>Travel</strong> : No<br> <br><strong>Schedule</strong> : Full-time<br> <br><strong>Job Posting</strong> : Sep 9, 2024, 10:57:19 AM<br> <br><strong>Req ID:</strong> 240003C6<br> <br>#additional<br> <br>Stantec provides equal employment opportunities to all qualified employees and applicants for future and current employment and prohibit discrimination on the grounds of race, color, religion, sex, national origin, age, marital status, genetic information, disability, protected veteran status, sexual orientation, gender identity or gender expression. We prohibit discrimination in decisions concerning recruitment, hiring, referral, promotion, compensation, fringe benefits, job training, terminations or any other condition of employment. Stantec is in compliance with local, state and federal laws and regulations and ensures equitable opportunities in all aspects of employment. EEO including Disability/Protected Veterans

Stantec Business Intelligence Interview Guide

Overview

Stantec Business Intelligence Salary

Stantec Business Intelligence Interview Process

Stantec Business Intelligence Interview Questions

Stantec Business Intelligence Jobs