Job Description
Data Engineer (Middle)
Department: IT Business Systems & Security
Employment Type: Full Time
Location: Portugal
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.
