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

Factset Business Intelligence Interview Guide

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


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

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

Overview

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

Factset 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>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

<p>What are the logistic and softmax functions? What is the difference between the two?</p>

<p>What makes them useful for use in logistic regression?</p>


<p>In logistic regression, how is the predicted class determined based on the logistic function?</p>


In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

<p>What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?</p>


What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

Factset Business Intelligence Interview Questions

<p>Buy Side Engineering is responsible for FactSet’s industry leading Portfolio, Risk, Quantitative, and Fixed Income products. These products are used by thousands of Asset Managers around the world every day to assist with investment decisions, analysis of performance, risk management, and the presentation of results. Analytical Product Engineering’s product space represents a high growth opportunity for FactSet.</p><p><br></p><p><br></p><p><strong>SUB-PROCESS BRIEF</strong></p><p>As a member of the Fixed Income Analytics team, you will be working on various aspects of our analytics engine. This engine is responsible for the generation of mathematical results focusing on numerous available asset types include Bonds, Mortgages, Derivatives, etc. The original emphasis for this role will be to work on feature enhancements and improving the handling of different asset types through incorporation of additional terms and conditions data as well as improvements to mathematical algorithms. Working on this project will provide insight into the architecture of the engine. Engineers working in this group maintain strong relationships with peer engineers but also need to work very closely with Product Development and stakeholders. There are plenty of opportunities to learn strong programming best practices along with learning Fixed Income financial fundamentals. </p><p><br></p><p><br></p><p><strong>RESPONSIBILITIES:</strong></p><ul><li>Develop new and enhance existing features for projects owned by Calc Engine Team.</li><li>Work with Product Development and stakeholders to ensure the highest quality analytics.</li><li>Translate work requirements into testable and maintainable code ensuring that all success criteria have been satisfied.</li><li>Work with Fixed Income Product Development to understand project requirements and work with other Analytics Engineers on the technical design of those solutions.</li><li>Apply best practices to their own work and propagate this information within the team.</li></ul><p><br></p><p><br></p><p><strong>REQUIRED SKILLS:</strong></p><ul><li><strong>3-7 years</strong> of development experience in <strong>C++, especially in OOPs and Data Structures.</strong></li><li>Relational Database experience</li><li>Python experience/familiarity a plus</li><li>Ability to articulate and quickly adopt development best practices.</li><li>Excellent organizational and communication skills</li><li>Willingness to work as a member of a team, including participating in peer code reviews, maintaining project and operational documentation.</li><li>Ability to set own goals based on shifting priorities for self.</li><li>Ability to work as part of a geographically diverse team.</li><li>Ability to create, review documentation and test plans.</li><li>Ability to communicate with both technical and non-technical people.</li><li>B.Tech or M.Tech in Computer Science or equivalent</li></ul><p></p>

