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 responsibilities

1. Designing and planning BI solutions
2. Debugging, monitoring and troubleshooting BI solutions
3. Writing relational and multidimensional database queries
4. Configuring, deploying and maintaining database servers
5. Design, 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.
6. Provide Tier 2 support for BI Platform through SSAS/Tableau
7. Work with all levels of development from analysis through implementation and support
8. Creating and deploying Data Marts to be consumed by reports and BI models
9. Resolve end user reporting problems
10. Other duties as assigned

Required Skills

1. B.S. degree in technical discipline
2. 5+ years in general database development using MSSQL up through SQL 2005-2008/R2. Experience in Oracle is a plus
3. 2+ years working with BI tools such as Tableau, Cognos or other relevant BI Solution a plus
4. Advanced level of writing stored procedures, reading query plans, tuning indexes and troubleshooting performance bottlenecks
5. 1+ years C#/VB .Net
6. 3+ years ETL experience, including SSIS or other ETL toolset in an enterprise environment
7. 3+ years BI experience utilizing SSAS or other OLAP toolset
8. 2+ years experience with SSRS programming
9. Problem solving, analytical and communication abilities.
10. Challenge current thinking to provide new and improved ways of delivering information and performing business processes.
11. Proactively identify areas for improvement and evaluate viable alternative IT solutions to business problems using data in innovative ways.
12. Work closely with associates and departments at all levels of the business in identifying and resolving data related problems.
13. Maintain and ensure integrity of data in and assist with the administration of various databases.
14. Extensively test and document solutions to a high and consistent standard.
15. Leverage maximum benefit from existing systems.