Data Architect -Azure Synapse Analytics

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 6 Month(s)
No Travel Required

Skills

Synapse Analytics
Azure Synapse Analytics
Azure SQL
Azure data services
T-SQL
data architecture
data governance
Python

Job Details

Title: Data Architect - PR666261
Location: Tallahassee,FL
Duration: 6 + Months

Description : The activities this candidate will be tasked with include, but are not limited to the following:
Work with stakeholders and development team to determine project scope and vision,gather and prioritize collected requirements.
Designing and Implementing Data Architectures: Develop comprehensive data architecturesthat support the organization s business goals, using Azure Synapse Analytics, Azure SQL,and other Azure data services.
Managing Dedicated SQL Pools: Efficiently manage and optimize Dedicated SQL Pools in Synapse to handle large-scale data warehousing and analytics workloads.
Database Design and Management: Design, implement, and manage databases using AzureSQL and Azure Managed Instance, ensuring high performance, availability, and security.
Data Integration and ETL Processes: Develop and manage ETL (Extract, Transform, Load)processes using Synapse Pipelines, ensuring efficient data flow from various sources to thedata warehouse.
Data Governance and Cataloging: Implement data governance practices and manage thedata catalog to ensure data quality, consistency, and accessibility.
Building and Maintaining Data Models: Create and maintain data models that accuratelyrepresent the data landscape, ensuring they are scalable and optimized for performance.
Ensuring Data Security and Compliance: Implement and oversee data security measures,ensuring compliance with legal and regulatory standards.
Maintain procedures manuals and system documentation.
Research software solutions to support recommendations, analyzing current and futuretechnology trends.These positions are to provide technical guidance and expertise in supporting the department indeveloping, architecting, and maintaining data, data mappings, and monitoring high-volumecomplex data transfer processes.


Minimum Required KSAs:
1. 4+ years of experience in Synapse Analytics, Dedicated SQL Pools, Azure SQL Database, andAzure Managed Instance.
2. 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 errorhandling.
3. 4+ years of experience in data architecture design principles, methodologies, and bestpractices.
4. 3+ years of experience in data governance principles and compliance requirements relatedto data security and privacy.
5. 3+ years of experience in integrating data from various sources and managing large datapipelines.
6. 2+ years of experience in cloud computing concepts, particularly in Microsoft Azure,including storage solutions and compute capabilities.
7. 1+ years of Experience with programming languages such as Python or Scala.
8. 1+ years of experience in Salesforce, Message MQ, and MuleSoft9. Strong analytical and problem-solving skills to address complex data challenges.
10. Ability to design and implement robust, scalable, and efficient data architectures.
11. Ability to provide excellent customer support; meticulous quality of work and work product

2.4 Education and CertificationsEducation:
Bachelor s or Master s Degree in Computer Science, Information Systems, or otherrelated field. Or
equivalent work experience. (Required)Certifications:
Microsoft Dynamics 365 Certification (Desired) and MS Dynamics Power PlatformCertifications (Desired)

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.