Senior Data Warehouse and Integration Engineer

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

Role overview

Own complex database, warehouse, and integration work from investigation and design through production deployment and ongoing support. The role focuses on SQL Server engineering and data movement across systems, while maintaining existing Microsoft based environments and contributing to a gradual move toward Azure services.

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.

Requirements

• Strong Microsoft SQL Server and advanced T-SQL experience, including stored procedures, views, functions, and SQL Agent jobs.
• Experience designing data warehouses, enterprise data models, and dimensional schemas.
• Background supporting production data warehouses and resolving database, integration, and reporting incidents.
• Experience with SSIS or comparable ETL tools, data pipeline design, and integrations across APIs, files, and feeds.
• Skills in query optimization, data reconciliation, lineage and dependency analysis, testing, deployment, and change management.
• Familiarity with Azure data services where applicable.

Nice to have

• Experience with complex operational, financial, or regulatory reporting, multi-system integrations, large production SQL environments, or warehouse modernization.