Prepare for and practice interview questions from International Rescue Committee.

International Rescue Committee Interview Questions

International Rescue Committee 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

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?

International Rescue Committee Salaries by Position

The International Rescue Committee (IRC) responds to the world's worst humanitarian crises, helping to restore health, safety, education, economic wellbeing, and power to people devastated by conflict and disaster. Founded in 1933 at the call of Albert Einstein, the IRC is one of the world's largest international humanitarian non-governmental organizations (INGO), at work in more than 40 countries and 29 U.S. cities helping people to survive, reclaim control of their future and strengthen their communities. A force for humanity, IRC employees deliver lasting impact by restoring safety, dignity and hope to millions. If you're a solutions-driven, passionate change-maker, come join us in positively impacting the lives of millions of people world-wide for a better future.
 Program Overview: Implemented by the IRC, theCultural Orientation Resource Exchange (CORE) is a technical assistance program that connects and supports refugee resettlement staff globally to deliver effective Cultural Orientation which helps newcomers achieve self-sufficiency in the United States. Settle In, available in multiple languages, is CORE's digital information service that directly engages newcomers through its website (https://www.SettleInUS.org), mobile app, and social media platforms. Settle In serves as another touchpoint to disseminate vital, accurate information tied to resettlement services. Job Overview: The Digital Product Manager will report to CORE's Digital Product Officer andsupport contributions to the growth and strategic effectiveness of the CORE website, Settle In website, and Settle In mobile app while supporting day-to-day operations.The Digital Product Manager will manage content on CORE's digital platforms using Drupal, WordPress, and Phrase TMS (translation management system), which includes building pages, uploading content and translations, and supporting product improvements in collaboration with internal teams and external partners. This role also oversees project management and communications with vendors that support maintenance and development of CORE's digital products. Major Responsibilities: <ul> <li>Manage content on the CORE website, the Settle In website, and the Settle In mobile app using content management systems (WordPress/Drupal), translation management systems (Phrase), and other relevant software; </li><li>Manage maintenance vendors for the Settle In website, Settle In mobile app, and CORE website, and coordinate across IRC and external teams (e.g., Phrase TMS, Semrush, Hotjar) to ensure products are fully operational and bug-free; </li><li>Develop project plans and coordinate among internal teams and external vendors to monitor project progress, resolve issues, and implement improvements; </li><li>Conduct quality assurance of CORE's digital platforms on an ongoing basis, including when uploading new content or during other related updates; </li><li>Support the Digital Product Officer in developing and implementing the product vision and roadmap of CORE's digital products based on their impact on business goals and user needs; </li><li>With support from theDigital Officer and Monitoring & Evaluation Officer, assist with implementing user testing, user feedback initiatives, and other assessments of CORE digital platforms to ensure frequent and actionable user feedback is incorporated into product decisions; </li><li>With support from the Digital Product Officer and Monitoring & Evaluation Officer, evaluate digital analytics (Google Analytics, Firebase, Hotjar, Semrush), analyze findings, and make recommendations to increase awareness, use, and engagement of CORE's digital resources; </li><li>Collaborate across internal teams to ensure maximum visibility and integration of all new CORE resources; </li><li>As needed, support development of product management guidelines, frameworks, SoPs, and best practices; </li><li>Represent CORE at meetings, internal and external workshops and conferences, and other events, as needed; </li><li>Perform other duties as assigned. </li></ul> Job Requirements: <ul> <li>Bachelor's Degree in computer science, library science, multimedia journalism, communications, or a related field required; </li><li>Minimum 2-3 years progressive work experience; </li><li>Experience with WordPress/Drupal website content management required, preference for experience managing large, complex websites in multiple languages; </li><li>Experience working with designers and developers, with proven ability to understand and communicate product needs and requirements between non-technical and technical collaborators; </li><li>Excellent written and oral communication skills: the ability to communicate effectively with colleagues and partners from diverse backgrounds and experiences; </li><li>Solid project management and organizational skills with the ability to juggle multiple tasks, coordinate multiple stakeholders, set priorities, effectively manage time, and meet deadlines; </li><li>Detail orientated and self-directed; </li><li>Solid computer skills: facility with Microsoft Office, email/internet, and project management software (e.g., Monday.com); </li><li>Strong commitment to social service or humanitarian assistance programs and willingness to adhere to IRC's code of conduct; </li><li>Demonstrated knowledge of the US Refugee Admissions Program and Cultural Orientation programs preferred; </li><li>The ability to be flexible and work well under pressurein a fast-paced team environment. </li></ul> Working Environment: <ul> <li>Remote position </li></ul> Compensation: Posted pay ranges apply to US-based candidates. Ranges are based on various factors including the labor market, job type, internal equity, and budget. Exact offers are calibrated by work location, individual candidate experience and skills relative to the defined job requirements. Equal Opportunity Employer: We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation. US Benefits: The IRC offers a comprehensive and highly competitive set of benefits. All US employees are eligible for sick time, a 403b retirement savings plans: up to 4.5% immediately vested matching contribution, plus an 3-7% additional IRC contribution, and an Employee Assistance Program which is available to our staff and their families to support in times of crisis and mental health struggles. In addition, full-time employees are eligible for 10 US paid holidays, 20-25 paid time off days, disability & life insurance, medical, dental, and vision insurance (employee contribution starting at $135, $7, and $5 per month respectively) and FSA for healthcare, childcare, and commuter costs. Part-time employees are eligible for a proportionate amount of paid time off. These additional benefits apply to employees who work at least 6 months within a 12 month time period. Standard of Professional Conduct:The IRC and the IRC workers must adhere to the values and principles outlined in the IRC Way - our Code of Conduct. These are Integrity, Service, Accountability, and Equality.

 Commitment to Gender, Equality, Diversity, and Inclusion: The IRC is committed to creating a diverse, inclusive, respectful, and safe work environment where all persons are treated fairly, with dignity and respect. The IRC expressly prohibits and will not tolerate discrimination, harassment, retaliation, or bullying of the IRC persons in any work setting. We aim to increase the representation of women, people that are from country and communities we serve, and people who identify as races and ethnicities that are under-represented in global power structures.