<p>"Locations: Toronto, CAD, New York, NY, Norwalk, CT, and London, UKWorking Environment: Hybrid FactSet is a financial data and software company headquartered in Norwalk, CT with offices in 37 locations worldwide. As a global provider of financial information and analytics, FactSet helps the worlds best investment professionals outperform. More than 62,000 users stay ahead of global market trends, access extensive company and industry intelligence, and monitor performance with FactSets desktop analytics, mobile applications, and comprehensive data feeds. The Institutional Buy Side group is responsible for defining and creating products that Portfolio Managers and Traders heavily rely on throughout the trading day. The EMS Product Management team is responsible for streamlining the user experience across the trade execution lifecycle. We are currently looking for a Principal Product Manager (TCA & Market Structure Specialist) to help in the design of our execution management system. As a member of this team, you will become a valued SME and product owner, responsible for guiding specific areas of the EMS based on our strategic vision and client requests. The Principal Product Manager will work as a liaison between Sales, and Engineering leveraging their experience with market structure, trading, and trade analytics. The candidate will also develop and maintain client relationships including on-boarding, providing product demonstrations, assessing product quality, and reflecting client feedback to enhance the feature set of FactSets Trading Analytics suite. In addition, the candidate will have experience with the full investment cycle from portfolio optimization, pre-trade analytics, in-trade, and post-trade analytics. A key aspect of the role is to understand the nuances of global market micro-structure and how that can affect both trading and investment performance. The candidate must be detail oriented and focused on identifying calculation errors, data quality issues and how analytics can be presented in an intuitive manner to clients. The Product Manager will work as a liaison between Sales, and Engineering leveraging their experience with market structure, trading, and trade analytics. The candidate will also develop and maintain client relationships including on-boarding, providing product demonstrations, assessing product quality, and reflecting client feedback to enhance the feature set of FactSets Trading Analytics suite. In addition, the candidate will have experience with the full investment cycle from portfolio optimization, pre-trade analytics, in-trade, and post-trade analytics. A key aspect of the role is to understand the nuances of global market micro-structure and how that can affect both trading and investment performance. The candidate must be detail oriented and focused on identifying calculation errors, data quality issues and how analytics can be presented in an intuitive manner to clients.RESPONSIBILITES:Work directly with clients to get feedback and implement new features and reportsDevelop prototypes to confirm features with clients prior to engaging engineeringWrite user stories for engineering to implement into productionTroubleshoot issues that arise in TCA that are related to market data and/or trade dataOn-board clients into FactSets Trading Analytics suite-Provide subject matter expertiseProvide client training Demo at trade shows/conferences-Track usage at firm and user levelUAT for development work -Suggest new product enhancements based on client feedbackIdentify and pursue prospects/sales opportunities on both buy-side and sell-sideQUALIFICATIONS:Bachelors Degree in Economics, Finance, Computer Science, or related field.10 years experience working in capital marketsTrading experienceKnowledge of global market structure for equities, FX, Futures, Options and Fixed Income. Listed derivatives and foreign exchange a plusPREFERRED BACKGROUND:Passionate about trading analytics-Highly analytical, methodical, inquisitive, and persevering mindset focused on data-driven delivery solutions.A deep understanding of trading workflows for institutional investors.Understanding of statistics and machine learningExcellent communications skillsUnderstanding of tools being used in product development lifecycle including R, Python, Apache-Ability to visualize complex data sets to enable users to easily understand performanceUnderstand trader pain-points and be able to articulate solutionUnited States applicants must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future Whats In It For You:Flexible work accommodations. Choose to work remotely, in person, or in a hybrid set-up.The opportunity to join a growing firm with a proven track record of success for over 40 years, made up of thoughtful, innovative minds that value collaboration and welcome your new ideas to the tableMentorship and growth opportunities from senior employeesCareer progression planning and a focus on career development, complete with dedicated time each month for conference attendance, online learning seminars, and networkingA robust social community dedicated to volunteerism, intramural sports, and team-building eventsBusiness resource groups that align with our DE&I strategy, designed to cultivate an inclusive environment for all Learn more about our benefits here. The budgeted amount range for this position in the States of Connecticut and in New York City is $168,000 - $220,000 Returning from a break? We are here to support you If you have taken time out of the workforce and are looking to return, we encourage you to apply and chat with our recruiters about our available support to help you relaunch your career.At FactSet, we celebrate diversity of thought, experience, and perspective. We are committed to disrupting bias and a transparent hiring process. All qualified applicants will be considered for employment regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or veteran status. FactSet participates in E-Verify. FactSet is an Equal Opportunity Employer - M/F/Veteran/Disability/Sexual Orientation/Gender IdentityVEVRAA Federal ContractorRequest Priority Protected Veteran & Disabled Referrals for all of our locations within the stateThe EEO is the Law poster is available here.FactSet Research Systems Inc. endeavors to make our website accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact Jennifer Passeck, Lead Recruiting Specialist, Human Resources at 1 (203) 810-2472 or recruitingfactset.com.Equal Opportunity Employment PolicyIt is the policy of FactSet Research Systems Inc. ("FactSet") to provide equal employment and advancement opportunities to all qualified employees and applicants for employment regardless of their race, color, religion, sex, age, sexual orientation, gender identity or expression, national origin, physical or mental disability, genetic information, protected veteran status, pregnancy, military or military reserve obligations, or any other class or status protected by law. This policy applies to all policies and procedures related to recruitment, hiring, training, promotion, compensation, benefits, transfer, discharge, and other terms and conditions of employment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status. If you have questions concerning this policy, please contact the Human Resources department at 1 (203) 810-1000.PDN-9c29e16f-5aaf-48a7-be03-40b9f8cab3a7"</p>

Factset Business Intelligence Interview Guide

Overview

Factset Business Intelligence Salary

Factset Business Intelligence Interview Process

Factset Business Intelligence Interview Questions

Factset Business Intelligence Jobs