The Fannie Mae Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Fannie Mae Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Fannie Mae? The Fannie Mae Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Fannie Mae Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Fannie Mae.</li>
<li>Practice real Fannie Mae Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Fannie Mae Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Fannie Mae? The Fannie Mae Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Fannie Mae Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Fannie Mae.
- Practice real Fannie Mae Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Fannie Mae Business Intelligence interview.
        

Overview

Fannie Mae Business Intelligence Salary

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Fannie Mae Business Intelligence Interview Process

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.</p>

<p>Write a query to get the total three-day rolling average for deposits by day.</p>

<p><em>Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout</em></p>

<p><strong>Example:</strong></p>

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

<p><code>bank_transactions</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Rolling Bank Transactions

<p>Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.</p>

<p><strong>Example:</strong></p>

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

<p><code>transactions</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>users</code> table</p>

<table>
<thead>
<tr>
<th>Column</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>
<p> 
<strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>customer_name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>


<p>Which of the following queries will return a list of customers and the total amount they have spent on orders?</p>


Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

<p>Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.</p>

<p>You wish to begin with the age group that is currently generating the most connections (fastest growing).</p>

<p>Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.</p>

<p><em>Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.</em></p>

<p><em>We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

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

<p><strong><code>friend_requests</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>requests_accepted</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>age_groups</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>user_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

Fannie Mae Business Intelligence Interview Questions

