Data Engineer (Middle)

Intermedia; Coimbra; Híbrido; EUR 45 000 - 65 000; Tempo integral

Resumo da oferta

Intermedia is seeking a Data Engineer (Middle) to join IT Business Systems & Security in Portugal. The role supports a remote‑friendly setup with occasional Coimbra office visits and future office openings in Aveiro and Porto.

You will own data pipelines from ingestion to consumption using Snowflake, dbt, MSSQL, and S3, with a strong emphasis on SQL and data quality. The ideal candidate has 3–5 years in data engineering or analytics, strong SQL skills, and hands‑on experience with production

Qualificações

• Degree in Computer Science, Data Analytics, Statistics, Mathematics, Economics, or similar.
• 3–5 years doing data engineering, data analysis, or similar.
• SQL that actually impresses people—joins, window functions, and performance considerations.
• Ability to read stored procedures and diagnose issues.
• Experience with production databases (MSSQL, Oracle, PostgreSQL or similar).
• Understanding data flow: raw → staging → consumption; why shortcuts hurt.
• Incremental loads with watermarks; MERGE vs INSERT trade-offs.
• Git for version control; code reviews and PRs.
• Familiarity with Snowflake, dbt, and related data tools.
• Python for scripting and automation.

Responsabilidades

• Build and fix pipelines—ingestion, transformation, consumption.
• Write dbt models with tests and docs.
• Trace data issues from report back to source.
• Troubleshoot incidents: MSSQL, Snowflake, S3 issues.
• Run backfills and validate results to confirm fixes.
• Migrate data from MSSQL to Snowflake without loss.
• Monitor data quality and alert on anomalies.
• Document processes so future you can understand.

Conhecimentos

SQL proficiency

Data modeling

Data pipelines

Python scripting

Problem solving

Ownership

Read stored procedures

Production DB experience

Git & code review

CI/CD concepts

Formação académica

Degree in Computer Science, Data Analytics, Statistics, Mathematics, Economics, or similar

Ferramentas

MSSQL

Oracle

PostgreSQL

Snowflake

dbt

S3

GitHub Actions

Python

Snowpipe

ETL tooling

Descrição da oferta de emprego

Data Engineer (Middle)

Department: IT Business Systems & Security

Employment Type: Full Time

Location: Portugal

Description

While primarily remote, this role requires occasional visits to the office in Coimbra. We plan to open offices in Aveiro and Porto in the future. This approach gives team members the flexibility to work remotely while also coming together in the office for collaboration and teamwork.

About Intermedia

Are you looking for a company where YOUR VOICE is heard? Where you can MAKE A DIFFERENCE? Do you THRIVE in a FAST-PACED work environment? Do you wake every morning EXCITED to work with GREAT PEOPLE and create SUCCESS TOGETHER? Then Intermedia is the place for you.

Intermedia has established itself as a leading provider of cloud communications and collaboration tech that allows companies to connect better. We have a strong track record of growth, profitability, and creating an environment where everyone matters. Everyone. While we are fast‑paced and optimistic at Intermedia, we invite passionate, creative, and talented people to join us — here you can indulge your passion for creating and supporting great cloud technology. What's more, we always look to promote from within and have many employees who have been with us 10, 15, and 20+ years!

Culture at Intermedia is built on teamwork and transparency. We hold each other accountable and always have each other's back!

Are you ready to make your mark?

Key Responsibilities

You know that feeling when you finally find the one row that broke everything? Or when a pipeline you built runs perfectly for weeks without a single alert? We live for that.

We take messy data from source systems, move it into Snowflake, shape it into something people can actually use, and make sure it stays that way. SQL is your main weapon. The stack is Snowflake, dbt, MSSQL, S3 — and if you haven’t used all of it, that is totally fine. What we really care about: you pick things up fast, you finish what you start, and when something goes wrong, you are the kind of person who figures out why.

Our stack

Snowflake · dbt · MSSQL (SQL Server) · S3 · MuleSoft · Git

A typical week

• Build and fix pipelines — ingestion, transformation, consumption, all of it


• Write dbt models that actually have tests and docs (yes, we check)


• Chase down a data issue from the report all the way back to the source


• Jump on an incident — MSSQL job died, Snowflake task hung, S3 file vanished — and fix it


• Run a backfill, validate the results, confirm the fix actually worked


• Help move data from MSSQL into Snowflake without losing anything along the way


• Keep an eye on monitoring so users don’t find problems before you do


• Leave things documented well enough that future-you will say thank you

Skills, Knowledge & Expertise

• You own your work — no hand-holding, no reminders, you close the loop


• A degree in Computer Science, Data Analytics, Statistics, Mathematics, Economics, or something similar


• 3–5 years doing data engineering, data analysis, or something close


• SQL that actually impresses people — joins, window functions, CTEs, and you know why that query is slow


• You can read someone else’s stored procedure and figure out what went wrong


• You have shipped something with a real database in production: MSSQL, Oracle, PostgreSQL, or similar


• Layers make sense to you: raw → staging → consumption, and you know why shortcuts hurt


• Incremental loads are not scary: watermarks, MERGE vs INSERT, you know the trade‑offs
  
• Git is just how you work: branches, PRs, code review — no big deal


• You keep your tickets updated without being asked


• Snowflake: stages, file formats, Snowpipe, performance tricks


• dbt: models, tests, incremental — or you are genuinely excited to learn it


• MSSQL / SQL Server: stored procedures, SSIS, optimization


• S3 / flat files: CSV, JSON, Parquet


• Oracle as a source


• Python for scripts and automation


• CI/CD: GitHub Actions, dbt Cloud, or whatever gets the job done

AI tools

• You already use Copilot, Claude, ChatGPT — to code faster, debug smarter, write better docs


• We use them too. Every day. Not as a gimmick.

What you get

• Real problems, modern stack, no pointless busywork


• Full ownership from day one — you own what you ship — and you build it so anyone on the team can pick it up tomorrow


• A genuinely friendly team spread across different countries, continents, and time zones


• Room to grow in any direction you want to take it


• A place where AI tools are part of the culture, not a talking point

Diversity, Inclusion, and Equal Opportunity

We hire, promote, and compensate employees based on their ability to perform their job responsibilities, without regard to race, color, creed, religion, sex, gender, marital status, national origin, ancestry, age, citizenship, physical or mental disability, sexual orientation, or any other basis protected by applicable law (collectively referred to in our Code of Conduct as \"Protected Classes\"). We do not tolerate employment discrimination in the workplace, and we are committed to making reasonable accommodations for identified disabilities or other limitations as required by all applicable laws. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.