- Address: Boston
- City: boston
- State: united states
Job Purpose:
Senior Developer / Analyst is required for our Derivatives program to build out robust modules require for managing the liquidity risk associated with Derivatives business. This will enable users for better decision making and forecasting. There are several critical programs which are developed and are in a process of further enhancements under Derivatives umbrella mentioning some of those Collateral management, Mark-to-Market position of Derivatives products , Product Stress Test in case of stress scenarios , Downgrade / Upgrade of Citi Legal entity by Rating agencies , ISDA reports. There are other important programs which currently we are working on viz. VM stress, Volatility of Non Liquid assets, Data Visualization etc.
Key Responsibilities:
Developing projects from a detailed business requirements, working through solutions and managing execution and rollout of these solutions, in the context of an overall consistent global platform
Understand business requirements
Create T SQL queries / stored Procedures / Functions / Triggers using SQL Server 2008 R2, 2012 and 2014
Understand basic data warehousing & relational model concepts.
Design / Develop SSIS packages to pull data from various source systems and load to target tables
May be required to develop Dashboards and Reports using Qlikview / SSRS
Work on BAU JIRAs and also do some levels of L3 support related activities whenever required
Providing detailed analysis and documentation of processes and flows where necessary
Work on DMM tools like uDeploy, Bitbucket etc.
Justification for Role:
AQUA is the Global Liquidity Management System serving Broker-Dealer Treasury and the various trading desks like FI & EQ Funding, Delta One, Prime Finance, In-business Risk, Derivatives. Liquidity Management is a broad front-to-back initiative intended to rationalize and improve secured financing activities within Citi, across both Fixed Income Finance and Equity Finance Desks.
Qualifications
Knowledge / Experience:
6+ years of overall IT experience
Strong knowledge of database fundamentals and advanced concepts, ability to write efficient sql, tune existing sql queries
3+ years experience in any ETL tool, preferably SSIS
Experience with a reporting tool (e.g. SSRS, QlikView)
Experience with analytical tool (e.g. SSAS)
Experience with a job scheduling tool (e.g. Autosys)
Experience in Finance Industry a plus
Experience with all phases of Software Development Life Cycle
Skills:
SQL Server, SSIS,SSAS, SSRS, Autosys
Job details
Undefined | |
0 - 80000 Hour |
List all items from this seller
Useful information
- Avoid scams by acting locally or paying with PayPal
- Never pay with Western Union, Moneygram or other anonymous payment services
- Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
- This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"