Senior Tableau / ETL Developer

The role will serve as a Senior Lead Developer supporting CT DCF's existing .NET applications and next-generation child welfare system. The position focuses on Tableau reporting, SQL/T-SQL development, SSIS/SSRS, ETL, data modeling, data migration, data conversion, system integration, and data validation.

Key Requirements:

• 5+ years Tableau

• 5+ years complex SQL queries

• 5+ years T-SQL, SSRS, SSIS or Talend

• SQL query performance tuning and optimization

• SSIS package deployment using Git/TFS, environment variables and SQL Agent

• Data modeling – logical and physical

• Data marts and data dictionaries

• ETL/ELT development

• Data migration and conversion

• Data quality and reconciliation

• SQL Server and DB2

• SOAP/REST or web services integration

• FTP/SFTP

• Tableau report development and deployment

• Strong problem-solving and communication skills

Key Responsibilities:

• Develop Tableau reports and dashboards.

• Design and maintain logical/physical data models.

• Develop data acquisition and data-quality strategies.

• Support legacy-to-new system data migration.

• Develop T-SQL scripts, stored procedures and triggers.

• Design and maintain SSIS ETL packages.

• Perform data extraction, mapping, loading and testing.

• Validate data flows and reconcile data loads.

• Optimize SSIS and SQL performance.

• Develop FTP/SFTP-based data exchange processes.

• Integrate external data with internal systems.

• Work with Business Analysts and users to validate requirements.

• Create and maintain SSRS reports.

• Support application development, testing, troubleshooting and documentation.

• Participate throughout the SDLC.

Important:

The position requires candidates to be local or willing to commute/relocate to Hartford, CT, with approximately 1 day onsite per week.

Please send me your updated resume and confirm your experience with Tableau, T-SQL/SQL Server, SSIS, SSRS, ETL, data modeling, data migration, FTP/SFTP and Tableau report development.