Job Description

• Leading the design and delivery of innovative data solutions using latest services from Azure eco-system.
• Exploiting industry best practices and your experience to create a data platform to enable business growth.
• Liaise with internal and external stakeholders in order to collect and document technical requirements.
• Contribute ideas to help ensure that required standards and processes are in place and actively look for opportunities to enhance and innovate solutions and improve process efficiency.

Qualifications

A minimum of 5 years’ professional experience is required.

• 3-5 years working with core Microsoft Azure Data Services (Data Factory, Databricks, Azure SQL)
• Azure Data Certification
• Experience with Data Warehouse design and Kimball methodology
• ETL experience using SSIS and Azure Data Factory
• Experience working with SQL Server, SQL Data Warehouse and Azure Data Lake
• Strong knowledge of data modelling and data warehousing concepts
• SQL server schema design and optimization to meet performance requirements
• Python programming for Data engineering and clean up.
• Experience of working with Power BI OR (tableau, Qlik) and DAX programming.
• Strong knowledge of Apache Spark, Power Query and SQL.
• Good understanding and experience of working with data security options on Azure.
• Proven ability to translate complex business requirements into design of end-to-end data systems including scalability, HA and DR

Technologies

• Technologies: SQL Server, data integration, ETL Design, Azure Data Lake, Azure Databricks, Azure Data Factory, Azure SQL Server and Azure Synapse
• Core Programming languages: T-SQL, Power Shell, Azure API, DAX

Desired Qualifications and Other Experience

• A minimum of a third level degree in Maths, Physics, Engineering, Computer Sciences or a related discipline
• Commercial experience in Data Warehousing and business intelligence projects.
• Experience in handling large and complex datasets using multiple programming languages (T-SQL, Python, R etc.) is essential
• Experience analysing multiple business domains and translating them to dimensional designs for analytics and reporting
• Basic knowledge of or exposure to machine learning, data visualisation, and artificial intelligence techniques. Experience working with Data Scientists and Machine Learning teams.
• Data governance experience desirable.