Prepare for and practice interview questions from Selby Jennings.

Selby Jennings Interview Questions

Selby Jennings 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?

Selby Jennings Salaries by Position

Selby Jennings is currently working with an Investment Management Firm in Dallas, TX. The team is looking for a skilled Senior Software Engineer with industry experience in either commodities (oil & gas, energy, etc.), finance, or geophysics to join their technology team and engage in backend software development for their complex and tech-centric services. Responsibilities<ul><li>Collaborate on designing, developing, and maintaining backend services and APIs.</li><li>Work closely with senior engineers, front-end developers, and UX/UI designers to improve user experiences.</li><li>Partner with cross-functional teams to define software requirements.</li><li>Participate in code reviews, follow best practices, and enhance proficiency in idiomatic programming and foundational principles.</li><li>Support data management tasks using SQL and NoSQL databases in cloud platforms like Azure.</li><li>Commit to continuous learning to stay current with industry advancements and emerging technologies.</li></ul> Qualifications<ul><li>Education: A Bachelor’s or Master’s degree in Computer Science, Software Engineering, or a related field is preferred; substantial relevant experience may also be considered.</li><li>Experience: Over 8 years of expertise in backend development.</li><li>Programming Languages: Proficient in Python and/or Ruby.</li><li>Frameworks and Libraries: Skilled in Rails, Pandas, and Polars.</li><li>Web Development: Extensive experience in designing, building, and maintaining web applications.</li><li>Distributed Systems: Deep understanding of distributed systems with an emphasis on scalability and availability.</li><li>Cloud and Containerization: Hands-on experience with cloud platforms and Docker for container management.</li><li>Cloud-Native Development: Expertise in building cloud-native applications.</li><li>DevOps & CI/CD: Proficient in implementing and managing continuous integration and delivery pipelines.</li><li>Databases: Experienced with relational databases (PostgreSQL, SQL Server) and NoSQL solutions (Redis, MongoDB, Elasticsearch).</li><li>Messaging Systems: Familiar with message queues like Kafka.</li></ul>

Selby Jennings is working with a notable financial services firm in St. Petersburg, FL, to fill a Lead Data Engineer position to join their Enterprise Data Team. They are looking for a career-oriented individual with a minimum of five (5) YOE in data engineering and expert knowledge in Oracle Data Integrator (ODI), AWS Redshift, and SQL performance tuning. Responsibilities<ul><li>Design and implement scalable, reliable, and flexible data integration solutions that are both elastic and adaptable.</li><li>Develop low-latency data integration systems to provide near real-time data access for multiple consumers.</li><li>Collaborate with Data Engineers, Data Architects, and Service Developers to create optimal and efficient ETL processes and database code.</li><li>Deliver dynamic, data-driven solutions that align with strategic business objectives.</li><li>Focus on designing, building, and deploying efficient and reliable data infrastructure to scale and support business needs.</li><li>Contribute to project success by meeting predefined success criteria, including business goals, budget constraints, and capital expenditure requirements.</li><li>Serve as an Application Support specialist for critical production systems, optimizing batch processes to meet defined SLA requirements.</li><li>Take on additional responsibilities and duties as needed to ensure project and business success.</li></ul> Qualifications<ul><li>Bachelor’s degree in Computer Science, MIS, or a related field, with at least five (5) years of relevant development or engineering experience, or an equivalent combination of education, training, and experience.</li><li>Five (5) years of experience as a Data Engineer.</li><li>Knowledge of the Financial Services industry preferred, however. substantial data exposure in another industry (such as Health Care) would suffice.</li><li>ETL Expertise: Advanced proficiency with ETL tools; experience with Oracle Data Integrator (ODI) is a must.</li><li>Data Volume: Has delt with data loads with volumes that are equal or greater than 10-15 million records/day.</li><li>Database Platforms: Extensive experience with database platforms; expertise in Oracle and AWS Redshift is a must.</li><li>SQL Optimization: Expert in SQL tuning, optimizing ETL processes, and physical database optimization.</li><li>SRE Concepts: Strong familiarity with Site Reliability Engineering practices, including evaluating and implementing monitoring and observability tools like Splunk, DataDog, and CloudWatch, as well as job, log, and dashboard management for customer support and application health monitoring.</li><li>AWS Services: Knowledge of AWS services and tools such as Terraform, DMS, S3, Spark, Python, Glue, and EMR is highly desirable.</li></ul>

Selby Jennings has partnered with a leading hedge fund based in Chicago, known for its fundamental, research-intensive approach to equity investing. They are seeking to add an Equity Research Analyst to the team with a generalist focus. Position Overview They are looking for a motivated and analytical Equity Research Analyst with 1-3 years of experience in equity research, investment banking, or a related field to join our team in Chicago. Key Responsibilities <ul> <li>Conduct comprehensive research on broad equities and sectors </li><li>Build and maintain detailed financial models and valuation analyses to support investment theses. </li><li>Track and analyze industry trends, company performance, and economic factors to assess potential impacts on investments. </li><li>Interact with company management, attend industry conferences, and review market data to gather intelligence and inform investment decisions. </li><li>Prepare concise, well-supported reports and present findings to portfolio managers and other members of the investment team. </li></ul> Qualifications <ul> <li>1-3 years of experience in equity research, investment banking, or a related field. </li><li>Strong financial modeling and analytical skills, with a solid understanding of financial statements and valuation techniques. </li><li>Proficiency in Excel, Bloomberg, and other relevant financial software. </li><li>Excellent written and verbal communication skills, with the ability to clearly articulate investment theses and insights. </li><li>A self-starter with strong attention to detail, intellectual curiosity, and the ability to work effectively both independently and within a team. </li> </ul>

