Prepare for and practice interview questions from The Brattle Group.

The Brattle Group Interview Questions

The Brattle Group 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?

The Brattle Group Salaries by Position

The Brattle Group, a privately held, global economics consulting firm, is looking for a Data Engineer to join our Boston, MA or Washington, D.C. office. The Data Engineer works in the data engineering team and alongside Brattle consulting teams to implement the latest technologies and provide expert guidance on technical workstreams. Responsibilities will range from researching and implementing new tools, communicating with external clients, and creating reproducible scripts to clean, process, or analyze data. Projects are wide-ranging with numerous opportunities for professional development, innovation, and growth. We are seeking a candidate who has experience working as a Data Scientist or with applied data science experience that is interested in transitioning into a data engineering role. Some of the day-to-day responsibilities of this role include: <ul><li>Developing processes and pipelines for cleaning, validating, and uploading data to tabular formats ex: SQL Server, Azure Databricks, or PowerBI, in collaboration with IT and project teams</li><li>Writing reproducible scripts (Python preferred) and defining processes that will classify, clean, and visualize unstructured text data</li><li>Researching and implementing new tools and technologies to improve or introduce capabilities</li><li>Loading and supporting internal applications used for eDiscovery and structured text extraction</li><li>Liaise with clients and Brattle IT to determine ideal mode of delivery of digitized data/information from client to Brattle project teams</li><li>Maintaining an internal repository of scripts for common work to be used throughout the firm</li><li>Grow internal knowledge base by developing and presenting training courses to consulting staff</li><li>Keeps abreast of new tools, software, and technologies and make recommendations to project teams for future deployment</li></ul> THE CANDIDATE <ul><li>Bachelor's Degree in Computer Science, Computer Engineering, or related field</li><li>3-4 years of relevant professional experience, preferably in a professional services firm</li><li>Experience working as a Data Scientist or in an applied data science role</li><li>Proficiency with Python, SQL, and utilizing SQL in data solutions</li><li>Experience with cloud computing services (Microsoft Azure or AWS)</li><li>Experience with Generative AI or other Machine Learning applications such as predictive modeling, classification, and clustering</li><li>Experience with R is a plus</li><li>Data visualization skills is a plus</li><li>Excellent requirements gathering and project delivery skills</li><li>Outstanding verbal and written communication skills</li><li>Strong technical communication skills and experience writing for non-technical clients</li><li>Ability to estimate and convey project timelines, challenges, and milestones</li><li>Ability to work collaboratively and maintain a holistic view of project goals</li><li>Entrepreneurial orientation with an interest in owning research projects</li><li>Preference for experience working as a teaching assistant</li><li>Requires the ability to concentrate and pay close attention to detail and data anomalies</li><li>Evening/weekend work may be expected/required, including travel</li></ul> Brattle offers a competitive benefits package, base salary, and bonus program for eligible roles based on individual and firm performance. The anticipated base gross salary range for this position in Washington, D.C. is $100,000 - $105,000 annually. Actual salary will depend on a variety of factors, including experience and training. THE EMPLOYER The Brattle Group answers complex economic, finance, and regulatory questions for corporations, law firms, and governments around the world. We are distinguished by the clarity of our insights and the credibility of our experts, which include leading international academics and industry specialists. Brattle has 500 talented professionals across North America, Europe, and Asia-Pacific. For more information, please visit brattle.com. EQUAL OPPORTUNITY The Brattle Group is an Equal Opportunity and Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, citizenship status, national origin, ancestry, sex, gender identity and expression, age, height, weight, domestic partner status, Acquired Immune Deficiency Syndrome or HIV status (AIDS/HIV status), genetic information, sexual orientation, disability (where the applicant or employee is qualified to perform the essential functions of the job with or without reasonable accommodation), marital status, veteran status, political affiliation, drug or alcohol abuse or alcoholism, or any other characteristic protected under applicable law. We encourage all applicants to click here to review our full Equal Employer Opportunity Statement and here for more information on our commitment to promoting equity and inclusion across all identities and experiences.

The Brattle Group Interview Questions

The Brattle Group Interview Guides

The Brattle Group Interview Questions

The Brattle Group Salaries by Position

The Brattle Group Opening Jobs