Prepare for and practice interview questions from Federal Reserve Bank Of Richmond.

Federal Reserve Bank Of Richmond Interview Questions

Federal Reserve Bank Of Richmond Interview Guides

<p>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.</p>

<p>Write a query to randomly sample a row from this table.</p>

<p><strong>Input:</strong></p>

<p><code>big_table</code> table</p>

<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

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


<p>What is a key disadvantage of the F-test when compared to multiple t-tests?</p>

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?

<p>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.</p>

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

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


<p>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?</p>

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?

Federal Reserve Bank Of Richmond Salaries by Position

<p>Company
Federal Reserve Bank of Richmond

When you join the Federal Reserve—the nation's central bank—you’ll play a key role, collaborating with leading tech professionals to strengthen and protect our economic, financial and payments systems. We invest in contemporary and emerging technology each year to support the Federal Reserve and our economy, and we’re building a dynamic and diverse team for our future.

Bring your passion and expertise, and we’ll provide the opportunities that will challenge you and propel your growth—along with a wide range of benefits and perks that support your health, wealth, and life. In addition to competitive compensation, we offer a comprehensive benefits package that includes tuition assistance, generous paid time off, top-notch health care benefits, child and family care leave, professional development opportunities, a 401(k) match, pension, and more. All brought together in a flexible work environment where you can truly find balance.

About the Opportunity
The Information Technology Services (ITS) Demand and Portfolio Management department has an immediate opening for a Business Analyst at either the Advanced or Senior level, reporting to the ITS Business Enablement Manager.

As the Business Analyst, you will provide research and analyze data to identify appropriate solutions and provide recommendations to solve problems and issues related to ITS Demand and Portfolio Management. You will provide guidance in identifying and developing processes and procedures that are effective and meet requirements; and plan and execute solutions and provide consultation to clients, colleagues and management. You will also use your technical expertise in Tableau/Power BI to create dashboards. You will participate in Federal Reserve System or customer workgroups concerning areas related to ITS or your role as a Business Analyst.

What You Will Do:

Perform complex analysis of major business issues and search for and recommend sustainable solutions using established methodology and tools.

Reviews and conducts analysis of budget, forecast, and actual expenditures within FedPPM (Clarity) and provides timely, relevant and accurate reporting of the results of organization's performance to facilitate decision-making towards the achievement of the budget and strategic plan.

Review, compile, and analyze detailed and complex statistics and data for major business issues, and provide guidance and collaboration in completing analysis, information or process mapping, and/or alignment of the business and related areas.

Lead process improvement and solution discussions and present outcomes and actionable recommendations to senior management.

Develop and design new processes of major and critical nature, and coordinate the updating of existing business processes.

Leverage technical expertise to develop reports and dashboards.

Qualifications:

Bachelor’s degree or higher; concentration in a business, finance or technical field preferred.

Advanced Level: 9+ years of relevant experience. Senior Level: 5+ years of relevant experience.

Demonstrated written and verbal communication skills, with the ability to articulate technical concepts to all audiences.

Experience with Excel Pivot tables, Jaspersoft, and Tableau/Power BI.

Exceptional computer skills, including Microsoft Office suite.

Discover the Reason Why So Many People Love It Here!
When you join the Richmond Fed, not only will you find a challenging and purposeful career, you’ll also have access to a wide range of benefits and perks that support your health and wealth, including:

Great medical benefits

Pension and 401(k) with employer match

Paid time off

Tuition reimbursement

Employee resource networks

Paid volunteer leave

Flexible work options

Onsite amenities that make working here fun

Other Requirements and Considerations:

Candidates should review the Bank’s Employee Code of Conduct to ensure compliance with conflict-of-interest rules and personal investment restrictions.

If you need assistance or an accommodation due to a disability, please notify rich.recruit@rich.frb.org .

Employees who work at and/or visit another Federal Reserve entity or outside business as part of their job duties are required to comply with any onsite safety and health protocols of those organizations (including, but not limited to, requirements to vaccinate or test, mask, social distance, etc.).

Sponsorship is not available for this role. Selected candidate is subject to special background check procedures.

The Federal Reserve offers a hybrid work environment with 3 days working onsite per week (onsite Tuesday, Wednesday and Thursday).

The hiring range for the Business Analyst- Senior is $79,400 - $109,120 annually and the Business Analyst-Advanced is $88,900 - $111,100 - $144,400.

Salary offered will be based on the job responsibilities and the individual’s knowledge, skills, and experience as defined in the job qualifications/experience.

Applications are reviewed on a rolling basis. Interested candidates are strongly encouraged to apply as soon as possible.

The Federal Reserve Banks believe that diversity and inclusion among our employees is critical to our success as an organization, and we seek to recruit, develop and retain the most talented people from a diverse candidate pool. The Federal Reserve Banks are committed to equal employment opportunity for employees and job applicants in compliance with applicable law and to an environment where employees are valued for their differences.

#J-18808-Ljbffr</p>

Federal Reserve Bank Of Richmond Interview Questions

Federal Reserve Bank Of Richmond Interview Guides

Federal Reserve Bank Of Richmond Interview Questions

Federal Reserve Bank Of Richmond Salaries by Position

Federal Reserve Bank Of Richmond Opening Jobs