Azure Data Architect

Job Title: Azure Data Architect

Location : NEvada Remote

Duration : Full Time

The candidate is expected to be a Sr. consultant / Technical Architect who can work with customers and teams (local or remote) and lead technical or business discussions and provide technical guidance to clients and team members delivering initiatives. An ideal candidate must have been in a Senior Architect/Consultant / Engineer role where she/he has led the design/implementation of several complex dataoriented solutions on Azure Data Platform with multiple integrations and reporting needs. Additional experience in On Prem and other Cloud Data technologies will be helpful.

The role is a combination of solutioning consulting and handson experience. The ideal candidate will need to envision design and implement the technical solution working with customer and internal technical team. Candidate will lead multiple Data and Analytics projects providing design/implementation guidance to teams.

The candidate is expected to have the following expertise/experience.

Minimum 10 years experience in architecture and design of highly scalable performance resilient data and analytical solutions

Modern Data Platform

1. Excellent written and verbal communication

2. Must have worked on several (5) projects building solutions for Data Pipelines Data warehousing Data Modelling on Azure Data Platform

3. Expertise in design and development of Data pipelines and ETL using ADF/Synapse Databricks to move data from relational/structured/semistructured data from source to data lake to data warehouse on Azure

a. Creating Pipelines and integrations of multiple data sources

b. Data processing and transformation using Databricks (Scala/Python)

c. Expertise in optimizing cost and performance of data pipelines

4. Experience working with Data Lake Synapse on Azure

a. Designing Data Lake storage layer following Medallion architecture

b. Designing data storage DB schema data models and processing on Azure Synapse DW

c. Experience with Synapse Spark Pool

5. Experience in Data Modelling

a. Building Data Models from structured and semistructured data (Data Model Common Data Model etc.)

b. Performance optimization of data model for high performance analytical and reporting workloads

6. Expertise with Azure/ SQL Server and extensive experience with SQL programming

a. Programming and optimizing DB objects Views Stored Procs Functions

7. Good experience in defining data access policy and security for azure data services

8. Experience with Oracle EDW

9. Knowledge/Experience migrating from Oracle EDW to any cloud DW

10. Experience working with Health Catalyst and data models in Health Catalysts

Reporting Good to have

1. Expertise in building scalable high performance reporting solution using Power BI in both shared and dedicated capacity

Designing Reports against cloud and onprem data sources

Performance analysis and optimization of slow performing reports/visuals

Import models and Direct Query

Expertise in integrating Power BI reports with custom applications using Power BI Embedded or Premium

Experience working with Power BI Paginated reports

Building data models in Power BI

Handson with DAX

2. Migrating reports from Tableau to Power BI