Description
The SQL Consultant will be responsible for maintaining and designing the SQL Back End for our Logistics solutions (schemas, stored procs, ETL, reports, etc.). The resource would also be reviewing the existing SSRS reports and provide recommendations based on possible consolidation of the existing reports, improving performance, etc. Datawarehouse schema(s) need to be designed to provide slice and dice capabilities for reporting. New reports and dashboards need to be created to provide operational versus energy consumption comparisons. The resource must be a self-starter and results-driven. They must be able to provide results with minimal supervision. This will be an indefinite contract.
- Strong SQL skills using years + experience) [70 %]
- Strong Transact SQL Skills (Stored procedures, functions, views, etc.)
- Experienced with performance tuning (SQL Execution Plans, Partitioning a plus)
- Experienced with SQL Server Reporting Services
- Experienced creating data warehouses
- Experience with BI presentation layer tools (ProClarity, etc.)
- SSAS
- SSIS
.NET Framework years + experience) [30%]
- ASP .NET
- VB.NET
- C#