Sr. Consultant, Data Integration, Information Delivery, HFS

Job Description: Data Integration Senior Consultant, Hedge Fund Services
Department: Information Delivery
Summary: Northern Trust Hedge Fund Services (NTHFS) is looking for a highly motivated Sr Consultant to join our growing Information Delivery team. This team works with clients and internal partners to understand their data needs and looks at creative solutions to deliver the required data in an effective and efficient way. The candidate will be responsible for client and internal cross business unit collaboration to design, solution, test, implement and maintain data and reporting solutions that meet the requirements of external clients and internal partners.
The ideal candidate will have the knowledge and understanding of databases and data structures accompanied with strong analytical skills to manage the transition from proprietary reporting models/tools to market leading reporting tools (Microsoft SQL Server stack of solutions).
Key Duties and Responsibilities:
Work closely with clients, business owners and SME's to help capture and formalize client requirements
Interact with technology and operations to formulate and implement solutions to enhance existing services, create new client deliverables, or improve processes. Identify impact of changes and processes on teams; facilitate acceptance of change through training and communication. Provide ongoing support for the solution
Evaluate the quality and effectiveness of new processes, systems and/or modifications to existing solutions. Coordinate testing of new systems and systems modifications
Troubleshoot data and reporting issues and work with various support teams to implement solutions
Configure back-end infrastructure for the report delivery process
Perform functional and regression testing for ongoing developments
Be a proactive partner to our end-users by communicating effectively, gaining a deep understanding of requirements, managing expectations, and driving efficient execution
Explore new technologies and learn new skills to continuously improve the way we operate
Develop novel data solutions to drive self-service and make data easily accessible to clients and internal partners
Assist with solutioning and strategic design for agile development
Gain an understanding of the business processes and the technology platform that enables it
Minimum Qualifications (Education, Experience, Skills):
Minimum 3+ years of work experience within a Financial Services domain
Clear and concise business communication
Excellent interpersonal skills
In depth technical knowledge of daily financial and/or investment industry usually acquired through experience in related areas is required to design process improvements and provide support
Knowledge of systems and technological capabilities usually acquired through formal training or experience
Advanced analytical and communication skills are required to evaluate effectiveness of processes, and to redesign or implement changes.
Prior experience with data modeling; knowledge of data warehouse concepts (ie Star, columnar vs.row, In-Memory)
Project leadership skills are required to communicate with partners and implement solutions
Adaptive, flexible style - able to work in a dynamic, fast-paced environment
Experience analyzing business risks and operational processes
Strong multi-tasking and problem solving skills
Extensive experience transforming underlying data into functional data sets in order to generate meaningful insights
Previous experience accessing, manipulating and interpreting data to inform decision-making. Working with large, multi-dimensional data sets to uncover meaningful insights
Knowledge of the best practices for implementation and integration with data visualization frameworks
Strong familiarity with data warehouse design principles, including dimensional modeling
Preferred technical skills ? SQL, VBA, Python, Tableau, Microsoft SSRS/PowerBI
Experience in Microsoft SQL Server stack of solutions, including SSIS and SSAS, SQL, R, Python, Power BI a plus
Bachelor's Degree required
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.
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.
As of September 30, 2018, Northern Trust Corporation had:
$10.8 trillion in assets under custody/administration
$8.2 trillion in assets under custody
$1.2 trillion in assets under management
$132 billion in banking assets

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Senior Consultant, Data Integration
Chicago, IL Strata Decision Technology, LLC
Sr. Consultant, Reconciliation & Control, HFS
Illinois City, IL Northern Trust
HR Sr. Consultant - Project Management
Illinois City, IL Northern Trust
Project Manager/Sr. Consultant
Chicago, IL Robert Half
Market Research & Insights Sr. Consultant
Chicago, IL KeyBank