The Northern Trust Corporation Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Northern Trust Corporation Business Intelligence Interview Guide

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


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

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

Overview

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.

Northern Trust Corporation 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

What are the logistic and softmax functions? What is the difference between the two?

What makes them useful for use in logistic regression?

In logistic regression, how is the predicted class determined based on the logistic function?

In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

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

Northern Trust Corporation Business Intelligence Interview Questions

About Northern Trust: Northern Trust, a Fortune 500 company, is a globally recognized, award-winning financial institution that has been in continuous operation since 1889. Northern Trust is proud to provide innovative financial services and guidance to the world's most successful individuals, families, and institutions by remaining true to our enduring principles of service, expertise, and integrity. With more than 130 years of financial experience and over 22,000 partners, we serve the world's most sophisticated clients using leading technology and exceptional service. Job Title: Associate Product Manager - Global Family Office (GFO) About Global Family Office: The Global Family & Private Investment Offices team ("GFO") is a sales and client servicing group, within the Wealth Management division, specifically dedicated to supporting ultra-high net worth individuals and families (>$200m of investable assets), their charities and foundations. Given their wealth, these families act like institutions but require a personal and high touch approach, as well as the highest level of discretion. Our family's wealth is mixed in nature with some being multi-generational inherited wealth and some being new entrepreneurial wealth. With the diversity of their investments, they often take a broad range of products and services from Northern Trust including asset servicing (custody), fiduciary, fund administration, investment management and banking/credit. Job Description Summary: Associate Product Managers are critical team members to ensuring smooth, optimized, and successful execution of new product features and enhancements. Associate Product Managers work closely with the Domain's Product Manager, Engineering Manager and Scrum Teams as well as the Head of Product Management and GFO Business partners. Associate Product Managers are responsible for supporting their Domain's features across the entire product development lifecycle - from product discovery & design to story writing and working with engineering teams to conduct agile delivery, to release communication and management, to following up on product performance and maintenance. Responsibilities: The Associate Product Managers are critical team members to smooth, optimized, and successful execution of new product features and enhancements. Their responsibilities include: <ul><li>Collaborate closely with Product Manager and Development Team to deliver story quality, timing, assignment and volume to manage and prioritize Sprint backlogs <ul><li>Decompose features for each MVP into high-level functional and non-functional stories</li><li>Write complete user stories and acceptance criteria which meet the Definition of Ready (DoR) and in a way that create best-in-class client- and partner-friendly omni-channel solutions</li><li>Cohost Product Backlog Refinement sessions</li><li>Prioritize stories within backlog with quant/qual data</li><li>Ensure user stories meet the Definition of Ready (DoR) before socializing to the Scrum Teams</li><li>Actively participate in release nights to validate and test new features and fixes in real-time.</li></ul></li><li>Lead Sprint Reviews with key stakeholders to secure buy-in, ensure timely follow-up and closure on feedback and action items</li><li>Assist Product Manager to ensure effective Product Backlog management, grooming, tagging, and prioritization</li><li>Assist Product Manager and Scrum Leads in maintaining a deliberate and on-track overarching Project Plan and Product Roadmap</li><li>Engage and collaborate with Product Manager and others (Designer, Architect, Tech Lead, team members, etc.) as needed to understand scope to create product backlog items</li><li>Ensure Product Backlog is transparent, visible, and understood by the Scrum Team</li><li>Act as proxy Scrum Master to help address/resolve dependencies and risks</li><li>Act as proxy Scrum Master for Scrum/PI Planning events (ie: daily scrum, sprint planning, PI planning, etc.)</li><li>Assist with testing</li><li>Help identify and escalate dependencies and risks</li><li>Coordinate Release Management and communication</li><li>Assist Product Manager and Product Leadership with other ad-hoc projects as needed (such as presentations, roadmaps, strategic research, etc.)</li></ul> Key Characteristics: <ul><li>3+ year experience with functional and technical story writing, acceptance criteria, refinement, and Agile practices preferred</li><li>Superior analytical skills that will allow for detailed research when planning for new features/enhancements or looking into issues</li><li>Good communicator, written and verbal</li><li>Ability to multi-task and simultaneously work on multiple things</li><li>Attention to details</li><li>Stay accountable to clarify and review the user stories for the Scrum Team in a timely manner</li><li>Good facilitator</li><li>Reliable and dependable</li><li>Excellent problem-solving skills and the ability to work under tight deadlines.</li><li>Focused on moving the team forward</li><li>Follow up on clarification</li><li>Stay up to date on Scrum Team's status</li><li>Encourage collaboration and communication</li><li>High sense of urgency</li><li>Curious and ask questions, continuous learning mindset</li><li>Committed to continuous improvement</li><li>Technical Skills: Azure DevOps, Confluence, MS O365 Suite</li></ul> Salary Range: $80,800 - 133,400 USD Salary range is a good faith estimate of base pay. Northern Trust provides a comprehensive benefits package including retirement benefits (401k and pension), health and welfare benefits (medical, dental, vision, spending accounts and disability), paid time off, parental and caregiver leave, life & accident insurance, and other voluntary and well-being benefits. Northern Trust also provides a discretionary bonus program that may include an equity component. Working with Us: As a Northern Trust partner, greater achievements await. You will be part of a flexible and collaborative work culture in an organization where financial strength and stability is an asset that emboldens us to explore new ideas. Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to assisting the communities we serve! Join a workplace with a greater purpose. We'd love to learn more about how your interests and experience could be a fit with one of the world's most admired and sustainable companies! Build your career with us and apply today. #MadeForGreater Reasonable accommodation Northern Trust is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at MyHRHelp@ntrs.com. We hope you're excited about the role and the opportunity to work with us. We value an inclusive workplace and understand flexibility means different things to different people. Apply today and talk to us about your flexible working requirements and together we can achieve greater.

