SQL BI positon(SSAS/TSQL)

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients – including governmental agencies and private companies – throughout the United States and India.We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.Job Description

This role is ideally suited to an individual who is passionate about IT and data and its application in the business environment in support of growth and efficiency. Creating logical and innovative solutions to complex business problems, with a heavy emphasis on SQL BI, the role encompasses all aspects of a project from initial briefing through final delivery and testing. It is suited to someone who is comfortable interfacing at all levels of the organization, providing great customer satisfaction while delivering first-class solutions. Ability to function effectively without close supervision.Main responsibilitiesDesigning and planning BI solutionsDebugging, monitoring and troubleshooting BI solutionsWriting relational and multidimensional database queriesConfiguring, deploying and maintaining database serversDesign, develop and support ETL packages (SSIS) for data flow including SQL tables, views, functions, stored procedures, synonyms for BI use in end-user reporting applications SSRS, Tableau and cubes feed as well as the DW.Provide Tier 2 support for BI Platform through SSAS/TableauWork with all levels of development from analysis through implementation and supportCreating and deploying Data Marts to be consumed by reports and BI modelsResolve end user reporting problemsOther duties as assignedRequired SkillsB.S. degree in technical discipline5+ years in general database development using MSSQL up through SQL 2005-2008/R2. Experience in Oracle is a plus2+ years working with BI tools such as Tableau, Cognos or other relevant BI Solution a plusAdvanced level of writing stored procedures, reading query plans, tuning indexes and troubleshooting performance bottlenecks1+ years C#/VB .Net3+ years ETL experience, including SSIS or other ETL toolset in an enterprise environment3+ years BI experience utilizing SSAS or other OLAP toolset2+ years experience with SSRS programmingProblem solving, analytical and communication abilities.Challenge current thinking to provide new and improved ways of delivering information and performing business processes.Proactively identify areas for improvement and evaluate viable alternative IT solutions to business problems using data in innovative ways.Work closely with associates and departments at all levels of the business in identifying and resolving data related problems.Maintain and ensure integrity of data in and assist with the administration of various databases.Extensively test and document solutions to a high and consistent standard.Leverage maximum benefit from existing systems.

#J-18808-Ljbffr