Job Description :
Data Warehouse Architect and ETL Lead
Location: New York, NY
Long term contract

The Data Warehouse Architect will work with our client and lead in assessing requirements and defining the strategy, technical architecture, implementation plan, and delivery of data warehouse projects. The Data Warehouse Architect must have significant prior experience leading successful data warehousing implementations, as well as, a broad background and experience with BI solutions. This individual is responsible for establishing the long-term strategy and technical architecture, as well as, the short-term scope for a multi-phased data warehouse effort. This person must have strong professional consulting skills and the ability to communicate well at all levels of the organization. They will work with the client to define the overall data warehouse architecture (e.g., ETL process, ODS, EDW, Data Marts)
Responsibilities include:
Recommend/select data warehouse technologies (e.g., ETL, RDBMS)
Define physical architecture, server and storage, to support technical and SDLC requirements
Translate business requirements using complex methods/models to determine appropriate data warehouse solutions and data needs
Design and direct the ETL process, including data quality and testing
Design and implement the logical and physical database structure
Define and direct the implementation of security requirements for the data warehouse
Define metadata standards for the data warehouse
Direct the data warehouse metadata capture and access effort
Define production release requirements
Create documentation and processes for standards and best practice
Willingness to code ETL and play tech lead role
Performance tuning of ETL, database and BI components

Required Skills:
BS in computer science with a minimum of 7 years experience
7 years experience with market leading business intelligence applications
7 years of data modeling experience including ODS and STAR schema
7 years of ETL development and architecture experience
Strong knowledge and proven experience in architecting, designing and implementing large scale advanced enterprise data warehouses
Extensive experience with all phases of Data Warehouse development including prototyping, data modeling, analysis, design, development, data security, ETL processes, and BI
Extensive knowledge of warehousing methodologies such as Ralph Kimball and W H Inmon
Expertise in both federated or hybrid-federated, normalized and de-normalized data warehouse designs
Deep knowledge of data modeling techniques for 3NF, dimensional models and hyper-normalized models (or generic data modeling components a plus), or dimensional-normal form models
Strong background with relational database management objects (tables, schemas, indexes, stored procedures, etc), database design principles and data administration standards, and information security terminology
Expert database knowledge and SQL skills required - Oracle, SQL Server and DB2
Experience with Oracle 12 and above
Experience with Oracle RAC in a data warehousing environment