Aerospace Data Warehouse SQL Developer (Remote)

Tsunami Tsolutions; Glastonbury (CT); Hybrid; USD 65,000 - 90,000; Full time

Benefits offered by this job

Job summary

Tsunami Tsolutions in the United States is seeking a SQL Developer / Data Analyst to support the CSDW data environment. This junior/mid-level role emphasizes strong SQL and analytical skills and a passion for solving complex data problems.

You will develop and maintain SQL Server data warehouse solutions, perform root cause analysis, and implement corrections and new data features while collaborating with internal teams and customers in an Agile environment.

Qualifications

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

Responsibilities

• Gather and refine customer requirements 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.

Skills

SQL

T-SQL

Data analysis

Analytical skills

Communication

GitHub

Jira

Zephyr

Bash

Tools

SSIS

Databricks

Tosca

D365

Job description

Tsunami Tsolutions in the United States is seeking a SQL Developer / Data Analyst to support the CSDW data environment. This junior/mid-level role emphasizes strong SQL and analytical skills and a passion for solving complex data problems.

You will develop and maintain SQL Server data warehouse solutions, perform root cause analysis, and implement corrections and new data features while collaborating with internal teams and customers in an Agile environment.