Senior Data Warehouse & Integration Engineer (Azure-ready)

Openkrill; United States; A distancia; USD 120.000 - 180.000; Jornada completa

Descripción de la vacante

Goods & Services is seeking a Senior Data Warehouse and Integration Engineer to own database engineering, data warehouse architecture, and data integration. You will support production operations, troubleshoot, and help move from on-prem/Microsoft environments toward Azure-based solutions.

You will design SQL Server databases, ETL processes, data models, and data flows, collaborate with Development, BA, PM, Applications, Infrastructure, and Support teams, and maintain documentation.

Formación

• Strong Microsoft SQL Server experience.
• Advanced T-SQL ability.
• Data warehouse design and architecture experience.
• 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 optimization.
• Production deployment and change management.
• Azure data services experience where applicable.

Responsabilidades

• 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 root cause 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.
• Define and execute testing for database, warehouse, and integration changes.
• Support DEV, TEST/UAT, and PROD deployments, including rollback planning where needed.
• Build monitoring, failure detection, retry, and recovery processes for automated integrations and warehouse processes.
• Maintain documentation for critical databases, warehouse architecture, integrations, jobs, reports, data flows, and support procedures.
• Work with Development, BA, PM, Applications, Infrastructure, and Support teams.

Conocimientos

Microsoft SQL Server

Advanced T-SQL

Data warehouse design

Dimensional modeling

Data warehouse troubleshooting

Stored procedures / views

SSIS / SSISDB

ETL architecture

Data integration

Query performance

Production deployment

Azure data services

Herramientas

SSIS/ETL tools

Descripción del empleo

Goods & Services is seeking a Senior Data Warehouse and Integration Engineer to own database engineering, data warehouse architecture, and data integration. You will support production operations, troubleshoot, and help move from on-prem/Microsoft environments toward Azure-based solutions.

You will design SQL Server databases, ETL processes, data models, and data flows, collaborate with Development, BA, PM, Applications, Infrastructure, and Support teams, and maintain documentation.