Please reply to:- Prabhu,Shivprasad / spra...@compunnel.com / 609-606-9010 Ext.# 1432
Job Details:-
| Job Title : | SQL BI Developer |
| Location : | Richmond, VA |
| Expected Duration of Project : | 10 Months |
| Start Date : | 08/29/2013 |
| Interview Type : | Personal |
| Duties & Responsibilites : | Job title:- BI Developer
Location:- Richmond, VA (Remote Position consultant will need to work only 1 day from client site)
Duration:- 10 months
Interview:- Telephonic followed by In-Person
Description:-
The scope of work for the Legacy Warehouse Data Integration project includes data gap analysis, data structure design (working with a data architect), SQL code development (ETL components using Blackboard Analytics’ architecture) , SSAS cube development (dimensions, hierarchies, measures, data source views, etc), and report development using Pyramid Analytics’ BioXL.
Place Of Performance:-
The selected BI Developer for the Legacy Warehouse Data Integration project will perform a majority of the work remotely. The developer will be required to work at clients James Monroe Building office one day per week (day TBD) for weekly status meetings, planning, and development reviews. The client will provide desk space and arrange for meeting spaces within its facility for all required work days and meetings.
Work Requirements:-
As part of the Legacy Warehouse Data Integration project the BI Developer will be responsible for performing tasks throughout various stages of this project. The following is a summary of these tasks which will result in the successful completion of this project:
Gap Analysis:-
- Produce an inventory of needed reports and report objects, working with both the existing reports in the Legacy Data Warehouse and the user community, and including a priority order of development
- Create and present detailed description of the data elements within the SAS-designed legacy data warehouse, with a determination of which data elements are needed and do not exist in the new decision support system in a useable form
- Extract, analyze and document the logic behind each needed data element which does not exist in the new decision support system, and provide this to the data architect and the project team
Planning:-
- Participate in project planning efforts to develop an overall project plan, project schedule, risk inventory, and performance plan, as well as other planning efforts
Design:-
- Work with client staff and others to gather and document requirements and establish metrics
- Work with project data architect to design data structures to incorporate needed data elements identified during based on collected requirements
Development:-
- Develop data structures or enhance existing structures in the Blackboard Analytics’ data model for client review and approval, using T-SQL and Business Intelligence Development Studio in the SQL Server and Analysis Services environments
- Implement designs in a non-production environment, test those designs, and work with client subject matter experts to validate the data and the embedded logic
- Document development efforts and work with ITS staff to implement approved data structures and changes into the production environment
- Develop reports for use by end-users in the Pyramid Analytics BioXL environment
- Present written status at weekly meeting
Knowledge, Skills and Abilities Required
The Business Intelligence Developer should have the following skills and abilities:
- Advanced SQL skills in both Oracle and Microsoft SQL Server
- Substantial experience developing relational database data warehouse star schemas
- Substantial experience developing OLAP cubes in Microsoft SQL Server Analysis Services (SSAS) using Business Intelligence Development Studio (BIDS)
- Experience working with end-users, performing requirements analysis, and writing documentation
- Preference will be given to candidates with prior experience with the Blackboard Analytics system or iStrategy
- Preference will be given to candidates with familiarity with SAS Business Intelligence structures
Skill Required / Desired Amount of Experience Expertise Rating:-
- Advanced SQL skills in both Oracle and SQL Required 8 Years
- Experience developing relational database data warehouse star schemas Required 8 Years
- Experience developing OLAP cubes in SQL Server Analysis Services (SSAS) using Business Intelligence Development Studio (BIDS) Required 8 Years
- Requirements analysis, documentation Required 8 Years
- Blackboard Analytics system or iStrategy Highly desired 2 Years
- SAS Business Intelligence structures Highly desired 2 Years |
Click here to see details and upload resume for this job.
Click here to see all jobs on jobs.compunnel.com.
--
You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com.
To post to this group, send email to sap-vendor@googlegroups.com.
Visit this group at http://groups.google.com/group/sap-vendor.
For more options, visit https://groups.google.com/groups/opt_out.
