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

Shulman Fleming & Partners Interview Questions

Shulman Fleming & Partners Interview Guides

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

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

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>AVP Data AnalystEnterprise Data Management OfficeMUST be local to New York City, Hybrid Schedule at least 3 days onsiteNo Sponsorship Salary Range: $77k to 135kNo Relocation You must be working at a financial firm and have strong experience with automated data extraction from ServiceNow and analyzing data for weaknesses. Common Service Data Model experience is a huge plus. Without financial and ServiceNow your resume will not be reviewed.Key Responsibilities:<ul><li>Maintain documentation of data quality issues and corrective actions taken.</li><li>Analyze large datasets to identify trends, patterns, and risk factors that may impact the organization.</li><li>Develop and maintain data catalog, list of pain points, dashboards, reports, and visualizations to provide insights to stakeholders.</li><li>Maintain and identify changes needed in metadata for domain data.</li><li>Perform ad-hoc analysis to answer specific needs.</li></ul>Experience:<ul><li>3+ years of experience in data quality management, data analytics, or risk management.</li><li>Hands-on experience with ServiceNow and CMDB</li><li>Proven experience in implementing data controls and governance frameworks.</li><li>Proficiency in MS Office, especially Excel, and data analytics tools (e.g., SQL, Python).</li><li>Experience with data design, data audit, data governance, and visualization tools, E.g. Power BI, Tableau, Dataiku.</li></ul>Skills:<ul><li>Excellent attention to detail and organizational abilities.</li><li>Knowledge of data sources, transformation rules, and uses of data for the domain. Particularly the experience with ServiceNow platform and CMDB in supporting IT services and operations.</li></ul></div></div>

<h3>Job Description</h3><div>Job Description<div>Contract Business Analyst (Waterfall only)MUST be local to New York City, Hybrid Schedule, at least 3 or 4 days onsiteThis 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>

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