Prepare for and practice interview questions from Shulman Fleming & Partners.

Shulman Fleming & Partners Interview Questions

Shulman Fleming & Partners Interview Guides

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.

How would you assess the validity of the result?

Experiment Validity

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.

What factors could have biased this result, and what would you look into?

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

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?

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.

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

Input:

<code>big_table</code> table

<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

Shulman Fleming & Partners Salaries by Position

<h3>Job Description</h3><div>Job Description<div>Contract Business Analyst (Waterfall only)MUST be local to New York City, Hybrid Schedule, At Least 2 Days in OfficeThis is a critical role within a very lean and strong team that owns a portfolio of technologies and projects, including Banking's Salesforce CRM system and business intelligence tools. The BA will perform business analysis functions in collaboration with front office stakeholders as well as internal partners and other team members. This is not a technical BA position. Principal Duties and Responsibilities:<ul><li>Prepare Swim Lane diagrams and create workflow diagrams</li><li>Pull reports from Salesforce and perform data analysis using strong Excel skills (must do Pivot tables)</li><li>Requirements analysis responsibilities include requirements gathering and documentation, process analysis and documentation (process flow diagrams), development of user stories and business requirements documents (BRDs), mock-ups of screens </li><li>Financial analysis, reconciliations and monitoring </li><li>Support various change management tasks including development of user documents, drafting of change communication memos, and user training </li><li>Must be attentive to details and have the highest level of oral communication</li></ul>Minimum Qualifications:<ul><li>5-7 years' experience </li><li>Strong analytical and quantitative skills and experience in Waterfall is a must</li><li>Strong knowledge of advanced Excel, SQL / VBA </li><li>Superior oral & written communication skills</li><li>Ability to plan, organize and handle multiple tasks simultaneously, with limited supervision </li><li>Experience supporting the implementation of change management initiatives</li></ul>Interview process: The manager will ask each candidate selected to complete a one hour written case study for his review. If the case study is sub-par the candidate will not proceed. There will then be a 1-hour video with several people followed by an onsite interview. No exceptions to this process.Additional note: The manager will not read any resume longer than 2 pages.The manager will not interview anyone who does not have perfect communication skills.The manager said he prefers someone out of a major management consulting firm like PWC, Anderson, McKinsey, etc. who brings broad highly professional skills.</div></div>

Contract Equity Swaps BAMUST be local to New York City. Hybrid Schedule at least 3 days in office Qualifications:<ul><li>In-depth knowledge of Total Return Swaps, Portfolio Swaps, Basket Swaps and/or Synthetic Prime Business.</li><li>Detailed knowledge of Swaps Trading Lifecyle and Regulatory Requirements (CFTC, SEC etc.)</li><li>Experience with a core Equity Swaps platforms, Swap One, Murex, NuvoPrime preferred.</li><li>Hands-on with producing Business Analysis Artifacts, including BRD, Functional Flows , test cases.</li><li>Experience working with all stakeholders in Front Office, Middle Office and Operations.</li><li>Experienced working on Trading System project implementation and all its major milestones including Analysis, Development, Testing and Release.</li><li>10+ years of experience required</li></ul>Skills:<ul><li>Effective interpersonal and relationship-building skills.</li><li>Strong written and verbal communication skills including the ability to present complex material.</li><li>Strong analytical and problem-solving abilities with keen attention to detail.</li></ul>Education:<ul><li>Bachelor’s Degree</li></ul>

<h3>Job Description</h3><div>Job Description<div>Contract Business Analyst for COO OfficeMUST be local to New York City, Hybrid Schedule, At Least 2 Days in OfficeSeeking a Business Analyst to work in the COO Office of a large international Corporate and Investment Bank. Play a key role in supporting technology transformation.A Few Particulars:Must be available to work full-time on-site in the Manhattan office. Open office floorplan promotes a collaborative team environment. This is not a 9-5 job; overtime and flexibility to perform hours work will be required Legally authorized to work in the United States The BA is a critical role within a very lean and strong team that owns a portfolio of technologies and projects, including Banking's CRM system, strategic data repository, data controls model and business intelligence tools.The BA will perform business analysis (including requirements and data analysis) functions in collaboration with front office stakeholders as well as internal partners and other team members.Principal Duties and Responsibilities:<ul><li>Prepare Swim Lane diagrams and create workflow</li><li>Requirements analysis responsibilities include requirements gathering and documentation, process analysis and documentation (process flow diagrams), development of user stories and business requirements documents (BRDs), mock-ups of screens </li><li>Data analysis responsibilities include business / financial analysis, reconciliations and monitoring as well as establishment of data processes and controls that promote data integrity </li><li>Support various change management tasks including development of user documents, drafting of change communication memos, and user training </li><li>Perform ad hoc analysis based on management's request </li><li>Analyze and identify opportunities for business process improvement and technology efficiencies</li></ul>Minimum Qualifications:<ul><li>2-5 years' experience performing the kinds of business / data analysis and quality assurance work </li><li>Strong analytical and quantitative skills and experience in Waterfall</li><li>Strong knowledge of advanced Excel, SQL / VBA a plus</li><li>Superior oral & written communication skills</li><li>Ability to plan, organize and handle multiple tasks simultaneously, with limited supervision </li><li>Experience supporting the implementation of technology systems or change management initiatives</li></ul></div></div>

Shulman Fleming & Partners Interview Questions

Shulman Fleming & Partners Interview Guides

Shulman Fleming & Partners Interview Questions

Shulman Fleming & Partners Salaries by Position

Shulman Fleming & Partners Opening Jobs