BI Architect opportunity, NJ, long term consulting

BI Architect , NJ, Long term consulting opportunity

• Participate in requirements gathering sessions with the business and BI Analysts to understand business analysis requirements
• Develop prototype views and reports of the data, and work with business users to refien their analysis requirements
• Work with BI Analysts and EDW DBA to develop Data Mart table designs
• Participate in data design walkthroughs to communicate Data Mart table designs to ETL developers
• Develop BI solutions using EDW standard tools set
• Develop and execute functional test plans of Data Mart loads and report/view objects
• Work with EDW Tech Leads and DBA to develop production batch stream processes that will work within our required processing window
• Follow established SQL Server standards for design, development and migrations
• Follow established standards for source version control and Change Management, i.e. Dev, QA/UAT, and Production
• Research and help implement new tools and technologies for satifying analysis needs
• Participate in testing of DBMS and BI tool upgrades
Requirements: Requirements/Skills:
• 5-7 years of Analysis Services experience, 2-3 years of Analysis Services 2005
• 2-3 years of Reporting Services experience
• 2-3 years of SSIS experience
• 5-7 years experience developing BI solutions in a large Data Warehouse environment
• Very strong SQL and stored procedure skills
• Stong Star Schema modeling skills
• Experience with Analysis SQL Server 2008 desired 

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.