Lead Full Stack Developer (ETL & Tableau) - Contract role
About The Position
The agency seeks a senior-level Lead Full Stack Developer to participate in software development lifecycle (SDLC) processes, including requirements verification, design, development, testing, maintenance, and support, under the direction of agency management. The role supports existing .NET applications and participates in the SDLC for a new SACWIS system, working with the System Integrator to facilitate knowledge transfer and ongoing maintenance for an assigned module. The position also involves creating and maintaining SSRS reports and SSIS ETL packages, supporting SOA integration initiatives, and reviewing System Integrator deliverables related to requirements, design, testing, and environment configuration. The developer will build Tableau reports; contribute to database architecture and data modeling; develop data acquisition, quality, and discrepancy strategies; and help migrate and integrate data and processes from legacy systems. The role designs and maintains SQL scripts, stored procedures, triggers, and ETL/ELT solutions; integrates external and in-house data; validates requirements and data flows; develops legacy data conversion strategies; and performs reconciliation, error handling, testing, troubleshooting, documentation, and performance optimization. It also includes designing SSIS packages for file exchange, including FTP/SFTP, and deploying reports to a report server or integrated SharePoint report server. This is a contract position based in Hartford, Connecticut, with hybrid attendance required: the employee must be able to work in the office two days every two weeks or one day per week. The stated work schedule is full-time, 40 hours per week, Monday through Friday, 8 AM to 5 PM. The estimated duration is November 22, 2026, through November 14, 2027.
Requirements
- At least 10 years of prior experience demonstrating the knowledge and skills required for the role; the posting references State IT Professional Services Agreement classification Solution Architect requirements.
- 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 T-SQL, SSRS, SSIS, or Talend.
- Experience debugging and improving query performance.
- Experience deploying SSIS packages using Git check-in, configuring environmental variables, and creating corresponding SQL Agent jobs.
- Experience with code control/versioning using 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.
- Ability to access data in database management systems such as DB2 and SQL Server.
- Ability to work in the Hartford office at the required hybrid frequency.
Nice To Haves
- Experience with Salesforce.
- Experience with MuleSoft.
- Experience with Transact-SQL and stored procedures is described as desired.
Responsibilities
- Participate in SDLC activities, including requirements verification, design, development, testing, maintenance, and support.
- Support existing .NET applications and participate in the SDLC for the new SACWIS system, coordinating with the System Integrator on knowledge transfer and ongoing module maintenance.
- Create and maintain SSRS reports and SSIS ETL packages and support SOA integration initiatives.
- Review and verify System Integrator deliverables, including requirements, design, testing, and environment configuration.
- Develop Tableau reports and deploy reports to a report server or integrated SharePoint report server.
- Assist with database architecture, including relational structures, data marts, data dictionaries, and logical and physical data models.
- Develop strategies for data acquisition, data quality, and data discrepancy management.
- Assist in migrating and integrating data and processes from legacy systems to new applications and technologies.
- Develop and maintain documented custom Microsoft T-SQL scripts, stored procedures, and triggers in accordance with business rules and requirements.
- 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 from legacy systems to new platforms.
- Perform design validation, 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, including file transfer and secure file transfer, and import and export files via FTP/SFTP.
- Participate in requirements gathering, data mapping, extraction, loading, testing, troubleshooting, documentation, performance optimization, and maintenance.
- Create Tableau reports using features such as dynamic grouping and sorting, on-demand subreports, drill-down and summary reports, and cross-tab reports.
- Deploy SSIS packages using Git check-in, configure environment variables, and create corresponding SQL Agent jobs.
- Create, deploy, and maintain Talend reports.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
