Job Details:
Contract: 4 months - urgent start
Location: Croydon, London but mainly remote ( You can be required to travel to the office occasionally )
Sector: Public
Rate: 400 - 450 GBP daily
IR35 Status: PAYE only
Candidate must have active SC Clearance
Job Spec:
- * Strong T-SQL language skills required:
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