SQL Developer (Hybrid - Glastonbury, CT)

Company Overview Tsunami Tsolutions is a leading provider of technology solutions tailored for the aerospace & defense sector and other highly regulated industries. We specialize in delivering innovative enterprise solutions that enhance operational efficiency, compliance, and decision-making for airlines, MROs, and aerospace manufacturers. NOTE: This position requires access to technologies and hardware subject to US national security-based export control requirements. All applicants must be US Persons (8 USC 1324b(a)(3)), or otherwise authorized by the U.S. Government. NO Company Sponsorship offered. Position Overview We are seeking a SQL Developer / Data Analyst to support business programs and data environment. This junior/mid-level role is ideal for a developer with strong SQL and analytical skills who enjoys solving complex data problems, investigating defects, and developing reliable data warehouse solutions. In this role, you will develop and maintain SQL Server data warehouse solutions, perform root cause and impact analysis, and implement corrections and new data features. The position requires strong T-SQL skills, analytical judgment, attention to detail, and effective written and verbal communication with internal teams and customers. Knowledge of commercial aviation maintenance is preferred, as requirements may be incomplete or require industry context to identify defects, exceptions, and potential production impacts. Key Responsibilities Gather and refine customer requirements and work with the Project Manager and subject matter experts to clarify ambiguous requirements Perform root cause analysis of bugs and defects within customer data structures Design, develop, test, and implement SQL-based solutions to resolve identified defects Perform design and impact analysis for new data features and elements, including downstream dependencies Develop and maintain stored procedures that extract data from source databases, apply business rule transformations, and load the data warehouse Analyze and maintain table DDL to store source data in the required format and structure Analyze and maintain views that present warehoused data in customer-specified formats Create and execute test scripts and support customer, change request, system-level, and regression testing Work within an Agile SDLC and use Jira for ticketing and workflow management Report progress, risks, blockers, and metrics to program leadership and the Integrated Product Team (IPT) Champion adherence to established Product Development Workflow and ORCA processes What You’ll Do Develop complex SQL and T-SQL within Microsoft SQL Server Build stored procedures, views, tables, and related database objects from scratch Support ETL and reporting solutions within the data warehouse environment Troubleshoot data issues and implement reliable, production-ready fixes Use GitHub and Bash for source version control Support manual,…