Job Description

Job Description: Data Systems Analyst

Company: Aviva Canada
Location: Markham, Ontario (Minimum 3 days per week on-site)

About Aviva & The Role

Aviva is embarking on an ambitious Digital Transformation journey to build a next-generation data platform. This role is a unique opportunity to contribute to high-impact, forward-looking initiatives in a collaborative and innovative environment.

We are seeking a collaborative and resourceful Data Systems Analyst to join our fast-paced Technology Delivery Data function. You will act as a key liaison between various business units and technical data teams, helping to scale our data and analytics capabilities. You will be responsible for creating a center of excellence for data artifacts, requirements, and documentation, playing a pivotal role in enabling our direct-to-consumer business, data science capabilities, and digital expansion.

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.

Key Responsibilities

1. Claims & Policy Data Analysis

• Analyze structured and semi-structured data related to claims, policies, underwriting, and customer interactions.

• Identify patterns in claims frequency, fraud indicators, and loss ratios using lakehouse datasets.

• Support actuarial teams with data extracts and trend analysis.

2. Customer & Risk Insights

• Segment customers based on behavior, risk profiles, and product usage.

• Analyze customer lifetime value, churn risk, and cross-sell/up-sell opportunities.

• Collaborate with risk and compliance teams to monitor exposure and regulatory thresholds.

3. Regulatory & Compliance Reporting

• Prepare data extracts and reports for regulatory bodies (e.g., OSFI, FSRA, NAIC).

• Ensure data lineage and traceability for audit and compliance purposes.

• Validate data accuracy and completeness for filings and disclosures.

4. Data Wrangling & Preparation

• Clean and transform raw data from diverse sources (e.g., policy admin systems, CRM, claims systems) into analytics-ready formats.

• Leverage lakehouse tools (e.g., Delta Lake, Apache Iceberg) to manage versioned and time-travel datasets.

• Collaborate with data engineers to ensure efficient ETL/ELT processes.

5. Business Intelligence & Visualization

• Build dashboards and visualizations for underwriting, claims, finance, and product teams.

• Use tools like Power BI, Tableau, or Qlik to present insights from lakehouse data.

• Enable self-service analytics by creating reusable datasets and semantic layers.

6. Data Quality & Governance

• Profile and validate data to ensure consistency across policy, claims, and financial domains.

• Tag and catalog datasets using metadata tools (e.g., Unity Catalog, Collibra).

• Support master data management and reference data initiatives.

7. Collaboration & Stakeholder Engagement

• Work with actuaries, underwriters, product managers, and IT teams to understand data needs.

• Translate business questions into analytical queries and data models.

• Document business logic, assumptions, and data definitions clearly.

8. Predictive & Advanced Analytics Support

• Assist data scientists with feature engineering and exploratory data analysis.

• Provide historical data extracts for model training and validation.

• Interpret model outputs and integrate them into business reporting.

What You Bring

Education & Experience:

• A university degree in Computer Engineering, Computer Science, or a related field.

• Minimum 8 years’ experience as a Business/Systems Analyst working on mid-to-large projects for the design, development, and implementation of enterprise data systems.

• Minimum 5 years’ successfully leading Data Systems Analysis teams and building large-scale enterprise data assets.

• Insurance industry knowledge is a strong asset.

Technical Skills:

• Solid grasp of data technologies & tools (e.g., Snowflake, Hadoop, PostgreSQL, Informatica).

• Outstanding knowledge and experience in ETL with the Informatica product suite.

• Experience establishing documentation standards frameworks for data quality, governance, stewardship, and metadata management.

• Ability to foundationally understand complex business processes driving technical systems.

Professional Skills:

• Strong leadership and influencing skills at the senior management level.

• Excellent stakeholder management and verbal/written communication skills.

• Strong analytical, critical thinking, and problem-solving skills.

• Solid understanding of Project and Program Management processes.

Working at Aviva

• This role requires on-site availability at our Markham office a minimum of three days per week.

• As part of Aviva’s digital transformation, occasional extended hours may be required to meet critical project milestones. We seek candidates who are flexible and committed to supporting these initiatives.

• We offer the opportunity to work alongside experienced leaders and cross-functional teams driving meaningful change.