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

Metaphase Consulting Business Intelligence Interview Guide

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


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

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

Overview

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

Metaphase Consulting 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 the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

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

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

<p><code>employees</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>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</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>team</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>manager</code></td>
<td>VARCHAR</td>
</tr>

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


Manager Team Sizes

<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

Metaphase Consulting Business Intelligence Interview Questions

<p>DescriptionAt MetaPhase, we believe Quirky is Cool and being authentic is the only way to be! We take the work we do very seriously and do a lot of important mission-focused work for our clients. We are individuals with different passions and strengths who take as much joy in the work we do as from those we work with. Today, we have a team that is invested in creating new solutions that lean forward, challenge the status quo, but also reflect our intimate knowledge of our customers' business. Over the years we have fostered a culture in which we are united by shared values-passion, solidarity, generosity, curiosity, and boldness-and these come alive in the work we do and how we do it. Together, we know our people are our difference-for our clients and our colleagues. Are you ready to: Work alongside a dedicated and diverse set of people to offer honest advice and practical guidance to our clients? Learn and grow by taking advantage of every opportunity available to you? Join a company which prides itself on its shared values and inclusive culture? Be the difference and make it happen? Role Summary We are looking for a dynamic team player to help U.S. Immigration and Customs Enforcement (ICE) within the Homeland Security Investigations (HSI) further automate and implement process efficiencies. In support of this project, MPC is seeking a consultant with five (5+) years of experience to provide business analysis, process improvement, supporting project management activities, and collaborating with cross-functional teams to contribute to the successful delivery of business solutions. What You Will Be Doing Performing typical business analytic functions including, but not limited to, requirements gathering and synthesis, workflow and business process analysis, change management, and program management support Being able to provide agile methodologies in a non-technical background utilizing JIRA and Confluence.Creating communications and presentations, facilitating meetings, tracking decisions/issues/risks, and supporting the team and senior leadership in a fast-paced environment Translating strategy into specific business initiatives and recommendations Understanding the client personalities, environment, and overall project scope in relation to overall mission and organization goals Supporting and directly developing project deliverables with a high degree of quality and accuracy Organizing and using knowledge management tools effectively to support team and client needs Managing both client and company relationships and responsibilities such as training and compliance activities What We Need From You (Required) At least 5 years of work experience with at least 3 years of work experience in management consulting and/or technology transformation efforts At least 1 year of work experience in government-related roles (e.g., in Federal policies and procedures, government contracting and etc.) Self-motivated, detail oriented, and highly organized High level of communication - both verbally and written - skills Technical Writing (SOPs, SOWs & Government Charters) Required software experience: Jira and Microsoft Office (Word, Excel, PowerPoint) Bonus Points (Desired) Experience in developing and using performance metrics to measure, evaluate, and enhance program and client success through program evaluation and performance management techniques Software experience: Power BI or Tableau, ServiceNow, SharePoint, Adobe Experience working within ICE Work Location Arlington VA Travel None Education Level Bachelor's degree in business management or IT related fieldClearance Level Public Trust; U.S. Citizenship required (NO EXCEPTIONS) About MetaPhase ConsultingMetaPhase Consulting is different with a purpose - demonstrating a new approach to the industry that puts employees and culture first! We continue to be recognized by industry as one of the fastest growing and most impactful consultancies in the nation, and are aggressively hiring to grow our team:Fastest GrowingInc 5000 Fastest Growing Company - 2020, 2021, 2022, 2023 Washington Technology Fast 50 Award - 2020, 2021Financial Times America's Fastest Growing Companies - 2021, 2022, 2023Best Places to WorkWashington Post Top Workplaces - 2022, 2023Washington's Business Journal's Best Places to Work - 2021, 2022Virginia Businesses Best Place to Work - 2021, 2022, 2023Northern Virginia Technology Council Top 100 Technology Firms - 2020Company & Individual Awards2021 Washington Business Journal Small Business - CEO of the Year2021 FedScoop 50 - Industry Leadership Award Nominee2021, 2023 Moxie Award Finalist2022 SECAF Government Contractor Awards ($27.5 to $50 Million in Revenue)2022 FedScoop Best Bosses Finalist - Brett McLaren 2022 Washington Business Journal 40 under 40 - Brett McLaren2022 FedHealth IT and G2XChange Women in in Leadership Awards - Beth Angerman2022 George Mason University Prominent Patriots in Business - Fred Costa2022 TiE DC Capital ELITE Award2023 Elev8 Engage GovCon Finalist2023 Maryland Tech Council ICON Awards Finalist for Government Contracting Company of the Year: Over $50 Million2023 Greater Washington Government Contractor of the Year ($25 to $75 million) Awards FinalistMetaPhase Consulting is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, or any other factors protected by federal, state, or local law.</p>

