Details
Description: Job Title: Data Engineer (SQL)
Clearance required: SC / SC eligible - urgent role so candidates who are currently cleared will be preferred
Nationality Requirement: UK passport or 5 years permanent residence in the UK
Interview process: 121
Location: Croydon but mainly remote
Sector: Public
IR35 Status: PAYE only
Job Description:
* * Strong T-SQL language skills including:
o DDL (e.g. CREATE, DROP, ALTER)
o DML (e.g. SELECT, INSERT INTO, UPDATE, DELETE)
o Joins (e.g. INNER JOIN, LEFT JOIN, CROSS APPLY,…)
o Built-in functions (e.g. CAST, DATEDIFF, CONCAT,…)
o Conditional logic (e.g. CASE, COALESCE,…)
o Aggregate functions (e.g. COUNT, MAX,…)
o Window functions (e.g. OVER PARTITION BY)
* Knowledge of creating T-SQL stored procedures, views, functions and indexes
* Hands-on experience with Microsoft database platforms including SQL Server, Azure SQL DB and Azure Synapse Analytics
* Knowledge of ETL pipelines and different methods of transforming data
* Knowledge of modern data formats e.g. parquet, json
* Knowledge of Azure storage options e.g. Data Lake
* Experience with the following tools: SQL Server Management Studio (SSMS), Visual Studio, Visual Studio Code, Azure Storage Explorer, git, Azure DevOps, Synapse Studio, Azure Data Studio
* Able to convert written business rules into SQL code
* Security-cleared / clearable (meaning UK passport or 5 years permanent residence in the UK)
Nice to have:
o Experience with Azure Synapse Analytics / Azure Data Lake Gen 2
o Experience with ETL tools e.g. SSIS, Azure Data Factory (ADF)
o Experience with Power BI, including DAX
o Python
o Automation skills including Powershell
o Certification AZ-900: Azure Fundamentals
o Certification DP-900: Azure Data Fundamentals
