As a Middle Data Engineer, migrate SQL Server data warehouses to Snowflake, refactor ETL processes, build data pipelines, and ensure reliable data movement.
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
*not applicable for freelancers
Top Skills
Aws S3
Dbt
ETL
MySQL
Oracle
Postgres
Python
Snowflake
SQL
Ssis
Similar Jobs
.png){kind=avatar}
Fintech • Machine Learning • Software • Financial Services
Join the HackaTUM challenge for a chance to win prizes. Team registration required; no CV needed. Insights sessions at specified times.
Financial Services
As a Lead Software Engineer, you'll design and develop software solutions, lead technical evaluations, and enhance operational stability in an agile environment, focusing on financial services.
Top Skills:
.NetAngularArtificial IntelligenceC#CloudHazelcastKafkaMachine LearningMobileMulti-Threaded ApplicationsRabbitMQReactRedisTypescript
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
The AI Backend Python Engineer will design and develop backend systems for generative AI applications, overseeing API delivery and AWS infrastructure while mentoring junior engineers.
Top Skills:
AWSCloudFormationDockerFastapiKubernetesLangchainLangfuseLitellmPythonTerraform
What you need to know about the London Tech Scene
London isn't just a hub for established businesses; it's also a nursery for innovation. Boasting one of the most recognized fintech ecosystems in Europe, attracting billions in investments each year, London's success has made it a go-to destination for startups looking to make their mark. Top U.K. companies like Hoptin, Moneybox and Marshmallow have already made the city their base — yet fintech is just the beginning. From healthtech to renewable energy to cybersecurity and beyond, the city's startups are breaking new ground across a range of industries.
