Senior Data Engineer

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

Role

We are looking for an experienced Senior Data Engineer / SQL Server Developer with strong hands-on experience in Microsoft SQL Server, T-SQL development and SSIS-based ETL processes. The candidate will be responsible for developing, maintaining and optimising database solutions and data integration workflows.

Immediate joiners or candidates serving notice with a confirmed joining date are strongly preferred. The selected candidate should be available to join on or before 1 December 2026.

Key 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 (Extract, Transform and Load) 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 appropriate error handling and data validation mechanisms.
• Monitor, troubleshoot and resolve database and ETL-related issues.
• Ensure data accuracy, consistency, integrity and reliability across systems.
• Work closely with the development and data management teams to understand requirements and deliver effective data solutions.

Preferred Candidate Profile

• 4-9 years of relevant experience in SQL Server development and database technologies.
• Strong hands-on expertise in Microsoft SQL Server and T-SQL.
• Proven experience in developing and maintaining SSIS packages and ETL pipelines.
• Good understanding of SQL joins, subqueries, CTEs, stored procedures, indexing, transactions and query execution plans.
• Experience with SQL performance tuning, troubleshooting and database optimisation.
• 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.
• Candidates with experience in data warehousing and large-scale data processing will be preferred.

Important:

This is a hands-on technical development position. Candidates should have practical experience in SQL Server/T-SQL development and SSIS, rather than exclusively reporting, coordination, project management or team management experience.