Senior Cloud Data Warehouse Engineer
ALLTECH CONSULTING SVC INC · Québec, Canada ·
- Seniority
- Senior
- Category
- Logistics
- Experience
- 3+ years
ALLTECH CONSULTING SVC INC · Québec, Canada ·
The Controls Engineering, Measurement and Analytics (CEMA) department is responsible for Cyber Risk and Control assessment, management, monitoring, and reporting capabilities across Technology, resulting in risk reduction and better oversight of the technology risk landscape of the firm. Our work is always client-focused, and our engineers are problem-solvers and innovators. We seek exceptional technologists to help deliver solutions on our user-facing applications, data stores, and reporting and metric platforms while being cloud-centric, leveraging multi-tier architectures, and aligned with our DevOps and Agile strategies. We are modernizing our technology stack across multiple platforms to build scalable, front-to-back assessment, measurement, and monitoring systems using the latest cloud, web, and data technologies. We are looking for someone with a systematic problem-solving approach, coupled with a sense of ownership and drive. The successful candidate will be able to influence and collaborate globally, be a strong team player, have an entrepreneurial approach, push innovative ideas while considering risk, and adapt in a fast-paced changing environment.
As a Senior Cloud Data Warehouse Engineer, you will be a member of the C3 Data Warehouse team focusing on building our next-gen data platform used for sourcing and storing data from various technology systems across the firm into a centralized data platform. This platform will empower reporting and analytics solutions for the Technology Risk functions within the Company. You will primarily contribute to developing our Cloud Data Warehouse utilizing Snowflake and Python-based tooling. Responsibilities include designing and developing our data warehouse with Snowflake features such as data sharing, time travel, Snow Park, workload optimization, and handling structured and unstructured data. You will also work on integrating our Snowflake data warehouse with internal platforms for data quality, cataloging, discovery, incident logging, and metric generation. Collaboration with data warehousing leads, data analysts, ETL developers, infrastructure engineers, and data analytics teams is essential to facilitate the implementation of this data platform and pipeline framework.