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

Mckinstry Business Intelligence Interview Guide

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


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

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

Overview

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

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

Mckinstry Business Intelligence Interview Questions

Build the future, spark innovation and align your career with purpose.

McKinstry is innovating the waste and climate harm out of the built environment and creating lasting impact. Together, we're building a thriving planet.

Buildings are a leading contributor to the climate crisis, generating nearly 40% of total global energy-related carbon emissions. We're making a lasting impact on our industry and within our communities by addressing the climate, affordability and equity crises through:

renewables and energy services
engineering and design
construction and facility services

To get where we're going, we need big thinkers, problem solvers and collaborative mindsets. Does that sound like you?

The Opportunity with McKinstry  We are adding a Senior Product Manager to our growing Business Technology division. Additionally, some responsibilities you will have include:

Product Management Leadership   Takes the lead and owns a major, large-scale initiative.
Manage product life cycle (including modifications, upgrades and maintenance) through end of life.
Lead coordination and documentation of project activities including product introduction meetings, design review meetings, and user acceptance testing.
Partner with IT, consultants, and software vendors to specify, deliver, and maintain solutions and integrations.

People Leadership   Trains, mentors and manages assigned staff.
Creates performance plans, assesses performance, and provides performance feedback.

What You Need to Succeed at McKinstry   Proven experience in product management, with a strong focus on Salesforce products.
Salesforce certification is highly desirable.
6-10 years in Product Management or A/E/C industry technology solutions required.
Knowledge of software development methodologies a plus.

PeopleFirst Benefits   When it comes to the basics, we have you covered:
Competitive pay
401(k) with employer match and profit-sharing plan
Paid time off and holidays
Comprehensive medical, prescription, dental, and vision with low or zero deductible options and low out of pocket maximums

People come first at McKinstry, and we go beyond the basic benefits with:
Family formation benefits, including adoption and IVF assistance
Up to 16 weeks paid parental leave
Transgender inclusive benefits
Commuter benefits
Pet insurance
"Building Good" paid community service time
Learning and advancement opportunities via McKinstry University
McKinstry Moves onsite gyms or reimbursement for remote workers

See benefit plan documents for complete details.

If you're driven by our vision to build a thriving planet together, McKinstry is the place to build your career.

The pay range for this position is $99,270- $169,900 per year; however, base pay offered may vary depending on job-related knowledge, skills, and experience. Base pay information is based on market location. A bonus may be provided as part of the compensation package, in addition to a full range of medical, financial, and/or other benefits, dependent on the position offered.

The McKinstry group of companies are equal opportunity employers. We are committed to providing equal employment opportunities to all employees and qualified applicants without regard to sex, gender identity, sexual orientation, age, race, color, creed, marital status, national origin, disability, veteran status, genetic information or any other basis protected by law. This policy applies to all terms and conditions of employment including, but not limited to employment, advancement, assignment, and training. This commitment to Equal Employment Opportunity is made equally as a social responsibility and as an economic and business necessity.

McKinstry is a drug-free workplace. Employment is contingent upon successfully passing a pre-employment drug and alcohol test, complying with the requirements of the Immigration Reform and Control Act and a Confidentiality Agreement, in addition to successful outcomes of background and reference checks.

Applicants for this role will only be considered if they possess current US Work Authorization, and do not require employer-sponsored VISA support to begin or remain in this role.

#LI-AK1

#J-18808-Ljbffr

