Data Engineer

Proactive Appointments

Posted on Jan 20, 2025 by Proactive Appointments
London, United Kingdom
IT
Immediate Start
£50k - £62k Annual
Full-Time

Data Engineer

Hybrid - 2/3 days onsite

Our client, a leader in the financial services sector, is seeking an experienced Data Engineer to join their dynamic team. This is an excellent opportunity to apply your technical expertise in data engineering to support innovative, data-driven solutions in a collaborative and fast-paced environment. The role requires you to work onsite in London 2-3 days per week, allowing you to closely engage with cross-functional teams while balancing some remote flexibility.

Key Responsibilities:
As a Data Engineer, you will:

  • Analysis & Design: Assist the Data Analyst with tasks such as mapping source data to the existing data model and design of database schemas and SSIS packages.
  • ETL Uplift & Data Integration: Using the technical standards provided, uplift and redevelop existing ETL processes to ingest source data from different systems while ensuring seamless integration of data from these systems into the unified data warehouse.
  • T-SQL Programming: Write complex T-SQL scripts for data retrieval, manipulation, and analysis. Optimize existing queries and stored procedures to enhance performance and ensure efficient data processing.
  • Performance Optimisation: Ensure the stability, flexibility, and scalability of the data warehouse. Identify and resolve potential issues, ensuring the system can handle increasing data volumes and user demands.
  • Testing & Validation: Conduct preliminary testing to validate the accuracy and performance of ETL processes and the data warehouse. Assist in identifying and resolving any data quality, transformation or integration issues.
  • Documentation: Maintain comprehensive documentation of ETL processes, data mappings, and other technical aspects of the data warehousing initiative. Help develop and document functional, technical requirements and evidence of testing.
  • Collaboration & Communication: Work closely with the development team, data analysts, subject matter experts and business stakeholders to ensure the successful execution of the data warehousing initiative.

Key Requirements:

  • Extensive experience with SQL Server Integration Services (SSIS) and development within Microsoft SQL Server.
  • Advanced proficiency with T-SQL for stored procedure programming.
  • Proficiency in Scripting languages (such as C#, PowerShell, or Python) for enhancing SSIS functionality.
  • Solid understanding of data warehousing concepts, architectures, and best practices.
  • Strong knowledge of database architecture, indexing, and query optimization techniques.
  • Demonstrable analytical and problem-solving skills with a keen eye for data quality and accuracy.
  • Excellent communication and collaboration skills, with the ability to interact effectively with diverse teams and stakeholders.

What's on Offer:

  • 25 days holiday, rising with service to a maximum of 30
  • Private medical healthcare
  • Life, Dental and Travel insurance
  • Pension - 2% employee/6% employer
  • Opportunity to work within a leading financial services organization.
  • Hybrid working model, with 2-3 days per week onsite in London.
  • Collaborative and growth-oriented team environment, with opportunities for career progression

Data Engineer

Due to the volume of applications received for positions, it will not be possible to respond to all applications and only applicants who are considered suitable for interview will be contacted.

Proactive Appointments Limited operates as an employment agency and employment business and is an equal opportunities organisation

We take our obligations to protect your personal data very seriously. Any information provided to us will be processed as detailed in our Privacy Notice, a copy of which can be found on our website


Reference: 2884145645

https://jobs.careeraddict.com/post/98960137

This Job Vacancy has Expired!

Proactive Appointments

Data Engineer

Proactive Appointments

Posted on Jan 20, 2025 by Proactive Appointments

London, United Kingdom
IT
Immediate Start
£50k - £62k Annual
Full-Time

Data Engineer

Hybrid - 2/3 days onsite

Our client, a leader in the financial services sector, is seeking an experienced Data Engineer to join their dynamic team. This is an excellent opportunity to apply your technical expertise in data engineering to support innovative, data-driven solutions in a collaborative and fast-paced environment. The role requires you to work onsite in London 2-3 days per week, allowing you to closely engage with cross-functional teams while balancing some remote flexibility.

Key Responsibilities:
As a Data Engineer, you will:

  • Analysis & Design: Assist the Data Analyst with tasks such as mapping source data to the existing data model and design of database schemas and SSIS packages.
  • ETL Uplift & Data Integration: Using the technical standards provided, uplift and redevelop existing ETL processes to ingest source data from different systems while ensuring seamless integration of data from these systems into the unified data warehouse.
  • T-SQL Programming: Write complex T-SQL scripts for data retrieval, manipulation, and analysis. Optimize existing queries and stored procedures to enhance performance and ensure efficient data processing.
  • Performance Optimisation: Ensure the stability, flexibility, and scalability of the data warehouse. Identify and resolve potential issues, ensuring the system can handle increasing data volumes and user demands.
  • Testing & Validation: Conduct preliminary testing to validate the accuracy and performance of ETL processes and the data warehouse. Assist in identifying and resolving any data quality, transformation or integration issues.
  • Documentation: Maintain comprehensive documentation of ETL processes, data mappings, and other technical aspects of the data warehousing initiative. Help develop and document functional, technical requirements and evidence of testing.
  • Collaboration & Communication: Work closely with the development team, data analysts, subject matter experts and business stakeholders to ensure the successful execution of the data warehousing initiative.

Key Requirements:

  • Extensive experience with SQL Server Integration Services (SSIS) and development within Microsoft SQL Server.
  • Advanced proficiency with T-SQL for stored procedure programming.
  • Proficiency in Scripting languages (such as C#, PowerShell, or Python) for enhancing SSIS functionality.
  • Solid understanding of data warehousing concepts, architectures, and best practices.
  • Strong knowledge of database architecture, indexing, and query optimization techniques.
  • Demonstrable analytical and problem-solving skills with a keen eye for data quality and accuracy.
  • Excellent communication and collaboration skills, with the ability to interact effectively with diverse teams and stakeholders.

What's on Offer:

  • 25 days holiday, rising with service to a maximum of 30
  • Private medical healthcare
  • Life, Dental and Travel insurance
  • Pension - 2% employee/6% employer
  • Opportunity to work within a leading financial services organization.
  • Hybrid working model, with 2-3 days per week onsite in London.
  • Collaborative and growth-oriented team environment, with opportunities for career progression

Data Engineer

Due to the volume of applications received for positions, it will not be possible to respond to all applications and only applicants who are considered suitable for interview will be contacted.

Proactive Appointments Limited operates as an employment agency and employment business and is an equal opportunities organisation

We take our obligations to protect your personal data very seriously. Any information provided to us will be processed as detailed in our Privacy Notice, a copy of which can be found on our website

Reference: 2884145645

CareerAddict

Alert me to jobs like this:

Amplify your job search:

CV/résumé help

Increase interview chances with our downloads and specialist services.

CV Help

Expert career advice

Increase interview chances with our downloads and specialist services.

Visit Blog

Job compatibility

Increase interview chances with our downloads and specialist services.

Start Test

Similar Jobs

Data Engineer - Contract

London, United Kingdom

Data Engineer

Monument, City and County of the City of London, United Kingdom

Data Engineer

City of London, City and County of the City of London, United Kingdom

Data Engineer

London, United Kingdom