Apply now

Posted 11 days ago

Lead Data Designer - P&C Insurance / ACORD & Data Products

@ Aviva Canada Inc

Markham, Ontario

10+ years experience
Apply now
SIGNALS

Overview

Aviva Canada Inc is hiring a Lead Data Designer to define enterprise data models, standards and frameworks for trusted, secure and reusable data across analytics, AI and digital solutions. The role owns data domains, data contracts and design assurance, and applies Property & Casualty insurance expertise and ACORD standards. The posting names 10+ years of enterprise data modeling experience and a bachelor's degree or equivalent practical experience.

Responsibilities:

  • Own and govern data models for assigned domains
  • Define data standards, contracts and semantic governance
  • Lead end-to-end enterprise data design initiatives
  • Design governed datasets for AI and analytics
  • Review and approve data models, schemas, APIs and events

Requirements summary:

  • 10+ years of enterprise data modeling experience
  • Strong SQL, ETL/ELT and integration skills
  • Deep P&C insurance knowledge and ACORD concepts
  • Bachelor's degree or equivalent practical experience
  • Experience with cloud data platforms such as Snowflake and AWS

Tools & skills

Benefits mentioned

Retirement plan
Source and dates

Employer career site / ATS feed · workday

Employer posting date
2026-11-05
First seen by our source
2026-10-09
Source record updated
2026-11-13

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

SeniorityLead
DepartmentData & analytics
Experience10+ years
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high
LanguagesEnglish
EducationBachelor’s degree (required)
Fields of studyComputer science, Information systems, Data management, Engineering

Summary and details written by AI from the posting; the employer’s posting is the authority.

Aviva Canada Inc

Saved company profile

Historical company information from a saved The Jobs API profile (LinkedIn/Crunchbase fields). It is not live-verified; figures may have changed. Missing values remain unknown.

Leading insurer for home, auto, lifestyle and Business / Assurance automobile, habitation, mode de vie et entreprise

Full company description

Aviva Canada is one of the leading property and casualty insurance groups in the country, providing home, automobile, lifestyle, and business insurance to 2.5 million customers coast to coast. A subsidiary of UK-based Aviva plc, we have the financial strength, scale and are a trusted insurance provider globally for more than 325 years. Proud Recipient of: 🌟 2025 Great Place to Work 🌟 2025 Greenest Employer 🌟 2025 Greater Toronto Top Employer 🌟 2025 Insurance Business Canada 5-Star Claims award For more information, visit aviva.ca or Aviva Canada’s Twitter, Facebook, Instagram and LinkedIn pages.

LinkedIn followers
118,479
People associated on LinkedIn
5,067
Reported office locations
  • 10 Aviva Way, Markham, Ontario L6G 0G1, CA
Other recorded names
  • Aviva Canada
Profile identifies a recruitment agency
No

Aviva Canada is one of the leading property and casualty insurance groups in the country, providing home, automobile, lifestyle, and business insurance to 2.5 million customers coast to coast. A subsidiary of UK-based Aviva plc, we have the financial strength, scale and are a trusted insurance provider globally for more than 325 years. Proud Recipient of: 🌟 2025 Great Place to Work 🌟 2025 Greenest Employer 🌟…

FieldValue
IndustryInsurance
Company size1,001-5,000 employees
HeadquartersMarkham, Ontario
Organization typePublic Company
Year founded1835
Open jobs on Jobsy106
LinkedInView page
Job description

Individually we are people, but together we are Aviva. Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence.


At Aviva Canada, we put people first, our employees, our customers, and our communities. We’re proud of a culture built on care, inclusion, and collaboration, where your voice matters and your growth is supported. We’re not just about insurance; we’re about making a real difference by protecting what matters most.



At Aviva, data is at the heart of every customer experience, business decision, and innovation journey. As a Lead Data Designer, you'll play a critical role in shaping our enterprise data landscape by defining the standards, models, and frameworks that enable trusted, secure, and reusable data across analytics, AI, and digital solutions. Working closely with business and technology partners, you'll lead end-to-end data design initiatives, apply Property & Casualty insurance expertise and industry standards such as ACORD, and help deliver scalable data solutions that support digital transformation, platform modernization, and future growth. You'll also influence how Canadian data domains align with Aviva's global data strategy while ensuring local business needs remain at the forefront.



What you'll do



