Tableau Programmer/Developer / Hartford , CT ( Hybrid),6+ Months Contract

Suncap Technology - Hartford, CT

Full-time - Senior

Hartford, CT

Professional, Scientific, and Technical Services

About the position

The position is for a Lead Full Stack Developer specializing in Tableau programming and development, primarily focused on supporting existing .NET applications and participating in the SDLC process for a new SACWIS system. The role involves creating and maintaining SSRS reports and SSIS ETL packages, as well as ensuring effective integration and maintenance of data solutions.

Responsibilities

• Develops Tableau Reports.
• Assist in the design and development of the database architecture including relational data structures, data marts, data dictionaries and logical and physical data models.
• Develop strategies for data acquisitions, data quality and data discrepancy.
• Assist in migration and integration of data and processes from legacy systems to new applications and new technologies.
• Develop and maintain efficient, well documented custom SQL scripts, stored procedures, triggers using Microsoft T-SQL in accordance with defined business rules and requirements to support application development.
• Access data stored in a variety of database management systems such as DB2, SQL Server and others.
• Design, develop and implement ETL/ELT solutions for data ingestion, cleansing, business rules execution and Data Distribution.
• Implement Data Analytics best practices in designing data modeling, ETL Pipelines, Near time data solutions.
• Coordinate with Business Analyst and users to validate requirements.
• Implement solutions to integrate external data with in-house data.
• Perform tests and validate data flows and prepare ETL processes according to business requirements.
• Design and implement a data conversion strategy from legacy to new platforms.
• Perform design validation, reconciliation and error handling in data load processes.
• Optimize SSIS Package execution and SQL execution to optimize data load performance.
• Design SSIS packages using data exchange tasks such as File transfer and Secured File transfer.
• Involvement in all stages like Requirements gathering, Data mapping, Data extraction, Data loading, Data testing, Troubleshooting, documentation, performance optimization and maintenance.
• Development of different kinds of reports using Tableau as per user requirement and deploying to report server/integrated SharePoint report server.
• Experience using dynamic grouping fields, dynamic group sorting, on-demand sub reports, drill down and summary reports, and creating cross tab reports highlighting key summary information.

Requirements

• 10 or more years of prior experience in IT Professional Services Agreement (22PSX0163).
• More than 5 years of Experience with Tableau.
• More than 5 years of experience writing complex SQL queries.
• More than 5 years of expertise with TSQL, SSRS, SSIS or Talend.
• Experience with debugging and improving query performance.
• Experience with deploying SSIS packages using git check-in, setting up environmental variables and creating respective jobs in SQL Agent.
• Experience with Transact-SQL and stored procedures desired.
• Experience with creating, deploying and maintaining Talend reports.
• Experience with code control/version Team Foundation.
• Strong problem solving, cross-functional analysis and forward-thinking abilities.
• Flexibility to adapt to changing situations, handle multiple tasks, and meet tight deadlines.

Nice-to-haves

• Experience with Salesforce.
• MuleSoft.