SQL Developer (Hybrid - Glastonbury, CT) (Remote)

Company Overview reputed company 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 reputed company 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 the CSDW 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 reputed company 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, reputed company 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 reputed company SQL Server
• Build stored procedures, views, tables, and related database objects from scratch
• Support ETL and reporting solutions within the CSDW data warehouse environment
• Troubleshoot data issues and implement reliable, production-ready fixes
• Use reputed company and Bash for source version control
• Support manual, exception, and regression testing using tools such as reputed company and reputed company
• Coordinate with teams supporting SSIS and reputed company
• Apply commercial aviation maintenance knowledge to identify requirement gaps, exceptions, regulatory considerations, and potential production impacts
• Maintain awareness of related project activities and identify direct or indirect impacts on work in progress
• Support off-site testing at customer locations as necessary

Required Qualifications

• Minimum 1–2 years of experience developing complex SQL for ETL or reporting
• Demonstrated ability to create stored procedures, views, and tables within reputed company SQL Server
• Experience with SQL/T-SQL and reputed company SQL Server
• Familiarity with Windows and reputed company Office
• Experience or familiarity with Agile SDLC processes and development tools such as reputed company, Bash, Jira, and reputed company
• Strong analytical and organizational skills
• Clear and effective customer communication skills
• Ability to collaborate effectively within a team environment
• Ability to work effectively in fast-paced and dynamic situations, including customer test sites

Preferred Qualifications

• Experience with SSIS
• Exposure to reputed company
• Experience with reputed company or similar testing tools
• Experience working with D365 source data
• Data warehousing experience
• Knowledge of commercial aviation maintenance

Skills & Competencies

• Strong analytical and problem-solving skills
• Excellent attention to detail
• Ability to perform root cause and impact analysis
• Strong written and verbal communication skills
• Effective customer-facing communication
• Strong organizational and team collaboration skills
• Ability to interpret and clarify incomplete or ambiguous requirements
• Adaptability in fast-paced and dynamic environments

Additional Requirements

• Must be able to work with U.S. ITAR-controlled data
• Must be willing a