Architect

InnoSoul•Hartford, CT

14h•Hybrid

About The Position

We are seeking a skilled SSIS/SSRS Developer/Architect with expertise in data modeling, TSQL, PowerBI, SSAS, TFS, and XSLT. This role is for a hybrid/local position in Hartford, Connecticut, with a duration of 12 months. The ideal candidate will have 10 or more years of experience in analyzing and designing application solutions, writing complex SQL queries, and optimizing query performance. Experience with real-time, multi-tiered data processing systems, Transact-SQL, stored procedures, and deploying/maintaining SSRS reports is essential. Proficiency in code control using Team Foundation and enterprise data integration technologies like Java, SQL, XSLT, Graphical, and XML is also required. Strong problem-solving, cross-functional analysis, and adaptability to changing situations, multiple tasks, and tight deadlines are key attributes for this role.

Requirements

10+ Years of experience in Database Data Modeling
10+ Years of experience in Microsoft SQL Server
10+ Years of experience in SQL Server Reporting Services (SSRS)
Experience in the analysis and design of application solutions within appropriate standards.
Ability to write complex SQL queries.
Expertise with TSQL, SSRS, SSIS.
Experience with debug and improve query performance.
Experience with deploying SSIS packages using git check-in, setting up environmental variables and creating respective jobs in SQL Agent.
Significant experience in real-time, multi-tiered data processing systems.
Experience with creating, deploying and maintaining of SSRS reports.
Experience with code control/version Team Foundation.
Experience with enterprise data integration technologies including Java, SQL, XSLT, Graphical, and XML.
Strong problem-solving, cross-functional analysis and forward-thinking abilities.
Flexibility to adapt to changing situations, handle multiple tasks, and meet tight deadlines.

Nice To Haves

Power-BI
SSAS
Experience with Transact-SQL and stored procedures.

Responsibilities

Analysis and design of application solutions within appropriate standards.
Write complex SQL queries.
Debug and improve query performance.
Deploy SSIS packages using git check-in, setting up environmental variables and creating respective jobs in SQL Agent.
Work with real-time, multi-tiered data processing systems.
Create, deploy, and maintain SSRS reports.
Utilize code control/version Team Foundation.
Engage with enterprise data integration technologies including Java, SQL, XSLT, Graphical, and XML.
Demonstrate strong problem-solving, cross-functional analysis, and forward-thinking abilities.
Adapt to changing situations, handle multiple tasks, and meet tight deadlines.