Prepare for and practice interview questions from Princeton University.

Princeton University Interview Questions

Princeton University 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

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 you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Princeton University Salaries by Position

Overview Do you want to advance humanistic research through software? Are you a humanities researcher who loves to write code to solve problems? Are you a software engineer who wants to tackle research questions? If so, consider applying to join the Center for Digital Humanities (CDH) as our new Research Software Engineer (RSE).As RSE, you will be an integral member of a collaborative team that designs and implements high-quality, sustainable software to advance research in the humanities. You will work closely with faculty, student, and campus partners to translate research priorities into software needs, including analyzing data, implementing models or simulations, and developing software modules or tools. You will advise Princeton scholars and recommend appropriate approaches and solutions, and will contribute to research articles, presentations, and course modules. For this position, we are looking for a team member with expertise in data analysis and visualization, particularly from a humanities perspective. Your work will enable domain-specific research discoveries, while also advancing data visualization research within the digital humanities. The interests and experience you bring to CDH will benefit existing projects, and will help recruit new partners for future collaborations. We look forward to hearing in your cover letter how you envision your work connecting with and expanding the efforts of the CDH to advance scholarship at the intersection of the humanities and computation.This position reports to the CDH Assistant Director and qualifies for 20% R&D time on personal research or professional development that enhances/complements departmental work. It is a full time, full benefits, permanent position in Princeton, NJ, with the possibility for some flexible work arrangements. This is not a remote position. Responsibilities <li>Build, port, test, debug, and document research software. Contribute to maintenance and updates for existing research software as needed.</li><li>Analyze, transform, migrate, and process data and metadata.</li><li>Participate in code review and contribute to team best practices (unit testing, documentation, continuous integration, etc.). </li><li>Translate research goals into software deliverables; analyze requirements, design software, design information architecture.</li><li>Advise faculty and students on best practices, solutions, and scope for humanities data-driven research.</li><li>Promote the work of the CDH and Research Computing at Princeton campus and to the broader digital humanities community (e.g. give presentations, write blog posts, etc.).</li> Qualifications REQUIRED <ul><li>Bachelors degree in a Humanities, Data Science, Computer Science, Computational, or related discipline.</li><li>4 - 8 years experience as a Research Software Engineer or in a similar role.</li><li>Experience with humanities research and ability to communicate with humanities researchers, computer scientists, and data scientists.</li><li>Programming skills, particularly in one or more languages (Python, R, or JavaScript) typically used for computational humanities research and data analysis (Python preferred). </li><li>Demonstrated success: </li><ul><li>Using conventional and readable coding style. </li><li>Creating comprehensive and well-written documentation. </li><li>Using version control systems and automated testing, including unit testing, integration testing, and continuous integration. </li></ul><li>Demonstrated successes contributing to a collaborative research team. </li><li>Ability to learn new programming languages and technologies beyond area of core knowledge. </li></ul>PREFERRED<ul><li>Graduate-level research (MA or PhD) in a humanities, computational or related discipline.</li><li>Experience conducting exploratory data analysis and creating interactive visualizations of complex data for use as a research tool and as a research output.</li><li>Ability to manage projects and multiple priorities.</li><li>Experience writing scripts to gather and process data from diverse sources and formats.</li><li>Experience working with and visualizing high-dimensional data using projections such as t-SNE or UMAP.</li><li>Familiarity with web accessibility standards (e.g. WCAG).</li></ul> *Please include code samples or links to Github repositories on your resume. Princeton University is an <a href="https://rrr.princeton.edu/eop" target="_blank"> Equal Opportunity/Affirmative Action Employer</a> and all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability status, protected veteran status, or any other characteristic protected by law. <a href="https://www.eeoc.gov/sites/default/files/2022-10/EEOC_KnowYourRights_screen_reader_10_20.pdf" target="_blank"> KNOW YOUR RIGHTS </a> <img src="https://www.click2apply.net/v/6737907d81f2bb491d7cf114" /> PI423192a51c12-26289-35661033

