• Maria Zakourdaev

Azure Data Platform Roles

Do you have a clear understanding the difference between Data Engineer and Data Administrator? How Azure AI Engineer is different from Data Scientist?

If there is any doubt, here are the main differences and responsibilities.

There are total 5 roles and 5 role-based certifications, offered by Microsoft, for the people who deal with cloud focused data.

  • Azure Database Administrator

  • Azure Data Engineer

  • Azure Data Analyst

  • Azure Data Scientist

  • Azure Artificial Intelligence Engineer

Azure Database Administrator

Role Description: As the title implies, its an administrator. He is responsible for building and management cloud based solutions aka databases as well as hybrid solutions ( involving Sql Server databases located in the different public or private cloud services as well as on-premises).

Tools and services used: Azure ARM Templates, Azure CLI, Powershell, Management Studio, Azure Sql Database, Azure Synapse Analytics. Azure database administrator also uses Transact SQL but only for administrative management purposes.

Azure Data Engineer

Role Description: Designing and implementation the management, monitoring, security and privacy aspects of data.

Tools and services used: Data Engineer is using a full stack of Azure data services to satisfy business needs. Azure Sql Database, Azure Data Factory, Azure Logic Apps, Azure Kusto service, Azure Databricks, Azure HDInsights, Azure Synapse Analytics.

Azure Data Analyst

Role Description: enables business to maximize value of their data assets and is also responsible for designing and building data models inside Power BI including data cleaning and transformations.

Tools and services used: Uses Power BI to build meaningful data visualizations

Azure Data Scientist

Role Description: Someone who can predict future using the data patterns from past. Applies their knowledge of data science and machine learning to implement and run machine learning workloads in Azure.

Tools and services used: Azure Machine Learning Service, Data Science Virtual machines, HDInsight Spark and Hive Clusters, Azure Synapse Analytics, Azure Data Lake, Azure Databricks.

Azure Artificial Intelligence Engineer

Role Description: Software engineer who designs and develops intelligent solutions that encapsulate artificial intelligence.

Tools and services used: Azure Cognitive Services, Azure Machine Learning, Azure Bot Service, Azure Cognitive Search and knowledge mining, natural language processing etc.