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.