About the company:

Avenue Code is the leading software consultancy focused on delivering end-to-end development solutions for digital transformation across every vertical. We're privately held, profitable, and have been on a solid growth trajectory since day one. We care deeply about our clients, our partners, and our people. We prefer the word 'partner' over 'vendor', and our investment in professional relationships is a reflection of that philosophy. We pride ourselves on our technical acumen, our collaborative problem-solving ability, and the warm professionalism of our teams.

Avenue Code has been believing in and promoting plurality actions for over 10 years, understanding that recognizing differences and fostering a safe environment, employment opportunities, representation, and support are the best ways to promote an increasingly equitable culture.

About the opportunity:

We are seeking a highly skilled Senior Snowflake Cloud Engineer to lead data preparation and integration efforts within our Pharma Supply Chain Management IT business domain. This role is critical in designing and optimizing Snowflake-based data solutions, ensuring seamless integration with SAP and OMP data models, and enabling advanced analytics and data quality to drive operational excellence.

Responsibilities:

• (a) Architect, develop, and optimize scalable and highperformance data solutions in Snowflake.
• (b) Drive data governance, security, and performance optimization across cloud-based data environments.
• (c) Collaborate with cross-functional teams to align data strategies with business and supply chain objectives.
• (d) Develop and implement best practices for data modeling, ETL/ELT processes, and advanced analytics enablement.

Required Qualifications:

(a) Architect, develop, and optimize scalable and high-performance data solutions in Snowflake.

(b) Drive data governance, security, and performance optimization across cloud-based data environments.

(c) Collaborate with cross-functional teams to align data strategies with business and supply chain objectives.

(d) Develop and implement best practices for data modeling, ETL/ELT processes, and advanced analytics enablement.

Qualifications:

(a) Proven experience in Snowflake architecture, data engineering, and cloud platforms.

(b) Advanced SQL skills for efficient query optimization and analytics.

(c) Expertise in data modeling, including star and snowflake schemas tailored for supply chain datasets.

(d) Experience with Snowflake security & access controls and built-in features (

e) Strong expertise in SAP and OMP data models within a supply chain context.

(f) Deep understanding of ETL/ELT frameworks, data pipelines, and performance tuning.

(g) Experience in supply chain processes and data, data quality, data, and operational data management

"Avenue Code discloses salary range information based on our commitment to fairness and transparency. We consider a wide range of factors such as internal equity, geographic location, relevant education, qualifications, certifications, experience, skills, seniority, business or organizational needs, and others. At Avenue Code, it is not typical for an individual to be hired at or near the top of the range for their role, and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for a Platform Engineer is from CAD 80k to CAD 120k per year."

Avenue Code reinforces its commitment to privacy and to all the principles guaranteed by the most accurate global data protection laws, such as GDPR, LGPD, CCPA and CPRA. The Candidate data shared with Avenue Code will be kept confidential and will not be transmitted to disinterested third parties, nor will it be used for purposes other than the application for open positions. As a Consultancy company, Avenue Code may share your information with its clients and other Companies from the CompassUol Group to which Avenue Code's consultants are allocated to perform its services.