One of the leading high frequency trading firm in NYC are looking for a C++ developer to join their greenfield project and work directly with the head of platform technology who is a pioneer of C++ trading systems development.The team has not started trading yet and are still in the process of building their core team and hiring key contributors. They have around 7 individuals including a junior researchers, a senior PM and quant developers. They are making a crucial hire of a C++ engineer who has experience building high performance simulation engines for microsecond trading strategies.The team is about 6 months away from their target "go-live" date where they hope to begin trading, so it's a great time to get on board to really build from scratch. The team is comprised of veterans from Radix / Jump Trading / Virtu financial and other Prop / HFT businesses in the market, so they have a strong team already. <ul><li>A STEM degree from a world leading university.</li><li>Low latency background or working on low latency distributed systems/platforms</li><li>To be a C++ enthusiast! (experience with C++20 is a bonus but not a must have)</li><li>Ideally some experience in a high frequency trading environment but will consider out of industry profiles as well</li></ul>.

Position Overview: Join our dynamic team to enhance and optimize our state-of-the-art automated trading system. You will play a pivotal role in streamlining processes, providing valuable insights, and contributing to our trading strategies. Key Responsibilities:<ul><li>Operate and enhance our advanced automated trading platform.</li><li>Utilize technical expertise to automate manual workflows and drive business scalability.</li><li>Develop automated visualizations and reports to extract essential insights.</li><li>Engage in projects aimed at boosting trading profitability and managing risk.</li><li>Monitor and evaluate trading activities within our automated market-making operations.</li><li>Analyze corporate events and their effects on portfolio performance, implementing automation where possible.</li><li>Oversee and improve financing structures, capital management, and electronic trading costs and incentives.</li><li>Manage stock lending practices, short-sale expenses, and risks associated with settlement and buy-ins.</li><li>Ensure compliance with registered market making and Lead Market Making standards.</li></ul> Qualifications:<ul><li>Proficient in a programming language, ideally Python.</li><li>Bachelor’s degree in a STEM discipline or a related area.</li><li>Strong analytical, quantitative, and problem-solving abilities.</li><li>Excellent communication and collaboration skills.</li><li>Detail-oriented with a structured approach to work.</li><li>Motivated to continuously enhance processes and systems.</li><li>Capable of working effectively under pressure and managing multiple tasks.</li></ul> Who You Are: You are a driven professional with a keen interest in financial markets, looking to leverage your skills in a fast-paced environment.

An established global hedge fund is looking to bring on software engineers to help enhance its research and technology capabilities. This role is ideal for candidates with a strong software engineering background, either from the financial industry or with a strong interest in applying their skills within the dynamic capital management sector to drive innovative technology solutions.What you will do:<ul><li>Contribute to building systems, tools, and platforms that support new strategies and products</li><li>Work closely with senior staff to enhance and develop software solutions for trading and risk management systems</li><li>Research and prototype new technologies to improve research and trading capabilities</li></ul>Qualifications:<ul><li>Proficiency in Python</li><li>3+ years of post-grad experience in related role</li><li>Relational database and SQL experience</li><li>B.S. or M.S. in Computer Science or other STEM field</li></ul>

My client, a private investment manager, is seeking a Product Manager to join their Data Science and AI team. This individual will lead the vision, development, and strategy of products, focusing on leveraging Generative AI and other market-leading methods in data science, machine learning, analytics, and AI. The ideal candidate will have 5-10 years of experience in a dynamic product management role, preferably with experience in developing AI or data science-related products, understanding of Generative AI technologies, and prior experience in financial services, consulting, or private equity is highly desirable. This is a hybrid work model in Boston, MA. Responsibilities: <ul><li>Communicate effectively with both technical and non-technical stakeholders</li><li>Lead the vision, development, and strategy of products</li><li>Work closely with deal teams, and technical teams</li><li>Manage the product lifecycle from conception through launch</li></ul> Qualifications: <ul><li>5+ years of experience in a product management role, preferably with experience in developing AI or data science related products.</li><li>Strong understanding of Generative AI technologies</li><li>Experience in managing cross-functional teams and leading product development projects</li></ul> Benefits:<ul><li>Hybrid work model</li><li>Competitive compensation package </li><li>Join a highly prestigious firm</li></ul>

Selby Jennings has partnered with a leading hedge fund based in Chicago, known for its fundamental, research-intensive approach to equity investing. They are seeking to add an Equity Research Analyst to the team with a generalist focus. Position Overview They are looking for a motivated and analytical Equity Research Analyst with 1-3 years of experience in equity research, investment banking, or a related field to join our team in Chicago. Key Responsibilities<ul><li>Conduct comprehensive research on broad equities and sectors</li><li>Build and maintain detailed financial models and valuation analyses to support investment theses.</li><li>Track and analyze industry trends, company performance, and economic factors to assess potential impacts on investments.</li><li>Interact with company management, attend industry conferences, and review market data to gather intelligence and inform investment decisions.</li><li>Prepare concise, well-supported reports and present findings to portfolio managers and other members of the investment team.</li></ul>Qualifications<ul><li>1-3 years of experience in equity research, investment banking, or a related field.</li><li>Strong financial modeling and analytical skills, with a solid understanding of financial statements and valuation techniques.</li><li>Proficiency in Excel, Bloomberg, and other relevant financial software.</li><li>Excellent written and verbal communication skills, with the ability to clearly articulate investment theses and insights.</li><li>A self-starter with strong attention to detail, intellectual curiosity, and the ability to work effectively both independently and within a team.</li></ul>

Selby Jennings Interview Questions

Selby Jennings Interview Guides

Selby Jennings Interview Questions

Selby Jennings Salaries by Position

Selby Jennings Opening Jobs