The Lead Data Designer establishes clear, consistent, and implementation-ready data designs across the enterprise. Key responsibilities include:


  • Enterprise domain authority: Own and govern data models for assigned domains, aligning them with business capabilities, target architecture, roadmaps, and Aviva Canada’s P&C ecosystem. Resolve semantic conflicts and manage shared identifiers, classifications, reference data, hierarchies, and golden records where applicable.
  • Business semantics and federated ownership: Partner with business experts, product managers, and data owners to define and drive adoption of key business concepts, critical data elements, domain boundaries, systems of record, and producer/consumer responsibilities. Ensure data models, glossaries, and contracts enable effective business, engineering, governance, and AI outcomes.
  • Solution and integration modeling: Lead data design across operational stores, warehouses, data lakes/lakehouses, data products, and relational or NoSQL platforms. Apply fit-for-purpose modeling approaches and use approved logical models to support integrations, APIs, events, analytics, data science, and emerging AI consumption patterns.
  • Standards, contracts, and semantic governance: Govern data modeling standards, naming conventions, and design patterns. Define and maintain data contracts covering ownership, schemas, quality, service levels, versioning, and compliance, with automated validation where appropriate. Ensure metadata, lineage, business glossaries, transformation rules, and governance controls support consistent data use across business, technology, and AI solutions.
  • Migration and physical optimization: Define canonical structures, mappings, history, survivorship, validation, cutover, and transition-state designs for migration and modernization. Optimize physical models for performance, scalability, maintainability, cost, and workload patterns using partitioning, clustering, indexing, denormalization, and query optimization where appropriate.
  • Privacy, security, and regulatory controls: Embed privacy and security by design, least privilege, classification, retention, masking, tokenization, and access controls. Ensure models support Canadian insurance reporting, auditability, records and evidence requirements, data residency and cross-border obligations, and insurance risk, actuarial, pricing, and capital modeling.
  • AI-ready data: Design governed datasets, semantic layers, feature models, and retrieval-ready content to support AI use cases. Ensure data is trustworthy, compliant, and fit for purpose by addressing quality, lineage, provenance, privacy, security, and bias considerations. Establish clear classification and governance for structured, unstructured, and multimodal data to improve AI accuracy, traceability, and trust.
  • Design assurance and conformance: Review and approve data models, schemas, APIs, and events based on established principles, risks, and trade-offs. Assess downstream impacts across data products, integrations, analytics, regulatory reporting, AI solutions, and consuming systems. Ensure implementation aligns with approved standards, document exceptions, and maintain clear decision records.
  • Data Views and governance: Recognize that Data View identifies the data domains/subdomains affected and their alignment with enterprise models, standards, ownership, and governance. Over time, assume ownership of the enterprise Data View and the Solution Data View for all projects, working through architecture forums, data governance boards, stewardship councils, and roadmap planning to balance enterprise control, regulatory obligations, reuse, and federated business agility.
  • Model lifecycle and observability: Manage model ownership, versioning, traceability, publication, discoverability, effective dating, change control, supersession, and retirement. After implementation, monitor adoption, semantic consistency, anomalies, schema drift, metadata and lineage completeness, data quality, contract compliance, compatibility, realized change impacts, and approved exceptions. Prioritize corrective action and continuous improvement with data owners, data-product owners, platform teams, and delivery backlogs.
  • Delivery leadership: Guide and coach data, business intelligence, analytics, AI, application, architecture, engineering, delivery, and external partner teams. Balance target-state design with delivery needs, legacy constraints, and incremental modernization.


What you'll bring



  • Experience and education: 10+ years of enterprise data modeling and design experience in large, complex organizations, including leadership of large-scale or cross-domain models. Bachelor’s degree in computer science, Information Systems, Data Management, Engineering, or related discipline, or equivalent practical experience.
  • Enterprise modeling and governance: Expertise in conceptual, logical, and physical modeling; normalization; dimensional modeling; data vault; semantic layers; glossaries; ontologies; knowledge and context graphs; active metadata; machine-verifiable data contracts; and structured and semi-structured schemas for human, analytical, application, and AI consumers. Strong knowledge of data governance, quality, metadata, master and reference data, stewardship, lineage, retention, privacy, and security.
  • Data engineering and integration: Strong SQL, data profiling, source-system and query analysis, reconciliation, and source-to-target mapping skills. Strong knowledge of ETL and ELT, batch and streaming integration, APIs, change data capture, event-driven data, and versioned API and event contracts, including ownership, backward compatibility, and schema evolution.
  • Platforms and modeling tools: Experience with cloud data platforms and modern data ecosystems. Knowledge of Snowflake, AWS data services, PostgreSQL, Hadoop, Informatica, dbt, Airflow, AWS Glue, SAP PowerDesigner, ERwin Data Modeler, or comparable modeling, metadata, and lineage tools is an asset.
  • Data delivery: Experience applying enterprise semantic, metadata, quality, lineage, privacy, and security practices to governed data for machine learning, generative AI, retrieval-augmented generation, agentic AI, feature engineering, and data products, including vector and embedding structures, representativeness, bias risk, and permitted-use controls.
  • P&C and industry standards: Deep knowledge of Property & Casualty insurance concepts, lifecycle, terminology, and data relationships across personal and commercial lines. Ability to translate them into stable, reusable models, apply ACORD concepts, and align Canadian models with global or federated enterprise models while documenting local extensions and justified deviations.
  • Decision-making and stakeholder influence: Evaluate trade-offs across performance, scalability, cost, resilience, usability, privacy, and control requirements. Apply strong facilitation, consulting, negotiation, and consensus-building skills to challenge constructively, resolve competing needs, and make timely decisions with clear evidence, rationale, and stakeholder alignment. Communicate models and decisions effectively to business experts, product and data-product owners, data stewards, risk and compliance teams, architects, engineers, AI practitioners, and senior leaders.
  • Leadership and execution: Work independently, lead through influence, collaborate effectively across business, architecture, governance, and delivery teams, take accountability for outcomes, prioritize competing demands, and deliver effectively in a fast-paced environment.