McKinstry Senior Product Manager Seattle, Washington   Build the future, spark innovation and align your career with purpose.
McKinstry is innovating the waste and climate harm out of the built environment and creating lasting impact. Together, we’re building a thriving planet.
Buildings are a leading contributor to the climate crisis, generating nearly 40% of total global energy-related carbon emissions. We’re making a lasting impact on our industry and within our communities by addressing the climate, affordability and equity crises through:
renewables and energy services
engineering and design
construction and facility services
To get where we’re going, we need big thinkers, problem solvers and collaborative mindsets. Does that sound like you?
The Opportunity with McKinstry
We are adding a Senior Product Manager to our growing Business Technology division. Responsibilities include:
Takes the lead and owns a major, large-scale initiative.
Manage product life cycle (including modifications, upgrades and maintenance) through end of life.
Lead coordination and documentation of project activities including product introduction meetings, design review meetings, and user acceptance testing.
Partner with IT, consultants, and software vendors to specify, deliver, and maintain solutions and integrations.
Trains, mentors and manages assigned staff.
Creates performance plans, assess performance, and provide performance feedback.
What You Need to Succeed at McKinstry
Proven experience in product management, with a strong focus on Salesforce products.
Salesforce certification is highly desirable.
6-10 years in Product Management or A/E/C industry technology solutions required.
Knowledge of software development methodologies a plus.
When it comes to the basics, we have you covered:
Competitive pay
401(k) with employer match and profit-sharing plan
Paid time off and holidays
Comprehensive medical, prescription, dental, and vision with low or zero deductible options and low out of pocket maximums
People come first at McKinstry, and we go beyond the basic benefits with:
Family formation benefits, including adoption and IVF assistance
Up to 16 weeks paid parental leave
“Building Good” paid community service time
Learning and advancement opportunities via McKinstry University
McKinstry Moves onsite gyms or reimbursement for remote workers
If you’re driven by our vision to build a thriving planet together, McKinstry is the place to build your career.
The pay range for this position is $99,270- $169,900 per year; however, base pay offered may vary depending on job-related knowledge, skills, and experience. Base pay information is based on market location. A bonus may be provided as part of the compensation package, in addition to a full range of medical, financial, and/or other benefits, dependent on the position offered.
The McKinstry group of companies are equal opportunity employers. We are committed to providing equal employment opportunities to all employees and qualified applicants without regard to sex, gender identity, sexual orientation, age, race, color, creed, marital status, national origin, disability, veteran status, genetic information or any other basis protected by law. This policy applies to all terms and conditions of employment including, but not limited to employment, advancement, assignment, and training.
McKinstry is a drug-free workplace. Employment is contingent upon successfully passing a pre-employment drug and alcohol test, complying with the requirements of the Immigration Reform and Control Act and a Confidentiality Agreement, in addition to successful outcomes of background and reference checks.

#J-18808-Ljbffr

<p><strong>Build the future, spark innovation and align your career with purpose.</strong></p><br/><p>McKinstry is innovating the waste and climate harm out of the built environment and creating lasting impact. Together, we're building a thriving planet.</p><br/><p>Buildings are a leading contributor to the climate crisis, generating nearly 40% of total global energy-related carbon emissions. We're making a lasting impact on our industry and within our communities by addressing the climate, affordability and equity crises through:</p><br/><ul><li>renewables and energy services</li><li>engineering and design</li><li>construction and facility services</li></ul><br/><p>To get where we're going, we need big thinkers, problem solvers and collaborative mindsets. Does that sound like you?</p><br/><h3>The Opportunity with McKinstry</h3><p>We are adding a Senior Product Manager to our growing Business Technology division. Additionally, some responsibilities you will have include:</p><br/><ul><li><strong>Product Management Leadership</strong><ul><li>Takes the lead and owns a major, large-scale initiative.</li><li>Manage product life cycle (including modifications, upgrades and maintenance) through end of life.</li><li>Lead coordination and documentation of project activities including product introduction meetings, design review meetings, and user acceptance testing.</li><li>Partner with IT, consultants, and software vendors to specify, deliver, and maintain solutions and integrations.</li></ul></li><li><strong>People Leadership</strong><ul><li>Trains, mentors and manages assigned staff.</li><li>Creates performance plans, assesses performance, and provides performance feedback.</li></ul></li></ul><br/><h3>What You Need to Succeed at McKinstry</h3><ul><li>Proven experience in product management, with a strong focus on Salesforce products.</li><li>Salesforce certification is highly desirable.</li><li>6-10 years in Product Management or A/E/C industry technology solutions required.</li><li>Knowledge of software development methodologies a plus.</li></ul><br/><h3>PeopleFirst Benefits</h3><p><strong>When it comes to the basics, we have you covered:</strong></p><ul><li>Competitive pay</li><li>401(k) with employer match and profit-sharing plan</li><li>Paid time off and holidays</li><li>Comprehensive medical, prescription, dental, and vision with low or zero deductible options and low out of pocket maximums</li></ul><br/><p><strong>People come first at McKinstry, and we go beyond the basic benefits with:</strong></p><ul><li>Family formation benefits, including adoption and IVF assistance</li><li>Up to 16 weeks paid parental leave</li><li>Transgender inclusive benefits</li><li>Commuter benefits</li><li>Pet insurance</li><li>"Building Good" paid community service time</li><li>Learning and advancement opportunities via McKinstry University</li><li>McKinstry Moves onsite gyms or reimbursement for remote workers</li></ul><br/><p>See benefit plan documents for complete details.</p><br/><p><strong>If you're driven by our vision to build a thriving planet together, McKinstry is the place to build your career.</strong></p><br/><p>The pay range for this position is $99,270- $169,900 per year; however, base pay offered may vary depending on job-related knowledge, skills, and experience. Base pay information is based on market location. A bonus may be provided as part of the compensation package, in addition to a full range of medical, financial, and/or other benefits, dependent on the position offered.</p><br/><p><em>The McKinstry group of companies are equal opportunity employers. We are committed to providing equal employment opportunities to all employees and qualified applicants without regard to sex, gender identity, sexual orientation, age, race, color, creed, marital status, national origin, disability, veteran status, genetic information or any other basis protected by law. This policy applies to all terms and conditions of employment including, but not limited to employment, advancement, assignment, and training. This commitment to Equal Employment Opportunity is made equally as a social responsibility and as an economic and business necessity.</em></p><br/><p><em>McKinstry is a drug-free workplace. Employment is contingent upon successfully passing a pre-employment drug and alcohol test, complying with the requirements of the Immigration Reform and Control Act and a Confidentiality Agreement, in addition to successful outcomes of background and reference checks.</em></p><br/><p><em>Applicants for this role will only be considered if they possess current US Work Authorization, and do not require employer-sponsored VISA support to begin or remain in this role.</em></p><br/><p><em>#LI-AK1</em></p>
#J-18808-Ljbffr

