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

Cubic Corporation Business Intelligence Interview Guide

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


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

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

Overview

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

Cubic Corporation 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>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

Cubic Corporation Business Intelligence Interview Questions

<strong><b>Business Unit:</b></strong> <br><br>Cubic Defense <br><br><strong><b>Company Details:</b></strong> <br><br>Cubic offers an opportunity to provide innovative technology for government and commercial customers around the globe, helping to solve their future problems today. We're the leading integrator of payment and information technology and services for intelligent travel solutions worldwide, and the leading provider of realistic combat training systems, secure communications and networking and highly specialized support services for military and security forces of the U.S. and allied nations. If you have an entrepreneurial spirit and thrive in an innovative environment, we want to talk to you about your next role at Cubic! We are seeking employees inspired by technology, and motivated by the rewards of hard work, commitment, teamwork, quality, integrity, and respect. We invite you to explore opportunities with Cubic. <br><br><strong><b>Job Details:</b></strong> <br><br><b>Job Summary: </b> <br><br>Directs a comprehensive product strategy from product conception and definition through end of life. Drives the creation, development and delivery of new hardware and network communications products supporting the defense market space. Performs ongoing market research, reviews customer satisfaction, works with development teams and measures product success. Formulates and executes long-term plans for cost/profit control. Selects, develops, and evaluates personnel to ensure the efficient operation of the function. This position typically works under limited supervision and direction. Incumbents of this position will regularly exercise discretionary and substantial decision-making authority. <br> <br><b>Essential Job Duties and Responsibilities:</b> <br> <ul><li>Responsible for planning and execution of product lines throughout their lifecycle including gathering and prioritizing product and customer requirements, defining product vision and working closely with management, development teams, engineering, sales, marketing, and other support groups to insure revenue, profit and customer expectations goals are met. </li><li>Work closely with upper management to develop long term product development and sales strategies for the company. </li><li>Understand, articulate, and capture customer market problems and then translate them into software and hardware requirements for product development teams. </li><li>Provide sales and business development teams with marketing strategy and guidance for selling, promoting products, and meeting customer needs. </li><li>Work closely with global team of support and sales personnel to meet customer and contractual requirements. </li><li>Monitor and analyze market trends and competitors to make sure product lines stay competitive and fulfill customer needs. </li><li>Understand all aspects of customer's business needs and how they can apply to our company's product lines. </li><li>Contributor in coordinating quote and proposal activities through business development and contracts to meet customer needs. </li><li>Generate business cases for product extensions and product enhancements to meet market demands and new sales potentials. </li><li>Develops investment plans for each product so that products will be up to date and meet all market driven and customer requirements. </li><li>Works with third parties to develop business strategies as well as teaming and license agreements. </li><li>Works closely with business development, corporate communications and local marketing team to insure advertising materials are current and available. </li><li>Insures all customer requirements and expectations are met by providing superior customer support and service. </li><li>Works to make sure all contractual requirements are satisfied including products, data and services. </li><li>Serves as expert with respect to the customer and competitive environment. </li><li>Responsible for developing consumer and channel communication strategies. </li><li>Responsible for the development and management of Radio Over IP (ROIP), Land Mobile Radio (LMR) gateway products and Push to Talk (PTT) systems and architectures. </li><li>Hybrid position with 1 day per week to work remotely. #LI-hybrid </li></ul> <br><br><b>Minimum Job Requirements: </b> <br> <br>Four-year college degree, or equivalent, in product line, business or program leadership fields; plus a minimum of eight years experience working as a product/consumer manager in a software or hardware environment. Must have experience in launching new products into the consumer market and evolving these into viable company revenue streams. Excellent teamwork skills. Demonstrated experience in creating product specifications, gathering customer requirements, performing competitive analysis and/or market research. Background working with ROIP, LMR and PTT businesses, service providers, acquisitions and business development arenas are preferred. Knowledge of ROIP, Internet Protocol (IP) and Radio Gateway systems preferred. Able to make decisions independently and coordinate large teams. Excellent presentation, written and verbal communication skills. <br> <br>The description provided above is not intended to be an exhaustive list of all job duties, responsibilities and requirements. Duties, responsibilities and requirements may change over time and according to business need. <br><br>Cubic Pay Range: <br><br>$120,000 - $158,163 + benefits. <br><br>The Cubic pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law. <br><strong><b>Worker Type:</b></strong> <br><br>Employee

