Senior Snowflake Consultant

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 looking for a Senior Snowflake Consultant. The ideal candidate embodies technical prowess in Snowflake data warehousing, coupled with a fervent commitment to making every piece of data matter. We value individuals who are detail-oriented, independent contributors with exceptional communication and problem-solving skills, ensuring that together, we continue to transform possibilities into reality.

This position is fully remote.

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

Key Responsibilities

• Design, develop, and administer Snowflake-based data warehouse solutions.
• Perform data analysis, transformation, and cleaning to ensure high-quality data for reporting and analytics.
• Conduct requirement analysis, data architecture design, and systems integration to meet client needs.
• Implement database design and development practices, ensuring system scalability and performance.
• Optimize database performance and troubleshoot complex issues, leveraging advanced SQL techniques.
• Collaborate with cross-functional teams to ensure seamless integration of ETL processes and tools.
• Provide expertise in cloud data warehousing, particularly in Snowflake, ensuring best practices in data modeling and architecture.
• Support the creation of robust data pipelines and assist in integrating DevOps practices within the data architecture.
• Guide and mentor junior team members while promoting the adoption of agile methodologies.

Requirements for the role 

• Proven expertise in SQL with extensive experience in complex database queries and optimizations.
• Strong experience working with Snowflake data warehousing solutions.
• Advanced knowledge of systems architecture, database design, and DB application development.
• Deep understanding of ETL concepts and proficiency with ETL tools.
• Solid understanding of database performance tuning and how to apply these techniques to ensure high-performance systems.
• Proficiency in scripting languages, particularly Python, for automating tasks and enhancing data workflows.
• Strong grasp of cloud data warehousing, particularly with Snowflake.
• Familiarity with data modeling concepts and experience in applying them within complex data environments.
• Good understanding of agile methodology and its practical application in data projects.
• Experience with DevOps practices as they relate to data infrastructure.
• Strong understanding of data warehouse architecture and database administration.
• 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!