Middle Data Engineer with Snowflake

N-iX; Portugal; Híbrido; EUR 55.000 - 85.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flexible working format

Competitive salary and compensation

Professional development tools

Descripción de la vacante

N-iX is seeking a Middle Data Engineer to shape and implement a global Media Data Foundation. You will build scalable data pipelines, harmonise data models in Snowflake, and move transformation logic to dbt in CI/CD pipelines.

You will collaborate with architects, product owners, media agencies and market teams to deliver reliable data solutions for dashboards and ROI analytics, across multiple markets.

Formación

• 2+ years of data engineering experience.
• Proficiency in Python and SQL.
• Snowflake data modeling expertise.
• Experience with marketing/advertising data sources.
• Knowledge of security and governance in Snowflake.
• Cloud experience (Azure or GCP), Azure preferred.
• ETL/ELT and orchestration tools.
• BI tools and Power BI preferred.
• Bachelor's/Master's in a relevant field.

Responsabilidades

• Develop and maintain data pipelines for ingestion, transformation and delivery.
• Design harmonised data models for cross-platform reporting in Snowflake.
• Migrate transformation logic to dbt with CI/CD.
• Collaborate with architects, product owners, and agencies.
• Ensure data quality, freshness, and monitoring.
• Support dashboards and marketing analytics (Power BI).

Conocimientos

Python

dbt

Snowflake

SQL

REST API

Power BI

ETL/ELT

Data Modeling

Data Warehousing

Azure

Educación

Bachelor's or Master's in CS/DS/EC

Herramientas

dbt

Power BI

Fivetran

Adverity

Snowflake

Descripción del empleo

Join an exciting journey to build and scale a global Media Data Foundation for a leading global organization based in Europe. This platform brings together paid media, digital analytics and marketing performance data from dozens of advertising and measurement platforms. It unlocks reliable media reporting, marketing ROI measurement and data-driven investment decisions across markets.

As a Middle Data Engineer, you will play a pivotal role in shaping and implementing the platform's architecture. The focus is on hands-on technical execution and collaboration with cross-functional teams.

Your work will turn raw media and marketing data into trusted, harmonised data products used by marketing, media and analytics teams around the world. You will use modern tools to solve complex challenges, working alongside skilled architects, engineers and business stakeholders.

Key Responsibilities

• Hands-On Development: Build, maintain and optimize data pipelines for ingestion, transformation and delivery of media data (Meta, Google Ads, DV360, TikTok, The Trade Desk, GA4, CM360 and others).


• Create and implement scalable solutions to handle many data sources, frequent API and schema changes, and high volumes of data.


• Data Modeling & Warehousing: Design and maintain efficient, harmonised data models for cross-platform media reporting in Snowflake.


• Lead the move of transformation logic to dbt, including orchestration, testing, documentation and CI/CD.


• Collaboration: Partner with Solution Architects to translate high-level designs into detailed implementation plans.


• Work closely with Technical Product Owners, media agencies and market teams to align data solutions with business needs.


• Platform Development: Enable data readiness for media dashboards (Power BI), marketing mix modelling / ROI analytics and campaign taxonomy governance.


• Implement robust frameworks to monitor data freshness, completeness, quality and pipeline performance, with automated alerting.


• Security & Compliance: Implement robust access controls and data protection across the pipeline and for data shared with internal and external consumers.


• Ensure compliance with data privacy regulations (e.g. GDPR, CCPA) and internal data governance policies (data product tiers, tagging, naming standards).


• Monitor and address potential vulnerabilities, including service account and secret management, ensuring the platform follows security best practices.

Requirements

• 2+ years of experience showing technical expertise and critical thinking in data engineering.


• Hands-on experience and strong Python programming skills; dbt (nice to have).


• Proficiency in Snowflake and strong expertise in data modeling are essential.


• Demonstrated experience with marketing, media or advertising data (ad platform APIs, campaign hierarchies, web analytics) is required.


• In-depth understanding of security and governance in Snowflake: RBAC, secure views, data sharing, masking and row access policies, object tagging.


• Ability to design, implement and promote solution patterns and standards for complex, multi-source data platforms.


• Familiarity with multiple cloud platforms (Azure or GCP preferred, with a focus on Azure, including ADF).


• Experience with ETL/ELT and data integration tools (Adverity, Fivetran or similar) and batch orchestration.


• Competence in SQL, relational database design and efficient methods for data retrieval and preparation at scale.


• Proven ability to collect and process raw data at scale, including scripting, REST API integration and SQL querying.


• Experience with BI tools (Power BI preferred) and supporting reporting consumers.


• Experience working in global environments and collaborating with virtual teams and external agencies.


• A Bachelor's or Master's degree in Data Science, Computer Science, Economics or a related discipline.

We offer*

• Flexible working format - remote, office-based or flexible


• A competitive salary and good compensation package


• Personalized career growth


• Professional development tools (mentorship program, tech talks and trainings, centers of excellence, and more)


• Active tech communities with regular knowledge sharing


• Education reimbursement


• Memorable anniversary presents


• Corporate events and team buildings


• Other location-specific benefits


• not applicable for freelancers