Senior Data Warehouse and Integration Engineer

JobgetherData engineering

Based in BrazilFull-TimeSenior

Salary not disclosed

Apply NowOpens the employer's application page

Job Details

Bring strong hands-on experience with Microsoft SQL Server and advanced T-SQL.
Work with complex queries, stored procedures, views, functions, and SQL Server Agent jobs.
Demonstrate expertise in data warehouse architecture, dimensional modeling, enterprise data modeling, and schema design.
Have practical experience with SSIS, SSISDB, or equivalent ETL technologies.
Understand integration architecture and data movement involving APIs, files, feeds, and scheduled processes.
Support production databases and warehouses, investigate failures, conduct root cause analysis, and resolve performance, reliability, and data quality issues.
Apply SQL query optimization and maintain large or complex database environments.
Support reporting platforms, investigate discrepancies, validate outputs, and trace data to source systems.
Analyze data lineage and upstream and downstream dependencies.
Test and deploy database, warehouse, and integration changes across development, testing/UAT, and production environments.
Be familiar with Azure data services and able to contribute to modernization initiatives.
Manage complex technical assignments through investigation, solution design, implementation, validation, deployment, and support.

Design, develop, maintain, and troubleshoot SQL Server databases, stored procedures, views, functions, jobs, and related objects.
Design and support enterprise data warehouse architectures, data models, schemas, and end-to-end data flows.
Improve query performance, data integrity, reliability, scalability, and maintainability across databases and warehouses.
Investigate production database, warehouse, integration, and reporting incidents, identify root causes, and implement lasting solutions.
Support and troubleshoot SSIS, ETL pipelines, APIs, file-based integrations, data feeds, scheduled processes, and data movement.
Investigate data discrepancies and reconcile reports against source systems.
Assess dependencies and downstream impacts of proposed database, warehouse, and integration changes.
Test and support deployment of changes across DEV, TEST/UAT, and PROD, including rollback planning where appropriate.
Improve monitoring, failure detection, retry, and recovery mechanisms for automated integrations and warehouse processes.
Document databases, architecture, integrations, jobs, reports, data flows, and operational support procedures.

View Full Description & ApplyYou'll be redirected to the employer's site