Senior Consultant, Integrated Portfolio Services Information Delivery

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

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.

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

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

• Experience with one or more of the following:
  Sigma, Alteryx, Power BI, Python, or xCeptor.
• Experience working within a structured Software Development…