Northern Trust Technology Business Analyst - VBA - 74863 in Chicago, Illinois

This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/ada/r/jobs/6425653 For more than a century, Northern Trust has worked hard building our legacy of outstanding service, expertise and integrity. From a Chicago-based bank founded in 1889, we now have more than 20 international locations and 18,500 employees globally. We serve the world's most-sophisticated clients - from sovereign wealth funds and the wealthiest individuals and families, to the most-successful hedge funds and corporate brands.

n

We burnished our reputation as a global leader delivering innovative investment management, asset and fund administration, fiduciary and banking solutions enabled by sophisticated, leading technology. And through it all, we continually laid a solid, forward-looking foundation on which future generations can continue growing and achieving greater.

n

As of December 31, 2018, Northern Trust Corporation had:

n

$10.1 trillion in assets under custody/administration

n

$7.6 trillion in assets under custody

n

$1.1 trillion in assets under management

n

$132 billion in banking assets

n

We are currently seeking a Technology Business Analyst to join our Subject Matter Expert team in the Investment Operations Outsourcing business unit of Northern Trust Global Funds Services. The Technology Business Analyst will use their strong knowledge of Excel VBA macro development to support our business's Cash Processing and Foreign Exchange service teams. We are seeking a self-starter willing to learn the existing business process and have the freedom to improve and optimize the current state through technology and process improvement.

n

Responsibilities of the Technology Business Analyst:

n

• Provide on-site, expert-level advice, support, and troubleshooting to all business unit macro users.

n

• Act as liaison between business users and off-site macro development team for issues related to using, testing, and developing macros.

n

• Identify improvement opportunities and create or review business requirements to address business needs.

n

• Solve complex macro problems and create solutions for various business processes using Excel VBA or other process automation solutions.

n

• Provide macro development as needed during periods of peak demand

n

• Establish and maintain Best Practices relative to the lifecycle of macros

n

• Maintain governance over our inventory of macros, including access rights, business continuity protocol, decommissioning of obsolete or redundant macros, etc.

n

• Provide advice and training to staff in both one-on-one and group/class situations.

n

• Manage and own daily metrics relative to support, utilizing development tools such as Power BI

n

• Participate in meetings and calls with all organizational levels internally.

n

• Be a key stakeholder in Process Optimization programs to enhance existing process and design an optimal future state

n

Requirements of the Technology Business Analyst:

n

• Bachelor's degree, preferably in technical field or Business/Finance with technology concentration

n

• Minimum of 3 years' experience in Excel macro development leveraging VBA required. Experience with SQLADO queries preferred.

n

• Proficiency in gathering business requirements from end users and translating into tactical and strategic Excel VBA/SQL solutions. Experience with other data and automation tools such as MS Access, Robotic Process Automation, Power BI, or SharePoint workflows preferred.

n

• Familiarity with financial services industry, ideally in cash or foreign exchange processing.

n

• Ability to work effectively on a team

n

• Project management capabilities preferred.

n