Back to Job Search

T-SQL Data Engineer

  • Location: Preston
  • £ Salary: Up to £51000 per annum per year
  • Job Type:Permanent

Posted 3 months ago

  • Sector: Technology
  • Contact: Mark Stiles
  • Start Date: ASAP
  • Expiry Date: 24 December 2023
  • Job Ref: JN -112023-482711

Job title: T-SQL Data Engineer

Location: Preston or Frimley - Hybrid 2/3 day weekly split.

Salary: Up to £51K + benefits




What you'll be doing:

· Develop, implement and optimise complex T-SQL scripts independently to support data ingestion processes and reporting

· Monitoring and do proactive validations and verifications of ETL development and monitoring of data loads into the data warehouse

· Maintaining existing ETL solutions and identifying improvements

· Analyse existing SQL queries for performance improvements

· Conducting peer code reviews and UAT validation and create well defined test cases

· Adhering to company source control, validation and promotion policy

· Working within change control environment

· Writing and Review technical documentation

Your skills and experiences:




Essential:

· Previous experience in a similar role Excellent in T-SQL programming and experience using SQL Server Management Studio and Microsoft BI stack (SSIS/SSRS)

· Excellent understanding of relational databases and normalisation

· Solid experience of working with Visual Studio to develop, debug and publish SSIS packages and reports and to proactive provide training to juniors and peers

Desirable:

· Knowledge of PowerShell scripting

· Appreciation of data warehousing architecture techniques, best practised and able to deploy packages for production to be at industrial strength

...