Azure BI Data Engineer

As a BI Developer/Engineer, you will transition business data platforms to Microsoft Fabric and create BI solutions for informed decision-making. This role is part of the Business Intelligence function, focusing on developing and governing our business systems. You will work on Azure/Fabric projects, including data platforms, pipelines, models, reports, and dashboards.

Key Responsibilities

• Implement the data migration strategy using Microsoft Fabric for stakeholder consumption and reporting
• Model data from multiple sources into output which provides actionable insight
• Manage and maintain the Data warehouse platform and investigate bugs and issues and ensure system works as expected
• Design and implement data pipelines across multiple source and destination systems using SSIS, Azure Data Factory and Fabric Pipelines
• Develop Power BI dashboards and customised paginated reports based on business requirements, to a standard suitable for external audiences
• Collaborate with IT resources to understand requirements from the business, present visualised recommendations and translate them into technical solutions
• Write optimised SQL queries against SQL Server and Azure Synapse Databases
• Align with development methodologies to implement and support robust, reliable deployment processes using CI/CD Pipelines in Azure DevOps

Personal Profile, Experience & Skills

• Extensive experience of Data Visualisation and Reporting using Power BI and paginated reports
• Extensive experience with SQL databases and data architecture
• Experience in multidimensional data modelling; star schemas, snowflakes, de-normalised models, handling - slow-changing- dimensions/attributes
• Experience using Visual Studio
• Experience in setting up complex ETL processes within SSIS and Azure Data Factory, involving relational and non-relational data
• Experience with cloud computing and Big Data stacks. Including Azure Synapse and Azure Data Factory, Data lakes etc
• Exposure to DevOps and Deployments using Arm/Bicep templates
• Experienced complete lifecycle of at least one data warehouse/Business Intelligence program at enterprise scale
• Research driven and committed to continuous improvement of solutions.
• Excellent problem solving and data analysis skills
• Ability to quickly grasp existing systems, goals and tech
• Review and propose appropriate solutions to both legacy and evolving architectures/technologies
• Should possess good communication capabilities, be a team player and self-motivated, results driven, adaptable, inspirational, organised and quality focused
• Understanding of best standards, security, guidelines etc. and cares about adhering to them.
• Exposure to Microsoft D365 Finance and Operations/Sales nice to have

Robert Walters Operations Limited is an employment business and employment agency and welcomes applications from all candidates