Azure Data Architect

Our client is a global leader in professional services.  As an Azure Data Architect you will be responsible for designing, managing, and optimizing data architecture on the Microsoft Azure cloud platform.

This role is 1 day per week in the office in Vaughan Ontario.  They offer 4 weeks vacation plus personal days, bonus opportunity, pension matching, and a strong benefits package. 

What you will do

• Develop comprehensive data architectures that align with business requirements, including data models, storage solutions, data pipelines, and analytics frameworks on the Azure platform.
• Design and implement cloud-based solutions for structured, semi-structured, and unstructured data.
• Utilize Azure services like Azure SQL Database, Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure Cosmos DB, Azure Blob Storage, and more to build scalable and secure data solutions.
• Design, develop, and maintain data integration workflows, ETL/ELT processes using Azure Data Factory or similar tools to ingest, transform, and load data from various sources.
• Design and enforce data access controls, encryption, masking, and other security measures to protect sensitive data.
• Collaborate with stakeholders to define data management strategies, including data retention, archiving, and backup solutions.
• Work closely with data engineers, business analysts, and other stakeholders to understand data requirements and provide architectural guidance.
• Communicate technical solutions effectively to non-technical stakeholders and ensure alignment with business goals.
• Optimize data storage, retrieval, and processing performance to enhance the efficiency and scalability of data solutions.
• Proactively identify and resolve data-related issues, ensuring high availability and reliability of data services.
• Provide guidance and mentorship to junior data architects, data engineers, and other team members.
• Lead architectural discussions, code reviews, documentation and design sessions to promote best practices and high-quality solutions.
• Continuously evaluate and improve the data architecture and related processes, incorporating feedback, industry trends, and new technologies.

What you bring to the role

• Strong knowledge of Microsoft Azure and cloud data services.
• 7 to 10 years of experience as an Architect in data Analytics domain.
• Expertise in data modeling, database design, and data warehousing.
• Experience with ETL/ELT processes, data integration, and data pipeline orchestration.
• Proficiency in SQL, NoSQL, Python, Spark, and other relevant technologies.
• Understanding of data governance, security, and compliance requirements.
• Excellent communication, problem-solving, and leadership skills.

Technical skills

• Experience in configuring and implementing Azure Storage, Azure Data Factory, Azure Data Lake, Azure SQL Server Data Warehouse and Azure SQL Server db.
• Good understanding of AZURE components, storage & compute services
• Familiarity with DevOps practices and tools, such as Azure DevOps, Git, and CI/CD pipelines 
• Experienced in Data modelling and data architecture design.
• Experience with Data testing, including ability to create test plans, test cases, execute test cycles, etc.
• Experience is creating the efforts estimation, timelines for all new projects/programs
• Understanding of Azure networking fundamentals, including Virtual Networks (VNets), subnets, Azure Private Link, and ExpressRoute.
• Knowledge of resource provisioning, management, and scaling using Azure Resource Manager (ARM) templates or Terraform.
• Stay current with the latest Azure offerings and best practices for data architecture, storage, and analytics.
• Experience with data visualization tools such as Power BI for creating dashboards, reports, and analytics solutions.
• Certifications: Holding relevant certifications such as Azure Solutions Architect Expert