Executive Reporting provides clients with a consolidated view of all information pertaining to their custody relationship with Citi. The goal of the current ER transformation program is to create a best in class client analytics platform available to all clients through Citi’s Velocity web portal. The scheduled updates span from the source processing systems that provide Executive Reporting with data through to the visualisation tool used for the UI. A particular area of focus is the cleaning of data coming from source systems and the structuring of logic to correctly classify data within category subsets. As a result the transformation team currently includes team members from the business, technology and product to ensure that the highest levels of accuracy are achieved. Which focuses on enrichment of functionality for end users as well as data quality asurrance.
Responsibilities:
-
Strategic Development - in partnership with Product, Sales, Operations and Technology
-
Developing front end applications using QlikView / QlikSense
-
Analysis of data flows for propper data processing
-
QlikView, QlikSense, Nprinting, Thoughtspot ‘proof-of-concept’ design
-
Utilizing scripting language to meet complex business requirements
-
Design, build, test and debug QlikView solutions based upon specified requirements
-
Tune data loads and QlikView application for efficient performance
-
Velocity & Mobile Strategy execution
-
Supporting ad-hoc client requests
-
Assurance of data quality in the applications
-
Read/Write SQL queries based on Cloudera Impala / Hive / Apache SQL
Qualifications:
-
5+ years’ experience in Investor & Financial Services
-
Excellent analytical and processing skills
-
Ability to work well in a group wtih common goal
-
Ability to communicate with senior stakeholders and manage expectations
-
QlikView experience preferable
-
Strong knowledge of SQL
-
Basic programming skills required
-
QlikSense & Nprinting experience preferable
-
Fund Accounting and FX product experience preferable
-
Understanding of data quality principles
-
Strong organisational and planning skills
-
Comfortable working independently in an environment focused on ownership and accountability
Education:
-
Bachelor’s/University degree or equivalent experience
This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.