Data Engineer

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 ori