Delivering full life cycle solutions to our clients, from data acquisition, engineering, modelling, analysis, and visualisation.
Running workshops with clients gathering information and communicating with clients on both a business and technical level.
Migrating on-premises data solutions to the cloud. So, knowledge of the SQL Server stack (SQL, SSIS, SSAS and SSRS) is expected.
Reports, Dashboards and Analysis using tools such as Power BI to help our clients visualise their data and present it to the wider business.
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.
Experience in requirements gathering from various levels of stakeholders across a business.
Extensive experience in a BI, 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.
Exposure in implementing data lakes and medallion lake house design.
Experience of working with large data volumes in a BI or Data Warehouse project.
Experience in writing complex Python SQL queries (DDL, DML) and Stored Procedures.
Exposure to Analysis Services Development Multi-DimensionalTabular (MDX, DAX).
Expertise in the delivery of complex Dashboards, Reports & Analytical Models using a variety of different tools.
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.