Technical Architect with Data Warehouse Experience

IT Smart is seeking a Technical Architect with Data Warehouse experience for a client in Trenton, NJ.

Short Description:
The Architect will develop a dashboard for the Super storm Sandy recovery project. Assist the Governor's Office of Recovery and Rebuilding and identifying the appropriate sources for data input into the internal dashboard.

Complete Description:
Due to the extraordinary amount of money being provided for the rebuilding and recovery from the impact of Super storm and Post-Tropical Cyclone Sandy, administering, tracking and monitoring is essential. The State currently does not have a dedicated system in place to provide a method to track and/or report on these funds. Those Agencies that are receiving the bulk of the funds have already been evaluating and implementing solutions to track and report. The Office of Information Technology is assisting the Governor's Office of Recovery and Rebuilding in identifying the appropriate sources for data input into the internal dashboard. However, as identification is taking place, it's apparent that the data will need to be housed in a central repository and also interface with the State's financial system. This project will consist of, but not be limited to, identifying all State Agencies that will receive federal funds for Sandy, coordinating the data inputs into the Governor's internal dashboard and State interfaces, and working with developers to develop a State data warehouse for Sandy data.

This endeavor will require a Project Technical Architect under direction of the Project Manager or designee in the Office of Information Technology (OIT). The Project Technical Architect is responsible for the solution design to meet the objectives of the project and overseeing the implementation of that design. The Project Technical Architect will be responsible for the effectiveness of the design and the communication of it to the project team, including:

- Designing the solution consistent with the New Jersey Enterprise Information Management Framework and the New Jersey Shared IT Architecture
- Assisting the Project Manager and Business Analyst with requirements gathering and analysis
- Assisting the Business Analyst with creation of detailed data flow diagrams
- Assisting the Data Architect with creation of the logical and physical data models required
- Assisting developers with construction of the solution and resolution of technical problems
- Assisting the Quality Assurance Specialist with development and execution of test plans

REQUIRED SKILLS:

- Bachelor's degree (minimum requirement)
- 7 years experience in Data integration and/or data warehousing technologies and methodologies.
- 5 years experience working with large heterogeneous enterprise environments
- 3 years experience as a data warehousing project manager, team leader, or architect
- 1 year experience on projects within large heterogeneous enterprise environments
- Understanding of database technology, Oracle preferred
- Understanding of ETL technology, Oracle preferred
- Understanding of data normalization and logical Datamodelling
- Strong analytical skills, with the ability to develop effective logical system designs
- Proficient in MS Office productivity tools
- Strong interpersonal skills, with the ability to convey complex tasks to technical staff effectively

PLEASE SEND YOUR RESUME WITH RATE REQUIREMENT.