Job Description :
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


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


Similar Jobs you may be interested in ..