Business Intelligence Consultant
Summary
In this role you will participate in consulting teams to deliver data warehouse and BI solutions utilizing the Microsoft BI platform. Perform data modeling based on business requirements, and optimization of data models for business intelligence implementations. Perform Maintenance of existing data warehouse and business intelligence implementations (involving SQL Server 2000/05/08 tools). Perform Migration of existing data warehouse and business intelligence from other BI platforms or earlier versions of the MS Platform. Communicate with technical and business staff in technical and plain English language. In addition, you will document all work carried out (e.g. data models, configurations, and setup); Perform occasional business analysis; assistance in preparation of project proposals, including client and vendor meetings and provide Input into the Scalability Experts best practice for BI projects
Educational Qualification and Experience
- Solid experience as a SQL Server 2005/08 & R2 BI developer
- Development experience in team environment with mid to high-end projects from inception through delivery with competency in most of the following areas
- Logical and physical database design experience
- SQL Server 2005/08 OLAP database development including MDX programming
- SQL Server 2005/08 RDBMS database development including T-SQL programming
- ETL implementation using SQL Server Integration Services (SSIS)
- BI presentation delivery utilizing SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) or other BI tools including ProClarity
- Knowledge of/experience in the Kimball DW/BI Design & Implementation Methodologies
- Client facing and thinking strategically from client’s perspective to deploy correct solutions
- Strong knowledge of Performance Point
- In-depth Monitoring and Analytics
- Development of Dashboards, Scorecards, Charts, integration of charting and pivot tables, SSRS integration
- BI capabilities of Office 2007; SharePoint 2007
- PerformancePoint integration and deployment
- Report Services integration and deployment
Desired Qualifications and Experience
Leading BI & Performance Management technologies, including any of:
- Panorama
- MicroStrategy
- Business Objects
- Oracle BI (including Hyperion)
- Other non-Microsoft database platform and ETL experience, including Oracle, Ab Initio, DataStage, Informatica
Required Competencies
- Ability and willingness to learn new technologies
- Good customer-facing skills
- Good listening, communication and documentation skills
- Team player
- Self motivated with a “can-do” attitude
- Flexibility and the ability to multi-task and prioritize
- Eye for detail and quality
- Global mobility
- Sociable
If you would like to apply please send us a note at jobs@scalabilityexperts.com
About Scalability Experts
Migrating from Oracle to SQL Server?
Learn more about Scalability Experts'
worldwide training 
Headed into the cloud?
Learn more about Scalability Experts'
cloud computing services
Extend your SQL Server 2008 Management Data Warehouse (MDW) with Scalability Experts Smart™ 
