Prepare for and practice interview questions from Central Business Solutions.

Central Business Solutions Interview Questions

Central Business Solutions Interview Guides

<p>Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.</p>

<p>How would you assess the validity of the result?</p>


Experiment Validity

<p>Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.</p>

<p>Write a query to randomly sample a row from this table.</p>

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

<p><code>big_table</code> table</p>

<table>
<thead>
<tr>
<th>Columns</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>


Write a query to randomly sample a row from a big table.

Random SQL Sample

<p>Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.</p>

<p>What factors could have biased this result, and what would you look into?</p>


<p>What could potentially bias the average boarding time in favor of an airline that only flies domestically?</p>

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Central Business Solutions Salaries by Position

<p>Position Role/Tile: Business Analyst

Location: Atlanta, GA / Remote

The Department of Community Affairs (DCA) would benefit from a business analyst to develop a high-level master plan for digitization of paper documents and the creation of digital workflows to create process and work duty efficiencies.
This position writes, revises, and models the business requirements for clarity, project understanding, and problem-solving.
This position will perform a needs assessment for all the agency programs (approximately 60) to determine what, if any, digital workflows would be helpful to adopt and put together the requirements needed to provide to a vendor to complete a digitalization project in the future.
This position provides recommendations based on the analysis and revises existing documentation and/or creates new related project documentation (e.g., business and technical project artifacts) for various audiences.
This person will need to have a thorough understanding of the process of the digitization of documents and be proficient in the documentation skills needed to document the current environment, make recommendations regarding future process improvements, and if necessary, create and/or re-engineer processes that appear inefficient or inadequate.
Knowledge of Content Manager or any other Enterprise Content/Document management system and document scanning processes is required.
Expert use of Visio, Excel, SharePoint, and other MS products is also required.
Essential Functions

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
50% - Business Process Analysis / Requirements Gathering
Identifies opportunities for improving business processes through information systems.
Researches, plans, gathers, and analyzes business and user requirements for projects.
Interfaces with project subject matter experts to analyze and design solutions and to provide recommendations on deliverables.
Assesses and analyzes processes and procedures to identify improvement opportunities.
Creates content that is easy to read, thorough, flows logically, edited, indexed, and formatted.
Elicits requirements utilizing interview, document analysis, business process descriptions, use cases, scenarios, business, task, and workflow analysis.
Translates requirements into a document ensuring requirements are clear, concise, and repeatable.
Analyzes, defines, and documents requirements for data, workflow, logical processes, hardware and operating system environment, internal and external checks and controls, interfaces with other systems, and outputs.
Communicates user needs to IT and project teams through a variety of project-specific documents (e.g., TDD, FDD, etc.).
Monitors, identifies, and reports information security risks to protect the enterprise’s IT assets.
Partners with the IT Security team in the prevention, analysis, and mitigation of IT security-related items.
Identifies and reports on compliance issues that require follow-up or investigation.
Tracks and fully documents changes for functional and business specifications.
10% - Stakeholder Interfacing
Consults with Project Managers, subject matter experts (SMEs), technical staff, and stakeholders to identify, define, interpret, integrate, and document business needs and objectives, current operational procedures, problems, input and output requirements, and levels of systems access.
Acts as a liaison between users and IT in the analysis, design, configuration, testing, and maintenance of case management systems to ensure optimal operational performance.
Provides assistance by responding to inquiries from others regarding errors, problems, or questions about systems.
40% - Technical Writing/Content Management
Writes, retains, and maintains system requirements and design documentation.
Creates detailed project documents, workflows, and diagrams to provide clearly defined project deliverables.
Creates and organizes new supporting documents.
Creates user documentation to increase users' understanding of the end product and/or process re-engineering.
Edits content to ensure compliance with the organizations' style guidelines and branding consistency.
Assists in organizing and maintaining the project’s SharePoint site and other document repositories.
Communicates and documents updates for users.

#J-18808-Ljbffr</p>

Central Business Solutions Interview Questions

Central Business Solutions Interview Guides

Central Business Solutions Interview Questions

Central Business Solutions Salaries by Position

Central Business Solutions Opening Jobs