Senior Data Analyst

Senior Data Analyst – Waterloo, Ontario

Responsibilities

• Design, develop, and maintain ETL programs to our Analytics databases.
• Create and manage robust, scalable data marts including transactional, in force, new business, quote, claims, billing, and experience datasets.
• Collaborate with IT and Actuarial colleagues to ensure alignment on data architecture and sourcing.
• Develop processes and standards to ensure data integrity, quality, and availability across all Actuarial databases.
• Conduct regular audits, monitoring, and issue resolution for data anomalies.
• Document data definitions, lineage, and transformation logic to support transparency and repeatability.
• Investigate and execute complex, time‑sensitive ad‑hoc data requests from Actuarial, Finance, Underwriting, and Executive teams.
• Translate business questions into analytical tasks and provide meaningful, actionable insights.