Delan Associates Inc
Cloud Data Engineer
Delan Associates Inc - New York, New York, us, 10261
Work at Delan Associates Inc
Overview
- View job
Overview
Cloud Data Engineer:
a. Minimum 12 years of relevant experience in architecting, design, and development of data warehouse systems (SQL Server based on Cloud/on premise and Analytics) at enterprise scale.
b. Experience in building end to end data warehouse and analytical systems using SQL Server family of products, Analysis Services Power BI, etc.
Experience in Data platforms development using Azure SQL database, Azure Data Factory, Azure Storage, Azure Pipelines, Azure IaaS/PaaS related to database.
d. Expert level understanding on Azure Data Factory, Azure Synapse, Azure SQL, Azure Data Lake, and Azure App Service is required.
e. Designing and building of data pipelines using API ingestion and Streaming ingestion methods.
f. Knowledge of Dev-Ops processes (including CI/CD) and Infrastructure as code is essential.
g. Experience in developing NO SQL solutions using Azure Cosmos DB is essential.
h. Thorough understanding of Azure and AWS Cloud Infrastructure offerings.
i. Strong experience in common data warehouse modelling principles including Kimball, Inmon.
j. Knowledge in Azure Databricks, Azure IoT, Azure HDInsight + Spark, Azure Stream Analytics, Power BI is desirable.
k. Knowledge of Microsoft BI Stack (SSRS/SSAS (Tabular with DAX & OLAP with MDX) SSIS) is desirable.
l. Knowledge of C# and Hands-on with PowerShell scripting is desirable.
m. Working knowledge of Python is desirable.
n. Experience developing security models.
o. Bachelor's degree in computer science/engineering or related fields.
a. Minimum 12 years of relevant experience in architecting, design, and development of data warehouse systems (SQL Server based on Cloud/on premise and Analytics) at enterprise scale.
b. Experience in building end to end data warehouse and analytical systems using SQL Server family of products, Analysis Services Power BI, etc.
Experience in Data platforms development using Azure SQL database, Azure Data Factory, Azure Storage, Azure Pipelines, Azure IaaS/PaaS related to database.
d. Expert level understanding on Azure Data Factory, Azure Synapse, Azure SQL, Azure Data Lake, and Azure App Service is required.
e. Designing and building of data pipelines using API ingestion and Streaming ingestion methods.
f. Knowledge of Dev-Ops processes (including CI/CD) and Infrastructure as code is essential.
g. Experience in developing NO SQL solutions using Azure Cosmos DB is essential.
h. Thorough understanding of Azure and AWS Cloud Infrastructure offerings.
i. Strong experience in common data warehouse modelling principles including Kimball, Inmon.
j. Knowledge in Azure Databricks, Azure IoT, Azure HDInsight + Spark, Azure Stream Analytics, Power BI is desirable.
k. Knowledge of Microsoft BI Stack (SSRS/SSAS (Tabular with DAX & OLAP with MDX) SSIS) is desirable.
l. Knowledge of C# and Hands-on with PowerShell scripting is desirable.
m. Working knowledge of Python is desirable.
n. Experience developing security models.
o. Bachelor's degree in computer science/engineering or related fields.