About Northern Trust:Northern Trust, a Fortune 500 company, is a globally recognized, award-winning financial institution that has been in continuous operation since 1889.Northern Trust is proud to provide innovative financial services and guidance to the worlds most successful individuals, families, and institutions by remaining true to our enduring principles of service, expertise, and integrity. With more than 130 years of financial experience and over 22,000 partners, we serve the worlds most sophisticated clients using leading technology and exceptional service.The Identity Governance and Administration team is in need of an Information Security Analyst with strong analytical, organizational and problem-solving skills. Candidate must be a fast learner who can hit the ground running, eager to learn, detail-oriented, multi-task oriented, move with urgency and can contribute quickly. Primary focus of the role is on day-to-day deliverables, developing solutions based on subject expertise and giving representation where needed.Job Description/Major Duties:<ol><li>Prepares and sets up applications, tests data for Identity and Access Management projects.</li><li>Interacts with Clients to troubleshoot application issues and determine a resolution.</li><li>Learns and complies with Identity and Access Management principles and objectives.</li><li>Analyzes Clients requests to determine the necessary requirements.</li><li>Implements and identifies improvements to Access Control system enhancements.</li><li>Manages consulting practice with business partners for technology security topics.</li><li>Maintains relationships with partners to manage effectiveness of the access security life cycle management process.</li><li>Mitigates risk of conversions to partners.</li><li>Operates independently; has in-depth knowledge of business unit / function.</li><li>As subject area expert, provides comprehensive, in-depth consulting and leadership to team and partners at a high technical level.</li><li>Carries out activities that are large in scope, cross-functional and technically difficult.</li><li>Role is balanced between high level operational execution and development, and execution of strategic direction of business function activities.</li></ol>Knowledge/Skills:<ul><li>Excellent oral and written communication skills are required.</li><li>Highly motivated, self-directed and possess solid execution skills.</li><li>Strong analytical, organizational and problem-solving skills are required.</li><li>Experienced in writing business requirements and details.</li><li>Experience leading requirements gathering sessions.</li><li>Demonstrates critical thought and probes beyond the surface of the requested data to get at the valuable (actionable) information.</li><li>An in-depth understanding of Information Security is beneficial.</li><li>Must be highly flexible and adaptable to change.</li><li>Excellent people skills are also necessary since this position interacts with all levels of resources across the entire organization.</li><li>In-depth Functional/Industry Knowledge, such as IT audit, IT Risk Management and Information Security is beneficial.</li></ul>Additional Responsibilities:<ol><li>Working in a collaborative team environment helping the team to maintain and build integrations with cloud and on-prem solutions at Northern Trust.</li><li>Responsible for application configuration and integration, evaluates and makes recommendations on techniques, practices, or technologies that would enhance business needs, also does work to ensure continuous process improvements.</li><li>Coding, testing, and debugging application programs from functional specifications.</li></ol>Experience Level: (2-5+ yrs)Qualifications:<ul><li>Strong development/support experience in Java, microservices, Spring Boot, Python Spring Framework, SQL databases.</li><li>Understanding of enterprise architecture patterns and best practices.</li><li>Azure DevOps/Control-M/ServiceNow experience.</li><li>Experience working across Linux and Windows Active Directory platforms.</li><li>Excellent oral and written communication skills are required.</li><li>Highly flexible and adaptable to change.</li><li>Analytical and problem-solving skills.</li><li>A positive goal-oriented attitude with a focus on service delivery.</li></ul>Nice to Haves:<ul><li>Cloud-based container architecture on Azure and/or AWS.</li><li>IAM/IGA Product Expertise.</li></ul>Tasks and Responsibilities:<ol><li>Monitor and troubleshoot application issues in production.</li><li>Leads troubleshooting, analysis, and solution of unexpected systems behaviors that impact the quality of service.</li><li>Liaise with stakeholders (tech and business) in problem resolution.</li><li>Communicate issue/resolution status (written and verbal) to project team and management.</li><li>Minor production bug fixes.</li><li>Disaster Recovery and Patch testing.</li><li>Perform Setup/configure tasks related to application onboarding.</li><li>Perform reconciliation and reporting of identity and access data.</li><li>Access review/Audit activity.</li></ol>Other Experience:A College or University degree and/or relevant proven work experience in the area of Information Security is required. Industry certification such as CISSP, CISM, CISA, GIAC is preferred. Proven experience working with commercial IAM products for a sizeable enterprise (preferably 5,000+ employees / external users), including development of solutions for Identity Management, user provisioning, Single-Sign & Reduced Sign On and Web Access Management solutions.Salary Range: $74,200 - 126,200 USDSalary range is a good faith estimate of base pay. Northern Trust provides a comprehensive benefits package including retirement benefits (401k and pension), health and welfare benefits (medical, dental, vision, spending accounts and disability), paid time off, parental and caregiver leave, life & accident insurance, and other voluntary and well-being benefits. Northern Trust also provides a discretionary bonus program that may include an equity component.Working with Us:As a Northern Trust partner, greater achievements await. You will be part of a flexible and collaborative work culture in an organization where financial strength and stability is an asset that emboldens us to explore new ideas.Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to assisting the communities we serve! Join a workplace with a greater purpose.Wed love to learn more about how your interests and experience could be a fit with one of the worlds most admired and sustainable companies! Build your career with us and apply today.Reasonable accommodation:Northern Trust is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at <a href="#">MyHRHelp@ntrs.com</a>.We hope youre excited about the role and the opportunity to work with us. We value an inclusive workplace and understand flexibility means different things to different people.Apply today and talk to us about your flexible working requirements and together we can achieve greater. #J-18808-Ljbffr