Position: Lead Research Software Engineer OverviewThe “Princeton Language and Intelligence” Initiative at Princeton University invites applications for a Lead Research Software Engineer. This multidisciplinary initiative has three Research thrusts: (a) Better design, evaluation, safety and understanding of large AI models (especially language models); (b) Applications of large AI models to many academic disciplines; and (c) Studying the impact of large AI models on society and the world. The Initiative will produce open-source software and models. In this position, you will be a lead and integral member of dynamic research teams focused on building innovative and complete software solutions for cutting-edge AI research and making fundamental contributions to AI projects with Princeton’s world-class researchers. As a Lead RSE, you will oversee a team of Research Software Engineers working on varied engineering solutions associated with large AI models. You will bring your advanced technical knowledge and project management experience to raise the computational capability of the team and translate key PLI priorities into engineering solutions. The term of this appointment is 3 years, with the possibility of renewal based upon satisfactory performance and funding. The position is located in Princeton, NJ with the possibility for some flexible work arrangements. This is not a remote position. ResponsibilitiesJob responsibilities will include a subset of the following: Management and Technical Leadership<ul><li>Directly oversee a team of RSEs dedicated to PLI’s mission. Responsible for managing their effort and all team software development work while establishing project priorities and following best practices in project management.</li><li>Lead the team in providing technical expertise and guidance for improving the performance and quality of new and existing code bases through hands-on work with ongoing research.</li><li>Mentor, instruct and educate less experienced Research Software Engineers, including those outside the direct team (including PLI researchers), in advanced computational techniques learned from developing novel research software engineering project solutions.</li><li>Formally train and mentor the members of the PLI RSE team in both research software engineering as well as AI-specific topics.</li><li>Organize professional development and professional growth activities for the team. This includes leading code reviews within their projects.</li><li>Monitor and manage all team projects and architect a set of applicable best practices uniquely appropriate for that project (e.g., version control, continuous integration and continuous delivery, software design, programming model, etc.).</li><li>Conduct Annual Performance Reviews for direct report RSE staff.</li><li>Supervise professional development of direct reports, including the coordination of activities and events supporting the acquisition of new skills and expertise.</li><li>Build and develop a diverse, effective, and collaborative group of Research Software Engineers and participate in other RSE hiring committees.</li><li>Create an inclusive atmosphere and environment in which best engineering practices are valued, shared, and prioritized.</li></ul> Software Development<ul><li>Collaborate with our diverse team to help develop and improve large AI models, helping conduct experiments, analyze results, and co-author research publications.</li><li>Develop, maintain, and improve our shared infrastructure for training / fine-tuning and prompting large AI models.</li><li>Maintain software libraries/environment/GitHub repositories and support model use.</li><li>Provide support for use of these libraries in the core AI models group as well as for interdisciplinary work. This includes documentation of projects in a descriptive and appropriately detailed manner that can be understood by both researchers and future Research Software Engineers.</li><li>Serve as liaison with Princeton Research Computing staff on GPU cluster related issues.</li></ul> Professional Development<ul><li>Learn the underlying science, mathematics, statistics, data analysis, and algorithms of computational research questions. This may involve independent research, studying existing code bases, and keeping up-to-date with publications.</li><li>Build awareness of software development tools and techniques, software engineering best practices, programming languages, high-performance computing hardware, and computational research solutions.</li><li>Access to a community of about two dozen research software engineers as well as continued professional development opportunities at Princeton Research Computing.</li></ul> QualificationsEssential Requirements:<ul><li>A Bachelor/Masters degree in Computer Science, Engineering, Sciences, or related computational field is required.</li><li>Solid coding skills and good experience with large AI models.</li><li>Experience leading multiple software projects</li><li>Familiarity with GPU computing environments and ML frameworks and libraries (e.g,, DeepSpeed, HuggingFace).</li><li>Prior research experience in AI/ML and/or contributions to open-source libraries.</li><li>Strong written and oral technical communication skills.</li></ul> Preferred Requirements:<ul><li>1+ years experience managing a small team</li></ul> Additional Information<ul><li>This position is located in Princeton, NJ with the possibility for some flexible work arrangements. This is not a remote position.</li><li>The position is up to a 3-year term, with a possibility of reappointment.</li><li>Competitive compensation package with attractive work conditions.</li><li>Access to state-of-the-art research facilities and a new GPU cluster.</li><li>Opportunities for professional growth and career advancement.</li><li>Collaborative and inclusive work environment that fosters creativity and innovation.</li></ul> If you are passionate about advancing AI research, working alongside leading researchers, and contributing to impactful open-source projects, we encourage you to apply for this position.Elevating the individual within a culture of collaboration, Princeton University is a powerful foundation upon which to build one’s career and family. Princeton’s competitive array of benefits reflects a holistic approach to supporting individuals and their families at work and beyond. The University is also an engaging, transformative resource in and of itself. From opportunities for collaboration to world-class research and cultural facilities, you will find all manner of spaces that bring people together and inspire new ideas. Princeton, NJ is one of the country’s most historic communities. Situated midway between Philadelphia and New York City, Princeton is a charming and walking-friendly small town with easy access to neighboring cities. In 2022 Niche Magazine rated the Princeton Public Schools as one of the top public school districts in NJ and included Princeton on its list of the best places to live in America. Princeton University is an Equal Opportunity/Affirmative Action Employer and all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability status, protected veteran status, or any other characteristic protected by law. KNOW YOUR RIGHTS

Application of Domain Expertise:Through directed independent studies, including reading publications and studying existing code bases, understand relevant topical areas and corresponding numerical methods in Geophysics, which will be needed for softw Software Engineer, Research, Software, Engineer, Development, Technology, Education, Science

Princeton University Interview Questions

Princeton University Interview Guides

Princeton University Interview Questions

Princeton University Salaries by Position

Princeton University Opening Jobs