Want to know if this job is worth applying to?
Canada
Remote only
This position is listed on behalf of a partner company, which manages all applications and next steps. Our partner is looking for a Senior Data Warehouse and Integration Engineer based in Canada.
We are seeking an experienced data engineering professional to take ownership of complex database, data warehouse, and integration initiatives from initial investigation through production deployment and ongoing support. This role combines hands-on Microsoft SQL Server engineering with enterprise data warehouse architecture, ETL development, reporting support, and production troubleshooting. You will help maintain reliable data operations while improving performance, scalability, and long-term maintainability. Working across an established on-premises Microsoft environment, you will also contribute to the evolution toward modern Azure-based data solutions. Collaboration with development, business analysis, project management, applications, infrastructure, and support teams will be essential. The ideal candidate brings strong technical judgment, a proactive approach to problem-solving, and the ability to drive complex work through to a documented, tested, and sustainable outcome.
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.
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.
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.
