Senior Data Engineer - SQL Server & SSIS ETL Expert

Denalica Software Solutions; United States; Remote; USD 120,000 - 170,000; Full time

Job summary

Denalica Software Solutions is seeking an experienced Senior Data Engineer / SQL Server Developer to design, implement and optimize SQL Server-based data solutions and ETL workflows. The role emphasizes hands-on development with SSIS packages and complex SQL components.

You will collaborate with development and data teams to ensure data accuracy and robust integration across multiple sources, with a focus on performance and scalable data pipelines.

Qualifications

• 4-9 years of experience in SQL Server development and related database technologies.
• Hands-on expertise in Microsoft SQL Server and T-SQL.
• Proven experience with SSIS packages and ETL pipelines.
• Strong knowledge of joins, subqueries, CTEs, stored procedures, indexing, transactions and query execution plans.
• Experience with SQL performance tuning, troubleshooting and database optimization.
• Understanding of incremental data loading, data transformations, error handling and data validation.
• Ability to independently develop, debug, and maintain SQL and SSIS solutions.
• Strong analytical, problem-solving and communication skills.
• Experience in data warehousing and large-scale data processing preferred.

Responsibilities

• Design, develop and maintain complex SQL queries, stored procedures, functions, views and database objects using Microsoft SQL Server.
• Develop, implement and maintain SSIS packages for ETL processes.
• Design and manage data integration workflows involving multiple data sources and destinations.
• Perform SQL query optimisation, performance tuning, indexing and troubleshooting.
• Develop incremental data-loading processes and implement error handling and data validation.
• Monitor, troubleshoot and resolve database and ETL-related issues.
• Ensure data accuracy, consistency, integrity and reliability across systems.
• Collaborate with development and data management teams to deliver effective data solutions.

Skills

SQL Server development

T-SQL

SSIS

Joins & subqueries

Performance tuning

Incremental loading

Self-reliant development

Analytical skills

Data warehousing

Job description

Denalica Software Solutions is seeking an experienced Senior Data Engineer / SQL Server Developer to design, implement and optimize SQL Server-based data solutions and ETL workflows. The role emphasizes hands-on development with SSIS packages and complex SQL components.

You will collaborate with development and data teams to ensure data accuracy and robust integration across multiple sources, with a focus on performance and scalable data pipelines.