Middle Data Engineer (#4314)

N-iX; Deutschland; Remote; EUR 60.000 - 80.000; Vollzeit

Zusammenfassung

A leading IT consultancy in Germany is seeking a Middle Data Engineer to support the migration of legacy SQL Server data warehouses to a cloud-based Snowflake environment. The role involves building data pipelines, refactoring ETL processes, and optimizing cloud data performance. Candidates should have strong experience with cloud technologies, SQL skills, and proficiency in Python. A flexible working format is offered along with a competitive salary and professional development opportunities.

Leistungen

Flexible working format

Competitive salary

Professional development tools

Active tech communities

Qualifikationen

• Experience with cloud data warehouse technologies.
• Solid SQL skills; experience with migrations to cloud.
• Proficiency in Python for pipelines and automation.

Aufgaben

• Build and modify data pipelines to migrate data from SQL Server to cloud.
• Refactor legacy ETL jobs for cloud environments.
• Optimize performance and costs of cloud data processing.

Kenntnisse

Cloud data warehouse technologies

SQL

ETL frameworks and tools

Python

Documentation and communication skills

Tools

Snowflake

AWS S3

SSIS

dbt

Jobbeschreibung

As a Middle Data Engineer, you will support the migration of legacy on‑premises SQL Server data warehouse to a cloud‑based Snowflake environment. The project involves integrating various data sources, refactoring ETL processes, and ensuring efficient, reliable data movement for analytics and reporting.

Responsibilities

• Build and modify data pipelines to migrate data from SQL Server and other databases (Azure SQL, Oracle, Aurora) to AWS S3 and Snowflake.
• Refactor legacy ETL jobs (SSIS, Transact‑SQL) for use in cloud environments.
• Implement data transformations and staging using dbt and/or similar tools.
• Optimize the performance and costs of cloud data processing and storage.
• Work collaboratively with client’s and N-iX engineers, ensuring smooth handoff and documentation.
• Participate in QA, testing, deployment, and post‑migration validation.

Must‑Have Technologies

• Experience with cloud data warehouse technologies, including Snowflake and AWS S3.
• Solid SQL skills; experience migrating legacy environments to cloud platforms.
• Familiarity with ETL frameworks and tools (preferably SSIS, dbt).
• Proficiency in Python for data pipeline development and automation.
• Strong documentation and communication skills; able to work in cross‑functional teams.

Nice to Have

• Background working with varied database platforms (SQL Server, Oracle, PostgreSQL, MySQL).
• Knowledge of reporting platforms such as Looker is a plus.

We Offer

• Flexible working format – remote, office‑based or flexible.
• A competitive salary and good compensation package.
• Professional development tools (mentorship program, tech talks and trainings, centers of excellence, and more).
• Active tech communities with regular knowledge sharing.