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

Tiaa Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Tiaa? The Tiaa Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Tiaa Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Tiaa.</li>
<li>Practice real Tiaa Business Intelligence interview questions.</li>
</ul>
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 Tiaa Business Intelligence interview.


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

- Know what skills are necessary for Tiaa Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Tiaa.
- Practice real Tiaa 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 Tiaa Business Intelligence interview.
        

Overview

Tiaa Business Intelligence Salary

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

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

Tiaa Business Intelligence Interview Process

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.

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

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

Example:

Input:

<code>bank_transactions</code> table

<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>
Output:

<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

You’ve been asked to analyze the player’s behaviors at a gaming company.

Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.

Example:

Input:

<code>players</code> table

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

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

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Obtain count of players based on games played.

Player Analysis

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

Example:

Input:

<code>transactions</code> table

<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>
<code>users</code> table

<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>
 
Output:

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

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

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

Customer Orders

Tiaa Business Intelligence Interview Questions

Nuveen Investment’s Leveraged Finance team is seeking to hire an analyst to evaluate the full capital structure of convertible bond issuers, the majority of whom are in the technology and healthcare sectors.
The Leveraged Finance platform at Nuveen applies a collaborative and team-based approach to rigorous fundamental underwriting across the capital structure and risk spectrum. The team’s philosophy is to invest, both long and short, where relative value dislocations and event-driven catalysts exist. Investment strategies include hedge funds, separately managed accounts, comingled strategies, and sub-advisory mandates for both retail and institutional clients, including Nuveen’s parent company, TIAA-CREF.
This analyst will be dedicated to a multi-strategy credit hedge fund that includes convertible arbitrage, long/short credit, and CLO investments.
 
Key Responsibilities and Duties
<ul>
<li>Assume primary coverage for convertible bond investments, both new issues and secondary opportunities.</li>
<li>Make investment recommendations and have real-time views on companies, including their credit quality and equity valuation.</li>
<li>Actively monitor investments and take a predictive approach to managing risk exposures.</li>
<li>Engage with management teams regularly to discuss business conditions and potential catalysts.</li>
<li>Monitor, research, and analyze relevant economic, industry, and company data and market trends, preparing reports and developing models to support investment decisions.</li>
<li>Contribute to all formal reports and research processes (internal ratings, recommendation lists, watch lists, etc.) that enable the efficient and transparent oversight of the coverage universe.</li>
</ul>
 
Educational Requirements
<ul>
<li>University (Degree) Preferred</li>
</ul>
 
Work Experience
<ul>
<li>3+ Years Required; 5+ Years Preferred</li>
</ul>
 
Physical Requirements
<ul>
<li>Sedentary Work</li>
</ul>
 
Career Level 7IC
Related Skills
Asset Valuation, Capital Markets, Collaboration, Communication, Credit Analysis, Data Analysis, Financial Modeling, Fixed Income Investments, Investment Research/Analysis, Investments, Market/Industry Dynamics, Research Synthesization, Sector Expertise, Underwriting
 
Anticipated Posting End Date: 2025-01-31
Base Pay Range: $118,100/yr. - $180,000/yr.
Actual base salary may vary based upon relevant experience, time in role, base salary of internal peers, prior performance, business sector, and geographic location. In addition to base salary, the competitive compensation package may include participation in an incentive program linked to performance.
 
Company Overview
Nuveen, the investment manager of TIAA, offers a comprehensive range of outcome-focused investment solutions designed to secure the long-term financial goals of institutional and individual investors. Its affiliates offer deep expertise across a comprehensive range of traditional and alternative investments through a wide array of vehicles and customized strategies.
For more information about the firm please visit our website <a href="#">www.Nuveen.com</a>.
 
Benefits and Total Rewards
The organization is committed to making financial well-being possible for its clients and is equally committed to the well-being of our associates. That’s why we offer a comprehensive Total Rewards package designed to make a positive difference in the lives of our associates and their loved ones. Our benefits include a superior retirement program and highly competitive health, wellness, and work-life offerings that can help you achieve and maintain your best possible physical, emotional, and financial well-being.
To learn more about your benefits, please review our <a href="#">Benefits Summary</a>.
 
