Designing and implementing robust ETL/ELT solutions in the Microsoft/Azure stack.
Designing and implementing data lakes with a medallion design approach.
Scalable solutions to satisfy our clients current and future needs.
Migrating on-premises data solutions to the cloud. So, knowledge of the SQL Server stack (SQL, SSIS, SSAS and SSRS) is beneficial.
The continued support and development of a data solution following go live.
Requirements :
Ability to build relationships within a team and with our clients, creating an environment where people feel they belong and can fully contribute.
Extensive experience in a Data Engineering or Data Warehouse Development role involving hands-on experience with the Azure andor SQL Server technology stack.
Experience in designing and developing ETLELT processes using the Azure platform (Azure Synapse Analytics, Data Factory, Data Bricks) supported with SQL and Python.
Knowledge of implementing data lakes and medallion lake house design.
Experience of working with large data volumes of data from multiple sources.
Experience in writing complex Python SQL queries (DDL, DML) and Stored Procedures.
Exposure to Analysis Services Development Multi-DimensionalTabular (MDX, DAX).
Understanding of business intelligence and data warehousing concepts.
Strong database design and development skills in any relational database technology.
Good knowledge of optimisation techniques and design patterns for large data solutions.