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 Business Intelligence Developer. Under direction of the Project Manager or designee in the Office of Information Technology (OIT), the Business Intelligence Developer will assist the Project Manager and Project Technical Architect constructing the solution to meet the objective of the project. The Business Intelligence Developer will be responsible for the construction, testing and deployments of operational and analytical Extraction, Transformation and Load development and operational and analytical reporting, including:
Developing the solution consistent with the New Jersey Enterprise Information management Framework and the New Jersey Shared IT Architecture
Assisting the Project Manager Business Analyst and Data Architect with requirements gathering and analysis
Assisting the Business Analyst with the Creating of detailed data flow analysis
Assisting the Data Architect with creation of mapping documents
Construction of the solution and resolution of technical problems
Assisting the Quality Assurance Specialist with development and execution of test plans
Years of Relevant Experience:
7 plus years
4 year college degree
All roles specified in Business Intelligence Developer plus the following:
Experience in all area of the software development life cycle.
Experience configuring and supporting large volumes of data for business intelligence applications
Extensive enterprise wide implementation of complex ETL tools and BI tools
May have worked on Parallel processing implementations.
May have worked on tool set upgrading implementations.
7 Years experience in Enterprise Data Warehouse/Data Mart environment utilizing Data Modeling, DataStage 8.x and Business Object XI
7 Years experience with ETL and Business Intelligence development in an enterprise data warehouse environment, including identifying user requirements
7 Years experience using Ascential DataStage Server and Enterprise Edition in an Oracle-hosted Data Warehouse
7 Years experience in developing and maintaining Dependent/Independent data marts
7 Years experience in using DataStage Basic (DSBASIC) Language and Extensible Markup Language (XML), use of TOAD, SQL and PL/SQL
7 Years experience in Source to Target mapping between Data Warehouse and target data mart universe databases
7 Years experience using BusinessObjects Designer and WebIntelligence including universe and report design, construction and documentation
7 Years experience with Business Objects environment for warehouse projects