رقم الوظيفة : 1569074
100% Remote, Position Purpose The Data Warehouse Architect will assist with Data Warehouse Architecture, Data Warehouse Development and ETL Development for Envoy Solutions Data Warehouses in the Azure Cloud. This position reports to the Director of Data Architecture Adding new data sources to the Data Warehouse. Adding in new companies to the Integrated Data Warehouse as Envoy Solutions acquires new companies. Adding additional tables and columns to an existing Integrated (Enterprise) Data Warehouse. Adding, revising, troubleshooting ETLs. Working with Warehouse users (Reporting, Application, Data Analytics) to address their needs. Working with Data Analyst on Data Mapping, Analysis, View development, Reporting and Data Dictionary. Data Warehouse Security. Team Environment: Getting this information for me Skill Requirements: Desired Skills Creating and deploying Azure Analysis Services cubes using Visual Studio. Azure Blob Storage, Azure Key Vault, Azure Integration Runtime, Azure Webhooks, Azure Monitoring, and/or other Azure related skills. Using SQL to generate SQL code Using Visual Studio for Data Warehouse development, including using Visual Studio for deploying upgrades Using SQL Server extended attributes to maintain a Data Dictionary Data Warehouse monitoring and notifications/alerts when events and/or thresholds are reached JIRA GIT and/or DevOps Power BI and/or Excel reporting knowledge, Power Query SQL Server; ideally Azure SQL Server Azure Data Factory SQL Server Integrated Services (within Visual Studio) Data Warehouse Architecture using Kimball Warehouse design concepts Development and maintenance of Extract and Load (EL) and Extract, Transfer, and Load (ETL) processes Data Mapping Data Warehouse Security Good communication skills