Equal Opportunity
We are an Equal Opportunity/Affirmative Action Employer. We consider all qualified applicants for employment regardless of age, race, color, national origin, sex, religion, veteran status, disability, sexual orientation, gender identity, or any other protected status.
Read more about the Equal Opportunity Law <a href="#">here</a>.
 
Accessibility Support
TIAA offers support for those who need assistance with our online application process to provide an equal employment opportunity to all job seekers, including individuals with disabilities.
If you are a U.S. applicant and desire a reasonable accommodation to complete a job application please use one of the below options to contact our accessibility support team:
Phone: (800) 842-2755
Email: <a href="#">accessibility.support@tiaa.org</a>
 
Privacy Notices
For Applicants of TIAA, Nuveen and Affiliates residing in US (other than California), click <a href="#">here</a>.
For Applicants of TIAA, Nuveen and Affiliates residing in California, please click <a href="#">here</a>.
For Applicants of Nuveen residing in Europe and APAC, please click <a href="#">here</a>.
#J-18808-Ljbffr

Nuveen Investment’s Leveraged Finance team is seeking to hire an analyst to evaluate the full capital structure of convertible bond issuers, the majority of whom are in the technology and healthcare sectors.
The Leveraged Finance platform at Nuveen applies a collaborative and team-based approach to rigorous fundamental underwriting across the capital structure and risk spectrum. The team’s philosophy is to invest, both long and short, where relative value dislocations and event driven catalysts exist. Investment strategies include hedge funds, separately managed accounts, comingled strategies and sub-advisory mandates for both retail and institutional clients, including Nuveen’s parent company, TIAA-CREF.
This analyst will be dedicated to a multi-strategy credit hedge fund that includes convertible arbitrage, long/short credit, and CLO investments.
 
Key Responsibilities and Duties
<ul>
<li>Assume primary coverage for convertible bond investments, both new issues and secondary opportunities.</li>
<li>Make investment recommendations and have real-time views on companies, including their credit quality and equity valuation.</li>
<li>Actively monitor investments and take predictive approach to managing risk exposures.</li>
<li>Engage with management teams regularly to discuss business conditions and potential catalysts.</li>
<li>Monitor, research and analyze relevant economic, industry, and company data and market trends, preparing reports and developing models to support investment decisions.</li>
<li>Contribute to all formal reports and research processes (internal ratings, recommendation lists, watch lists, etc.) that enable the efficient and transparent oversight of the coverage universe.</li>
</ul>
Educational Requirements
<ul>
<li>University (Degree) Preferred</li>
</ul>
Work Experience
<ul>
<li>3+ Years Required; 5+ Years Preferred</li>
</ul>
Physical Requirements
<ul>
<li>Sedentary Work</li>
</ul>
 
