Prepare for and practice interview questions from Baird.

Baird Interview Questions

baird is an employee-owned, international wealth management, capital markets, private equity and asset management firm with offices in the united states, europe and asia. established in 1919, baird has more than $145 billion in client assets and over 3,100 associates serving the needs of individual, corporate, institutional and municipal clients.
a great place to work, baird ranked no. 5 on fortune’s 100 best companies to work for® in 2015 – its twelfth consecutive year on the list. baird’s principal operating subsidiaries are robert w. baird &amp; co. in the united states and robert w. baird group ltd. in europe. baird also has an operating subsidiary in asia supporting baird’s investment banking and private equity operations. for more information, please visit baird’s web site at www.rwbaird.com.
baird is committed to employment policies and practices that provide equal employment opportunity at all times. these non-discriminatory practices apply to all areas of employment including:

baird is an employee-owned, international wealth management, capital markets, private equity and asset management firm with offices in the united states, europe and asia. established in 1919, baird has more than $145 billion in client assets and over 3,100 associates serving the needs of individual, corporate, institutional and municipal clients.

 a great place to work, baird ranked no. 5 on fortune’s 100 best companies to work for® in 2015 – its twelfth consecutive year on the list. baird’s principal operating subsidiaries are robert w. baird & co. in the united states and robert w. baird group ltd. in europe. baird also has an operating subsidiary in asia supporting baird’s investment banking and private equity operations. for more information, please visit baird’s web site at www.rwbaird.com.

 baird is committed to employment policies and practices that provide equal employment opportunity at all times. these non-discriminatory practices apply to all areas of employment including:

Overview

Baird Interview Guides

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

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

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?

Baird Salaries by Position

