Tableau Developer

InnoSoul•Hartford, CT

1d•Hybrid

About The Position

The Department of Children and Families is seeking a senior-level Lead Full Stack Developer to support existing .NET applications and participate in the software development lifecycle for Connecticut’s next-generation Comprehensive Child Welfare Information System (CCWIS). The developer will work with the System Integrator to support knowledge transfer and ongoing maintenance for an assigned module. The role includes requirements verification, design, development, testing, maintenance, and support, under agency management direction. The developer will create and maintain SSRS reports and SSIS ETL packages, develop Tableau reports, support SOA integration initiatives, and participate in reviews of System Integrator deliverables, including requirements, design, testing, and environment configuration. The role also contributes to database architecture, data modeling, data quality, data migration and integration, ETL/ELT solutions, analytics practices, and data conversion from legacy systems. The position is hybrid in Hartford, Connecticut, and requires the candidate to be local and able to work in the office two days every two weeks or one day per week.

Requirements

At least 10 years of prior experience demonstrating the required knowledge and skills; the job posting also lists database data modeling and Microsoft SQL Server expertise at 10+ years.
More than 5 years of Tableau experience.
More than 5 years of experience writing complex SQL queries.
More than 5 years of expertise with T-SQL, SSRS, SSIS, or Talend.
Experience debugging queries and improving query performance.
Experience deploying SSIS packages using Git check-in, setting up environmental variables, and creating corresponding SQL Agent jobs.
Strong problem-solving, cross-functional analysis, and forward-thinking abilities.
Flexibility to adapt to changing situations, handle multiple tasks, and meet tight deadlines.
Strong verbal and written communication skills; ability to work in an organized, proactive, self-directed manner and drive work from requirements through implementation.
Local to Hartford, Connecticut, and able to work in the office two days every two weeks or one day per week.
Ability to access data in database management systems such as DB2 and SQL Server.

Nice To Haves

Experience with Salesforce and MuleSoft.
Experience with Transact-SQL and stored procedures.
Experience creating, deploying, and maintaining Talend reports.

Responsibilities

Drive work from requirements through implementation and participate in requirements verification, design, development, testing, maintenance, and support.
Support existing .NET applications and participate in the SDLC for the new SACWIS system, working with the System Integrator on knowledge transfer and ongoing module maintenance.
Create and maintain SSRS reports and SSIS ETL packages, and develop Tableau reports.
Support SOA integration initiatives and participate in meetings with the System Integrator to verify requirements, design, testing, and environment-configuration deliverables.
Assist in designing and developing database architecture, including relational structures, data marts, data dictionaries, and logical and physical data models.
Develop strategies for data acquisition, data quality, and data discrepancy management.
Assist with migration and integration of data and processes from legacy systems to new applications and technologies.
Develop and maintain documented T-SQL scripts, stored procedures, and triggers in accordance with business rules and requirements.
Design, develop, and implement ETL/ELT solutions for data ingestion, cleansing, business-rule execution, and data distribution.
Apply data analytics practices to data modeling, ETL pipelines, and near-time data solutions.
Coordinate with business analysts and users to validate requirements and integrate external data with in-house data.
Test and validate data flows; prepare ETL processes according to business requirements.
Design and implement data-conversion strategies from legacy systems to new platforms, including design validation, reconciliation, and error handling.
Optimize SSIS package and SQL execution for data-load performance.
Design SSIS packages using file-transfer and secured-file-transfer tasks; import and export files using FTP/SFTP.
Participate in requirements gathering, data mapping, extraction, loading, testing, troubleshooting, documentation, performance optimization, and maintenance.
Develop Tableau reports and deploy reports to a report server or integrated SharePoint report server.
Create reports using dynamic grouping and sorting, on-demand subreports, drill-down and summary reporting, and cross-tab reports.
Deploy SSIS packages using Git check-in, configure environmental variables, and create corresponding SQL Agent jobs.
Create, deploy, and maintain Talend reports.