SLAIT Consulting is currently looking for a Data Warehouse Architect in Albany, NY for a minimum 1 year contract.
This position is for a Data Warehouse Architect Providing expert services in architecture, design and implementation of Business Intelligence (BI) and Data Warehousing solutions. Assist the department in establishing a new Enterprise Warehouse. Establishes an architectural model and a total solution for the department, establishes "best practices". Provides strong professional consulting skills and the ability to communicate well at all levels of the organization. Documents the system architecture and prepares design documents that is easily understandable to less technical individuals. Develops complex SQL statements using advanced analysis functions Design of data warehouse solutions using Oracle Design development testing and tuning of ETL processes. Experience in architecting a data warehouse from the ground up, including but not limited to the design of ETL processes and ETL strategy, security, auditing, maintenance, availability, etc. Provides experience with Oracle 10g databases. Team player, must be able to work professionally and collaboratively with the government customer and other contract members of the project team. Establishing the long-term strategy and technical architecture as well as the short-term scope for a multi-phased data warehouse effort.
7 years Providing expert services in architecting, designing and implementing data warehouses for applications and Business Intelligence (BI) solutions for large scale/complex environments. Demonstrates leadership and demonstrated experience in delivering Business Intelligence solutions.
7 years Experience in the design of ETL processes and ETL strategy, security, auditing, tuning and maintenance.
7 years Experience in incorporating data normalization and referential integrity enforcement techniques.
7 years Experience creating and using procedures, views and functions to support application development and BI solutions.
7 years Experience in designing Operational Data Stores, Ad-Hoc reporting databases, or Data Marts.
7 years Experience with Oracle databases in delivering large-scale warehousing solutions that are multi-terabyte in size.
4 years Establishing long-term strategies and technical architectures as well as the short-term scope for a multi-phased complex data warehouse efforts
1 year Experience with Financial Systems, including, but not limited to the NYS Statewide Financial Systems, and it processes and files.
SLAIT Consulting - 21 months ago