Description
Cloud/Data Engineer
Whitehall Resources are currently looking for a Cloud/Data Engineer.
You will be required to use an FCSA Accredited Umbrella Company for this role.
This role also requires someone to be SC eligible, and must not have been out of the UK for more than 6 months in the last 5 years.
Key Requirements:
- Strong T-SQL language skills including:
* DDL (eg CREATE, DROP, ALTER).
* DML (eg SELECT, INSERT INTO, UPDATE, DELETE).
* Joins (eg INNER JOIN, LEFT JOIN, CROSS APPLY)
* Built-in functions (eg CAST, DATEDIFF, CONCAT).
* Conditional logic (eg CASE, COALESCE).
* Aggregate functions (eg COUNT, MAX).
* Window functions (eg 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 eg parquet, json.
- Knowledge of Azure storage options eg 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.
Nice to have:
- Experience with Azure Synapse Analytics/Azure Data Lake Gen 20.
- Experience with ETL tools eg SSIS, Azure Data Factory (ADF).
- Experience with Power BI, including DAX.
- Python.
- Automation skills including Powershell.
- Certification AZ-900: Azure Fundamentals.
- Certification DP-900: Azure Data Fundamentals.
All of our opportunities require that applicants are eligible to work in the specified country/location, unless otherwise stated in the job description.