Azure Data Architect

This is a remote position.

Client is seeking an Azure Data Engineer to join our agile team implementing a modern Azure-based enterprise document and data management solution In this role, you will design and develop solutions using Azure Data Lake Storage, Azure SQL Database, Azure Data Factory, Power BI, and related tools.

Key Responsibilities:

• Data Architecture Design: Develop and maintain Azure data architectures that align with organizational goals and comply with data-related policies and standards.
  
• Data Integration: Design and implement data integration solutions using Azure services such as Azure Data Factory, Azure Databricks, and Azure Synapse Analytics to ingest, transform, and integrate data from various sources.
  
• Data Governance and Security: Establish and enforce best practices for data governance, security, and compliance, utilizing tools like Azure Role-Based Access Control (RBAC) and Unity Catalog.
  
• Performance Optimization: Optimize data storage and processing solutions for scalability and efficiency, ensuring minimal downtime and high availability.
  
• Collaboration: Work closely with data engineers, data scientists, and business stakeholders to understand requirements and translate them into technical solutions.
  
• Documentation and Training: Prepare architectural documentation and conduct knowledge-sharing sessions to upskill team members.
  

Requirements

Qualifications:

Must Have

• 5+ years of experience building Data and Analytics platforms focused on Azure Data and analytics solutions
  
• Expertise in configuring and implementing Azure Data Lake Storage (ADLS Gen 2) solutions to manage structured and unstructured data
  
• Expertise in designing, implementing, and tuning data models using Azure SQL Database
  
• Azure ETL tool experience (e.g., Azure Data Factory, SSIS, Power BI DataFlow)
  
• Experience with Azure Synapse Analytics
  
• Strong SQL Server and T-SQL development skills
  
• Experience in Programming Python
  

Preferred Skills:

• Knowledge/Experience on Kingsway Soft SSIS
  
• Bitbucket/Jenkins/GIT Integration using Azure repos for Source Control
  
• Experience using Azure Notebooks
  
• Experience/exposure to MS Fabric
  
• Proficiency in migrating from on-prem SQL to Azure PaaS SQL.
  
• Proficiency in Azure Data Platform (Azure SQL, Blob Storage, Power Automate, Event Grid)
  
• Familiarity with API Integrations (REST/oAuth) and cloud security best practices
  
• Experience with error handling, logging (Azure Monitor, Log Analytics) and performance tuning
  
• Knowledge of available APIs to access ADLS and Azure SQL Database