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.