# Lead Data Designer

**Company**: Aviva Canada
**Work arrangement**: hybrid
**Experience**: senior
**Job type**: full-time
**Salary**: $140,000 to $175,000
**Category**: Data Science
**Industry**: Finance

**Apply**: https://aviva.wd1.myworkdayjobs.com/en-US/External/job/Markham/Lead-Data-Designer_R-173783?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply
**Canonical**: https://yubhub.co/jobs/job_5aba5801-139

## Description

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.

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.

**Responsibilities:**

- 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.

- 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.

- Solution and integration modeling: Lead data design across operational stores, warehouses, data lakes/lakehouses, data products, and relational or NoSQL platforms.

- Standards, contracts, and semantic governance: Govern data modeling standards, naming conventions, and design patterns.

- Migration and physical optimization: Define canonical structures, mappings, history, survivorship, validation, cutover, and transition-state designs for migration and modernization.

- Privacy, security, and regulatory controls: Embed privacy and security by design, least privilege, classification, retention, masking, tokenization, and access controls.

- AI-ready data: Design governed datasets, semantic layers, feature models, and retrieval-ready content to support AI use cases.

- Design assurance and conformance: Review and approve data models, schemas, APIs, and events based on established principles, risks, and trade-offs.

- Data Views and governance: Recognize that Data View identifies the data domains/subdomains affected and their alignment with enterprise models, standards, ownership, and governance.

- Model lifecycle and observability: Manage model ownership, versioning, traceability, publication, discoverability, effective dating, change control, supersession, and retirement.

- Delivery leadership: Guide and coach data, business intelligence, analytics, AI, application, architecture, engineering, delivery, and external partner teams.

**Requirements:**

- 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.

- 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.

- Strong SQL, data profiling, source-system and query analysis, reconciliation, and source-to-target mapping skills.

- 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.

**What you'll get:**

- The salary band for this position ranges from $140,000 to $175,000.

- 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.

## Skills

### Required
- data modeling
- data governance
- data quality
- metadata
- master data
- stewardship
- lineage
- retention
- privacy
- security
- SQL
- data profiling
- source-system analysis
- query analysis
- reconciliation
- source-to-target mapping
- cloud data platforms
- modern data ecosystems
- Snowflake
- AWS data services
- PostgreSQL
- Hadoop
- Informatica
- dbt
- Airflow
- AWS Glue
- SAP PowerDesigner
- ERwin Data Modeler

### Nice to have
- ACORD
- DAMA CDMP
- SnowPro
- AWS
- TOGAF

---

Source: [Apply at aviva.wd1.myworkdayjobs.com](https://aviva.wd1.myworkdayjobs.com/en-US/External/job/Markham/Lead-Data-Designer_R-173783?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)