Requisition ID: req55765 Job Title: Digital Product Manager Sector: Communications Employment Category: Regular Employment Type: Full-Time Compensation: USD 69,000.00 - 73,000.00 Annually Location: New York, NY HQ USA Work Arrangement: Fully Remote Job Description Program Overview: Implemented by the IRC, the Cultural Orientation Resource Exchange (CORE) is a technical assistance program that connects and supports refugee resettlement staff globally to deliver effective Cultural Orientation which helps newcomers achieve self-sufficiency in the United States. Settle In, available in multiple languages, is CORE's digital information service that directly engages newcomers through its website (https://www.SettleInUS.org), mobile app, and social media platforms. Settle In serves as another touchpoint to disseminate vital, accurate information tied to resettlement services. Job Overview: The Digital Product Manager will report to CORE's Digital Product Officer and support contributions to the growth and strategic effectiveness of the CORE website, Settle In website, and Settle In mobile app while supporting day-to-day operations. The Digital Product Manager will manage content on CORE's digital platforms using Drupal, WordPress, and Phrase TMS (translation management system), which includes building pages, uploading content and translations, and supporting product improvements in collaboration with internal teams and external partners. This role also oversees project management and communications with vendors that support maintenance and development of CORE's digital products. Major Responsibilities: <ul><li>Manage content on the CORE website, the Settle In website, and the Settle In mobile app using content management systems (WordPress/Drupal), translation management systems (Phrase), and other relevant software;</li><li>Manage maintenance vendors for the Settle In website, Settle In mobile app, and CORE website, and coordinate across IRC and external teams (e.g., Phrase TMS, Semrush, Hotjar) to ensure products are fully operational and bug-free;</li><li>Develop project plans and coordinate among internal teams and external vendors to monitor project progress, resolve issues, and implement improvements;</li><li>Conduct quality assurance of CORE's digital platforms on an ongoing basis, including when uploading new content or during other related updates; </li><li>Support the Digital Product Officer in developing and implementing the product vision and roadmap of CORE's digital products based on their impact on business goals and user needs; </li><li>With support from theDigital Officer and Monitoring & Evaluation Officer, assist with implementing user testing, user feedback initiatives, and other assessments of CORE digital platforms to ensure frequent and actionable user feedback is incorporated into product decisions; </li><li>With support from the Digital Product Officer and Monitoring & Evaluation Officer, evaluate digital analytics (Google Analytics, Firebase, Hotjar, Semrush), analyze findings, and make recommendations to increase awareness, use, and engagement of CORE's digital resources; </li><li>Collaborate across internal teams to ensure maximum visibility and integration of all new CORE resources;</li><li>As needed, support development of product management guidelines, frameworks, SoPs, and best practices;</li><li>Represent CORE at meetings, internal and external workshops and conferences, and other events, as needed;</li><li>Perform other duties as assigned.</li></ul> Job Requirements: <ul><li>Bachelor's Degree in computer science, library science, multimedia journalism, communications, or a related field required;</li><li>Minimum 2-3 years progressive work experience; </li><li>Experience with WordPress/Drupal website content management required, preference for experience managing large, complex websites in multiple languages;</li><li>Experience working with designers and developers, with proven ability to understand and communicate product needs and requirements between non-technical and technical collaborators;</li><li>Excellent written and oral communication skills: the ability to communicate effectively with colleagues and partners from diverse backgrounds and experiences;</li><li>Solid project management and organizational skills with the ability to juggle multiple tasks, coordinate multiple stakeholders, set priorities, effectively manage time, and meet deadlines;</li><li>Detail orientated and self-directed;</li><li>Solid computer skills: facility with Microsoft Office, email/internet, and project management software (e.g., Monday.com);</li><li>Strong commitment to social service or humanitarian assistance programs and willingness to adhere to IRC's code of conduct;</li><li>Demonstrated knowledge of the US Refugee Admissions Program and Cultural Orientation programs preferred;</li><li>The ability to be flexible and work well under pressure in a fast-paced team environment.</li></ul> Working Environment: <ul><li>Remote position</li></ul> Compensation: Posted pay ranges apply to US-based candidates. Ranges are based on various factors including the labor market, job type, internal equity, and budget.Exact offers are calibrated by work location, individual candidate experience and skills relative to the defined job requirements. Equal Opportunity Employer: We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation. US Benefits: The IRC offers a comprehensive and highly competitive set of benefits. All US employees are eligible for sick time, a 403b retirement savings plans: up to 4.5% immediately vested matching contribution, plus an 3-7% additional IRC contribution, and an Employee Assistance Program which is available to our staff and their families to support in times of crisis and mental health struggles. In addition, full-time employees are eligible for 10 US paid holidays, 20-25 paid time off days, disability & life insurance, medical, dental, and vision insurance (employee contribution starting at $135, $7, and $5 per month respectively) and FSA for healthcare, childcare, and commuter costs. Part-time employees are eligible for a proportionate amount of paid time off. These additional benefits apply to employees who work at least 6 months within a 12 month time period.

International Rescue Committee Interview Questions

International Rescue Committee Interview Guides

International Rescue Committee Interview Questions

International Rescue Committee Salaries by Position

International Rescue Committee Opening Jobs