Senior Data Warehouse and Integration Engineer

Accountabilities Database Engineering: Design, develop, maintain, and troubleshoot Microsoft SQL Server databases, stored procedures, views, functions, jobs, and related database objects.

Data Warehouse Architecture: Design and support enterprise data warehouse architectures, dimensional and enterprise data models, schemas, and end-to-end data flows.

Performance and Scalability: Evaluate and improve database and warehouse structures to strengthen query performance, data integrity, reliability, scalability, and maintainability.

Production Operations: Investigate and resolve database, warehouse, integration, and reporting incidents, identifying root causes and implementing effective, lasting solutions.

Data Integration and ETL: Support and troubleshoot SSIS, ETL pipelines, APIs, file-based integrations, data feeds, scheduled processes, and data movement between source systems, staging environments, warehouses, and reporting platforms.

Data Quality and Reconciliation: Investigate data discrepancies, reconcile reports against source systems, and ensure the accuracy and consistency of data across connected platforms.

Dependency and Impact Analysis: Review proposed changes to databases, data warehouses, and integrations to identify dependencies, assess downstream impacts, and reduce operational risk.

Testing and Deployment: Define and execute technical tests for database, warehouse, and integration changes; support DEV, TEST/UAT, and PROD deployments, including rollback planning where appropriate.

Monitoring and Recovery: Establish and improve monitoring, failure detection, retry, and recovery mechanisms for automated integrations and warehouse processes.

Documentation and Supportability: Maintain accurate documentation covering critical databases, architecture, integrations, jobs, reports, data flows, and operational support procedures.

Cross-Functional Collaboration: Work closely with Development, Business Analysis, Project Management, Applications, Infrastructure, and Support teams to coordinate technical delivery and resolve dependencies.

Delivery Ownership: Communicate progress, target dates, blockers, risks, and next steps clearly. Escalate issues early and ensure all assigned work is investigated, tested, validated, documented, deployed, and ready for ongoing support.

Requirements:

SQL Server Expertise: Strong hands-on experience with Microsoft SQL Server and advanced T-SQL, including complex queries, stored procedures, views, functions, and SQL Server Agent jobs.

Data Warehouse Design: Demonstrated expertise in data warehouse architecture, dimensional modeling, enterprise data modeling, schema design, and data pipeline development.

ETL and Integration: Practical experience with SSIS, SSISDB, or equivalent ETL technologies, including integration architecture, data movement, APIs, files, feeds, and scheduled data processes.

Production Troubleshooting: Proven ability to support production databases and data warehouses, investigate failures, conduct root cause analysis, and resolve performance, reliability, and data quality issues.

Performance Optimization: Strong understanding of SQL query optimization, data integrity, production stability, and the maintenance of large or complex database environments.

Reporting and Reconciliation: Experience supporting reporting platforms, investigating discrepancies, validating outputs, and tracing data back to source systems.

Data Lineage and Dependencies: Ability to analyze data lineage, understand upstream and downstream dependencies, and assess the impact of technical changes across connected systems.

Deployment and Change Management: Experience testing and deploying database, warehouse, and integration changes across development, testing/UAT, and production environments, including rollback and recovery planning.

Azure Data Services: Familiarity with Azure data services and the ability to contribute to modernization initiatives where applicable.

Technical Ownership: Ability to independently manage complex technical assignments from investigation and solution design through implementation, validation, deployment, and support.

Communication and Collaboration: Strong problem-solving, organizational, and communication skills, with the ability to coordinate across technical and business teams, communicate risks clearly, and keep work moving toward resolution.

Nice to have:

Experience working with enterprise-scale data warehouse environments.

Exposure to complex operational, financial, or regulatory reporting.

Experience managing integrations across multiple systems.

Familiarity with large-scale production SQL Server environments.

Involvement in data warehouse modernization, redesign, or migration initiatives.

Benefits:

Work Location: The position is listed for Brazil in this opportunity description; the original posting references remote roles in Mexico and Colombia, so the precise Brazil-based work arrangement should be confirmed during the hiring process.

Technical Impact: Opportunity to take ownership of mission-critical databases, data warehouse architecture, and integrations while improving production reliability and performance.

Modernization Opportunities: Exposure to established Microsoft and on-premises technologies, with opportunities to contribute to Azure-based data solutions.

Cross-Functional Collaboration: Work with multidisciplinary teams across development, business analysis, project management, infrastructure, applications, and support.

Professional Development: Opportunities to deepen expertise in enterprise data engineering, integration architecture, production operations, and warehouse modernization.

Compensation and Additional Benefits: The original job description does not specify a salary range, healthcare coverage, paid leave, or other individual benefits. These details should be confirmed with the hiring team.

How Jobgether works: We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team. We appreciate your interest and wish you the best!  Why Apply Through Jobgether? 

Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.

#LI-CL1