Role Name: Senior Data Warehouse Engineer, Modernization and Performance

Location: Montreal, QC

"We are seeking a highly experienced and results-oriented Senior Data Warehouse Engineer to work our data warehouse modernization and performance optimization initiatives. The ideal candidate will possess deep expertise in database programming and enterprise job scheduling, with a robust focus on enhancing system architecture, re-platforming legacy components, and improving data process efficiency. This role requires hands-on technical skills who can drive strategic improvements while maintaining operational excellence.

Responsibilities

- Lead and execute data warehouse modernization projects, including identifying and re-platforming legacy components to more modern, scalable architectures.
- Conduct in-depth performance analysis of data warehouse processes, queries, and ETL/ELT jobs to identify bottlenecks and implement strategic optimizations.
- Design, develop, and maintain advanced data models, ETL/ELT frameworks, and data integration solutions.
- Develop and optimize complex SQL and PL/SQL scripts, stored procedures, functions, and packages for data manipulation and transformation.
- Architect, develop, and maintain robust batch processes using Shell Scripting (UNIX/Linux) to support data loads, system automation, and operational monitoring.
- Utilize Control-M or similar enterprise job scheduling tools to design, manage, and monitor complex job workflows, ensuring optimal performance and reliability.
- Perform comprehensive root cause analysis (RCA) on performance degradation and system failures,



developing and implementing long-term preventative solutions.
- Develop and enforce data warehouse best practices, coding standards, and architectural patterns.
- Create and maintain detailed documentation for modernized processes, system architecture, and performance improvements.

Skills and Qualifications

- Minimum of 5 years of experience in data warehousing, with significant experience in modernization and performance-focused initiatives.
- Expert-level proficiency in SQL for writing complex, highly optimized queries.
- Extensive experience with PL/SQL for designing and developing efficient database applications and transformations in an Oracle or similar environment.
- Strong expertise in Shell Scripting (UNIX/Linux) for process automation, job control, and system administration.
- Proven hands-on experience with Control-M or another major enterprise job scheduler for orchestrating complex data workflows.
- Deep understanding of data warehouse concepts, dimensional modeling, and database architecture.
- Excellent analytical and problem-solving skills, with a focus on delivering high-performance, scalable solutions.
- Strong communication and collaboration skills, with the ability to influence technical and non-technical stakeholders.

Preferred (Optional) Skills

- Perl: Experience with Perl scripting for data processing, reporting, and automation.
- Python: Experience with Python for scripting, data manipulation, and building data pipelines.
- Experience with version control systems like Git.
- Incident management and change management tools experience like JIRA, ServiceNow"

📌 Senior Data Warehouse Engineer, Modernization and Performance (Quebec City)
🏢 Recutify
📍 Quebec City