Azure Lead Data Architect

Posted A month ago

AI Interview Copilot

Job Details

Full Time

Location

Canada

Job Description

Overview
At KPMG, you'll join a team of diverse and dedicated problem solvers, connected by a common cause: turning insight into opportunity for clients and communities around the world.

An Azure Lead Data Architect is responsible for designing, managing, and optimizing data architecture on the Microsoft Azure Cloud platform.

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

Providing you with the support you need to be at your best
Our Values, The KPMG Way
Integrity, we do what is right | Excellence, we never stop learning and improving | Courage, we think and act boldly | Together, we respect each other and draw strength from our differences | For Better, we do what matters

KPMG in Canada is a proud equal opportunities employer and we are committed to creating a respectful, inclusive and barrier-free workplace that allows all of our people to reach their full potential. A diverse workforce is key to our success and we believe in bringing your whole self to work. We welcome all qualified candidates to apply and hope you will choose KPMG in Canada as your employer of choice. For more information about Inclusion, Diversity & Equity in Recruitment, please click here .

Adjustments and accommodations throughout the recruitment process
At KPMG, we strive for an inclusive recruitment process that allows all candidates to Come As You Are and Thrive with Us. We aim to provide a positive experience and are ready to offer adjustments or accommodations to help you perform at your best. Adjustments (an informal request), i.e. extra preparation time or the option for micro breaks during interviews, and accommodations (a formal request), i.e. accessible communication supports or technology aids are tailored to individual needs and role requirements.

To begin a confidential conversation about adjustments or accommodations at any point throughout the recruitment process, we encourage you to contact KPMG's Employee Relations Service team for support by emailing cdnersteam@kpmg.ca or by calling 1-888-466-4778, Option 3.

For information about accessible employment at KPMG, please visit our accessibility page .

About KPMG

KPMG LLP is the Canadian member firm of KPMG International. We provide Audit, Tax, and Advisory services to many of the public and private business, not-for profit, and public sector organizations in Canada. Nationally, there are 40 offices and over 700 partners and 7,000 employees working together to help Canadian businesses achieve their goals. Leveraging the skills, knowledge and passion of our firm and our people allows us to serve our clients with uncompromising professionalism, cutting through complexity to provide valuable insight—in Canada and around the world. KPMG s.r.l./S.E.N.C.R.L. est le cabinet canadien membre de KPMG International Cooperative (« KPMG International »). Nous offrons des services professionnels en audit et en fiscalité ainsi que des services-conseils à une vaste clientèle composée notamment de sociétés ouvertes et fermées, d’organismes sans but lucratif et d’organisations du secteur public au Canada. KPMG compte 40 bureaux à l’échelle nationale, au sein desquels collaborent plus de 700 associés et 7 000 employés pour aider les sociétés canadiennes à atteindre leurs objectifs. Nous misons sur les compétences et le savoir-faire de notre équipe pour servir nos clients − au Canada et ailleurs dans le monde − avec rigueur et professionnalisme. Notre mission première : simplifier la complexité en proposant des perspectives éclairantes.