Career Level 7IC
Related Skills
Asset Valuation, Capital Markets, Collaboration, Communication, Credit Analysis, Data Analysis, Financial Modeling, Fixed Income Investments, Investment Research/Analysis, Investments, Market/Industry Dynamics, Research Synthesization, Sector Expertise, Underwriting
Anticipated Posting End Date: 2025-01-31
Base Pay Range: $118,100/yr. - $180,000/yr.
Actual base salary may vary based upon, but not limited to, relevant experience, time in role, base salary of internal peers, prior performance, business sector, and geographic location. In addition to base salary, the competitive compensation package may include, depending on the role, participation in an incentive program linked to performance (for example, annual discretionary incentive programs, non-annual sales incentive plans, or other non-annual incentive plans).
Company Overview
Nuveen, the investment manager of TIAA, offers a comprehensive range of outcome-focused investment solutions designed to secure the long-term financial goals of institutional and individual investors. Its affiliates offer deep expertise across a comprehensive range of traditional and alternative investments through a wide array of vehicles and customized strategies. For more information about the firm please visit our website at <a href="#">www.Nuveen.com</a>.
Benefits and Total Rewards
The organization is committed to making financial well-being possible for its clients, and is equally committed to the well-being of our associates. That’s why we offer a comprehensive Total Rewards package designed to make a positive difference in the lives of our associates and their loved ones. Our benefits include a superior retirement program and highly competitive health, wellness and work life offerings that can help you achieve and maintain your best possible physical, emotional and financial well-being. To learn more about your benefits, please review our <a href="#">Benefits Summary</a>.
Equal Opportunity
We are an Equal Opportunity/Affirmative Action Employer. We consider all qualified applicants for employment regardless of age, race, color, national origin, sex, religion, veteran status, disability, sexual orientation, gender identity, or any other protected status.
Read more about the Equal Opportunity Law <a href="#">here</a>.
Accessibility Support
TIAA offers support for those who need assistance with our online application process to provide an equal employment opportunity to all job seekers, including individuals with disabilities.
If you are a U.S. applicant and desire a reasonable accommodation to complete a job application please use one of the below options to contact our accessibility support team:
Phone: (800) 842-2755
Email: <a href="#">accessibility.support@tiaa.org</a>
Privacy Notices
For Applicants of TIAA, Nuveen and Affiliates residing in US (other than California), click <a href="#">here</a>.
For Applicants of TIAA, Nuveen and Affiliates residing in California, please click <a href="#">here</a>.
For Applicants of Nuveen residing in Europe and APAC, please click <a href="#">here</a>.
#J-18808-Ljbffr

TIAA is seeking a Mainframe (IBM z/OS), Adabas/Db2 Administrator who will manage test data hosted on Adabas, Db2 and VSAM data stores for mainframe application testing. This role will use mainframe utilities to refresh data from production data store systems, perform data masking (scrambling) and restore to test data stores. This role will work closely with the business quality assurance (QA) team and developers to ensure the data meets their requirement in advance of testing. Additionally, this role will work with Data Base Administrator(s) as needed to maintain the stability and availability of the test data stores. Key Responsibilities and Duties<ul><li>Work with the QA teams and developers to align test data requirements with the testing criteria.</li><li>Analyze data requirements and ensure data integrity during the testing process.</li><li>Collaborate on unit test plans and test cases to ensure the accuracy of source data.</li><li>Perform refresh of test data from Adabas, Db2 and VSAM data stores.</li><li>Scramble sensitive and confidential data before releasing for testing.</li><li>Document/update processes, procedures and runbooks as required.</li><li>Work with Data Base Administrator(s) to resolve database performance, capacity, and other database related issues.</li><li>Perform standard administration of mainframe files like copying and transferring.</li><li>Confirm data is appropriately scrambled and aligned with Cyber security standards.</li><li>Ensure alignment with Change/Incident management processes and procedures.</li></ul>Educational Requirements<ul><li>Bachelor's Degree Preferred</li></ul>Work Experience<ul><li>3+ Years Required; 5+ Years Preferred</li></ul>Physical Requirements<ul><li>Physical Requirements: Sedentary Work</li></ul>Qualifications:Required:<ul><li>Minimum of 3+ years of experience supporting mainframe data platform on z/OS mainframe operating system. Basic knowledge of relational databases.</li><li>Experience with data refresh processes and masking techniques for data hosted on Adabas, VSAM and Db2.</li></ul>Preferred:<ul><li>Working knowledge of the Mainframe and its utilities.</li><li>Familiar with ITIL Change/Incident management best practices.</li><li>Prior experience supporting quality assurance and development teams.</li><li>Familiar with automation using scripts to schedule the jobs (i.e. Runstats, Image copy, Restore, Load/Unload, etc.).</li><li>Knowledge of RACF and Db2.</li><li>Ability to manage multiple projects simultaneously and work in a fast-paced work environment.</li><li>Knowledge of scrambling tools used for data masking such as Dataguise.</li></ul>
#J-18808-Ljbffr

Tiaa Business Intelligence Interview Guide

Overview

Tiaa Business Intelligence Salary

Tiaa Business Intelligence Interview Process

Tiaa Business Intelligence Interview Questions

Tiaa Business Intelligence Jobs