Azure Data Warehouse Architect in Alpharetta, GA at HUNTER Technical Resources

Date Posted: 6/22/2019

Job Snapshot

Job Description


Azure Data Warehouse Architect

Required Technical Skills

  • 2+ years’ experience working in a Cloud DW environment
  • Experience architecting cloud data solutions for BI and Analytics use
  • Experience with one or more of the following Azure technologies:
  • Experience with Azure Data Factory (ADF) creating multiple complex pipelines and activities using both Azure and On-Prem data stores for full and incremental data loads into a Cloud DW
  • Experience managing Azure Data Lakes (ADLS) and Data Lake Analytics and an understanding of how to integrate with other Azure Services. Knowledge of USQL and how it can be used for data transformation as part of a cloud data integration strategy
  • Experience with Azure SQL DW pricing and geo redundancy models. Understanding of when to use Azure SQL DW vs Azure SQL Server/DB and loading patterns to move data from blob or ADLS into Azure SQL DW

Preferred Technical Skills
  • Understanding of the overall solution design of how PowerBI and Azure Analysis Services (AAS) fits into Azure architecture
  • Experience with other ETL tools (e.g. SSIS, Informatica, ODI, or Data Stage)
  • Certifications with Azure, specifically SQL DB, SQL DW, or Azure fundamentals
  • Consulting experience