Azure Data Architect - 15+ Years Onsite Florida

Techaffinity Consulting - Tallahassee, FL

Full-time - Senior

Tallahassee, FL

Administrative and Support Services

About the position

The Azure Data Architect position involves designing and implementing comprehensive data architectures that align with the organization's business goals. The role requires collaboration with stakeholders and development teams to gather requirements, manage SQL pools, and ensure data security and compliance. The architect will also oversee data integration processes and maintain data models, providing technical guidance and expertise in data management.

Responsibilities

• Work with stakeholders and development team to determine project scope and vision, gather and prioritize collected requirements.
• Develop comprehensive data architectures using Azure Synapse Analytics, Azure SQL, and other Azure data services.
• Manage and optimize Dedicated SQL Pools in Synapse for large-scale data warehousing and analytics workloads.
• Design, implement, and manage databases using Azure SQL and Azure Managed Instance, ensuring high performance, availability, and security.
• Develop and manage ETL processes using Synapse Pipelines for efficient data flow to the data warehouse.
• Implement data governance practices and manage the data catalog to ensure data quality and accessibility.
• Create and maintain data models that accurately represent the data landscape, ensuring scalability and performance optimization.
• 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 and analyze current and future technology trends.

Requirements

• 4+ years of experience in Synapse Analytics, Dedicated SQL Pools, Azure SQL Database, and Azure Managed Instance.
• 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.
• 4+ years of experience in data architecture design principles, methodologies, and best practices.
• 3+ years of experience in data governance principles and compliance requirements related to data security and privacy.
• 3+ years of experience in integrating data from various sources and managing large data pipelines.
• 2+ years of experience in cloud computing concepts, particularly in Microsoft Azure, including storage solutions and compute capabilities.
• 1+ years of experience with programming languages such as Python or Scala.
• 1+ years of experience in 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.
• Ability to provide excellent customer support with meticulous quality of work.

Nice-to-haves

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