Data Architect Azure SQL /SQL DDL DML T-SQL Microsoft Synapse Analytics or Snowflake MDM

Profile

FLDCF-1410

Primary Job Duties/ Tasks

The activities this candidate will be tasked with include, but are not limited to the following: This position is to provide technical guidance and expertise in supporting the department in developing, architecting, and maintaining Azure Synapse Analytics solution, Azure SQL Database, Master Data Management (MDM), Azure Databricks, spark pool, and monitoring of high-volume of complex data warehouse processes.

Data Architect:

Key Knowledge, Skills and Abilities 5 years of experience in advanced database design and administration with Azure SQL /SQL Server

5 years of experience in DDL, DML T-SQL skills, advanced stored procedure writing skills, tables, primary keys, foreign keys, constraints, indexes, transactions, process logging, and error handling

3 years of experience with Data Warehouse solutions like Microsoft Synapse Analytics or Snowflake

3 years of experience with MDM tools/ Architecture.

3 years of analyzing and interpreting large datasets, including cleaning, transforming, and visualizing data.

3 years of Experience with implementing MDM consumption patterns like Analytical,

Operational, Real-time, and bulk consumption patterns

2 years of experience in predictive models to drive decision-making and improve business outcomes.

Familiarity with system catalog views, Azure Cloud, experience with Microsoft Synapse dedicated SQL pools and pipelines

Ability to provide excellent customer support, meticulous quality of work and work product

Microsoft Dynamics 365 Certification (Desired) and MS Dynamics Power Platform Certifications (Desired)

Toll Free:

855-818-5109

Local:

518-218-1700

Map

& visit our office

Corporate - Albany NY

435 New Karner Rd, Ste 202

Albany NY 12205

Chicago

63E Lake Street, Ste 201

Chicago, IL 60601

Florida

17258 SE 121st Ave

Summerfield, FL 34491

© 2018 MVP Consulting Plus. All Rights Reserved.

Company info

Mvp Consulting Plus, Inc.