SQL Data Engineer

Hybrid working

The successful candidate will have strong experience in SQL Server Integration Services (SSIS), data warehousing, andETL development, with a proven ability to integrate data from multiple source systems into a unified enterprise data warehouse. You will work closely with Data Analysts, developers, subject matter experts, and business stakeholders throughout the analysis, development, testing, and implementation lifecycle.

• Support analysis and design activities, including mapping source data to existing data models and contributing to the design of database schemas andSSIS packages.
• Redevelop and enhance ETL processes in line with technical standards to support data ingestion, transformation, and integration from multiple source systems.
• Develop and maintain complexT-SQL scripts, stored procedures, and database objects to support data processing and analysis.
• Optimise ETL processes, queries, and database performance to ensure scalability, stability, and efficient handling of growing data volumes.
• Conduct testing and validation activities to ensure data accuracy, performance, and successful integration across systems.
• Identify, troubleshoot, and resolve data quality, transformation, and integration issues.
• Maintain comprehensive technical documentation, including ETL processes, data mappings, requirements, and testing evidence.
• Collaborate effectively with technical and non-technical stakeholders to ensure successful delivery of data warehousing initiatives.

• Extensive hands-on experience withSQL Server Integration Services (SSIS) and MicrosoftSQL Server development.
• Strong expertise in T-SQL programming, including stored procedures, query optimisation, and performance tuning.
• Experience scripting within SSIS using technologies such asPowerShell, C#, or Python.
• Strong understanding of data warehousing concepts, architectures, methodologies, and best practices.
• Solid knowledge of database design, indexing strategies, and query optimisation techniques.
• Strong analytical and problem-solving skills with the ability to identify and resolve complex data issues.
• Excellent communication and stakeholder engagement skills.
• High attention to detail and commitment to data quality and accuracy.

• Experience modernising or uplifting existing data warehouse environments.
• Experience of DB2
• Experience withWhereScape RED.
• Knowledge of additional database technologies and cloud-based data platforms.
• Understanding of data modelling and data architecture principles.
• Familiarity with data governance frameworks and data quality best practices.

SQL 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