The Beacon Street Services Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Beacon Street Services Business Intelligence Interview Guide

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


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

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

Overview

Beacon Street Services 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.

Beacon Street Services 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>Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.</p>

<p>You wish to begin with the age group that is currently generating the most connections (fastest growing).</p>

<p>Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.</p>

<p><em>Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.</em></p>

<p><em>We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

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

<p><strong><code>friend_requests</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>requests_accepted</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>age_groups</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>user_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>age_group</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>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

Beacon Street Services Business Intelligence Interview Questions

Overview:<br/><p style="margin: 0px;"><span style="font-size: 12pt; font-family: verdana, geneva;"><img style="display: block; margin-left: auto; margin-right: auto;" src="https://beaconstreetservices.icims.com/icims2/servlet/icims2?module=AppInert&action=download&id=20216&hashed=1160205364" alt="MarketWiseSolutionsCentered_Logo_Color_TM_RGB_iCIMS" width="500" height="156" /></span></p><p style="margin: 0px;"> </p><p style="margin: 0px;"><span style="font-size: 12pt; font-family: verdana, geneva;"><span style="color: black;">MarketWise Solutions (formerly known as Beacon Street Services) is continuing to build and expand its cloud services platform, the backbone for our data-driven marketing, sales, ecommerce, customer, and billing services. We're currently looking to bring on a <strong>Salesforce</strong> <strong><span style="border: 1pt none windowtext; padding: 0in;">Software Engineer </span></strong><span style="border: none windowtext 1.0pt; padding: 0in;">to help drive continued Salesforce enhancements, but this role will require some experience in other technologies which impact our eco-system including APIs, microservices, and Java applications. <br /><br /></span>This role is perfect for someone who wants to develop systems from concept to fruition that will reach millions of customers using the latest and greatest technologies in our stack, with a focus on <strong>microservices</strong>. The ideal candidate should enjoy a fast-paced environment and building new products at scale, playing with APIs and data, and discovering and exploring new technologies and ideas. <br /><br /></span>Were building 100%-cloud-native, serverless code on the <strong>AWS</strong> and <strong>Salesforce</strong> platforms to support our digital marketing platform.</span></p><p style="margin: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;"> </span></p><p style="margin: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;">Experience with Amazon Web Services, web development, and REST APIs is <u>ideal</u>, but not necessary. Well help you learn everything you need to know. Our team works hard, works smart, and works together. As a member of our team, you will own software development for a user story from design to deployment.</span></p><p style="margin: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;">  </span></p><p style="margin: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;">We work with cool, cutting-edge technology like:</span></p><ul><li><span style="font-family: verdana, geneva; font-size: 12pt;">AWS (Lambda, Step Functions, API Gateway, EC2, SQS, DynamoDB, <br />RDS, S3, Kinesis)</span></li><li><span style="font-family: verdana, geneva; font-size: 12pt;">Salesforce PaaS (Apex, Heroku, Lightning Web Components)</span></li><li><span style="font-family: verdana, geneva; font-size: 12pt;">Java, Angular, TypeScript, Node</span></li><li><span style="font-family: verdana, geneva; font-size: 12pt;">Snowflake database, Looker business analytics</span></li><li><span style="font-family: verdana, geneva; font-size: 12pt;">Event-driven architecture</span></li></ul><br/><br/>Responsibilities:<br/><ul><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Design, develop, modify, test, and support highly reliable and large-scale software applications and services for the cloud that serve millions of customers.</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Participate in software planning, design, and architecture sessions and fully own aspects of the technical solution.</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Must be an active coder in your day-to-day duties with an enthusiasm for technology, particularly with software development across multiple languages.</span></li><li><span style="font-family: verdana, geneva; font-size: 12pt;">Experience with and willingness to develop on the <strong>Salesforce </strong>platform.</span></li><li><span style="font-family: verdana, geneva; font-size: 12pt;">Understand business requirements and translate them into small pieces of a microservice architecture.</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Take accountability for tasks and resolve problems effectively.</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Excellent communication skills (both written and verbal), with the ability to convey technical issues clearly across multiple functional teams.</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Ability to work and thrive in a faced-paced environment. </span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Team oriented, with experience in Agile principles.</span></li></ul><br/><br/>Qualifications:<br/><div class="wpb_text_column wpb_content_element  about-first-pera"><div class="wpb_wrapper"><div class="wpb_text_column wpb_content_element  about-first-pera"><div class="wpb_wrapper"><div class="wpb_text_column wpb_content_element  about-first-pera"><div class="wpb_wrapper"><ul><li><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="color: black;">BS or MS </span>Degree in Computer Science or a similar field is desired, <em>but not required</em>; you should understand data structures and algorithms. </span></li><li><span style="font-family: verdana, geneva; font-size: 12pt;"><span style="color: black;">3</span>+ years of professional experience developing software on the Salesforce platform (e.g., Apex, LWC, Communities).</span></li><li><span style="font-family: verdana, geneva; font-size: 12pt;">Solid Java programming and SQL query skills.</span></li><li><span style="font-family: verdana, geneva; font-size: 12pt;">Desire and ability to write clean, beautiful code, including unit tests.</span></li><li><span style="font-family: verdana, geneva; font-size: 12pt;">Passion for learning and adopting new technology.</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Obsession with customer service and delivering business value. </span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Strong customer focus, ownership, urgency, and drive.</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Experience with AWS, a plus.</span></li><li><span style="font-size: 12pt; font-family: verdana, geneva;"><span style="color: black;">Experience with Angular, ReactJS, a plus.</span></span></li></ul><p style="margin: 0px;"> </p><div class="wpb_text_column wpb_content_element  about-first-pera"><div class="wpb_wrapper"><div class="wpb_text_column wpb_content_element  about-first-pera"><div class="wpb_wrapper"><p style="margin: 0px;"><span style="font-size: 12pt; font-family: verdana, geneva;"><strong>About MarketWise Solutions</strong></span></p><p style="margin: 0px;"><span style="font-size: 12pt; font-family: verdana, geneva;"><span>Formerly known as Beacon Street Services, MarketWise Solutions</span> is the services division of MarketWise LLC, providing world-class shared services, including, technical systems and expertise, legal, accounting and human resources.</span></p></div></div><div class="wpb_text_column wpb_content_element  vc_custom_1553872657448 about-hide-content"><div class="wpb_wrapper"><p style="margin: 0px;"> </p><p style="margin: 0px;"><span style="font-size: 12pt; font-family: verdana, geneva;">Our mission is to provide MarketWise the systems, support and information to do what they do best which is to provide the best in class subscription-based publications of financial information and software to millions of investors globally.</span></p><p style="margin: 0px;"> </p><p style="margin: 0px;"><span style="font-size: 12pt; font-family: verdana, geneva;"><span>The affiliate companies under MarketWise provide a broad range of services and opinions which means that one size does not fit all. MarketWise Solutions mirrors that philosophy by providing cutting edge, multi-tenant systems and services implemented by some of the best and brightest people in their respective fields.</span></span></p></div></div></div></div><p style="margin-bottom: 0in;"> </p><p style="margin-bottom: 0in;"> </p><p style="margin-bottom: 0in;"><em><span style="font-size: 12.0pt;">Take a virtual tour of our Baltimore, MD office </span></em><a href="https://www.youtube.com/watch?v=nu7H7TToSck&feature=youtu.be" target="_blank" rel="noopener"><em><span style="font-size: 12.0pt;">here</span></em></a><em><span style="font-size: 12.0pt;">.</span></em></p></div></div></div></div></div></div><p style="margin-bottom: 0in;"> </p><p style="margin-bottom: 0in;"> </p><p style="margin-bottom: 0in;"> </p><p style="margin: 0in 0in 12.0pt 0in;"><span style="font-family: verdana, geneva; font-size: 12pt;"><strong><span style="color: #333333;">Our commitment:</span></strong></span></p><p style="margin: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;">As an employer committed to equal opportunity and a diverse workforce, all qualified applicants will receive consideration without regard to race, color, religion, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.</span></p>

