Job Description :
Job Description
Operations Control and Cross Functions Technology is responsible for analytics focused towards Volcker Regulatory Rule and Senior Management Decision Making. The team is focused on the creation and development of a unique set of analytical tools that enable senior management to examine drivers (PnL, Trades, Inventory, etc of the regulatory requirement and management metrics. The team produces reports and dashboards that summarize Trade Volumes, Aged Inventory, Revenues, PnL Explains, GAAP Assets, Headcount, etc.
The individual will be responsible for working with the business teams and other support groups to build QlikView based automated solutions around business dashboards/metrics.
The individual will have a unique opportunity to liaise and work with senior management, product management, multiple groups in the Financial Division (Product Control, Balance Sheet Control, Regulatory Reporting and Planning & Analysis), Risk Management, Human Resources, etc.
Required Skills
An expert in developing solutions using QlikView software
Expert level skill in integrating data using QlikView
Expert level skill in QlikView scripting
Decent exposure to QlikView UI development
Good level of comfort using VB Scripts to write Macros in QlikView and/or Excel
Expert level skill in Dashboard UX design (layouts, integrating maps, color schemes, etc
Good knowledge of installing and configuring/administering Qlikview Desktop, Qlikview Server, IIS Server and Qlikview Publisher
Should have architected and implemented QlikView in a high availability clustered environment
Experience in managing Accesspoint security thru Active Directory and DMS
Schedule QVW reloads on server and troubleshoot errors and failures
Candidate should possess strong background in Data Analysis and be an expert data modeler
Expert level skill in using SQL
Experience in a Data Warehouse environment reporting on dimensions/hierarchies
Experience in Star Schema/Snowflake modeling, FACT & Dimensions tables
Willingness to learn about business processes, and data ( systems/ returns/ performance/ drivers) to create robust and comprehensive analyses via technology solutions
Capable of multitasking & prioritizing in a fast paced and agile work environment
Attention to detail and a passion to produce a quality product
Minimum Prior Work Experience Requirements:
5 Years