MSSQL developer
CESNA, INC.
Novi, United States of America
27 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
EnglishJob location
Novi, United States of America
Tech stack
ASP.NET
.NET
Data analysis
ETL
Microsoft Dynamics GP
Microsoft Visual Studio
Microsoft Software
Microsoft SQL Server
SQL Stored Procedures
SQL Databases
SQL Server Reporting Services
SQL Server Integration Services
Systems Integration
T-SQL
Tools for Reporting
Job description
Design and develop reporting models, ad hoc queries to meet business requirements.
- Create Stored Procedures and SQL Server Integration Services (SSIS) packages to Extract, Transform and Load (ETL) data from financial transaction system (dynamics GP) into the reporting environment.
- Support and maintenance of the reporting environments.
- This role also will work to develop and maintain scripts, queries and reports, work processes, and maintenance procedures.
Requirements
Our current environment consists of Microsoft Stack (.NET 4, SQL Server 2008 R2, VS 2010, ASP.NET).
Qualified candidates must have:
- Advance knowledge of TSQL queries (complex SQL scripts, views, and stored procedures)
- Strong data analysis and report writing skills
- MS SQL 2008 Server and
- MS SQL Server Reporting Services (SSRS)
- MS SQL Server Integration Services (SSIS)