Job Description :
"Purpose Statement/Overall Description:

Implement end to end Business intelligence solutions using Microsoft SQL 2012 and beyond for Probation application.
The Reporting Developer will be responsible for working with our client Probation, operations, functional analyst, and business intelligence staff to build and automate reporting deliverables.
This position is a senior level contracting position

Gather and analyze business requirements and translate business needs into long-term business intelligence solutions
SharePoint, data migration components, and work in collaboration with the data warehouse environment and team
Define Business Intelligence framework and data model, semantic layers and BI Metadata repositories to support reporting and administration
Demonstrated experience with SSRS to include report front-end development, report query writing and tuning, report deployment and management
Demonstrated experience with SSIS to include creating, maintaining, and executing SSIS programs
Demonstrated experience with OLTP and OLAP databases to include reporting and data modeling.
Specific experience with MSSQL Server and Oracle environments.
Experience using MS SQL Server 2008/2012 SSRS, SSIS, PowerPivot, integration with Excel

Qualifications/Requirements: At least 3 years of experience developing solutions using the BI stack of Microsoft and 5 years of experience in IT, which include:

Knowledge of SSIS
Expert level with SSRS
Expert level with TSQL
Creating dynamic reports with parameter and chart elements
Displaying performance with indicators
Reusing report parts
Securing report server content
Performing administrative tasks
Stored procedures
User-Defined Functions and Types
Error handling
Query Performance Tuning
Files, File groups, and Integrity
Implementation end to end packages that must include variables, parameters, expressions, transactions, Script task, Script component using C# is a plus
Knowledge of SQL Server replication or always on is a plus
Fact ETL, Dimension ETL and advanced including slow changing dimensions and late arrivals
SSAS Multidimensional is a plus"

Reach Me at samg(at)mysbscorp(dot)com.