<strong>Description</strong><br> <br> <strong>Description</strong><br><br>At MetaPhase, we believe Quirky is Cool and being authentic is the only way to be! We take the work we do very seriously and do a lot of important mission-focused work for our clients. We are individuals with different passions and strengths who take as much joy in the work we do as from those we work with. Today, we have a team that is invested in creating new solutions that lean forward, challenge the status quo, but also reflect our intimate knowledge of our customers' business. Over the years we have fostered a culture in which we are united by shared values-passion, solidarity, generosity, curiosity, and boldness-and these come alive in the work we do and how we do it. <br><br>Together, we know our people are our difference-for our clients and our colleagues. <br><br><b>Are you ready to:</b><br><ul><li>Work alongside a dedicated and diverse set of people to offer honest advice and practical guidance to our clients? </li><li>Learn and grow by taking advantage of every opportunity available to you? </li><li>Join a company which prides itself on its shared values and inclusive culture? </li><li>Be the difference and make it happen?</li></ul><strong>Role Summary</strong><br><br>MetaPhase Consulting (MPC) is currently supporting our client at the US Department of the Treasury with their project intake and processing functions to include project inquiry, evaluation, estimation, approval, and financial management activities. MetaPhase is seeking a Business Analyst with a minimum of four (4) years of experience supporting business process execution and management in the Federal environment. This individual will help to facilitate routine business operations such as data entry and management, meeting management, document development and refresh, and status reporting. This individual will also be required to consult with office leadership, project analysts, and customers in order to aid in project performance and management activities as well process improvement related initiatives.<br><br><strong>What You Will Be Doing</strong><br><ul><li>Entering and maintaining project and financial related data in ServiceNow.</li><li>Preparing and maintaining reports and records to include capturing, analyzing, detailing, and updated project information (status, metrics, outputs, etc.)</li><li>Gathering, consolidating, and analyzing information via engagement with stakeholders and independent research into existing systems and records in support of responding to data calls. </li><li>Facilitating meetings to include scheduling and capturing, distilling, and distributing meeting minutes.</li><li>Updating existing and developing new: </li><ul><li>Standard Operating Procedures (SOPs)</li><li>Reference Guides</li><li>Templates</li><li>Process Flows</li><li>Forms</li><li>Waivers</li><li>Calendars</li></ul><li>Maintaining and updating SharePoint Site information and repositories with general office and project specific related information.</li><li>Supporting recurring project intake and processing related services and Interagency Agreement (IAA) funding renewals.</li></ul><strong>What We Need From You (Required) </strong><br><ul><li>4+ years of experience supporting a range of standard business functions.</li><li>Strong customer engagement skills, with the ability to successfully communicate with clients and manage the client relationship and expectations.</li><li>Sound understanding of and ability to support financial management related activities.</li><li>Well organized and detail-oriented with the ability to balance multiple work requirements simultaneously.</li><li>Proactive and self-starter mindset in order to ramp up quickly in a dynamic client environment, pivot to new requirements, and adjust to changing direction.</li><li>Strong written and verbal communication skills with demonstrated ability to articulate information in an effective manner.</li><li>Proficient with the Microsoft Office Suite of tools (Word, Excel, PowerPoint).</li><li>Experience utilizing Microsoft Visio, Microsoft SharePoint, and ServiceNow.</li></ul><strong>Bonus Points (Desired)</strong><br><ul><li>Experience gathering technical requirements in support of acquisition initiatives. </li></ul><strong>Work Location</strong><br><br>This position is majority remote, but requires the employee to be within the commuting area of Washington, D.C. to support ad hoc, in-office work requirements. <br><strong>Travel</strong><br><br>None<br><strong>Education Level</strong><br><br>Minimum Bachelor's degree <br><strong>Clearance Level</strong><br><br>Public Trust; U.S. Citizenship required (NO EXCEPTIONS) <br><br><strong>Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is 95-110k.</strong><br><strong>About MetaPhase Consulting </strong><br><br>MetaPhase Consulting is different with a purpose - demonstrating a new approach to the industry that puts employees and culture first! We continue to be recognized by industry as one of the fastest growing and most impactful consultancies in the nation, and are aggressively hiring to grow our team:<br><br>Fastest Growing <br><ul><li>Inc 5000 Fastest Growing Company - 2020, 2021, 2022, 2023 </li><li>Washington Technology Fast 50 Award - 2020, 2021 </li><li>Financial Times America's Fastest Growing Companies - 2021, 2022, 2023</li></ul><br><br>Best Places to Work <br><ul><li>Washington Post Top Workplaces - 2022, 2023 </li><li>Washington's Business Journal's Best Places to Work - 2021, 2022</li><li>Virginia Businesses Best Place to Work - 2021, 2022, 2023</li><li>Northern Virginia Technology Council Top 100 Technology Firms - 2020</li></ul><br><br>Company & Individual Awards<br><ul><li>2021 Washington Business Journal Small Business - CEO of the Year </li><li>2021 FedScoop 50 - Industry Leadership Award Nominee </li><li>2021, 2023 Moxie Award Finalist</li><li>2022 SECAF Government Contractor Awards ($27.5 to $50 Million in Revenue) </li><li>2022 FedScoop Best Bosses Finalist - Brett McLaren </li><li>2022 Washington Business Journal 40 under 40 - Brett McLaren </li><li>2022 FedHealth IT and G2XChange Women in in Leadership Awards - Beth Angerman </li><li>2022 George Mason University Prominent Patriots in Business - Fred Costa </li><li>2022 TiE DC Capital ELITE Award</li><li>2023 Elev8 Engage GovCon Finalist </li><li>2023 Maryland Tech Council ICON Awards Finalist for Government Contracting Company of the Year: Over $50 Million</li><li>2023 Greater Washington Government Contractor of the Year ($25 to $75 million) Awards Finalist</li></ul><br><br>MetaPhase Consulting is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, or any other factors protected by federal, state, or local law.<br><br>#DICE <br><br>#LI-Hybrid

Metaphase Consulting Business Intelligence Interview Guide

Overview

Metaphase Consulting Business Intelligence Salary

Metaphase Consulting Business Intelligence Interview Process

Metaphase Consulting Business Intelligence Interview Questions

Metaphase Consulting Business Intelligence Jobs