The C.H. Robinson Business Intelligence interview guide, interview questions, salary data, and interview experiences.

C.H. Robinson Business Intelligence Interview Guide

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


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

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

Overview

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

C.H. Robinson Business Intelligence Interview Process

<p>Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.</p>

<p>Given two tables: <code>employees</code> and <code>projects</code>, find the sum of the salaries of all the employees who didn’t complete any of their projects.</p>

<p>Clarification:</p>

<p>We will consider a project unfinished if it has no end date (its <code>End_dt</code> is <code>NULL</code>).</p>

<p>Given this, we’ll say an employee didn’t finish any of their projects when:</p>

<ul>
<li>They were assigned at least one project.</li>
<li>None of their projects have an <code>End_dt</code>.</li>
</ul>

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

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

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>id</th>
<th>salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>projects</code> table</p>

<table>
<thead>
<tr>
<th>employee_id</th>
<th>project_id</th>
<th>Start_dt</th>
<th>End_dt</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>INTEGER</td>
<td>DATETIME</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>total_slack_salary</th>
</tr>
</thead>

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


Find the total salary of slacking employees.

Slacking Employees Salaries

<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>You have been given a table <code>tbl_numbers</code> with only one column: <code>int_numbers</code>.  It can have one integer number value per row in a sequential manner.</p>

<p>Write a query to return the number repeated by one times its own value.</p>

<p>For example, the integer number 5 would appear five times in the output (1 times 5).</p>

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

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

<p><code>tbl_numbers</code> table</p>

<table>
<thead>
<tr>
<th>int_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>seq_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>


Sequentially Fill in Integers

C.H. Robinson Business Intelligence Interview Questions

