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 clients 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
*not applicable for freelancers
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 analyti...
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 clients 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
*not applicable for freelancers
View more
View less