Senior Tableau Report Developer / ETL Developer

Location: Hartford, CT
Work Mode: Onsite / Local Candidates Only
Experience: 10 Years

We are seeking an experienced Senior Tableau Report Developer / ETL Developer with strong expertise in Tableau, Microsoft SQL Server, T-SQL, SSIS, and SSRS. The ideal candidate will be responsible for developing interactive Tableau reports, designing and optimizing ETL/ELT processes, supporting database architecture, and integrating data from legacy systems into modern applications.

The candidate will collaborate with business analysts, technical teams, and end users to validate requirements, maintain data quality, optimize reporting performance, and deliver reliable data solutions.

Local candidates who can work onsite in Hartford, CT, are required.

• Design, develop, deploy, and maintain Tableau reports and dashboards based on business requirements.

• Develop and maintain complex SQL queries, T-SQL scripts, stored procedures, and database objects.

• Design, develop, and optimize SSIS packages and ETL/ELT pipelines for data extraction, transformation, cleansing, validation, and loading.

• Create and maintain SSRS reports and support reporting server and SharePoint-integrated reporting environments.

• Assist in designing database architecture, relational data structures, data marts, data dictionaries, and logical and physical data models.

• Develop data acquisition, integration, migration, reconciliation, and data quality strategies.

• Integrate data from legacy systems and external sources into new applications and platforms.

• Work with databases such as Microsoft SQL Server, DB2, and other relational database management systems.

• Configure and deploy SSIS packages using source control, environment variables, and SQL Server Agent jobs.

• Optimize SQL queries, ETL processes, and SSIS package execution for improved performance.

• Develop secure file transfer processes using FTP/SFTP and related data exchange tasks.

• Create Tableau reports with dynamic grouping, sorting, drill-down functionality, summary reports, cross-tab reports, and on-demand subreports.

• Perform data validation, reconciliation, troubleshooting, and error handling throughout data integration and conversion processes.

• Participate in requirements gathering, data mapping, development, testing, deployment, documentation, and ongoing maintenance.

• Collaborate with business analysts, users, and technical teams to validate requirements and deliver effective solutions.

• Maintain code quality and version control using Git and Team Foundation Version Control (TFVC/TFS).

• 10 years of overall IT experience in data development, reporting, ETL, or database development.

• 5 years of hands-on experience developing Tableau reports and dashboards.

• 5 years of experience writing complex SQL queries and troubleshooting query performance.

• 5 years of experience with T-SQL and SSRS, SSIS, or Talend.

• Strong experience with SQL Server, stored procedures, data transformations, and database optimization.

• Hands-on experience developing and deploying ETL/ELT solutions.

• Experience with data migration, data conversion, data integration, and data reconciliation.

• Experience deploying SSIS packages through source control, configuring environment variables, and scheduling jobs using SQL Server Agent.

• Experience with Git and/or Team Foundation Version Control.

• Strong analytical, problem-solving, communication, and documentation skills.

• Ability to manage multiple priorities, work independently, and meet project deadlines.

• Experience with Salesforce.

• Experience with MuleSoft and SOA integrations.

• Experience with Talend reporting and ETL tools.

• Experience supporting enterprise reporting and data integration environments.

• Must be local to Connecticut and available to work onsite in Hartford, CT.

• Must be available to work a full-time, Monday–Friday schedule.

• Must be able to complete applicable background screening and confidentiality requirements.