Snowflake Data Architect

Empowered by our motto, "Making Data Matter", Keyrus stands at the forefront of global consultancy in Data & Analytics, AI & Machine Learning, and Digital Transformation. With a presence in 27 countries across 4 continents, we're on a mission to elevate the impact of data.

We are data experts, guiding our clients through their data journey regardless of their level of maturity in analytics. As an end-to-end partner, we address varied challenges that our clients face, from Advanced Analytics, Cloud, Data Governance, Visualisation to Enterprise Performance Management, from advisory to delivery.

With more than 3200 employees in all corners of the world, Keyrus is dedicated to helping businesses taking advantage of the Data and Digital paradigm to enhance their performance, facilitating, and accelerating their transformation, and generating new drivers of growth, competitiveness, and sustainability.

Job Summary 

Keyrus is seeking a seasoned Data & Snowflake Architect to lead the design and implementation of enterprise-grade data platforms for a high-profile client in the financial sector. You will be at the forefront of defining scalable data architectures and best-in-class Snowflake solutions, playing a critical role in enabling robust analytics, advanced reporting, and intelligent business insights.

This position is ideal for a senior technologist with deep expertise in cloud data warehousing, Snowflake architecture, and data engineering best practices, who thrives in fast-paced, agile environments and values clean, performant, and reliable data systems.

• 📍 Location: Europe-based (with possible local on-site client meetings)
• ✈️ Occasional travel to Zurich
• 🕒 Start Date: Mid-September

Note: All applications/CV’s must be submitted in English.

Key Responsibilities

• Architect, design, and manage end-to-end Snowflake-based data platforms, ensuring high performance, scalability, and reliability.
• Lead data modelling efforts (dimensional, normalised, and hybrid) to support complex financial reporting and analytical use cases.
• Drive the design and implementation of data pipelines, including ETL/ELT orchestration, data ingestion, and real-time data streaming integrations.
• Collaborate with stakeholders to analyse data requirements, translating business needs into effective data architecture designs.
• Ensure best practices in Snowflake implementation, including performance optimisation, security, access control, and storage management.
• Write advanced SQL and Python scripts for data manipulation, pipeline automation, and validation routines.
• Integrate DevOps practices into the data engineering lifecycle, including CI/CD for data workflows and infrastructure-as-code for data platforms.
• Provide architectural leadership and mentoring to data engineers; foster best practices in agile delivery, documentation, and team collaboration.
• Support the creation of proof-of-concepts (POCs) and guide the technical evaluation of tools and technologies.

Requirements for the role 

• 7+ years of experience in data engineering, with a minimum of 3 years architecting Snowflake solutions at scale.
• Expertise in SQL and performance tuning for large-scale analytical workloads.
• Strong knowledge of Snowflake architecture, including storage, virtual warehouses, query optimisation, and data sharing.
• Proficient in data modelling (3NF, star/snowflake schemas) and designing data marts/lakes.
• Solid experience with ETL/ELT tools and orchestration frameworks (e.g., dbt, Airflow, Dataiku, Talend).
• Fluency in Python or similar scripting languages for automation and transformation tasks.
• Understanding of DevOps practices in data environments, including CI/CD and version control.
• Familiarity with data governance, security, and compliance practices in a cloud environment.
• Strong interpersonal and communication skills; able to engage with technical and business stakeholders.
• Financial services or insurance industry experience is a plus.
• Fluent in English
• Must be a Portuguese or European citizen or have a work permit for Portugal

What we offer at Keyrus Portugal:

• Competitive salary based on your skills & experience and according to the Data market practice
• Meal allowance of €8.32 per day
• Flexible benefits option
• Private Medical Insurance
• 22 days of annual leave (increasing every 3 years up to a maximum of 25 days)
• Training Program through KLX (Keyrus Learning Experience) Platform

Why Keyrus?

Joining Keyrus means joining a market leader in the Data Intelligence field and an (inter)national player in Management Consultancy and Digital Experience.

Keyrus Portugal operates on five guiding pillars that shape our approach to work and collaboration – Diversity; Trust; Flexibility; Ownership & Innovation - we're dedicated to cultivating a team as diverse as the challenges we take on. 

We embrace and celebrate the rich variety of backgrounds, perspectives, and talents that each individual brings. We firmly believe that diversity fuels innovation, ignites creativity, and propels us towards greatness. 

Regardless of race, ethnicity, gender, sexual orientation, disability, age, or any other dimension of diversity, everyone is not only welcome but valued here. 

Join us in shaping a future where everyone can thrive!