From: sandi.greenfield@princetoninformation.com <sandi.greenfield@princetoninformation.com> Subject: Data Analyst Opening in NYC! To: jcsspike@yahoo.com
Date: Tuesday, August 16, 2011, 2:59 PM
My name is Sandi and I'm an IT recruiter at Princeton Information. One of my largest Investment Banking clients has an opening for a Data Analyst in their NYC headquarters. Please let me know if you are qualified for this long term consulting opportunity! Data Analyst for the following - Day to Day Responsibilities: - - Drive new product on-boarding onto the existing platform. Understand business requirements, interact with upstream source systems, perform data analysis, derive ETL mappings and customize the existing functionalities
- Analyze trading and settlement data from various client sources: front end trading systems, and historical databases. Reconcile source data to various Exchange, Broker, banks reports and invoices.
- Perform data validation, conversion and massaging to Strategic Platform's format. Ensure data quality and accuracy. Write sql queries for different source databases by interpreting their data models
- Map the data from external sources to Strategic platform. Create and maintain the Strategic platform's data standards. Identify data exception conditions.
- Analyze data requirements and design data models in both OLTP and OLAP using ERD and dimensional modeling. Translate business requirements into data fields.
- Meet with subject matter experts from the business line to determine reporting requirements
- Analyze the impact of requirements changes on existing system and there by effect the changes
- Perform development, user acceptance testing and production checkouts. Support development and testing cycles and manage UAT.
Essential Skills Required: - - In depth financial product knowledge: Equity, Fixed Income (Treasury, Bonds etc), Derivatives (Futures, Options, Swaps, Interest Rate Products, Equity, Credit etc ), Foreign Exchange, Commodities etc
- Data Architect in both OLTP/OLAP environments including data modeling, dimensional modeling, Data Mapping, ETL Design/Transformation and Metadata repository. Familiarity with Data Modeling Tools such as Erwin, ERStudio, or System Designer
- SQL skills and an understanding of a RDBM System (Sybase- RapidSQL Or Oracle- PLSQL)
- Working knowledge of UNIX, Linux - experience in writing simple commands.
- Candidate should have 12+ years of experience in the financial services industry with a minimum of 8 years supporting Investment Banking IT projects in a major investment bank. Candidate should possess knowledge of transaction mechanics and market structure for all major product classes and instrument types: fixed income, treasury products, listed and OTC derivatives, and equity.
- Experience with data warehousing and reporting projects is a plus.
.
If you are qualified, available, interested, planning to make a change, or know of a friend who might have the required qualifications and interest, please call me ASAP at (917) 533-7998 even if we have spoken recently about a different position. If you do respond via e-mail please include a daytime phone number so I can reach you. In considering candidates, time is of the essence, so please respond ASAP. Thanks again.
Sandi
............................ Princeton Information 100 Harborside Financial Center, 11th Floor Jersey City, NJ 07311 917-533-7998
MIS Ntwk Assoc Mtg Dates:
Aug 23rd - Tues Reg Mtg - 6 pm - Berman Larson Kane Offices, Paramus - DO NOT use GPS for directions - Get dir from BLK site - Bring 15 copies of your resume
Aug 30 - Tues - No Meeting Labor Day Holiday
Sept 6 - Tues - No Meeting Labor Day Holiday |
No comments:
Post a Comment