About the position The Lead Tableau Report Developer will work as a senior-level lead developer, participating in software development lifecycle activities including requirements verification, design, development, testing, maintenance, and support under agency management direction. The role supports existing .NET applications and participates in the SDLC for a new SACWIS system, working with the system integrator to support knowledge transfer and ongoing maintenance for an assigned module. The developer will create and maintain reports and ETL packages, support service-oriented architecture (SOA) integration initiatives, and work with the system integrator to verify requirements, design and testing deliverables, and environment configuration. The role also covers Tableau reporting, database architecture and modeling, data integration and conversion, data quality, SQL development, ETL/ELT implementation, testing, troubleshooting, documentation, and performance optimization. The position is a one-year contract based in Hartford, Connecticut, with a hybrid work arrangement and local candidates requested. Candidates must be able to work without visa sponsorship.

Responsibilities

• Develop Tableau reports and deploy them to a report server or integrated SharePoint report server.
• Assist with designing and developing database architecture, including relational data structures, data marts, data dictionaries, and logical and physical data models.
• Develop strategies for data acquisition, data quality, and resolving data discrepancies.
• Assist in migrating and integrating data and processes from legacy systems to new applications and technologies.
• Develop and maintain documented Microsoft T-SQL scripts, stored procedures, and triggers in accordance with business rules and requirements.
• Access data stored in database management systems such as DB2 and SQL Server.
• Design, develop, and implement ETL/ELT solutions for data ingestion, cleansing, business-rule execution, and data distribution.
• Apply data analytics best practices to data modeling, ETL pipelines, and near-time data solutions.
• Coordinate with business analysts and users to validate requirements.
• Integrate external data with in-house data.
• Test and validate data flows and prepare ETL processes according to business requirements.
• Design and implement data conversion strategies for moving from legacy systems to new platforms.
• Validate designs and perform reconciliation and error handling in data-load processes.
• Optimize SSIS package execution and SQL execution for data-load performance.
• Design SSIS packages for data exchange tasks, including file transfer and secure file transfer, and import and export files using FTP/SFTP.
• Participate in requirements gathering, data mapping, data extraction and loading, data testing, troubleshooting, documentation, performance optimization, and maintenance.
• Create reports using dynamic grouping and sorting, on-demand subreports, drill-downs, summaries, and cross-tab reports that highlight key information.
• Support existing .NET applications and participate in SDLC activities for the new SACWIS system.
• Work with the system integrator on knowledge transfer, ongoing module maintenance, and verification of requirements, design, testing, and environment-configuration deliverables.
• Drive work from requirements through implementation and contribute to SDLC requirements, design, development, testing, maintenance, and support activities.

Requirements

• At least 10 years of prior experience demonstrating relevant knowledge and skills.
• More than 5 years of Tableau experience.
• More than 5 years of experience writing complex SQL queries.
• More than 5 years of expertise with T-SQL, SSRS, and SSIS or Talend.
• Experience debugging queries and improving query performance.
• Experience deploying SSIS packages using Git check-in, setting up environment variables, and creating corresponding SQL Agent jobs.
• Strong problem-solving, cross-functional analysis, and forward-thinking abilities.
• Ability to adapt to changing situations, handle multiple tasks, and meet tight deadlines.
• Strong verbal and written communication skills.
• Highly organized, proactive, self-directed, and self-starting; able to drive work from requirements to implementation.
• Strong abstract thinking and problem-solving skills.
• Ability to work without visa sponsorship.

Nice-to-haves

• Experience with Salesforce.
• Experience with MuleSoft.
• Experience with Transact-SQL and stored procedures.
• Experience creating, deploying, and maintaining Talend reports.
• Experience with Team Foundation for code control and versioning.