As we continue to grow and add top talent to the Baird family of technical associates, we are currently seeking an IT Portfolio Business Analyst for our Milwaukee Office. The IT Portfolio Business Analyst is responsible for supporting the IT PWM (Private Wealth Management) Leadership Team and working closely with the Lead Portfolio Business Analysts to support the business and IT needs within the PWM IT portfolio to ensure critical business outcomes.The IT Portfolio Business Analyst will use relationship building and influence to work with key business leaders, stakeholders, and team members to help identify business objectives and deliver technical solutions for Baird. In doing so, our Portfolio Business Analysts leverage diverse project methodologies (lean, agile, waterfall, iterative) and embody a strong culture of continuous improvement and learning. Portfolio Business Analysts support the Portfolio IT Leadership Team and are relied upon to build trusting, strategic partnerships with key stakeholders as well as effectively navigate organizational complexity to deliver results. As an IT Portfolio Business Analyst, you will:Portfolio DeliveryAs a member of the portfolio IT team,Support the ideation and definition of new project initiatives including problem statements, benefits, success criteria, business case, and solution optionsHelp ensure appropriate level of consistency of approach across teamsProvide transparency in order to manage team members expectationsContribute to a positive culture where our team members are engaged and motivatedSupport cross team / portfolio project planning activities (Increment Planning; Dependency Tracking, etc.)Capture portfolio level metrics for Portfolio Project Communications to business leadersIdentify gaps and opportunities for improvement within Portfolio Delivery approaches and processesWith support from the Lead Portfolio Business Analyst, manage stakeholder expectations regardless of initiative complexity or sizeWith support from the Lead Portfolio Business Analyst, identify and manages project risks, issues, dependencies, and milestones in accordance with project needUnderstands the strategic business needs and works with the team, IT- and business- leadership to deliver business-impactful resultsProvide business / field / client perspective in technical discussionsDocument / illustrate / Diagram complex technical ideas for consumption by non-technical team membersMerger & AcquisitionsDuring Firm-wide Merger and Acquisition endeavorsSupport the Lead Portfolio Business Analyst and IT Leadership Team on all Merger & Acquisition projectsCreate and maintain necessary communication materials (status reports; execution playbooks; etc.)Work with IT Ops & Client Services Teams to manage scope of work & timing of activitiesWork with IT Delivery Teams to manage scope of work and timing of activitiesSupport the creation of materials necessary for Exec / SCO level meetings / report outsSupport the Operational Data Conversion needs and & help execute solution plansRelationship ManagementCan build and maintain strong relationships across Baird with Senior Business and IT leadersWith support from the Lead Portfolio Business Analyst, evaluates the situation to effectively communicate to the right audience and at the right timeTailors message and communication style and can pivot as needed.Confidently participates in interactions with associates at all levels of the organization, including COOs and senior business leadersSupports the efforts around team and portfolio strategyHas highly advanced awareness of organizational dynamics and independently navigates to drive decisions and achieve outcomesCan utilize an established network throughout IT and leverage it to navigate complexityAnalysis and Solution DevelopmentElicits functional & nonfunctional requirements through the use of interviews, workflow analysis, requirements workshops, and surveys to provide business process descriptions, business requirements, use cases, and user stories, with minimal supportApplies a number of BA approaches and techniques with limited guidance from othersDevelops analysis approach for medium and/or moderately complex efforts while keeping senior leaders informedTakes a systems thinking approach to quickly develop an understanding of value streams and end-to-end processes, while looking for opportunities for improvementAble to work in ambiguous situations and derive actionable outcomes with support and guidanceCollaborates with delivery teams (business analysts, developers, architects, product owners) to establish the technical vision and analyze tradeoffs for complex / cross team initiativesContributes and supports the execution of Portfolio Level initiativesDevelops an end-to-end knowledge of technology ecosystem and its impacts on the businessWhat makes this opportunity great:Information technology is a core part of Baird's business strategy and plays a critical role in the growth and transformation of the firmAbility to work with a variety of teams and leaders, proving your ability to be flexible and high adaptableFast paced environment that will enable you to grow as a professional Team of associates passionate about achieving great results for clients and give back to the communities where we live and workWhat we look for:At least 5 years IT related experience including a minimum of 2 years Business Analysis experience is preferredB.S. in Computer Science, MIS, Business Administration, or Finance is preferred and we will consider combination of education and experience.Two years serving as a Business Analyst in the financial industry is preferredExperience in an agile/lean delivery environment is preferredExperience with a variety of tools for prototyping, modeling, data analysis, reporting, backlog and value stream management is preferred (Visio, Miro, PowerBI, Balsamiq, and Azure DevOps).Exposure to data visualization techniques (SQL, Power BI) is strongly preferredGood communication and collaboration skills, ability to influence without authority including with senior business leadersDetail-oriented and possesses exceptional organizational, critical thinking, and problem-solving skills#DI#LI-SB1#LI-HybridBaird is committed to diversity and provides employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex, pregnancy, citizenship, national origin, age, disability, military service, veteran status, sexual orientation, gender identity or expression, genetic information, or any other status protected by law.

