Best Option

Find the right accountancy solution for your requirements

  • Location: Winchester, Hampshire
  • Rate: Up to 0.00
  • Start Date: 02/09/2019
  • Duration: 3 months initially

Azure Data Lake Consultant required with hands-on experience of the Azure Data Lake environment and an in-depth knowledge of its implementation. The successful candidate will help develop and guide the Client's expanding analytics programme and provide detailed knowledge transfer to existing staff.

You will have a strong understanding of Azure Cloud environment and implementation of Azure Analytics. Have hands on experience (to a high level) of Azure Data Lake administration with in-depth knowledge of data lake Gen1 implementation (and with knowledge of Gen2). Development experience in Azure Data Factory v2; including knowledge of best practice principles including security. Significant understanding of enterprise Business Intelligence and Data Warehousing concepts and methods. Detailed knowledge of Azure Data Lake Analytics (including uSQL) and Azure Databricks. Experience in establishing robust processes and monitoring for data migration and analytics. Great Communication skills with the ability to present to both a technical and nontechnical audience at all levels of an organisation. Good writings skills with a history of producing high-quality technical documentation. Experience supporting the skills of a wider team; with a focus on quality.

It would be desirable is you had knowledge or experience of any of the following:

  • Microsoft SQL Server including SSRS, SSIS, SSAS

  • Analytics Models and Stored Procedures

  • Power BI, Power Pivot, Power Query

  • DAX, MDX

  • Wider ETL and SQL knowledge

  • C#, Python, R development experience

  • Other Database/Data Warehousing technologies

  • Experience in Azure HDInsight and reporting tools

  • Cosmos DB

  • Azure SQL Data Warehouse

Duties will include:

  • Create the process(es) to copy and configure required data sources into Data Lake

  • Assist in the creation of the service operating model and Datamodelling responsibilities

  • Provide expert knowledge on best practice in implementing, using and maintaining an Azure Data Lake environment in combination with Azure Data Factory

  • Help in the initial data migrations, and in forming of our standards, processes and strategy for future use of the Azure Data Lake

  • Train/advise staff in the skills needed to build, migrate and organise a data lake for structured and unstructured data on Azure, build data models & clean and create production ready cubes etc.

  • Document setup, processes and guidance to hand over to other users, analytics stakeholders and senior managers

This role is for initially for 3 months, in scope of IR35 and requires a Standard DBS check.