Hi
The company is based in Secaucus NJ. This is a consulting role The title is Architect, but the role is really a SOLID BI Developer with strong Microsoft BI experience including Integration Services (ETL), Analysis Services (Building Cubes), Reporting Services (Building Reports). (Part of MS SQL Server package) They will be hands on technically and will propose solutions from an Architecture perspective- but this is not a PURE Architect role. Any additional MS tool experience would be a huge plus - Sharepoint, Team Foundation Server for Change Management.. *Specific Responsibilities: * The Microsoft BI Architect will work on the Enterprise Data Warehouse (EDW) team, and be responsible for working with project managers, business analysts, and users to architect effective solutions to support specific business analysis functions. The architect will work with the Microsoft SQL Server Business Intelligence (version 2008) suite of applications - SSAS, SSRS, SSIS, ProClarity, Excel 2007 Services, Sharepoint, etc. - and be able to construct excellent solutions based on appropriate combinations that are consistent with our existing overall architecture and meet business requirements. Candidate must be highly proficient technically, well organized, and eager to learn new tools and techniques. Candidate must be highly motivated and highly productive. Specific responsibilities include: · Participate in the end-to-end design, development, and delivery of Data Marts within the Enterprise Data Warehouse (EDW) environment. · Participate in requirements gathering sessions with the users and Business Analyst to understand business analysis functions to be supported. · Develop prototype cubes and reports quickly with real data, and work with business users to refine their analysis requirements. · Work with BI Analyst to develop Data Mart table designs. · Participate in design walkthroughs to communicate Data Mart table designs to the project team. · Develop Reporting Services reports, Analysis Services cubes, ProClarity views and dashboards, and SSIS packages as required by the project. · Design data transformation processes to load Data Marts on the SQL Server 2008 database platform from DB2/400 on the iSeries. · Develop and document source to target mappings and detailed design of ETL processes. · Develop ETL processes using SSIS packages and Stored Procedures, including robust message and error handling. · Design and develop Analysis Services databases and cubes, optimized for handling large amounts of data efficiently through the use of various techniques, including partitioning, aggregations, attribute hierarchies, and increment load strategies. · Design and develop SSIS packages for handing efficient cube builds and error processing. · Design and develop reports using Reporting Services with various data sources, including cubes, data mart tables, and EDW tables. · Conduct design and code walkthroughs. · Conduct unit tests of ETL processes, cubes, and reports. · Optimize data structures, cube structures, queries, and ETL that may not be performing well. · Develop technical best practices and standards, as needed, for using the tools in the MS BI suite. · Develop and execute functional test plans of Data Mart loads and report/view objects. · Work with EDW Admin 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 change management between Dev, QA/UAT, and Production environments and source code version control. Candidate should possess the following specific technical skills: · 5-7 years of Analysis Services experience, 2-3 years of Analysis Services 2005 or 2008 · 2-3 years of Integration Services experience · 1-2 years Reporting Services experience · 5-7 years experience developing user interfaces in a large Data Warehouse environment · Strong SQL skills · Star Schema modeling a plus · Experience delivering BI solutions through Sharepoint Server a plus · Experience with Team Foundation Server a plus Candidate should possess the following other skills: · Highly motivated - highly productive · Excellent problem-solving ability · Strong written and verbal communication skills · Excellent communication skills; comfortable understanding and negotiating with users · Experience working in a team environment · Self-starter and ability to work independently * Preferred Education, Experience, Skills: * · Experience developing in SQL Server 2005 or 2008 environment · Experience with Analysis Services OLAP cube development · Experience with Integration Services ETL development · Experience with Reporting Services development · Experience with implementation and support of data warehouse environments · Experience with SQL · Experience with Star Schema modeling a plus · BA or BS in Computer Science or related area preferred. *Corporate Profile:* RSquare's mission is to be the destination and source for great technical talent. We have strong presence in the following industries: Financial, Pharma, Healthcare and Publishing. We deliver top technical talent with competencies covering full IT spectrum: Application Development (Microsoft .Net and Java/J2EE), Integration and Infrastructure Services, PMO, CRM, ERP and SCM Services, Data Warehousing &Business Intelligence and QA Services. RSquare Inc, is an IT services provider for Global 2000 companies with a comprehensive set of IT Project Solutions, IT Staff Augmentation Services solutions. RSquare is based in NJ, Ohio and India, with a project management and development center in Princeton, NJ & Chennai, India. We strongly adhere to strict non-discriminatory employment practices. All candidates in USA are encouraged to apply. R Square is an Equal Opportunity employer and complies with all applicable laws and regulations regarding equal employment opportunities. R Square gives hiring preference to qualified U.S. citizens and other protected individuals. Thanks and regards, *SANKAR **| **R **S**Q**UARE * ***Phone: +1 609-520-8204 x 183 **|** Fax: +1 609-520-8205 * *sankar.shanmu...@rsquarestaffing.com*<sankar.shanmu...@rsquarestaffing.com> * **| Web: **http://www.r-square.com* <http://www.r-square.com/>* * *R** **S**Q**UARE **|** **New Jersey -** **Ohio -** **Washington** **| ** **India **|** **Destination** & **Source** For **Great** Technical **Talent**T* ***Certified **Minority** Business **Enterprise*<http://www.state.nj.us/njbusiness/contracting/minority/certification.shtml> *[image: http://images.inc.com/Inc500_5000A.jpg]*<http://www.inc.com/inc5000/index.html> * **Company** 2009* * R Square is an Equal Opportunity employer and complies with all applicable laws and regulations regarding equal employment opportunities. R Square gives hiring preference to qualified U.S. citizens and other protected individuals. * Do you want to know about our HOT openings? Please check out HOT Jobs<http://seeker.dice.com/jobsearch/servlet/JobSearch?op=300&eid=23547&FRMT=0> -- You received this message because you are subscribed to the Google Groups "USITCV" group. To post to this group, send email to usi...@googlegroups.com. To unsubscribe from this group, send email to usitcv+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/usitcv?hl=en.