Middle Data Engineer (#4296)

#4296

Position Overview:  

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:

• Prior experience in large-scale data migration projects.

• 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

• 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