Senior Data Warehouse & ETL Engineer — SQL Server to Azure

goodsservices; United States; Remote; USD 120,000 - 160,000; Full time

Job summary

goodsservices is seeking a SQL Server Engineer to own complex database, warehouse, and integration work from investigation through deployment and ongoing support. You will focus on SQL Server engineering and data movement across systems while maintaining Microsoft-based environments and contributing to a gradual move toward Azure services.

The role involves designing data warehouses, building ETL pipelines with SSIS, optimizing queries, and supporting production data flows.

Qualifications

• Strong Microsoft SQL Server and advanced T-SQL experience.
• Experience designing data warehouses and dimensional schemas.
• Experience supporting production data warehouses and resolving incidents.
• Experience with ETL tools, data pipelines, and API/file/feed integrations.
• Skills in query optimization, data reconciliation, lineage analysis, testing, deployment, and change management.
• Familiarity with Azure data services where applicable.

Responsibilities

• Develop and maintain SQL Server databases, stored procedures, views, functions, and scheduled jobs.
• Design and support warehouse schemas, data models, and flows; improve performance, scalability, and maintainability.
• Build and troubleshoot ETL and integration processes involving SSIS, APIs, files, feeds, and scheduled transfers.
• Investigate production failures, data quality problems, reporting discrepancies, and performance issues through root cause and resolution.
• Plan data validation, dependency reviews, deployment and rollback steps, and monitoring with retry and recovery processes.
• Document data flows, systems, jobs, reports, and support procedures; coordinate delivery status and risks with partner teams.

Skills

SQL Server engineering

Data modeling

Performance tuning

Root cause analysis

Change management

Tools

SSIS

Azure Data Services

SQL Server

SQL Agent

Job description

goodsservices is seeking a SQL Server Engineer to own complex database, warehouse, and integration work from investigation through deployment and ongoing support. You will focus on SQL Server engineering and data movement across systems while maintaining Microsoft-based environments and contributing to a gradual move toward Azure services.

The role involves designing data warehouses, building ETL pipelines with SSIS, optimizing queries, and supporting production data flows.