Senior Consultant, Integrated Portfolio Services Information Delivery

Northern Trust

  • Chicago, IL ; Tempe, AZ
  • On-site
  • Senior level
  • 5+ yrs experience
  • Data Engineering
  • No visa sponsorship
  • $83k–$141k

The role in 30 seconds

The Northern Trust Integrated Portfolio Services Information Delivery team combines technical expertise with business knowledge to support internal and external clients. The team is responsible for delivering client reporting through files, dashboards, and feeds into client data warehouses, and for assisting clients with Snowflake data shares. The Senior Consultant will plan, design, and develop automated data extracts and technical solutions that meet business requirements and align with the frameworks established by the organization’s technical architects.

Is this role a fit for you?

The backgrounds this role is most likely to hire from, as RoleStack reads the posting.

Strong match

  • B2B enterprise platform / workflow software
  • Internal tooling / back-office systems
  • B2B infrastructure / API / developer tools
  • Enterprise users (complex workflows, admin panels, role-based access)
  • Internal users (employees, ops teams)

Workable stretch

  • B2C consumer-facing application
  • Creator / builder / self-serve tool
  • Marketplace / multi-sided platform
  • SMB / small business (self-serve, simplicity-focused)
  • Developers / technical users (docs, APIs, CLIs)

Harder transition

  • Data platform / ML pipeline
  • Embedded systems / hardware-adjacent
  • Consumer / general public (high polish, conversion-focused)

Industry: Financial Services & FinTech. See your personal match score

What they're really screening for

Must-haves

  • CORE Five or more years of relevant professional experience.
  • CORE Demonstrated experience analyzing requirements and developing technical or automated solutions to support data, reporting, systems, or process-improvement initiatives in partnership with technical and nontechnical stakeholders.
  • PLUS Excellent verbal and written communication skills.
  • CORE Strong analytical, critical-thinking, and problem-solving abilities.
  • CORE Proficiency in SQL and Snowflake.
  • CORE Working knowledge of financial products and how they appear in trade, position, pricing, and cash activity data, including equities, fixed income, FX, and listed and OTC derivatives such as interest rate swaps, credit default swaps and indices, total return swaps, and options.
  • PLUS Ability to manage multiple projects, balance competing priorities, adapt to changing business needs, and follow work through to completion, with a positive, goal-oriented focus on execution and delivery.
  • PLUS Previous experience in financial services or hedge fund operations is preferred.

Nice-to-haves

  • PLUS Experience with one or more of the following: Sigma, Alteryx, Power BI, Python, or xCeptor.
  • PLUS Experience working within a structured Software Development Life Cycle environment.
  • PLUS Familiarity with Atlassian, Azure DevOps, or similar project management and development tools.

Résumé keywords for this role

Terms the posting stresses. Include the ones you can honestly back up.

Tools & technologies

  • SQL
  • Snowflake
  • Sigma
  • Alteryx
  • Power BI
  • Python
  • xCeptor
  • Software Development Life Cycle
  • Atlassian
  • Azure DevOps

Concepts & phrases

  • Integrated Portfolio Services Information Delivery
  • automated data extracts
  • technical solutions
  • business requirements
  • client reporting
  • Snowflake data shares
  • feasibility studies
  • system requirements
  • data-processing projects
  • process-improvement initiatives
  • financial services or hedge fund operations
  • Software Development Life Cycle
  • project management and development tools
  • Northern Trust partner
  • financial products

Words that count as the same thing: "Snowflake" ≈ Cloud Data Warehouse · "SQL" ≈ Structured Query Language · "Software Development Life Cycle" ≈ SDLC

Check my résumé against these keywords

Hiring at Northern Trust

Open senior roles RoleStack tracks right now, posted in the last 30 days.

More open roles at Northern Trust

Full job description from Northern Trust

From Northern Trust's posting. View the original

About Northern Trust

As a global leader in innovative wealth management, asset servicing, asset management and banking services, Northern Trust (Nasdaq: NTRS) is proud to guide the world’s most successful individuals, families, corporations and institutions.

Since 1889, we have aligned our efforts with our three guiding Principles That Endure: Service, Expertise, and Integrity. Together, they reflect the three cornerstones of business conduct which we strive to instill in our employees, whom we call partners, and to provide to our clients and the communities we serve worldwide.

Show full description Show less

With more than 135 years of financial experience and over 24,000 partners, we serve the world’s most sophisticated clients using leading technology and exceptional service.

