Job Description
We are seeking an experienced Senior Tableau Developer / ETL Developer to support critical child welfare systems for the State of Connecticut. The ideal candidate will have strong expertise in Tableau, SQL Server, SSIS, SSRS, Talend, and Data Warehousing, along with experience designing and implementing scalable ETL solutions and data analytics platforms.
The selected consultant will work closely with business stakeholders, analysts, and technical teams to develop reporting solutions, optimize data processes, and support migration initiatives for enterprise applications.
Required Skills & Experience
- 10+ years of overall IT experience.
- 5+ years of hands-on experience with Tableau Development.
- 5+ years of experience writing and optimizing complex SQL/T-SQL queries.
- Strong expertise in SSIS, SSRS, Talend, and ETL/ELT development.
- Experience with SQL Server, stored procedures, triggers, and performance tuning.
- Strong knowledge of data modeling, database architecture, and data warehousing concepts.
- Experience developing and deploying SSIS packages, configuring environments, and scheduling jobs through SQL Server Agent.
- Experience working with multiple database platforms including SQL Server and DB2.
- Hands-on experience with data migration, integration, reconciliation, and data quality initiatives.
- Experience with source control/version management tools.
- Strong analytical, troubleshooting, and problem-solving skills.
- Excellent verbal and written communication skills.
Key Responsibilities
- Design, develop, and maintain interactive Tableau reports and dashboards.
- Build and support ETL/ELT pipelines for data ingestion, transformation, and distribution.
- Develop data marts, data models, and database solutions to support reporting and analytics requirements.
- Create and maintain efficient SQL scripts, stored procedures, and database objects.
- Perform data validation, reconciliation, and error handling for ETL processes.
- Optimize ETL workflows and SQL queries for maximum performance.
- Support data migration and integration activities from legacy systems to modern platforms.
- Collaborate with business users and analysts to gather and validate requirements.
- Participate in all phases of the SDLC including design, development, testing, deployment, and support.
- Ensure adherence to data analytics, reporting, and database best practices.
Preferred Qualifications
- Experience with Salesforce integration.
- Experience with MuleSoft.
- Previous State Government or Public Sector experience is a plus.
Work Authorization & Location
- Candidates must be local to Connecticut or willing to relocate/commute.
Must be able to work onsite in Hartford, CT, approximately 1 day per week
