Data Architect with Azure synapse || Onsite in Tallahassee, FL (Onsite)
About The Position
The Data Architect will work with stakeholders and the development team to define project scope and vision, and gather and prioritize requirements. The role designs and implements data architectures that support organizational business goals using Azure Synapse Analytics, Azure SQL, and other Azure data services. It manages and optimizes Synapse Dedicated SQL Pools for large-scale data warehousing and analytics, and designs, implements, and manages Azure SQL and Azure Managed Instance databases with attention to performance, availability, and security. The position develops and manages ETL processes using Synapse Pipelines to move data from various sources into the data warehouse. It implements data governance practices, manages data cataloging, and creates and maintains scalable, performance-optimized data models. The Data Architect also oversees data security and regulatory compliance, maintains procedure manuals and system documentation, researches software solutions and technology trends, and provides technical guidance on developing and maintaining data, mappings, and high-volume, complex data-transfer processes.
Requirements
- At least 4 years of experience with Synapse Analytics, Dedicated SQL Pools, Azure SQL Database, and Azure Managed Instance.
- At least 5 years of experience with DDL and DML T-SQL, advanced stored procedure writing, tables, primary and foreign keys, constraints, indexes, transactions, process logging, and error handling.
- At least 4 years of experience with data architecture design principles, methodologies, and best practices.
- At least 3 years of experience with data governance principles and compliance requirements related to data security and privacy.
- At least 3 years of experience integrating data from various sources and managing large data pipelines.
- At least 2 years of experience with cloud computing concepts, particularly Microsoft Azure, including storage solutions and compute capabilities.
- At least 1 year of experience with programming languages such as Python or Scala.
- At least 1 year of experience with Salesforce, Message MQ, and MuleSoft.
- Strong analytical and problem-solving skills to address complex data challenges.
- Ability to design and implement robust, scalable, and efficient data architectures.
- Bachelor's or Master's degree in Computer Science, Information Systems, or a related field, or equivalent work experience.
Nice To Haves
- Microsoft Dynamics 365 Certification.
- MS Dynamics Power Platform Certifications.
Responsibilities
- Work with stakeholders and the development team to determine project scope and vision, and gather and prioritize requirements.
- Design and implement data architectures that support business goals using Azure Synapse Analytics, Azure SQL, and other Azure data services.
- Manage and optimize Synapse Dedicated SQL Pools for large-scale data warehousing and analytics workloads.
- Design, implement, and manage Azure SQL and Azure Managed Instance databases, ensuring performance, availability, and security.
- Develop and manage ETL processes using Synapse Pipelines to move data from various sources into the data warehouse.
- Implement data governance practices and manage the data catalog to support data quality, consistency, and accessibility.
- Build and maintain scalable data models optimized for performance.
- Implement and oversee data security measures and ensure compliance with legal and regulatory standards.
- Maintain procedure manuals and system documentation.
- Research software solutions and analyze current and future technology trends to support recommendations.
- Provide technical guidance on developing, architecting, and maintaining data and data mappings, and monitoring high-volume, complex data-transfer processes.
