Tableau / ETL Developer

We are seeking an experienced Senior Tableau / ETL Report Developer to support enterprise-level reporting, legacy data migration, and data warehouse integration initiatives. In this role, you will collaborate closely with systems integrators and business analysts to design, develop, and optimize reporting dashboards, ETL pipelines, and complex database architectures across large-scale public sector systems., * Reporting & Dashboards: Design, develop, test, and deploy interactive Tableau reports and dashboards to report servers and integrated enterprise portals. Implement dynamic grouping, sorting, drilldowns, summary reports, and crosstab views.

• ETL & Data Pipelines: Build, maintain, and optimize robust SSIS and ETL/ELT packages for data ingestion, cleansing, transformation, business logic execution, and distribution. Set up secure data exchanges using FTP/SFTP.
• Database Development & Architecture: Assist in designing logical and physical data models, relational structures, data marts, and data dictionaries across multiple database platforms (SQL Server, DB2, and others).
• Query Optimization: Write, debug, and fine-tune complex T-SQL queries, stored procedures, and triggers. Optimize SQL execution and SSIS packages to handle large datasets and eliminate performance bottlenecks.
• System Migration: Support data acquisition, data discrepancy resolution, and end-to-end legacy data conversion strategies to modernize legacy platforms into new applications.
• Lifecycle & Release Management: Manage code deployments, configuration of environment variables, SQL Agent scheduling, and version control using standard source control systems.

• 10+ years of professional experience in enterprise database development, data warehousing, and business intelligence reporting.
• 5+ years of hands-on experience building complex reports and visual analytics in Tableau.
• 5+ years of hands-on experience writing complex SQL queries and performance tuning.
• 5+ years of expertise working with T-SQL, SSRS, and SSIS (or Talend).
• Proven experience in accessing and integrating data across diverse relational databases (e.g., Microsoft SQL Server, IBM DB2).
• Demonstrated experience handling full lifecycle data migration and conversion from legacy platforms.
• Hands-on experience with source control systems (e.g., Git, Team Foundation Server).
• Strong analytical, cross-functional communication, and problem-solving skills with the ability to lead technical tasks independently.
• Experience with Salesforce data integration or reporting.
• Experience with MuleSoft or SOA-based enterprise integrations.
• Prior experience in public sector, health, or human services environments., * Microsoft SQL Server (Required 10 Years)
• Data Modeling (Required 10 Years)
• SQL Server Reporting Services (SSRS) (Required 10 Years)

• Schedule: Standard business hours, Monday through Friday, 8:00 AM - 5:00 PM EST.
• On-Site Requirement: Candidates must reside within commuting distance or be willing to relocate, as the position requires regular on-site attendance in Hartford, CT (either 1 day per week or 2 days every 2 weeks).
• Background Check: Selected candidates must complete a comprehensive background check package, including federal, state, and county criminal searches, reference verification, and a 10-panel drug screening.
• Job Type: Full-Time Contract (40 hours/week)
• Location: Hartford, CT (Hybrid: 1 day/week or 2 days every 2 weeks on-site)