Data Warehouse Architect: Modernization & Performance Lead

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

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.