As we continue to grow and add top talent to the Baird family of technical associates, we are currently seeking an IT Portfolio Business Analyst for our Milwaukee Office. The IT Portfolio Business Analyst is responsible for supporting the IT PWM (Private Wealth Management) Leadership Team and working closely with the Lead Portfolio Business Analysts to support the business and IT needs within the PWM IT portfolio to ensure critical business outcomes.The IT Portfolio Business Analyst will use relationship building and influence to work with key business leaders, stakeholders, and team members to help identify business objectives and deliver technical solutions for Baird. In doing so, our Portfolio Business Analysts leverage diverse project methodologies (lean, agile, waterfall, iterative) and embody a strong culture of continuous improvement and learning. Portfolio Business Analysts support the Portfolio IT Leadership Team and are relied upon to build trusting, strategic partnerships with key stakeholders as well as effectively navigate organizational complexity to deliver results. As an IT Portfolio Business Analyst, you will: Portfolio Delivery As a member of the portfolio IT team,Support the ideation and definition of new project initiatives including problem statements, benefits, success criteria, business case, and solution optionsHelp ensure appropriate level of consistency of approach across teamsProvide transparency in order to manage team members expectationsContribute to a positive culture where our team members are engaged and motivatedSupport cross team / portfolio project planning activities (Increment Planning; Dependency Tracking, etc.)Capture portfolio level metrics for Portfolio Project Communications to business leadersIdentify gaps and opportunities for improvement within Portfolio Delivery approaches and processesWith support from the Lead Portfolio Business Analyst, manage stakeholder expectations regardless of initiative complexity or sizeWith support from the Lead Portfolio Business Analyst, identify and manages project risks, issues, dependencies, and milestones in accordance with project needUnderstands the strategic business needs and works with the team, IT- and business- leadership to deliver business-impactful resultsProvide business / field / client perspective in technical discussionsDocument / illustrate / Diagram complex technical ideas for consumption by non-technical team membersMerger & Acquisitions During Firm-wide Merger and Acquisition endeavorsSupport the Lead Portfolio Business Analyst and IT Leadership Team on all Merger & Acquisition projectsCreate and maintain necessary communication materials (status reports; execution playbooks; etc.)Work with IT Ops & Client Services Teams to manage scope of work & timing of activitiesWork with IT Delivery Teams to manage scope of work and timing of activitiesSupport the creation of materials necessary for Exec / SCO level meetings / report outsSupport the Operational Data Conversion needs and & help execute solution plansRelationship Management Can build and maintain strong relationships across Baird with Senior Business and IT leadersWith support from the Lead Portfolio Business Analyst, evaluates the situation to effectively communicate to the right audience and at the right timeTailors message and communication style and can pivot as needed.Confidently participates in interactions with associates at all levels of the organization, including COOs and senior business leadersSupports the efforts around team and portfolio strategyHas highly advanced awareness of organizational dynamics and independently navigates to drive decisions and achieve outcomesCan utilize an established network throughout IT and leverage it to navigate complexityAnalysis and Solution Development Elicits functional & nonfunctional requirements through the use of interviews, workflow analysis, requirements workshops, and surveys to provide business process descriptions, business requirements, use cases, and user stories, with minimal supportApplies a number of BA approaches and techniques with limited guidance from othersDevelops analysis approach for medium and/or moderately complex efforts while keeping senior leaders informedTakes a systems thinking approach to quickly develop an understanding of value streams and end-to-end processes, while looking for opportunities for improvementAble to work in ambiguous situations and derive actionable outcomes with support and guidanceCollaborates with delivery teams (business analysts, developers, architects, product owners) to establish the technical vision and analyze tradeoffs for complex / cross team initiativesContributes and supports the execution of Portfolio Level initiativesDevelops an end-to-end knowledge of technology ecosystem and its impacts on the businessWhat makes this opportunity great:Information technology is a core part of Baird's business strategy and plays a critical role in the growth and transformation of the firmAbility to work with a variety of teams and leaders, proving your ability to be flexible and high adaptableFast paced environment that will enable you to grow as a professionalTeam of associates passionate about achieving great results for clients and give back to the communities where we live and workWhat we look for:At least 5 years IT related experience including a minimum of 2 years Business Analysis experience is preferredB.S. in Computer Science, MIS, Business Administration, or Finance is preferred and we will consider combination of education and experience.Two years serving as a Business Analyst in the financial industry is preferredExperience in an agile/lean delivery environment is preferredExperience with a variety of tools for prototyping, modeling, data analysis, reporting, backlog and value stream management is preferred (Visio, Miro, PowerBI, Balsamiq, and Azure DevOps).Exposure to data visualization techniques (SQL, Power BI) is strongly preferredGood communication and collaboration skills, ability to influence without authority including with senior business leadersDetail-oriented and possesses exceptional organizational, critical thinking, and problem-solving skills#LI-SB1Commitment to Inclusion & Diversity Baird is committed to inclusion & diversity for our clients, our associates and the communities where we live and work. This commitment stems from our culture of integrity, genuine concern for others and respect for the individual. We view inclusion & diversity as an ongoing journey - one of shared responsibility, continuous improvement and a focus on progress. We invite you to join us as we work together to foster an environment where diversity unites rather than divides us.

Baird Interview Questions

Overview

Baird Interview Guides

Baird Interview Questions

Baird Salaries by Position

Baird Opening Jobs