Employer Industry:  Logistics and Supply Chain Management
Why consider this job opportunity:
Salary up to $196,400.00
Comprehensive benefits package including medical, dental, vision, and life insurance
Paid parental leave and generous paid time off (PTO)
Opportunities for career development and networking
Supportive and inclusive workplace culture
Chance to work on innovative projects that transform the logistics industry
What to Expect (Job Responsibilities):
Develop software and design solutions independently to meet customer requirements
Collaborate with engineering product managers to translate requirements into detailed designs
Conduct code reviews and write unit, integration, and acceptance tests to improve code quality
Optimize and refactor code to enhance performance and maintainability
Mentor and coach other software engineers through design and code reviews
What is Required (Qualifications):
4+ years of experience developing and implementing commercial software
3+ years of experience creating applications in an object-oriented environment (e.g., C#, .NET, Java)
Experience with relational and non-relational databases (e.g., MS SQL, MongoDB)
Proficiency in HTTP and REST architecture
Bachelor’s degree in Computer Science or related field, or equivalent work experience
How to Stand Out (Preferred Qualifications):
Experience in system integration or global projects
Familiarity with transportation, logistics, or business systems
Proven track record of delivering software in an agile environment
Experience building cloud-native applications (e.g., Azure, AWS)
A strong customer focus with effective communication skills
We prioritize candidate privacy and champion equal-opportunity employment. Central to our mission is our partnership with companies that share this commitment. We aim to foster a fair, transparent, and secure hiring environment for all. If you encounter any employer not adhering to these principles, please bring it to our attention immediately.
We are not the EOR (Employer of Record) for this position. Our role in this specific opportunity is to connect outstanding candidates with a top-tier employer.

#J-18808-Ljbffr

C.H Robinson is seeking a Principal Data Engineer who will take on the technical responsibility for our data architecture and strategy. You will collaborate with enterprise architecture, engineering, data, and analytics teams to design and implement enterprise-wide data solutions. You will anticipate business needs and apply technical expertise to drive architectural change that aligns with our long-term vision. You will contribute to architecture and development of enterprise data warehouse designs and development, and review team engineering practices for continuous improvement. You are responsible for providing technical guidance to our leadership team while also driving strategic projects throughout our enterprise.
This position is open to candidates located in Minneapolis, Chicago, or Kansas City. In this role, you will engage with your peers from the comfort of your own space, using cutting-edge tools to ignite creativity and deliver impactful results. Enjoy the flexibility and autonomy of a fully remote position, while still being an integral part of our dynamic team.
DUTIES AND RESPONSIBILITIES
The duties and responsibilities of this position consists of, but are not limited to, the following:
- Design data and information solutions that align to the long-term plan for a service or product based on deep expertise and customer insights
- Partner with various engineering teams to create and manage a long-term data and information architecture and execution roadmap for a product or service
- Review designs and implementation to ensure alignment with our long-term vision
- Drive architectural enterprise change and influence strategic business initiatives
- Define data and information solutions across multiple products or services
- Ensure consistent, usable, forward-looking, maintainable test infrastructure; draw from a large base of design patterns, is an expert in available technologies, and is adept at identifying practices that work well
- Optimize, refactor, and reuse code to improve performance and maintainability while ensuring maximum efficiency, effectiveness, and return on investment
- Lead code reviews across the product or service, understand the root causes of issues, and find ways to resolve them
- Apply technical expertise to solve problems and enable the team to deliver quality designs
- Develop and maintain thorough architectural documentation for the product or service
- Design products or services by using secure programming patterns and by finding, fixing, and enhancing security in existing applications
- Ensure security best practices are part of design and implementation of new features and applications
- Demonstrate strategic understanding of the timing and rationale for design choices, within the scope of work
- Assist in incubating new projects and technologies to enable the next wave of customer scenarios
- Provide technical guidance and mentorship to engineering teams through technical POCs, shared frameworks, and desired best practices and patterns for software development, delivery and management
- Ensure that teams across the organization have the appropriate engineering lifecycle that provides for task estimation, design and code review, bug triage, code check-in, testing, and performance standards to meet customer and business goals
- Collaborate across the organization to define new ways of thinking to improve quality, engineering excellence, and productivity
- Tailor communication to a variety of audiences and perspectives and anticipate issues to prevent conflict
- Other duties or responsibilities as assigned according to the team and/or country specific requirements
Required Qualifications:
- Bachelor's degree from an accredited college or university in Computer Science, Software Engineering, IS, MIS, or other technology degree or minimum of 4 years of equivalent work experience and high school diploma/GED
- Minimum 8 years of experience designing and driving implementation of large-scale software products or services that span multiple systems
- Experience working on large-scale data sets in a commercial environment
- Experience building and modeling data in relational and non-relational data storage technologies including schema design, stored procedure development and performance and optimization techniques (e.g. SQL Server, Postgres, Mongo, Cosmos, etc.)
- Experience implementing and designing data acquisition, data curation, and data analysis
- Experience establishing testing patterns, acceptance testing criteria, and reviewing others' automated tests
- Experience with version control systems (ex. GIT, GitHub, TFS, etc.)
- Experience with microservice architecture, CQRS, event driven and eventually consistent system design patterns and system flows
- Experience with CI/CD continuous integration / continuous deployment practices
- Experience orchestrating data transformation through cloud native platforms (ex. Azure, AWS, GCP)
- Experience with data streaming architecture and frameworks (Kafka, ESB)
Preferred Qualifications:
- Experience working on large-scale open source or inner source software development
- Experience in system integration projects or global projects
- Experience with machine learning models and data science solutions
- Experience with modern development languages (e.g. .Net CORE, C#, Java)
- Experience with thin-client development (e.g. HTML/CSS, JavaScript, JS frameworks)
- Proven record of strong decision-making, conflict resolution, follow through and building technical relationships with senior executives
- Possess solid communication skills and strong customer focus
- Effective collaborator, experienced in creating technical partnerships across teams
- Experience directly or indirectly leading high performing teams with the ability to assess and grow software engineering talent
- Ability to appreciate complex problems with a thorough design and collaborate with multiple partners on common goals
- Proven track record of effectively delivering results in a fast-paced environment while managing multiple priorities
- Contributions to open source projects, publicly available frameworks and/or patents
- Values a diverse and inclusive work environment
We will review applications for this role on an ongoing basis and encourage all interested candidates to apply at their earliest convenience.
Compensation Range
$146,600.00 - $251,400.00
The base pay range displayed on the job posting reflects the minimum and maximum base pay for this specific location. Your individual base pay within this range is determined by job-related skills, experience, and relevant education or training. Compensation details listed in this posting reflect the base pay only and do not include additional variable compensation.
Questioning if you meet the mark? Studies have shown that some individuals may be less likely to apply unless they match the job description exactly. Here at C.H. Robinson, we're building an inclusive workplace where all employees feel they belong. If this position excites you, we welcome you to apply whether you check all the preferred qualifications or just a few. You may just be our next great fit!
Equal Opportunity
C.H. Robinson is proud to be an Equal Opportunity Employer. We are committed to a workplace and performance culture that reflects the strengths of our worldwide marketplace. We value unique experiences and diverse backgrounds of our people within our company, our business relationships, and our communities. We're committed to providing an inclusive environment, free from harassment and discrimination, where all employees feel welcomed, valued and respected.
EOE//Disabled/Veteran
Benefits
Your Health, Wealth and Self
Your total wellbeing is the foundation of our business, and our benefits support your financial, family and personal goals. We provide the top-tier benefits that matter to you most, including:
- Two medical plans (including a High Deductible Health Plan)
- Prescription drug coverage
- Enhanced Fertility benefits
- Flexible Spending Accounts
- Health Savings Account (including employer contribution)
- Dental and Vision
- Basic and Supplemental Life Insurance
- Short-Term and Long-Term Disability
- Paid and floating holidays
- Paid time off (PTO)
- Paid parental leave
- Paid time off to volunteer in your community
- Charitable Giving Match Program
- 401(k) with 6% company matching
- Employee Stock Purchase Plan
- Plus a broad range of career development, networking, and team-building opportunities
Dig in to our full list of benefits on OUR CULTURE (https://jobs.chrobinson.com/culture) page.
Why Do You Belong at C.H. Robinson?
C.H. Robinson solves logistics problems for companies across the globe and across industries, from the simple to the most complex. With $22 billion in freight under management and 19 million shipments annually, we are one of the world's largest logistics platforms and rank in the FORTUNE 200. We've been an innovator in logistics for over 100 years. Our global suite of services accelerates trade to seamlessly deliver the products and goods that drive the world's economy. With the combination of our multimodal transportation management system and expertise, we use our information advantage to deliver smarter solutions for more than 90,000 customers and 450,000 contract carriers on our platform. Our technology is built by and for supply chain experts to bring faster, more meaningful improvements to our customers' businesses.
As a responsible global citizen, we contribute millions of dollars to support causes that matter to us and our people. FORTUNE has named C.H. Robinson one of the World's Most Admired Companies 2024, showcasing our position as a leader in our industry. Our commitment to excellence is further affirmed by being named a Great Place to Work 2023-24 by the Great Place to Work Institute, one of Forbes' Best Employers for Diversity and one of America's Greatest Workplaces in 2023 by Newsweek. Join us as we collaborate, innovate, and work as one global team to make life better and more sustainable for our customers, communities, and world. For more information, visit us at www.chrobinson.com .

#J-18808-Ljbffr

Question	Topic	Difficulty	Ask Chance
Slacking Employees Salaries	SQL	Medium	Very High
Player Analysis	SQL	Easy	Very High
Sequentially Fill in Integers	SQL	Hard	Very High

C.H. Robinson Business Intelligence Interview Guide

Overview

C.H. Robinson Business Intelligence Interview Process

C.H. Robinson Business Intelligence Interview Questions

C.H. Robinson Business Intelligence Jobs