Senior Data Warehouse Engineer

Cynet systems Inc; Montreal; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading technology firm in Montreal is seeking a Data Warehouse Modernization Specialist with extensive experience in data warehousing. The role includes leading modernization projects, analyzing performance, and optimizing SQL and PL/SQL scripts. The ideal candidate has over 5 years of relevant experience and expertise in Shell Scripting and Control-M. This position offers an opportunity to work in a dynamic environment focused on scalable solutions.

Qualifications

• Minimum of 5 years of experience in data warehousing.
• Expert-level proficiency in SQL for writing complex queries.
• Extensive experience with PL/SQL in an Oracle environment.
• Strong expertise in Shell Scripting (UNIX/Linux).
• Proven experience with Control‑M or similar job schedulers.
• Deep understanding of data warehouse concepts and architecture.

Responsibilities

• Lead and execute data warehouse modernization projects.
• Conduct performance analysis of data warehouse processes.
• Design, develop, and maintain advanced data models and ETL/ELT frameworks.
• Optimize SQL and PL/SQL scripts for data manipulation.
• Develop batch processes using Shell Scripting.
• Utilize Control-M for managing complex job workflows.

Skills

Data warehousing experience

Expert-level SQL

PL/SQL proficiency

Shell Scripting expertise

Control-M experience

Analytical skills

Communication skills

Collaboration

Tools

Control-M

Git

JIRA

ServiceNow

Job description

Job Description

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 optimised 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 modelling, 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.