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.
