What are the responsibilities and job description for the Cloud Data Engineer position at ITnova?
Job Description
Job Description
ITnova is looking for a Cloud Data Engineer with a minimum of 12 years of experience in architecting, designing, and developing enterprise-scale data warehouse systems using SQL Server on cloud and on-premise platforms. The ideal candidate will have expertise in Azure data platforms, including Azure SQL, Data Factory, Synapse, Data Lake, and Pipelines, along with strong knowledge of data pipelines, API ingestion, and DevOps processes. Experience with Azure Cosmos DB, cloud infrastructure (Azure / AWS), and data warehouse modeling principles is required.
Experience / Qualifications
- 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.
- Thorough understanding of Azure and AWS Cloud Infrastructure offerings.
- Strong experience in common data warehouse modeling principles, including Kimball and Inmon.
- Knowledge of Azure Databricks, Azure IoT, Azure HDInsight Spark, Azure Stream Analytics, and Power BI is desirable.
- Knowledge of Microsoft BI Stack (SSRS / SSAS (Tabular with DAX & OLAP with MDX) SSIS) is desirable.
- Knowledge of C# and hands-on experience with PowerShell scripting is desirable.
- Working knowledge of Python is desirable.
- Experience developing security models.
Education
Work Location