<p>Business Unit: Cubic Defense Company Details: When you join Cubic, you become part of a company that creates and delivers technology solutions in transportation to make people's lives easier by simplifying their daily journeys, and defense capabilities to help promote mission success and safety for those who serve their nation. Led by our talented teams around the world, Cubic is committed to solving global issues through innovation and service to our customers and partners. <br> <br>We have a top-tier portfolio of businesses, including Cubic Transportation Systems (CTS) and Cubic Defense (CD). Explore more on Cubic.com. Job Details: </p><p><b>Job Description Summary</b> </p> <p>Cubic is seeking a talented and motivated C++ Software Engineer to join our dynamic team of geospatial engineers. We work on mission-critical software applications at the enterprise level and at the edge, and we are looking for an engineer who can help us bridge that gap. The ideal candidate will have a dual role, serving not only as a software developer but also as a test engineer, ensuring the quality and reliability of our products. Hybrid position with 3 days on-site weekly. #LI-hybrid </p> <p><b>Key Responsibilities:</b> </p> <p>* Design, develop, and maintain high-quality C++ software applications. </p> <p>* Write clean, efficient, and well-documented code. </p> <p>* Develop and execute comprehensive test plans and test cases to ensure software quality. </p> <p>* Perform debugging and troubleshooting to identify and resolve issues in a timely manner. </p> <p>* Collaborate with cross-functional teams to define, design, and deliver new features. </p> <p>* Participate in Agile development processes, including sprint planning, stand-ups, and retrospectives. </p> <p>* Utilize JIRA for task management, bug tracking, and project tracking. </p> <p>* Contribute to the continuous improvement of the development and testing processes. </p> <p>* Stay up-to-date with industry trends and best practices in software development and testing. </p> <p><b>Qualifications:</b> </p> <p>* Bachelor's degree in Computer Science, Software Engineering, or a related field, plus 8 years of related experience. </p> <p>* Proven experience in C++ software development. </p> <p>* Active Secret clearance is required, must be eligible for TS/SCI. </p> <p>* Strong understanding of software development best practices and design patterns. </p> <p>* Experience in developing and executing test plans and test cases. </p> <p>* Familiarity with Agile development methodologies. </p> <p>* Proficiency in using JIRA for task management and bug tracking. </p> <p>* Excellent problem-solving skills and attention to detail. </p> <p>* Strong communication and teamwork skills. </p> <p>* Ability to work independently and manage multiple tasks simultaneously. </p> <p><b>Preferred Qualifications:</b> </p> <p>* Experience with geospatial technologies or pixel processing and applications. </p> <p>* Experience with programming language in Java. </p> <p>* Experience working cross platform in Windows and Linux </p> <p>* Experience with scripting in Bash </p> <p>* Knowledge of continuous integration and continuous deployment (CI/CD) processes. </p> <p>* Experience with version control systems, such as Git. </p> <p><b>What We Offer:</b> </p> <p>* Competitive salary and benefits package. </p> <p>* Opportunities for professional growth and development. </p> <p>* Collaborative and innovative work environment. </p> <p><b>Additional Job Description</b> </p> <p>The Engineering function is responsible for all engineering activities within a firm to ensure that business objectives are met. Includes the creation, development, design, and improvement of products, equipment, facilities, services, standards, and procedures in all engineering fields. <br> <br>Engineering > Software <br>The Software Engineering area is responsible for the development of computer programming systems and applications including the design, coding, testing and deployment of products and solutions to meet firm obligations. <br> <br><b>Role Knowledge and Application</b> <br>Exhibits advanced wide-ranging experience, using in-depth professional knowledge, acumen, concepts and company objectives to develop, resolve complex models and procedures. Provides solutions to issues in creative and effective ways. Understands the interrelationships of different disciplines. Directs the application of existing principles and guides development of new policies and ideas. <br> <br><b>Complexity and Problem-Solving</b> <br>Understands and works on complex issues where analysis of situations or data requires an in-depth evaluation of variable factors. Determines methods and procedures on new assignments. Exercises judgment in selecting methods, evaluating, adapting of complex techniques and evaluation criteria for obtaining results. <br> <br><b>Supervision</b> <br>Work is reviewed upon completion and is consistent with departmental objectives. <br> <br><b>Collaboration and Interaction</b> <br>Networks with key contacts outside own area of expertise. Adapts style and uses persuasion in delivering messages that relate to the wider firm business. Frequently advises others on complex matters. May be accountable through team for delivery of tactical business targets. <br> <br><b>Recommended Background and Experience</b> <br><i>The education/experience information should only be used for requisitions/external postings in accordance with local regulations</i> <br>Typically requires a minimum of 8 years of related experience with a Bachelor's degree; or 6 years and a Master's degree; or a PhD with 3 years experience; or equivalent experience. Some barriers to entry exist at this level, requiring department review. </p>Worker Type: Employee

Cubic Corporation Business Intelligence Interview Guide

Overview

Cubic Corporation Business Intelligence Salary

Cubic Corporation Business Intelligence Interview Process

Cubic Corporation Business Intelligence Interview Questions

Cubic Corporation Business Intelligence Jobs