What makes you stand out


  • Deep P&C Insurance and ACORD Knowledge.
  • Relevant certifications or formal learning in data management, cloud platforms, data governance, or enterprise architecture are assets, including DAMA CDMP, SnowPro, AWS, or TOGAF.

What you’ll get


  • The salary band for this position ranges from $140,000 to $175,000. Please note that individual salary is determined by factors such as job-related knowledge, skills and experience, as well as internal equity.
  • Compelling rewards package including base compensation, eligibility for annual bonus, retirement savings, share plan, health benefits, personal wellness, and volunteer opportunities.
  • Outstanding Career Development opportunities.
  • We’ll support your professional development education.
  • Competitive vacation package with the option to purchase 5 extra days off per year.
  • Employee driven programs focused on gender, LGBTQ+, origins, diversity, and inclusion.
  • Corporate wellness programs to support our employees’ physical and mental health.
  • Employee discount on home and auto insurance (where applicable).
  • Hybrid flexible work model.

This job advertisement is for a new vacancy which has been posted both internally & externally.

Aviva Canada may use AI (Artificial Intelligence) tools to assist us throughout the recruitment process to screen, assess or select applicants for a position.

Aviva Canada welcomes applications from all qualified individuals and has a process in place to provide accommodations for persons with disabilities at all stages of the hiring process and during employment. If you require an accommodation during the interview or hiring process, please contact your Aviva Talent Acquisition Partner so that an appropriate accommodation can be arranged.

#LI-PS1
#LI-Hybrid

Similar jobs

  • Senior Inspector

    Ottawa, ON +5
    Full Time

    EXP

    3+ YOECandidates need at least three years of senior inspection experience on MTO or municipal projects such as roads, bridges and sewers, plus OACETT registration as a C.E.T., C.Tech., RCSI or RCCA. Strong written and verbal communication, knowledge of OPSS/OPSD standards and MTO CAIS and CMS, and a valid driver's licence are also required.

    Microsoft Word, Microsoft Excel, AutoCAD Civil 3D, CMS, MTO CAIS Manual

  • Science teacher - secondary school

    Markham, ON
    Full Time

    BrightMinds Online School

    1+ YOECandidates need a bachelor's degree and one to two years of relevant experience.

    Professeur/professeure de sciences au niveau secondaire

    Markham, ON
    Part Time

    BrightMinds Online School

    1+ YOECandidates need a bachelor's degree and one to two years of experience, and must be available to start on the date in the posting. Candidates who are currently students are asked about.

  • Outside Sales Representative

    Markham, ON
    Full Time

    Longtech Computer Distribution Inc.

    Longtech Computer Distribution Inc. needs candidates with prior B2B sales experience, ideally in security equipment or IT hardware. They must have strong presentation, relationship-building and organizational skills, a valid driver's licence and reliable transportation.

    CRM

  • Senior Staff Accountant

    Markham, ON
    Full Time

    Ish Jindal CPA Professional Corporation

    3+ YOEIsh Jindal CPA Professional Corporation needs candidates with at least 3 years of recent Canadian public accounting experience, including T1 and T2 preparation and GST/HST filings. Candidates must have working knowledge of QuickBooks Desktop, QuickBooks Online, CaseWare, Tax Prep, Tax Cycle and Excel, and be legally authorized to work in Canada.

    QuickBooks Desktop, QuickBooks Online, CaseWare, Tax Prep, Tax Cycle, Microsoft Excel

  • Sr. Project Manager

    Markham, ON
    Contract

    SearchLabs: SearchLabs is a leading specialist recruitment firm established to meet the recruitment needs of the Design, Construction & Property, and…

    7+ YOECandidates need a university degree in computer science, business or a related field, and experience delivering projects with Waterfall and Agile methods. They also need proven success leading SaaS projects in accounting or financial services, including governance, budget tracking and risk management.

    Computer science, Agile, Regulatory compliance, Process improvement, Reporting, Risk management

  • Work From Home Client Retention Associate

    Markham, ON
    Remote

    AO Garcia Agency

    AO Garcia Agency asks for candidates who are coachable and consistent, able to work independently from home, and comfortable explaining things clearly by video. Interviews are conducted on Zoom only.

    Zoom

  • Data Engineer

    Markham, ON
    Full Time

    Amphenol Communications Solutions

    5+ YOECandidates need 5+ years of data or software engineering experience, advanced SQL and strong Python, hands-on Azure Data Factory and cloud data platform work, and experience with ETL, ELT and API integration. A bachelor's degree or equivalent experience is also required.

    Azure Data Factory, Microsoft Fabric, Git, QAD, Plex

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.