Job ID: CT-60130(98890310)
Hybrid/Local SSIS/SSRS Developer/Architect with data modeling, TSQL, PowerBI, SSAS, TFS, and XSLT experience
Location: Hartford, Connecticut (CT DCF)
Duration: 12 months
Skills:
Skills Database Data Modeling Expert (10+ Years) No
Skills Database Microsoft SQL Server Expert (10+ Years) No
Skills Tools SQL Server Reporting Services (SSRS) Expert (10+ Years) No
Refer to the State contracts for IT Professional Services Agreement (22PSX0163) for experience and skill requirements for the job classification Solution Architect to fill the role. In addition, the agency requires:
A 10 or more years of prior experience demonstrating the following knowledge and skills:
1. Experience in the analysis and design of application solutions within appropriate standards.
2. Ability to write complex SQL queries
3. Expertise with TSQL, SSRS, SSIS required and Power-Bi, SSAS a plus
4. Experience with debug and improve query performance
5. Experience with deploying SSIS packages using git check-in, setting up environmental variables and creating respective jobs in SQL Agent.
6. Significant experience in real-time, multi-tiered data processing systems
7. Experience with Transact-SQL and stored procedures desired.
8. Experience with creating, deploying and maintaining of SSRS reports.
9. Experience with code control/version Team Foundation.
10. Experience with enterprise data integration technologies including Java, SQL, XSLT, Graphical, and XML
11. Strong problem-solving, cross-functional analysis and forward-thinking abilities
12. Flexibility to adapt to changing situations, handle multiple tasks, and meet tight deadlines