<h3>Job Description</h3><div>Job Description<div>Company Description<br><br><p>At Fannie Mae, futures are made. The inspiring work we do helps make a home a possibility for millions of homeowners and renters. Every day offers compelling opportunities to use tech to tackle housing’s biggest challenges and impact the future of the industry. You’ll be a part of an expert team thriving in an energizing, flexible environment. Here, you will grow your career and help create access to fair, affordable housing finance.</p>Job Description<br><br><p>As a valued colleague on our team, you will contribute to supporting the product lifecycle, provide tactical support across product areas, collaborate with the team in assessing product needs and conducting product backlog maintenance, as well as collaborate with the team in managing plans, issues, and risks for products.<br><br><strong>THE IMPACT YOU WILL MAKE</strong><br /> The Sr. Product Analyst role will offer you the flexibility to make each day your own, while working alongside people who care so that you can deliver on the following responsibilities:</p><ul><li>Gather information about new or existing products.</li><li>Assess current state of product to discover additional needs.</li><li>Contribute to the design, development, testing, and evaluation of products.</li><li>Support multiple internal groups in an energizing environment.</li><li>Coordinate with internal team to define product strategy and customer outreach.</li></ul>Qualifications<br><br><p><strong>THE EXPERIENCE YOU BRING TO THE TEAM</strong></p><p><strong>Minimum Required Experiences:</strong></p><ul><li>At least 2 years of related experience</li></ul><p><strong>Desired Experiences:</strong></p><ul><li>Bachelor’s degree or equivalent in Accounting, Finance or Business administration and management</li><li>At least 2 years with Workday Reporting Tools and Workday Prism Analytics</li><li>4+ years of experience preferred</li><li>Certified in Workday Financials </li><li>Hands on experience and understanding of GL allocations, Reassignment of allocations, configuration, testing and overall monthly period close process</li><li>Continuous improvement mindset: who has/have demonstrated ability to work with various stakeholders to deliver optimal design solutions and skills needed to build positive rapport with various levels of internal and external stakeholders</li><li>Communication including communicating in writing or verbally, copywriting, planning and distributing communication that are adaptable based on the stakeholder.</li><li>Strong accounting skills and deep understanding of internal controls, risk management, and business processes</li><li>A data acumen and experience working with large volumes of data and an ability to balance data integrity and materiality</li><li>Critical thinking, analytical and financial analysis skills</li><li>Collective capabilities for supporting teams, giving/receiving feedback, facilitating meetings, and leading team meetings</li><li>Experience identifying measures, or indicators of system performance, and the actions needed to improve or correct performance to achieve desired outcomes</li><li>Ability to handle highly confidential information in a strictly professional manner</li><li>Leading huddle and/or squad and/or ticket resolution meetings</li><li>Able to analyze the customer requirements and coordinate with business users from techno-functional understanding and communicate with various teams</li><li>Knowledge of financial data usage in accounting, reporting and analysis</li><li>Well-versed with Agile methodology and experience working and leading in a scrum team</li><li>Bachelor’s degree or equivalent in Accounting, Finance or Business administration and management</li><li>Help and direct development of the design strategy for product enhancements with impact analysis documentation</li><li>Help and support team on the implementation process for new products</li><li>Support and provide adequate knowledge transition for any implementation of product improvements</li><li>Responsible for the product lifecycle and ongoing maintenance</li><li>Excellent written and oral communication skill in delivering complex technical information to audience with various background</li></ul><p><strong>Tools</strong></p><ul><li>Skilled in SQL</li><li>Skilled in TOAD SQL database management tool</li><li>Experience using SharePoint</li><li>Skilled in Excel</li><li>Skilled in Microsoft Teams</li><li>Experience using Microsoft Project</li><li>Experience using JIRA</li><li>Strong/Good experience with Workday Reporting Tools and Prism Analytics</li><li>Experience using Blackline</li></ul><br><br>Additional Information<br><br><p>The future is what you make it to be. Discover compelling opportunities at <span class="long-word">careers.fanniemae.com.</span></p><p>Fannie Mae is a flexible hybrid company. We embrace flexibility for our employees to work where they choose, while also providing office space for in-person work if desired. At times, business need may call for on-site collaboration, which means proximity within a reasonable commute to your designated office location is preferred unless job is noted as open to remote.<br><br> Fannie Mae is an Equal Opportunity Employer, which means we are committed to fostering a diverse and inclusive workplace. All qualified applicants will receive consideration for employment without regard to race, religion, national origin, gender, gender identity, sexual orientation, personal appearance, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation in the application process, email us at <span class="long-word">careers_mailbox@fanniemae.com.</span></p><div></div><p>The hiring range for this role is set forth on each of our job postings located on Fannie Mae's Career Site. Final salaries will generally vary within that range based on factors that include but are not limited to, skill set, depth of experience, certifications, and other relevant qualifications. This position is eligible to participate in a Fannie Mae incentive program (subject to the terms of the program). As part of our comprehensive benefits package, Fannie Mae offers a broad range of Health, Life, Voluntary Lifestyle, and other benefits and perks that enhance an employee’s physical, mental, emotional, and financial well-being. See more here.</p></div></div>

