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

Cdw Business Intelligence Interview Guide

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


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

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

Overview

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

Cdw 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

Cdw Business Intelligence Interview Questions

<p>The Senior Software Engineer II - Data will play a pivotal role in building and operationalizing the minimally inclusive data necessary for the enterprise data and analytics initiatives following best practices. The bulk of the data engineer's work would be in building, managing, and optimizing data pipelines and then moving these data pipelines effectively into production for key data and analytics consumers like business/data analysts, data scientists, or any persona that needs curated data for data and analytics use cases across the enterprise.</p><br/><p><b>Key Areas of Responsibility</b></p><ul><li>Develops and maintains scalable data pipelines to support continuing increases in data volume and complexity.</li><li>Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using big data technologies and SQL.</li><li>Collaborates with business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization.</li><li>Collaborate with other technology teams to help engineer data sets that data science teams use to implement advanced analytics algorithms that exploit our rich datasets for statistical analysis, prediction, clustering, and machine learning.</li><li>Responsible for using innovative and modern tools, techniques, and architectures to partially or completely automate the most-common, repeatable, and tedious data preparation and integration tasks in order to minimize manual and error-prone processes and improve productivity.</li><li>Train counterparts such as data scientists, data analysts, and data consumers in data pipelines and preparation techniques, which make it easier for them to integrate and consume the data they need for their own use cases.</li><li>Helps ensure compliance and governance during the use of data.</li><li>Be curious and knowledgeable about new data management techniques and how to apply them to solve business problems.</li></ul><br/><p><b>Qualifications - Internal</b></p><p><b>Education and/or Experience Qualifications</b></p><ul><li>BS or MS degree in Computer Science or a related technical field.</li><li>7+ years data application development experience.</li></ul><br/><p><b>Required Qualifications</b></p><ul><li>Strong experience with various Data Management architectures like Data Warehouse, Data Lake, Data Hub, and the supporting processes like Data Integration, Governance, Metadata Management.</li><li>Extensive experience with popular data processing languages including SQL, PL/SQL, Python, and others for relational databases and on NoSQL/Hadoop oriented databases like MongoDB, Cassandra, and others for non-relational databases.</li><li>Demonstrated ability to build rapport and maintain productive working relationships cross-departmentally and cross-functionally.</li><li>Demonstrated ability to coach and mentor others.</li><li>Excellent written and verbal communication skills with the ability to effectively interact with and present to all stakeholders including senior leadership.</li><li>Strong organizational, planning, and creative problem-solving skills with critical attention to detail.</li><li>Demonstrated success of facilitation and solutions implementation.</li><li>History of balancing competing priorities with the ability to adapt to the changing needs of the business while meeting deadlines.</li></ul><br/><p><b>Preferred Qualifications</b></p><ul><li>Extensive experience with Azure Data Factory.</li><li>Extensive experience working with cloud platforms (at least one of Azure, AWS, GCP).</li><li>Experience with ETL Tools (SSIS, Informatica, Ab Initio, Talend), Python, Databricks, Microsoft SQL Server Platform (version 2012 or later), and/or working in an Agile environment.</li></ul>
#J-18808-Ljbffr

