Short Description:
The Business Intelligence Developer (BID) requires the ability to work on the various stages of the development/implementation cycle. These services are required to address the needs of the agencies utilizing the Governor's Sandy Transparency.
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 one 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 Business Intelligence Developer. Under direction of the Project Lead or designee in the Office of Information Technology (OIT), the Business Intelligence Developer will assist the Project Lead and Project Technical Architect constructing the solution to meet the objective of the project.
In order to address the immediate need we will leverage the enterprise data warehousing methodology and earlier data integration work for the EDW. New data structures will be developed to integrate respective data sources, create data interfaces as needed and develop front-end reporting using Business Objects (BO). Data will be hosted in an Oracle database.
The Business Intelligence Developer will be responsible for:
• Construction, testing and deploymetn of applications built with Oracle APEX. These will be used by state agencies to enter their Sandy-related financial information as a source to the data warehouse in place of the current spreadsheet process.
• Resolution of technical problems
• Assisting the Quality Assurance Specialist with development and execution of test plans
Years of Relevant Experience:
7 plus years
Preferred Education:
4 year college degree
All roles specified plus the following:
Experience in all area of the software decelopment lifecycle.
Experience configuring and supporting large volumes of data for business intellligence applications
Experience with enterprisewide implementation of complex ETL tools and BI tools
Extensive experience with building applicaton using Oracle APEX
Skills:
Skill
Required / Desired
Amount
of Experience
-Software Development Development Lifecycle
Required
7
Years
Enterprise Data Warehouse/Data Mart enviroment utilizing Data Modeling, DataStage 8.x and Business Object XI
Required
7
Years
Experience with ETL and Business Intellegence development in an enterprise data warehouse environment, including identifying user requirements
Required
7
Years
Experience using Oracle APEX to develop applications
Required
4
Years
Experience in developing and maintaining Dependent/Independent data marts
Required
7
Years
Experienced in using TOAD, SQL and PL/SQL
Required
7
Years
Experienced in Source to Target mapping between Data Warehouse and target data mart universe databases
Required
7
Years
Experience using BusinessObjects Designer and WebIntelligence including universe and report design, construction and documentation
Required
7
Years
Previous experience with Business Objects environment for warehouse projects
Required
7
Years