Lead Data Warehouse & Integration Engineer (Azure)

Goods & Services; Colombia; On-site; COP 18,000,000 - 32,000,000; Full time

Job summary

Goods & Services is seeking a Senior Data Warehouse and Integration Engineer to own database engineering, data warehouse architecture, data integration, reporting support, and production troubleshooting. The role requires independent ownership from investigation to production delivery and ongoing support, with a focus on database/data integration and Azure-based modernization.

The candidate will work in a Microsoft SQL Server environment, contribute to SSIS-based ETL, and collaborate with

Qualifications

• Strong Microsoft SQL Server experience.
• Advanced T-SQL skills.
• Data warehouse design and architecture expertise.
• Dimensional and enterprise data modeling.
• Data warehouse support and production troubleshooting.
• Stored procedures, views, functions, and SQL Agent jobs.
• SSIS/ETL experience.
• ETL architecture and data pipeline design.
• Data integration and troubleshooting.
• Data reconciliation and reporting support; query performance optimization.
• Production database support and root cause analysis.
• Data lineage and dependency analysis.
• APIs, files, feeds, and system integrations.
• Production deployment and change management.
• Azure data services where applicable.

Responsibilities

• 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 technical 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.
• Maintain clear status, target dates, blockers, risks, and next steps; escalate risks early.

Skills

SQL Server

T-SQL

Data warehouse design

Dimensional modeling

Data integration

ETL design

Production troubleshooting

Root cause analysis

Data lineage

APIs integration

Change management

Azure data services

Query performance

Data reconciliation

Production deployment

Tools

SSIS

SQL Agent

Job description

Goods & Services is seeking a Senior Data Warehouse and Integration Engineer to own database engineering, data warehouse architecture, data integration, reporting support, and production troubleshooting. The role requires independent ownership from investigation to production delivery and ongoing support, with a focus on database/data integration and Azure-based modernization.

The candidate will work in a Microsoft SQL Server environment, contribute to SSIS-based ETL, and collaborate with