Middle Data Engineer @ N-iX

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.

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 :

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.

,[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.] Requirements : AWS, Snowflake, AWS S3, SQL, dbt, Python, ETL, Oracle, PostgreSQL, MySQL, Looker Additionally : Flexible working hours and remote work possibility, Mentoring program, Life insurance, Training budget, English lessons, Compensation of Certifications, Active tech community, International team, Referral program, Cafeteria, Modern office, Free coffee, Kitchen, Friendly atmosphere.