Job Description :
Azure Data Architect


* Responsible for supporting the Modern data and analytics portfolio by working with customer and internal stakeholders (business clients, business analysts, developers, other architects), defining customer solutions, and delivering engagements that are innovative and exceed business requirements.
* Collaborate with other team members to develop and architect the Azure Data Platform and deliverables
* Stay abreast of architectural/ industry changes; especially in the areas of big data and the cloud
* This position will assist with architecting of customer-focused solutions based upon market and customer needs on Azure Data Platform. This includes the architecting of the solution and project artifacts for current and new service offerings along with the quality of the delivery to customers.
* Meets with clients to determine needs and/or identify problem areas and suggest solutions.


* Knowledge of and experience with the Azure Data Platform - Azure Data Lake, Data Factory, Data Management Gateway, Azure Storage Options, DocumentDB, Data Lake Analytics, Stream Analytics, EventHubs, Azure SQL, CosmosDB.

* 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. 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

* Experience in establishing hot path and cold path data pipelines with automated batch, micro-batch, and incremental data refreshes.
* Knowledge of tabular OLAP, including PowerPivot and SSAS Tabular mode.
* Understanding of how traditional processes apply to the modern world (be able to talk about where big data and NoSQL can replace traditional enterprise data stores, how Azure Data Factory can supplement/replace SSIS, etc
* 5+ years, recent experience developing solutions in a Microsoft SQL Server environment using SQL, T-SQL stored procedures, T-SQL functions; and/or an Oracle Environment using SQL Plus and PL/SQL Coding Languages as well as familiarity with complex SQL Server scaling concepts (AlwaysOn, Geo-Scaling, Sharding, Large Scale Database Management)

Additional Skills:

* Exceptional customer engagement, interpersonal, presentation and overall communication skills.
* Ability to successfully handle multiple work streams across multiple engagements, while maintain composure and professionalism to meet tight deadlines and shifting priorities.
* Quickly learn and adapt to new business and technical concepts.
* Goal-oriented team player committed to quality and detail.
* Innovative thinker who is positive, proactive and readily embraces change.
* Strong understanding of Big Data, Data Visualization Business Intelligence and Data Warehouse concepts and best practices, with an understanding of its strategic importance to organizations.
* Superior conceptual and analytical abilities, identifying opportunities for improvement through analysis and creative thinking.

Thanks & Regards ,


Sage IT Inc.,

Extn: 389

Client : Sage IT Inc.