TRENTON, NJ, USA
16 days ago
Data Warehouse Architect
Job Seekers, Please send resumes to resumes@hireitpeople.com

Short Description:

 

The Architect will develop a dashboard for the Superstorm Sandy recovery project.  Assist the Governor's Office of Recovery and Rebuilding and identifying the appropriate soucres 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 Superstorm 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

 

Skills:

Skill        Required / Desired          Amount               of Experience

Bachelor'a degree (minimun requirement)         

Required                             

Data integration and/or data warehousing technologies and methodologies.     

Required             7              Years

Experience working with large heterogeneous enterprise environments             

Required             5              Years

Experience as a data warehousing project manager, team leader, or architect   

Required             3              Years

Experience on projects within large heterogeneous enterprise environments   

Required             1              Years

Understanding of database technology, Oracle preferred            

Required                             

Understanding of ETL techonolgy, Oracle perferred        

Required                             

Understanding of data normalization and logical data modeling 

Required                             

Strong analytical skills, with the ability to develop effective logical system designs            

Required                             

Proficient in MS Office productivity tools             

Required                             

Strong interpersonal skills, with the ability to convey complex tasks to technical staff effectively

Required                            

Confirm your E-mail: Send Email