Middle Data Engineer with Snowflake

N-iX; Union (NJ); Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

Flexible working format

Education reimbursement

Mentorship program

Tech talks and trainings

Company events and knowledge sharing

Job summary

N-iX is seeking a Middle Data Engineer to build and scale a global Media Data Foundation for a leading European-based organization. You will own hands-on data engineering tasks, work with cross-functional teams, and turn raw media data into trusted, harmonised data products used by marketing, analytics and media teams worldwide.

The role emphasizes data pipelines, dbt migrations, data modeling in Snowflake, and integration with BI tools such as Power BI, while adhering to security, governance

Qualifications

• 2+ years of experience in data engineering.
• Hands-on with dbt and Python.
• Strong Snowflake data modeling expertise.
• Experience with marketing/advertising data sources and APIs.
• Knowledge of RBAC, secure views, data sharing and data governance.

Responsibilities

• Build, maintain and optimize data pipelines for ingestion, transformation and delivery of media data.
• Design and implement scalable data models for cross-platform reporting.
• Lead the move of transformation logic to dbt and orchestrate CI/CD workflows.
• Collaborate with architects and product owners to translate designs into implementations.
• Ensure data freshness, quality, monitoring and security across pipelines.

Skills

dbt

Python

SQL

Data modeling

Education

Bachelor's or Master's in Data Science/CS/Economics or related

Tools

Snowflake

Adverity

Fivetran

Power BI

Azure

Job description

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 with dbt and strong Python programming skills.
• 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