Senior Data Engineer - Snowflake

Keyrus Portugal; United States; Remote; EUR 80,000 - 120,000; Full time

Job summary

A forward-thinking company is seeking a Senior Data Engineer with a strong background in Snowflake and SQL to join their dynamic team. In this fully remote role, you will design and develop data warehouse solutions, ensuring high-quality data for analytics and reporting. You will optimize database performance, collaborate with cross-functional teams, and mentor junior members. This is a unique opportunity to work with a market leader in Data Intelligence, contributing to innovative projects that drive business transformation. If you are passionate about data and eager to make an impact, this role is perfect for you.

Benefits

Competitive salary

Meal allowance

Flexible benefits

Private Medical Insurance

22 days of annual leave

Training Program

Qualifications

• Proven expertise in SQL and Snowflake data warehousing.
• Strong grasp of ETL concepts and cloud data warehousing.

Responsibilities

• Design and administer Snowflake-based data warehouse solutions.
• Optimize database performance and troubleshoot complex issues.

Skills

SQL

Snowflake

Database Design

ETL Concepts

Python

Cloud Data Warehousing

Agile Methodology

DevOps Practices

Education

Bachelor's Degree in Computer Science or related field

Tools

ETL Tools

Job description

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 Data Engineer -Snowflake.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 Portugueseor Europeancitizen 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!