Note: Position is not with our direct client.
Dear Partners:-
Please find the requirement currently open.
Data Modeler/Data Architect
NYC
1 Yearr
Open
Phone interview followed by face to face
1 to 2 yrs of financial experience a must
Role overview:
This is a data modeler/data architect role in the application architecture and development job family. Main responsibilities include ownership of the data modeling and data architecture function for the PCDW, a large scale, global data warehouse that consists of an Oracle 11g RAC implementation, Unix-based batch and intraday job streams that source data from various systems, a custom .NET C# & C++ middleware that enables ad hoc user queries, and several Excel-based and web-based front-end applications including Oracle Business Intelligence.
Key Deliverables:
Data models
ETL specs
Data architecture vision
Additional duties and responsibilities:
Act as a contributor in the data modeling group.
Define, document, and articulate design goals and standards.
Take ownership of data models, both logical and physical, inclusive of version control.
Analyze and consolidate business requirements across a multitude of data sourcing projects to design a common dimensional data model with conformed dimensions and facts.
Collaborate with BI reporting developers to prototype and define data access meta-models that drive the ad-hoc SQL generation.
Support developers in ETL design and documentation of data flows and interfaces.
Employ best practices in data profiling and designing solutions for handling data quality issues.
Qualifications/competencies:
Required
Knowledge of fixed income, equity, listed derivatives, loans & deposits, money markets, FX, and OTC products
Relational data modeling best practices
Dimensional modeling (Ralph Kimball)
ERWin
Awareness of best practices for warehousing very large datasets
Desired:
Knowledge of P&L reporting and financial accounting
Awareness of partitioning and indexing strategies for high performance.