Hybrid Tableau & SSRS Lead Developer

COOLSOFT; Hartford (CT); Hybrid; USD 90,000 - 130,000; Full time

Job summary

COOLSOFT in Hartford, CT is seeking a Lead Full Stack Developer to support SDLC activities across requirements, design, development, testing, and maintenance. You will work on .NET-related modules, SSRS reports, and ETL processes within a SACWIS context, coordinating with SI partners to ensure knowledge transfer and ongoing support.

The role emphasizes data integration, performance tuning of SSIS/SQL, and developing Tableau reports for stakeholders.

Qualifications

• Senior level Lead Full Stack Developer capable of SDLC oversight.
• Experience creating/maintaining SSRS reports and SSIS ETL packages.
• Strong data integration, SOA, and data performance optimization skills.

Responsibilities

• Develops Tableau Reports.
• Assist in the design and development of the database architecture including relational data structures, data marts, data dictionaries and logical and physical data models.
• Develop strategies for data acquisitions, data quality and data discrepancy.
• Assist in migration and integration of data and processes from legacy systems to new applications and new technologies.
• Develop and maintain efficient, well documented custom SQL scripts, stored procedures, triggers using Microsoft T-SQL in accordance with defined business rules and requirements to support application development.
• Must have the ability to access data stored in a variety of database management systems such as DB2, SQL Server and other.
• Design, develop and implement ETL/ ELT solutions for data ingestion, cleansing, business rules execution and Data Distribution.
• Implementing Data Analytics best practices in designing data modeling, ETL Pipelines, Near time data solutions.
• Coordinate with Business Analyst and users to validate requirements.
• Implementing solutions to integrate external data with inhouse data.
• Perform tests and validate data flows and prepare ETL processes according to business requirements.
• Designing and implement a data conversion strategy from legacy to new platforms.
• Perform design validation, reconciliation and error handling in data load processes.
• Optimize SSIS Package execution and SQL execution to optimize data load performance.
• Design SSIS packages using data exchange tasks such as File transfer and Secured File transfer. Ability to import and export files from FTP/SFTP.
• Involvement in all stages like Requirements gathering, Data mapping, Data extraction, Data loading, Data testing, Troubleshooting, documentation, performance optimization and maintenance.
• Development of different kind of reports using Tableau as per user requirement and deploying to report server/ integrated SharePoint report server.
• Experience using dynamic grouping fields, dynamic group sorti

Skills

Tableau

SQL Queries

SSRS

Problem Solving Skills

Tools

SSIS

SQL Server

DB2

Job description

COOLSOFT in Hartford, CT is seeking a Lead Full Stack Developer to support SDLC activities across requirements, design, development, testing, and maintenance. You will work on .NET-related modules, SSRS reports, and ETL processes within a SACWIS context, coordinating with SI partners to ensure knowledge transfer and ongoing support.

The role emphasizes data integration, performance tuning of SSIS/SQL, and developing Tableau reports for stakeholders.