<h3>McKinstry Senior Product Manager Seattle, Washington</h3><p><strong>Build the future, spark innovation and align your career with purpose.</strong></p><p>McKinstry is innovating the waste and climate harm out of the built environment and creating lasting impact. Together, we’re building a thriving planet.</p><p>Buildings are a leading contributor to the climate crisis, generating nearly 40% of total global energy-related carbon emissions. We’re making a lasting impact on our industry and within our communities by addressing the climate, affordability and equity crises through:</p><ol><li>renewables and energy services</li><li>engineering and design</li><li>construction and facility services</li></ol><p>To get where we’re going, we need big thinkers, problem solvers and collaborative mindsets. Does that sound like you?</p><p><strong>The Opportunity with McKinstry</strong></p><p>We are adding a Senior Product Manager to our growing Business Technology division. Responsibilities include:</p><ol><li>Takes the lead and owns a major, large-scale initiative.</li><li>Manage product life cycle (including modifications, upgrades and maintenance) through end of life.</li><li>Lead coordination and documentation of project activities including product introduction meetings, design review meetings, and user acceptance testing.</li><li>Partner with IT, consultants, and software vendors to specify, deliver, and maintain solutions and integrations.</li><li>Trains, mentors and manages assigned staff.</li><li>Creates performance plans, assess performance, and provide performance feedback.</li></ol><p><strong>What You Need to Succeed at McKinstry</strong></p><p>Proven experience in product management, with a strong focus on Salesforce products.</p><p>Salesforce certification is highly desirable.</p><p>6-10 years in Product Management or A/E/C industry technology solutions required.</p><p>Knowledge of software development methodologies a plus.</p><p><strong>When it comes to the basics, we have you covered:</strong></p><ol><li>Competitive pay</li><li>401(k) with employer match and profit-sharing plan</li><li>Paid time off and holidays</li><li>Comprehensive medical, prescription, dental, and vision with low or zero deductible options and low out of pocket maximums</li></ol><p><strong>People come first at McKinstry, and we go beyond the basic benefits with:</strong></p><ol><li>Family formation benefits, including adoption and IVF assistance</li><li>Up to 16 weeks paid parental leave</li><li>“Building Good” paid community service time</li><li>Learning and advancement opportunities via McKinstry University</li><li>McKinstry Moves onsite gyms or reimbursement for remote workers</li></ol><p><strong>If you’re driven by our vision to build a thriving planet together, McKinstry is the place to build your career.</strong></p><p>The pay range for this position is $99,270- $169,900 per year; however, base pay offered may vary depending on job-related knowledge, skills, and experience. Base pay information is based on market location. A bonus may be provided as part of the compensation package, in addition to a full range of medical, financial, and/or other benefits, dependent on the position offered.</p><p>The McKinstry group of companies are equal opportunity employers. We are committed to providing equal employment opportunities to all employees and qualified applicants without regard to sex, gender identity, sexual orientation, age, race, color, creed, marital status, national origin, disability, veteran status, genetic information or any other basis protected by law. This policy applies to all terms and conditions of employment including, but not limited to employment, advancement, assignment, and training.</p><p>McKinstry is a drug-free workplace. Employment is contingent upon successfully passing a pre-employment drug and alcohol test, complying with the requirements of the Immigration Reform and Control Act and a Confidentiality Agreement, in addition to successful outcomes of background and reference checks.</p>
#J-18808-Ljbffr

Mckinstry Business Intelligence Interview Guide

Overview

Mckinstry Business Intelligence Salary

Mckinstry Business Intelligence Interview Process

Mckinstry Business Intelligence Interview Questions

Mckinstry Business Intelligence Jobs