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
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.