<p>Job Description <br><p>As a valued colleague on our team, you will contribute to supporting the product lifecycle, provide tactical support across product areas, collaborate with the team in assessing product needs and conducting product backlog maintenance, as well as collaborate with the team in managing plans, issues, and risks for products.<br><br><strong>THE IMPACT YOU WILL MAKE</strong><br>The Sr. Product Analyst role will offer you the flexibility to make each day your own, while working alongside people who care so that you can deliver on the following responsibilities:</p><ul><li>Gather information about new or existing products.</li><li>Assess current state of product to discover additional needs.</li><li>Contribute to the design, development, testing, and evaluation of products.</li><li>Support multiple internal groups in an energizing environment.</li><li>Coordinate with internal team to define product strategy and customer outreach.</li></ul> <br>Qualifications <br><p><strong>THE EXPERIENCE YOU BRING TO THE TEAM</strong></p><p><strong>Minimum Required Experiences:</strong></p><ul><li>At least 2 years of related experience</li></ul><p><strong>Desired Experiences:</strong></p><ul><li>Bachelors degree or equivalent in Accounting, Finance or Business administration and management</li><li>At least 2 years with Workday Reporting Tools and Workday Prism Analytics</li><li>4+ years of experience preferred</li><li>Certified in Workday Financials </li><li>Hands on experience and understanding of GL allocations, Reassignment of allocations, configuration, testing and overall monthly period close process</li><li>Continuous improvement mindset: who has/have demonstrated ability to work with various stakeholders to deliver optimal design solutions and skills needed to build positive rapport with various levels of internal and external stakeholders</li><li>Communication including communicating in writing or verbally, copywriting, planning and distributing communication that are adaptable based on the stakeholder.</li><li>Strong accounting skills and deep understanding of internal controls, risk management, and business processes</li><li>A data acumen and experience working with large volumes of data and an ability to balance data integrity and materiality</li><li>Critical thinking, analytical and financial analysis skills</li><li>Collective capabilities for supporting teams, giving/receiving feedback, facilitating meetings, and leading team meetings</li><li>Experience identifying measures, or indicators of system performance, and the actions needed to improve or correct performance to achieve desired outcomes</li><li>Ability to handle highly confidential information in a strictly professional manner</li><li>Leading huddle and/or squad and/or ticket resolution meetings</li><li>Able to analyze the customer requirements and coordinate with business users from techno-functional understanding and communicate with various teams</li><li>Knowledge of financial data usage in accounting, reporting and analysis</li><li>Well-versed with Agile methodology and experience working and leading in a scrum team</li><li>Bachelors degree or equivalent in Accounting, Finance or Business administration and management</li><li>Help and direct development of the design strategy for product enhancements with impact analysis documentation</li><li>Help and support team on the implementation process for new products</li><li>Support and provide adequate knowledge transition for any implementation of product improvements</li><li>Responsible for the product lifecycle and ongoing maintenance</li><li>Excellent written and oral communication skill in delivering complex technical information to audience with various background</li></ul><p><strong>Tools</strong></p><ul><li>Skilled in SQL</li><li>Skilled in TOAD SQL database management tool</li><li>Experience using SharePoint</li><li>Skilled in Excel</li><li>Skilled in Microsoft Teams</li><li>Experience using Microsoft Project</li><li>Experience using JIRA</li><li>Strong/Good experience with Workday Reporting Tools and Prism Analytics</li><li>Experience using Blackline</li></ul> <br>Additional Information <br><p>The future is what you make it to be. Discover compelling opportunities at <a href="www.fanniemae.com/careers">careers.fanniemae.com.</a></p><p>Fannie Mae is a flexible hybrid company.?We embrace flexibility for our employees to work where they choose, while also providing office space for in-person work if desired. At times, business need may call for on-site collaboration, which means proximity within a reasonable commute to your designated office location is preferred unless job is noted as open to remote.<br><br>Fannie Mae is an Equal Opportunity Employer, which means we are committed to fostering a diverse and inclusive workplace. All qualified applicants will receive consideration for employment without regard to race, religion, national origin, gender, gender identity, sexual orientation, personal appearance, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation in the application process, email us at careers_mailbox@fanniemae.com.</p><div sr-tagline=""></div><p>The hiring range for this role is set forth on each of our job postings located on Fannie Mae's Career Site. Final salaries will generally vary within that range based on factors that include but are not limited to, skill set, depth of experience, certifications, and other relevant qualifications. This position is eligible to participate in a Fannie Mae incentive program (subject to the terms of the program). As part of our comprehensive benefits package, Fannie Mae offers a broad range of Health, Life, Voluntary Lifestyle, and other benefits and perks that enhance an employees physical, mental, emotional, and financial well-being. See more <a href="https://www.fanniemae.com/careers/benefits">here.</a></p>PandoLogic. Category: , Keywords: Product Analyst</p>

Fannie Mae Business Intelligence Interview Guide

Overview

Fannie Mae Business Intelligence Salary

Fannie Mae Business Intelligence Interview Process

Fannie Mae Business Intelligence Interview Questions

Fannie Mae Business Intelligence Jobs