Summary Develops, designs, maintains, tests, installs, and provides high-level support on system software. Duties and Responsibilities Responsible for creating, reviewing and maintaining SSAS 2008 Dimension Models Responsible for creating, reviewing and optimizing MDX queries Responsible for Informatica (9.1.0) ETL development/enhancement Responsible for creating and reviewing SSRS reports Responsible for developing/managing SQL Server database Responsible for maintaining/enhancing Enterprise BI platform Under general direction, provide technical expertise in the development of design and functional specifications Produce deliverables related to assigned project(s) Assist in post-implementation support and system enhancements Resolve customer software complaints and issues, as well as respond to suggested Requirements Must be US citizen Understand concept of Data Warehouse and Microsoft BI Knowledge / Skills / Ability 2 – 4 Years of experience with Data warehouse/BI experience 1 - 3 years of Dimensional Modeling experience 5 - 7 Year of SQL Server development experience 2 – 4 years of Microsoft Analysis Services (SSAS) development experience. 2 – 4 years of Microsoft SQL Server Reporting Services (SSRS) experience 1 - 2 years of experience with Microsoft Performance Point Services (Optional) 1 - 2 years of experience managing multiple offshore projects (Optional) Informatica CDC Power Exchange is a big plus.