ITnova is looking for a Cloud Data Engineer to architect, design, and develop enterprise-scale data warehouse systems using SQL Server on cloud and on-premise platforms, with expertise in Azure data platforms.
Requirements
- 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.
- 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.
- Expert level understanding on Azure Data Factory, Azure Synapse, Azure SQL, Azure Data Lake, and Azure App Service is required.
- Designing and building of data pipelines using API ingestion and Streaming ingestion methods.
- Knowledge of Dev-Ops processes (including CI/CD) and Infrastructure as code is essential.
- Experience in developing NO SQL solutions using Azure Cosmos DB is essential.
Responsibilities
- architecting, designing, and developing enterprise-scale data warehouse systems using SQL Server on cloud and on-premise platforms
- building end to end data warehouse and analytical systems using SQL Server family of products, Analysis Services Power BI, etc.
- Data platforms development using Azure SQL database, Azure Data Factory, Azure Storage, Azure Pipelines, Azure IaaS/PaaS related to database.
- Designing and building of data pipelines using API ingestion and Streaming ingestion methods.
- developing NO SQL solutions using Azure Cosmos DB
- developing security models.
Other
- Bachelor’s degree in computer science/engineering or related fields.
- Hybrid work at 2 Montgomery Street Jersey City, NJ 07302