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.