<h3>SR Software Engineer II, Cloud (Azure) Data</h3><br/><p>The Senior Software Engineer II - Data will play a pivotal role in building and operationalizing the minimally inclusive data necessary for the enterprise data and analytics initiatives following best practices. The bulk of the data engineer's work would be in building, managing and optimizing data pipelines and then moving these data pipelines effectively into production for key data and analytics consumers like business/data analysts, data scientists or any persona that needs curated data for data and analytics use cases across the enterprise.</p><br/><p><b>Key Areas of Responsibility</b></p><ul><li>Develops and maintains scalable data pipelines to support continuing increases in data volume and complexity.</li><li>Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using big data technologies and SQL.</li><li>Collaborates with business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization.</li><li>Collaborate with other technology teams to help engineer data sets that data science teams use to implement advanced analytics algorithms that exploit our rich datasets for statistical analysis, prediction, clustering and machine learning.</li><li>Responsible for using innovative and modern tools, techniques and architectures to partially or completely automate the most-common, repeatable and tedious data preparation and integration tasks in order to minimize manual and error-prone processes and improve productivity.</li><li>Train counterparts such as data scientists, data analysts, data consumers in data pipelines and preparation techniques, which make it easier for them to integrate and consume the data they need for their own use cases.</li><li>Helps ensure compliance and governance during use of data.</li><li>Be curious and knowledgeable about new data management techniques and how to apply them to solve business problems.</li></ul><br/><p><b>Education and/or Experience Qualifications</b></p><ul><li>BS or MS degree in Computer Science or a related technical field.</li><li>7+ years data application development experience.</li></ul><br/><p><b>Required Qualifications</b></p><ul><li>Strong experience with various Data Management architectures like Data Warehouse, Data Lake, Data Hub and the supporting processes like Data Integration, Governance, Metadata Management.</li><li>Extensive experience with popular data processing languages including SQL, PL/SQL, Python, others for relational databases and on NoSQL/Hadoop oriented databases like MongoDB, Cassandra, others for nonrelational databases.</li><li>Demonstrated ability to build rapport and maintain productive working relationships cross-departmentally and cross-functionally.</li><li>Demonstrated ability to coach and mentor others.</li><li>Excellent written and verbal communication skills with the ability to effectively interact with and present to all stakeholders including senior leadership.</li><li>Strong organizational, planning and creative problem solving skills with critical attention to detail.</li><li>Demonstrated success of facilitation and solutions implementation.</li><li>History of balancing competing priorities with the ability to adapt to the changing needs of the business while meeting deadlines.</li></ul><br/><p><b>Preferred Qualifications</b></p><ul><li>Extensive experience with Azure Data Factory.</li><li>Extensive experience working with cloud platform (at least one of Azure, AWS, GCP).</li><li>Experience with ETL Tools (SSIS, Informatica, Ab Initio, Talend), Python, Databricks, Microsoft SQL Server Platform (version 2012 or later), and/or working in an Agile environment.</li></ul>
#J-18808-Ljbffr

<p><strong>Senior Java Engineer</strong></p><p><strong>Bellevue, WA</strong></p><p><strong>Full Time / Contract-to-Hire</strong></p><p><strong> </strong></p><p>CDW has an excelling job opportunity for an experienced Java Engineer with 10+ years of experience to join our dynamic team. This position involves working with Java, Spring Boot, and SQL databases, with a focus on integrating systems for a global membership program.</p><p><br></p><p><strong>Key Responsibilities:</strong></p><ul><li>Design and implement major features autonomously with a focus on scalable, reliable solutions.</li><li>Collaborate with an architect and mentor junior engineers.</li><li>Contribute to the integration of Global Membership systems (Phase 1: scanner installations across stores).</li><li>Enhance member experience through identity verification and seamless store interactions.</li></ul><p><br></p><p><strong>Desired Skills & Experience:</strong></p><ul><li>10 (ten) years of software development experience</li><li>Proficiency in Java, Spring Boot, and SQL databases.</li><li>Knowledge of Azure functionalities (not required to be a cloud expert).</li><li>Experience designing large features is a plus.</li><li>Bonus if familiar with C# and .NET technologies (future plans to add this into this environment in the future.)</li></ul><p><br></p><p><strong>Work Environment:</strong></p><ul><li>Hybrid role: 3 days in-office (Tues-Thurs), 2 days remote (Mon & Fri).</li></ul><p><br></p><p>Join a growing team working on cutting-edge technologies in a collaborative, mentorship-driven environment. Send your resume to kaci.railey@cdw.com</p>

