Senior Data Warehouse and Integration Engineer

The role

The Senior Data Warehouse and Integration Engineer will handle database engineering, data warehouse architecture, and data integration. This person will own complex database work from design through production and support, working with on-prem Microsoft environments and moving toward Azure-based solutions.

What you will do

• Design, develop, maintain, and troubleshoot SQL Server databases, stored procedures, views, jobs, and related database objects.
• Design and support enterprise data warehouse architecture, data models, schemas, and data flows.
• Evaluate and improve data warehouse structure, scalability, performance, and maintainability.
• Support data warehouse production operations, including failures, performance issues, data quality issues, and downstream dependencies.
• Support and troubleshoot SSIS, ETL processes, integrations, APIs, files, feeds, and scheduled data processes.
• Design reliable data movement between source systems, staging layers, data warehouse environments, and reporting platforms.
• Investigate production database, data warehouse, integration, and reporting issues and drive them to root cause and resolution.
• Reconcile report and data discrepancies against source systems.
• Review database, warehouse, and integration changes for dependencies and downstream impact.
• Support query performance, data integrity, reliability, and production stability.

Required qualifications

• Strong Microsoft SQL Server experience
• Advanced T-SQL
• Data warehouse design and architecture
• Dimensional modeling and enterprise data modeling
• Data warehouse support and production troubleshooting
• Stored procedures, views, functions, and SQL Agent jobs
• SSIS / SSISDB or equivalent ETL experience
• ETL architecture and data pipeline design
• Data integration and troubleshooting
• Data reconciliation and reporting support
• Query performance and optimization
• Production database support

Nice to have

• Enterprise data warehouse environments
• Complex operational, financial, or regulatory reporting
• Multi-system integrations
• Large production SQL environments
• Data warehouse modernization or redesign initiatives

About the company

Goods & Services is a product design and engineering company that solves mission-critical challenges for large enterprises in regulated industries. They use a design-led approach applying AI, Data and Hardware Engineering with a global footprint including the United States, Mexico, and the United Kingdom.