Informacje o stanowisku

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:

• 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.

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, SQL, Snowflake, ETL, Python, s3, dbt, SQL Server, Oracle, PostgreSQL, MySQL, Looker Additionally: Flexible working hours and remote work possibility, English classes, Active tech community, Training budget, International team, Mentoring program, Compensation of certifications, Free coffee, Kitchen, modern office building.

Praca Warszawa

Warszawa - Oferty pracy w okolicznych lokalizacjach