Back to search
Data Engineer (SQL Server)
Hybrid Working - Edinburgh OR London- 1 day a week on site.
Financial Services
Lorien's leading banking client is looking for a Data Engineer to join the existing team on a brand-new migration project.
This role is looking for someone with expertise in SQL Server, Teradata, and Snowflake.
You will be optimizing database performance and work on creating scalable data pipelines for large datasets.
You will be handling data migration and integration tasks from the legacy systems into Snowflake, where knowledge of cloud platforms (AWS, Azure, GCP) and data warehousing best practices.
This role is based in Edinburgh OR London.
This role will be Via Umbrella.
Working in a Hybrid Model of 1 day a week on site.
Key Skills and Experience
- Proven experience working with SQL Server (e.g., T-SQL, Stored Procedures, Indexing, Query Optimization, System Catalog Views).
- Strong experience in Snowflake architecture, including data loading, transformation, and performance tuning.
- Proficient in ETL processes using tools such as Informatica PowerCenter and BDM, AutoSys, Airflow, and SQL Server Agent.
- Experience with cloud platforms preferably AWS.
- Strong knowledge of AWS cloud services, including EMR, RDS Postgres, Athena, S3 and IAM.
- Solid understanding of data warehousing principles and best practices.
- Strong proficiency in SQL for data manipulation, reporting, and optimization.
- Knowledge of data modelling and schema design.
- Experience working with large, complex datasets and implementing scalable data pipelines.
- Familiarity with version control tools such as GitLab.
- Experience with data integration, data governance, and security best practices.
IND_PC3
Carbon60, Lorien & SRG - The Impellam Group STEM Portfolio are acting as an Employment Business in relation to this vacancy.