About Northern Trust:

Northern Trust, a Fortune 500 company, is a globally recognized, award-winning financial institution that has been in continuous operation since 1889.

Northern Trust is proud to provide innovative financial services and guidance to the world's most successful individuals, families, and institutions by remaining true to our enduring principles of service, expertise, and integrity. With more than 130 years of financial experience and over 22,000 partners, we serve the world's most sophisticated clients using leading technology and exceptional service.

Role/ Department:

Due to a significant increase in workload especially in the area of regulatory reporting analysis we need to recruit a graduate trainee in the Brokerage Product Owner team

The key responsibilities of the role include:
Partners with Product Management and Business stakeholders to influence, support, and champion product vision and roadmaps, and to coordinate value realization across teams beyond their direct responsibility
Anticipates potential future client needs and proactively positions product capabilities to take advantage of business opportunities
Maintains a well-groomed backlog of development items to be used for efficient implementation of projects
Influences the shape and champions the adoption of automated testing frameworks; reviews and agrees acceptance criteria for new development and signs off on business-readiness, in coordination with quality assurance team members
Face off to Feature Team Business Owner
Agree catalogue priorities
Provide estimates and costs
Provide ongoing progress updates
Discuss timescales and resource constraints
Provide product demos
Discuss phased delivery
Manage Feature Team Priorities and Work Items with Technology
Be responsible for delivery of the requirement as it moves through the sprint cycle from development to testing to go-live
Add JIRA's to sprints and provide feedback to Business owners regarding effort and delivery dates
Discuss effort with development and add estimates to JIRAs
Document requirements and raise JIRAs
Face off to business users to capture detailed global requirements
Update technology on Business Owners priorities
Documentation and Testing
Work with the test team to script the changes for initial delivery and then discuss automation and regression
Document changes and educate support team and the business. Each major delivery or change will be included in a 'Quick Reference Guide (QRG)'
Assist support teams in each region post go-live
Skills/ Qualifications:     No prior product or business knowledge is required and on the job training will be given
Excellent communication and problem-solving skills
A willingness to learn and a high level of enthusiasm is needed
Comfortable operating in a technical environment involving complex business logic and its programmatic implementation
A strong work ethic
The ability to listen to advice, absorb and react to it
Be able to adapt to different situations and take ownership of issues
Good communication skills

Salary Range:
$60,720 - 91,080 USD

Salary range is a good faith estimate of base pay. Northern Trust provides a comprehensive benefits package including retirement benefits (401k and pension), health and welfare benefits (medical, dental, vision, spending accounts and disability), paid time off, parental and caregiver leave, life & accident insurance, and other voluntary and well-being benefits. Northern Trust also provides a discretionary bonus program that may include an equity component.

Working with Us:

As a Northern Trust partner, greater achievements await. You will be part of a flexible and collaborative work culture in an organization where financial strength and stability is an asset that emboldens us to explore new ideas.

Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to assisting the communities we serve! Join a workplace with a greater purpose.

We'd love to learn more about how your interests and experience could be a fit with one of the world's most admired and sustainable companies! Build your career with us and apply today. #MadeForGreater

Reasonable accommodation

Northern Trust is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at MyHRHelp@ntrs.com.

We hope you're excited about the role and the opportunity to work with us. We value an inclusive workplace and understand flexibility means different things to different people.

Apply today and talk to us about your flexible working requirements and together we can achieve greater.

Northern Trust Corporation Business Intelligence Interview Guide

Overview

Northern Trust Corporation Business Intelligence Interview Process

Northern Trust Corporation Business Intelligence Interview Questions

Northern Trust Corporation Business Intelligence Jobs