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