Overview:<br/><p style="margin: 0px;"><img style="display: block; margin-left: auto; margin-right: auto;" src="https://beaconstreetservices.icims.com/icims2/servlet/icims2?module=AppInert&action=download&id=36&hashed=1123752724" alt="TRADESMITH LOGO " /></p><p style="margin: 0px;"> </p><p style="margin: 0px;"><span style="font-size: 12.0pt; font-family: 'Verdana',sans-serif; color: #333333;">TradeSmith is hiring a<strong><span style="font-family: 'Verdana',sans-serif;"> Senior Quantitative Analyst</span></strong> to add to our growing company. This person will work to create, explore, and enhance financial models and algorithms within the TradeSmith universe.  This department is collecting extraordinary amounts of data and is in need of someone with an in-depth understanding of financial models and terms to write solutions that will identify new trends.  This person should have a strong background in SQL; experience in Python would be beneficial.  The </span><span style="font-size: 12.0pt; font-family: 'Verdana',sans-serif; color: black;">successful candidate</span><span style="font-size: 12.0pt; font-family: 'Verdana',sans-serif; color: #333333;"> will be open to aggregate, normalize, and clean data.  The ideal fit is an engineer a demonstratable Data Science experience in a Financial Services environment.  Then, through data extraction from the warehouse, work with our financial researchers, editors and marketing to craft and deliver various financial market reports, algorithms, and portfolio/strategy backtests.</span></p><br/><br/>Responsibilities:<br/><ul><li><span style="font-size: 12pt; font-family: verdana, geneva; color: black;">Work with key executives from multiple teams to understand problems, identify opportunities and present findings</span></li><li><span style="font-size: 12pt; font-family: verdana, geneva; color: black;">Identify predictive features for those problems/opportunities and run them through ML algorithms within a predictive analytics framework, Data Robot</span></li><li><span style="font-size: 12pt; font-family: verdana, geneva; color: black;">Extract the data required from the Data Warehouse (Snowflake) or other systems as needed, either through direct SQL extracts or other frameworks provided such as Looker, Tableau, etc.</span></li><li><span style="font-size: 12pt; font-family: verdana, geneva; color: black;">Create backtests and reports on various financial models, and algorithms</span></li><li><span style="font-size: 12pt; font-family: verdana, geneva; color: black;">Explore and enhance TradeSmith's deep financial data by crafting custom algorithms or indicators based on market data and trends</span></li><li><span style="font-size: 12pt; font-family: verdana, geneva; color: black;">Perform other tasks as needed within the broader Data and BI teams.</span></li><li><span style="font-size: 12pt; font-family: verdana, geneva; color: black;">Examples include, visualization tasks, BI meta data model development, data loading, data cleansing, etc.</span></li></ul><br/><br/>Qualifications:<br/><ul><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">BS or MS degree in Data Science or related quantitative field</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">A minimum of 2 years work experience within Data Science</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Highly proficient in SQL</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Python coding experience</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Comfortable working within a Predictive Analytics Framework</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Excellent communication skills</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Finance Technology background preferred</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Comfortable with shifting priorities and a fast-paced work environment</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Sedentary work that primarily involves sitting/standing</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Visual acuity for reading and using the computer</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Ability to hear</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Ability to freely move about the office or remote working environment</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Ability to use the phone/computer/keyboard/mouse/general office equipment for extended periods of time</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Ability to communicate with others in order to exchange information</span></li><li><span style="font-family: verdana, geneva; color: black; font-size: 12pt;">Fluency in the English language</span></li></ul><p style="margin: 0px;"> </p><p style="margin: 0px;"> </p><p style="margin: 0px;"><span style="font-size: 12pt; font-family: verdana, geneva;"><strong>About TradeSmith</strong></span></p><p style="margin: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;"> </span></p><p style="margin: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt;">TradeSmith is the leading Wealth Tech division of MarketWise. TradeSmith began as a simple way to track portfolios using trailing stops, and has evolved into a powerful suite of risk-management and portfolio analysis tools. Since 2005, weve been optimizing the powerful, proprietary algorithms behind our portfolio management software. This suite of tools features volatility-based buy and sell alerts, stock screener tools, a robust ratings system, and a groundbreaking options trading tool. TradeSmith's tools can be used on stocks, cryptocurrencies, commodities and funds to help limit risk and maximize upside. We track over 2.5 Million securities and over $20 billion in invested capital. TradeSmith empowers individual, self-directed investors by giving them a tremendous edge in the markets. TradeSmith believes that advanced market insights and user-friendly tools go hand-in-hand to create lasting wealth.</span></p><p style="margin: 0px;"> </p><p style="margin: 0px;"> </p><p style="margin: 0in 0in 12.0pt 0in;"><span style="font-family: verdana, geneva; font-size: 12pt; color: #000000;"><strong>Our commitment:</strong></span></p><p style="margin: 0px;"><span style="font-family: verdana, geneva; font-size: 12pt; color: #000000;">As an employer committed to equal opportunity and a diverse workforce, all qualified applicants will receive consideration without regard to race, color, religion, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.</span></p>

Beacon Street Services Business Intelligence Interview Guide

Overview

Beacon Street Services Business Intelligence Salary

Beacon Street Services Business Intelligence Interview Process

Beacon Street Services Business Intelligence Interview Questions

Beacon Street Services Business Intelligence Jobs