Description
Bring your IT career and talents to CDW, where you can have a greater impact, be inspired by our mission and excited about your career and future. A Fortune 200 leader, we’re the driven professionals and technology experts companies turn to most to solve their IT challenges.
CDW is a leading multi-brand provider of information technology solutions to business, government, education and healthcare customers around the Globe. A Fortune 500 company and member of the S&P 500 Index, CDW was founded in 1984 and employs over 15,000 coworkers, with headquarters across the United States, United Kingdom and Canada.
CDW prides itself on “making amazing happen”. Our relationships are fueled by our deep expertise and are grounded in the CDW Way. Our empowering leadership makes things happen and inspires their teams to do the same. From the teammates beside us to the leaders who guide us, we move forward together.
Job Summary
CDW UK’s Business Transformation are responsible for driving and accelerating change and transformation across people, process, and systems. Its role is to:
Provide portfolio management for all change initiatives ensuring they are assessed, prioritised, sequenced and governed to maximise benefit to CDW’s customers and co-workers, supported by robust Change Management
Support change initiatives with additional resource and skills, from Project Managers to Business Analysts and technical experts.
Own some of the major 70+ business-wide initiatives including Robotic Process Automation, ServiceNow implementation, Process Re-engineering, and ERP replacement.
CDW is undergoing a roll out of our Azure data platform, and we are looking for a Data Engineer to join a growing team to ingest, cleanse and model data into single source of truth Kimball datasets, used for Business Intelligence reporting and Data Science machine learning use cases.
Key responsibilities
Ingest data from various sources, including on premise SQL databases, REST API’s, Apache Kafka streams, etc.
Define and apply cleansing rules to the data to ensure meets quality expectations.
Define and model data into single source of truth Kimball datasets, e.g. dimensions and facts.
DevOps approach to software; create high quality code using traditional software practices, such as building, linting, unit and integration testing, repositories, CI/CD, peer reviews, etc.
DevOps approach to support; monitor pipelines to ensure businesscritical data pipelines are processed meeting time constraint and data quality expectations (including implementing reactive changes where applicable).
Drives and Integrates into the data team’s WOW, including backlog refinement, sprint planning, demonstrations, and retrospectives, including translation of user requirements into technical requirements including complexity estimation, implement into sprint cycles, collaboration into process improvement, etc.
Based on requirements, perform ad-hoc analysis of structured and unstructured data across multiple data sources to inform solution design.
Document datasets in data catalogue, including ownership, stewardship, dictionaries, glossaries, lineage, sensitivity, etc.
Ownership of Work Items and works with data owners / stewards to ensure high quality, aligned deliveries, and compliance with legislation, such as GDPR, e.g. PII vs non-PII, data retention, etc.
Document solution design in wiki.
The above is not an exhaustive list of duties and you will be expected to perform different tasks as necessitated by your changing role within the organisation and the overall business objectives of the organisation.
Qualifications, Skills & Experience
Must Have:
Architecture, modelling and leadership skills
Strong Azure data skills, including:
Azure Data Factory V2
Azure Data Lake Storage V2
Azure Databricks
Azure Function Apps& Logic Apps
Azure Stream Analytics o Azure Resource Manager skills (Terraform, Azure Portal, Az CLI and Az PowerShell)
Strong PySpark, Delta Lake, Unity CatLog and Python skills. o Includes ability to write unit and integration tests in Python with unittest, pytest, etc.
Strong understanding of software development practices, such as SOLID principals, structuring code, testing, IOC, etc.
Strong repositories, CI/CD skills.
Strong knowledge of Kimball data modelling, such as star schema, snowflake, etc.
Strong SQL skills.
Strong data analysis skills.
Excellent written and verbal communication skills
A minimum of 2 years of experience as an Architect.
A demonstrable track record of getting stuff done whilst managing competing pressures and deadlines and retaining an eye for detail and quality.
A passion for technology and its ability to have a positive impact on business.
Nice To Have:
Azure DevOps (git, multistage YAML, etc.)
Other languages, such as C#, PowerShell
IaC, e.g. Terraform, ARM, Bicep, etc.
Test driven development (TDD)
Streaming technologies, such as Azure Stream Analytics, Spark Structured Streaming, etc.
Power BI Engineering experience
Certified SCRUM Developer (CSD)
Machine learning and Artificial intelligence
Essential Attributes
Be a leader who can manage, inspire, and live by the CDW code.
Highly motivated self-starter with ability to work with executives, managers, and individual contributors at all levels.
Passionate about what they do and making a difference.
Exceptional problem-solving skills and be able to multitask and manage multiple work streams and problems simultaneously.
The ability to prioritise tasks through organisation and delegation is essential.
To demonstrate a positive, proactive, results driven team approach.
A highly energetic individual with a passion to lead, develop and contribute.
Able to demonstrate adaptability in response to changing needs and priorities.
Reliable, tolerant, and dependable under pressure
Able to work to deadlines.
Has a professional ‘can do’ attitude and approach
Who we are:
CDW is a leading technology solutions provider to business, government, education and healthcare organizations across the globe. Our fingerprints can be found on technology in workplaces of more than 250,000 companies; from fresh-faced start-ups to international conglomerates. With the breadth of products and services we offer, there is no request too big or too small.
What you can expect from us: Culture, coworkers, careers.
CDW is not only the People Who Get IT but the People who get People. Our relationships are fueled by our deep expertise and grounded in the CDW Way. Our empowering leadership makes things happen and inspires their teams to do the same. From the teammates beside us to the leaders who guide us, we move forward together. At CDW, you’ll work with people who inspire you. People with positive, success-driven attitudes who you will learn from and forge strong relationships with. Bring your best true self—and your best ideas—to CDW. Because diverse perspectives bring forth better problem solving—and better solutions for our customers on a rapidly evolving technology landscape.

Cdw Business Intelligence Interview Guide

Overview

Cdw Business Intelligence Salary

Cdw Business Intelligence Interview Process

Cdw Business Intelligence Interview Questions

Cdw Business Intelligence Jobs