*Kindly respond back to s...@3ktechnologies.com <s...@3ktechnologies.com>*
*Position: **SENIOR SQL BI Developer with SSAS (Looking for around 10+ years’ experience)* *Location: **New Kensington, PA * *Duration: **6 months +* *Interview: **Phone/ Skype* *We are looking for someone with 7+ years with SSAS. If they don’t have 7+ years I don’t want to see them* The core responsibility of the Senior BI Developer is to design and develop complete BI solutions. This would include design and development of programs using SQL Server Integration Services (SSIS) to extract information from various ERP into the staging area. Also includes development of various artifacts using T-SQL for the setup of the Enterprise Datawarehouse (EDW). Development of SQL Server Analysis Services (SSAS) cube for various business functions is also one of the primary responsibilities. The BI developer must have a strong knowledge of relational and multidimensional Databases including Cubes with *strong emphasis on MDX, DAX languages* to coach and mentor BI team. The role will also require interactions with business users and infrastructure support teams so must have strong communication skills, be a team player, as well as ability to effectively prioritize and manage a wide variety of tasks. *FUNDAMENTAL DUTIES * • Design, develop and implement Store Procedures, Functions and other artifacts in TSQL for data migration from staging area to EDW • Design, develop and implement the ETL process using SSIS, including data quality and testing • Design, develop and implement SSAS cubes for various business functions • Implement security requirements for the SSAS cubes using role-based or dimensional based • Create/maintain project documentation to successfully implement IT-based solutions including: Project Plans • Functional/Technical Design documents • Develop Training materials focused on end-users for various business functions • Assist in the install and configuration of various MS-SQL BI infrastructure, utilizing referenced project documentation • Work with other team members as needed to implement solutions in a timely manner • Assist management with prioritization of projects and establishing accurate timelines for implementation • Enforce best technical practices for the BI infrastructure to enhance user experience • Coach and mentor BI team members on the various aspects of BI development • Other duties and responsibilities performed as assigned. *EDUCATION AND EXPERIENCE * • *10+ years of experience* related to Microsoft BI development using SSAS • 5+ years of experience in writing T-SQL scripts on various versions of SQL server • 5+ years of experience with complete SDLC lifecycle in this area, including but not limited to requirements gathering, data analysis, design, development, QA, deployment • 3+ years of experience related to SSIS for data integration/ETL technologies • 3+ years of design and development experience in SSRS • 3+ years of experience in using SSMS for design of tables, views, common table expressions, foreign key constraints, and stored procedures *Please respond with only your W2 consultant's Updated resume, location, rate and contact information ASAP..* *Thanks & Regards* *Sai Chand* *1114 Cadillac Ct, Milpitas, CA 95035* www.3ktechnologies.com | *s...@3ktechnologies.com <s...@3ktechnologies.com>* *Gmail: ramineni.saichand45 **Yahoo: ramineni.saichand45* Analytics | BI | Big Data | Cloud |Software Engg. t: +1 (408)716-4190 | f: +1 (408) 884-2420 -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to citrix-and-sap-problems+unsubscr...@googlegroups.com. To post to this group, send email to citrix-and-sap-problems@googlegroups.com. Visit this group at https://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.