Senior Consultant, Integrated Portfolio Services Information Delivery

Job Description Summary

The Northern Trust Integrated Portfolio Services Information Delivery team combines technical expertise with business knowledge to support internal and external clients. The team is responsible for delivering client reporting through files, dashboards, and feeds into client data warehouses, and for assisting clients with Snowflake data shares. The Senior Consultant will plan, design, and develop automated data extracts and technical solutions that meet business requirements and align with the frameworks established by the organization’s technical architects.

Major Duties

• Partner with clients, technology, product management, operations, and other business teams to gather, analyze, and translate requirements for automated data extracts into functional, scalable, and sustainable solutions.
• Deliver and support client reporting through files, dashboards, and client data warehouse feeds, and assist clients with Snowflake data shares, including onboarding and ongoing questions.
• Balance and prioritize competing deliverables across projects, releases, and production support, and communicate trade-offs and timelines to stakeholders.
• Demonstrate strong follow-through by tracking open items and carrying work through to production.
• Conduct feasibility studies and define and design system requirements for complex data-processing projects.
• Review existing systems, processes, and business challenges to identify opportunities to reduce costs, improve processes, enhance services, and increase operational efficiency through automation or improved functionality.
• Design and develop solutions that meet business and technical requirements.
• Coordinate and support the testing of new systems, system enhancements, and modifications.
• Provide ongoing project support and assist with project planning, including estimating and managing work efforts.
• Prepare supporting materials, documentation, and user manuals.
• Provide training to business partners related to system or process changes.
• Deliver ongoing technical support and troubleshoot complex system, data, and reporting issues.
Knowledge and Skills

Core

• Excellent verbal and written communication skills.
• Strong analytical, critical-thinking, and problem-solving abilities.
• Proficiency in SQL and Snowflake.
• Working knowledge of financial products and how they appear in trade, position, pricing, and cash activity data, including equities, fixed income, FX, and listed and OTC derivatives such as interest rate swaps, credit default swaps and indices, total return swaps, and options.
• Ability to manage multiple projects, balance competing priorities, adapt to changing business needs, and follow work through to completion, with a positive, goal-oriented focus on execution and delivery.
Preferred

• Experience with one or more of the following: Sigma, Alteryx, Power BI, Python, or xCeptor.
• Experience working within a structured Software Development Life Cycle environment.
• Familiarity with Atlassian, Azure DevOps, or similar project management and development tools.
Experience Required

• Five or more years of relevant professional experience.
• Demonstrated experience analyzing requirements and developing technical or automated solutions to support data, reporting, systems, or process-improvement initiatives in partnership with technical and nontechnical stakeholders.
• Previous experience in financial services or hedge fund operations is preferred.
Education

• A college or university degree in Computer Science, Information Systems, Finance or a related field is preferred.

#LI-HY

#LI-CL1

Salary Range:

$83,100 - 141,300 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.

Work Authorization

Applicants must be authorized to work in the U.S. without the need for employment-based visa sponsorship now or in the future. Northern Trust will not sponsor applicants for U.S. work visa status for this opportunity (no sponsorship is available for H-1B, L-1, TN, O-1, E-3, H-1B1, F-1, J-1, OPT, CPT or any other employment-based visa).

Working with Us

As a Northern Trust partner, you will be part of a flexible and collaborative work culture, which has a strong history of financial strength and stability. Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to an inclusive workplace and assisting the communities we serve.

Philanthropy is deeply rooted in Northern Trust’s history and is an essential element of our culture. Employees around the world give their time and talent to work for the greater good of their communities.

Reasonable Accommodation

Northern Trust is committed to working with and providing adjustments to individuals with health conditions and disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at MyHRHelp@ntrs.com, or alternatively you can discuss your individual requirements with the recruiter you are working with.

FAQ

How much does a Senior Consultant, Integrated Portfolio Services Information Delivery at Northern Trust make?

The posted pay for this role is $83k–$141k a year.

How much experience do you need?

The posting asks for 5+ years in relevant professional experience. It is a senior-level role.

Does Northern Trust sponsor visas for this role?

The posting says visa sponsorship is not available.

Is this role remote?

It is an on-site role.

What tools and technologies does the posting mention?

SQL, Snowflake, Sigma, Alteryx, Power BI, Python, xCeptor, Software Development Life Cycle, Atlassian, Azure DevOps.