Data and Analytics Architect

2 weeks ago

Toronto, Ontario, Canada KPMG Full time $120,000 - $200,000 per year
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.

The Data and Analytics 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.

Adjustments and accommodations throughout the recruitment process

At KPMG, we are committed to fostering an inclusive recruitment process where all candidates can be themselves and excel. We aim to provide a positive experience and are prepared to offer adjustments or accommodations to help you perform at your best. Adjustments (informal requests), such as extra preparation time or the option for micro breaks during interviews, and accommodations (formal requests), such as accessible communication supports or technology aids, are tailored to individual needs and role requirements. You will have an opportunity to request an adjustment or accommodation at any point throughout the recruitment process. If you require support, please contact KPMG's Employee Relations Service team by calling

  • Data Architect

    1 week ago

    Toronto, Ontario, Canada Toparo Full time $150,000 - $200,000 per year

    The Data Architect (Data & Analytics) will architect and deliver comprehensive data solutions using Microsoft Fabric. You will work closely with clients to understand their business needs, translate them into technical requirements, and design scalable, efficient data architectures. Your expertise in Microsoft Fabric will be instrumental in enabling clients...

  • Data Architect

    1 day ago

    Toronto, Ontario, Canada SAIS IT Services Full time

    Google Cloud Platform (GCP) Data ArchitectHybrid role from Toronto, ONLong term Contract RoleWe are seeking a highly skilled Google Cloud Platform (GCP) Data Architect with strong SAP data integration expertise to design, implement, and oversee enterprise-grade data solutions. The ideal candidate will combine deep expertise in cloud data platforms, data...

  • Marketing Analytics

    2 weeks ago

    Toronto, Ontario, Canada LatentView Analytics Full time $120,000 - $180,000 per year

    Job Description:We are seeking an experienced and hands-on B2B Marketing Analytics Consultant to support end-to-end analytics solutions across lead generation, campaign measurement, funnel analysis, and advanced modeling for a global payment's client. The ideal candidate is both technically strong and client-facing, with proven expertise in SQL, Tableau,...

  • Data Architect

    1 week ago

    Toronto, Ontario, Canada KUMARAN SYSTEMS Full time $120,000 - $180,000 per year

    Contract Opportunity for Data Architect with Banking Customer - Toronto LocationMode : 6 Month ContractJob Description:Sources: Data that has been collected by the organizationIngestion: Process of bringing data into the platformAzure Data Factory – data integration service to move data from its source to its storage locationStorage: Data storage for...

  • Sr. Data Architect

    5 days ago

    Toronto, Ontario, Canada Source Code Full time $120,000 - $180,000 per year

    Sr. Data Architect - GOAPRDJP Eleventh Floor StreetEdmontonPrimarily work remotely but must be available for on-site meetings as required (Meetings may occur up to 3-4 times per fiscal month, but the actual frequency will depend on the specific initiative and will be determined on an on-demand basis.)Contract 4+ months1 Opening/ 3...

  • Senior Data Architect

    1 day ago

    Toronto, Ontario, Canada TechDoQuest Full time $1,600,000 - $1,960,000 per year

    Min 10 years of experience neededRole OverviewWe are seeking a visionary and hands-on Senior Data Architect with 10+ years of experience to lead the design and implementation of scalable, secure, and high-performance data architectures across GCP, AWS, and Azure. This role is central to our cloud-first strategy, enabling advanced analytics, AI/ML, and...

  • Data Architect

    1 week ago

    Toronto, Ontario, Canada Epsilon Solutions Ltd. Full time $120,000 - $180,000 per year

    Role: Data ArchitectLocation: Toronto, ONDuration: ContractData Architecture StrategyDesign and implement scalable secure and high performance data architectureDefine data standards governance policies and best practicesAlign data architecture with business goals and analytics needsPlatform Development DataOps FocusLead the development of a DataOps platform...

  • GCP Data Architect

    7 days ago

    Toronto, Ontario, Canada Software International Full time $120,000 - $150,000 per year

    Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US and Europe.We currently have an indefinite contract role as a GCP Data Architect with our global consulting client, working at remotely This is a 6 month contract initially, but could be...

  • Data Architect

    24 hours ago

    Toronto, Ontario, Canada Tek Tron IT Full time $74,000 - $130,000 per year

    OverviewJoin our innovative team as a Data Architect and lead the design, development, and management of robust data solutions that empower strategic decision-making. In this dynamic role, you will craft scalable data architectures, optimize data flow processes, and ensure the integrity and security of enterprise data assets. Your expertise will drive the...

  • Data Architect

    1 week ago

    Toronto, Ontario, Canada Hire Values Full time $120,000 - $180,000 per year

    Job DescriptionThe Data Architect is responsible for scaling the data function as new products and services are implemented and transforming data into insights that inform strategy and decision making to support profitable growth.Job Responsibilities:• Owns and drives the future direction of data strategy and processes, including intake, sources, database...