TRENTON, NJ, USA
1 day ago
Data Warehousing 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

 

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