Create, maintain and optimize the future-ready data pipeline architecture and implement it on Azure;
Solid experience in designing and implementing large scale data processing, data storage, data transformations in Azure
Experience in designing and delivering solutions using the analytics services part of Microsoft Azure among which Azure Data Lake, Azure Synapse, Azure Data Factory, Azure Stream Analytics, Azure Event Hub, Azure Purview
Identify, elicit and document project requirements in the business and translate these into technical specifications for Power BI applications and reports.
Participate in the design, development, testing and implementation of ETL/ELT solutions, using Azure Data-Factory, Azure Synapse, Azure Data Lake and Azure SQL services.
Orchestrate data using Azure Data Factory by creating Azure Data Pipelines and Data Flows.
Develop and maintain Azure Data Lake folders using best practice architecture.
Create an Azure data lake house to facilitate enterprise Power BI reporting architecture.
Design, develop, test and implement Azure Data Factory enterprise integration, migration and dataflow solutions.
Develop and maintain SQL tables, indexes, stored procedures, views, and triggers created for Power BI reporting, using T-SQL. Plan and/or develop data ETL and ELT procedures using Azure Synapse to orchestrate data and deliver tables required for Power BI Reporting.
Work closely with other developers, Project Managers, and business stakeholders to design Azure SQL database and Azure Data Lake storage solutions that effectively meet security guidelines.