Data Engineer – Snowflake & AI

InnoTech; Portugal; Presencial; EUR 65 000 - 95 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Mental health support

25 days vacation

Birthday/Carnival holiday

School supplies voucher

Petsitting partnerships

Pet bereavement day

Team events

InnoSports initiatives

Sustainability initiatives

Resumo da oferta

InnoTech is seeking a Data Engineer specializing in Snowflake & AI to design scalable data solutions and maintain robust ELT pipelines. You will optimize SQL transformations and data models across data warehouse and lake environments, while managing Snowflake warehouses for performance and cost.

The role includes exploring AI-driven data solutions and collaborating with cross-functional teams. Ideal candidates have proven Snowflake experience, strong SQL skills, and a solid foundation in data

Qualificações

• Proven professional experience with Snowflake in enterprise environments (data modelling, ELT pipelines, query optimization).
• Strong knowledge of advanced SQL for data transformation and analytics.
• Solid understanding of data modelling and data architecture in data warehouse/data lake contexts.
• Experience with Snowflake features (Snowpipe, Streams & Tasks) and warehouse management (cost/performance focus).
• CPLP nationality or EU work permit required to enable employment.

Responsabilidades

• Design and implement scalable data solutions using Snowflake for analytical consumption.
• Build and maintain ELT pipelines leveraging Snowflake features.
• Develop and optimize SQL transformations and data models across warehouse and lake environments.
• Manage Snowflake warehouses with focus on performance and cost efficiency.
• Explore AI-driven data solutions, including generative AI and ML use cases.

Conhecimentos

Snowflake

ELT pipelines

SQL

Data modelling

Data architecture

Python

Snowpipe

Streams & Tasks

Snowpark ML

Formação académica

BSc or MSc in Computer Science/Engineering/IT

Ferramentas

Snowflake

Snowpipe

Streams & Tasks

Snowpark ML

Descrição da oferta de emprego

A Company you will be happy to grow with!

At InnoTech, it´s all about connecting people with business through technology.

We truly care about you, your happiness, and your well-being. We look for passionate people who are eager to learn, evolve, and grow with us - because growth is in our DNA. This commitment has been consistently recognized: we are proud to be a Great Place to Work for five consecutive years, to be one of the Best IT Companies in Portugal, and to be recognized as a Best Workplace Wellbeing. We are also proud to hold ISO 27001 and ISO 9001 certifications, reinforcing our commitment to information security, quality, and continuous improvement. For us, sustainability is not just a buzzword. Integrity, social responsibility, and people-first values guide everything we do. Join our team of 180+ InnoTechers and bring your talent as a Data Engineer – Snowflake & AI.

Your Mission Will Be:

• Design and implement scalable data solutions using Snowflake, ensuring data is reliable, structured, and ready for analytical consumption;
• Build and maintain ELT pipelines, leveraging Snowflake capabilities such as Snowpipe, Streams & Tasks;
• Develop and optimize advanced SQL transformations and data models across data warehouse and data lake environments;
• Manage Snowflake warehouses while continuously improving query performance, scalability, and cost efficiency;
• Explore and contribute to the adoption of AI-driven data solutions, including use cases involving generative AI and Machine Learning.

You Will Need:

• Proven professional experience working with Snowflake in enterprise environments, including data modelling, ELT pipelines, and query optimization;
• Strong knowledge of advanced SQL for data transformation, preparation, and analytical workloads;
• Solid understanding of data modelling and data architecture, particularly within data warehouse and data lake environments;
• Experience with Snowflake features such as Snowpipe, Streams & Tasks, and warehouse management, with a focus on performance and cost optimization;
• CPLP nationality or an EU work permit is required to facilitate employment.

Would Be Awesome If You Have:

• Experience with Snowflake's AI capabilities, such as Cortex LLM Functions, Cortex Search, Cortex Analyst, or Snowpark ML;
• Practical exposure to generative AI or Machine Learning use cases, including RAG, embeddings, and AI-oriented data pipelines;
• Experience preparing and structuring data for consumption by external LLMs, AI agents, or other AI solutions;
• Python skills for scripting, data processing, and integration purposes;
• BSc or MSc in Computer Science/Engineering, Information Technology, or related fields.

What we offer:

• Health-focused partnerships, including free mental health support;
• 25 days of vacation, including your birthday, Carnival, and a bridging day between Christmas and New Year;
• Half a vacation day on your children's birthday and a school supplies voucher;
• Petsitting partnerships and a pet bereavement day;
• Regular team buildings, four annual company parties, game nights, and social events;
• InnoSports initiatives (football, marathons, and more);
• Events focused on sustainability and social responsibility actions.

Are you convinced? Come see it for yourself.