Business System Analyst

Compunnel, Inc.; Mississauga; On-site; CAD 110,000 - 140,000; Full time

Job summary

Compunnel, Inc. in Mississauga, Canada seeks an experienced Senior Data Analyst with strong insurance and actuarial domain knowledge to support data analysis, reporting, governance, and business intelligence initiatives.

You will work with actuarial, underwriting and broking teams, data engineers, and reporting teams to translate requirements into data solutions. The ideal candidate has hands-on actuarial/insurance experience, strong SQL capabilities, and the ability to translate complex

Qualifications

• 12+ years of experience as a Senior Data Analyst in Insurance, Reinsurance, Actuarial environments.
• Experience translating business requirements into data solutions and governance.

Responsibilities

• Analyze source systems and define data mappings for reporting and BI initiatives.
• Collaborate with actuarial, underwriting, broking, data engineers, and reporting teams.
• Document data transformations, business rules, and data definitions.
• Ensure data quality, reconciliation, and lineage across warehouses and data lakes.

Skills

Advanced SQL

Insurance domain knowledge

Actuarial data experience

Data governance

Data modeling

Tools

Azure Databricks

Azure Data Lake

ETL/ELT tooling

Job description

plaintext

JOB SUMMARY

We are seeking an experienced Senior Data Analyst with strong insurance and actuarial domain knowledge to support data analysis, reporting, governance, and business intelligence initiatives. The role will involve working closely with business stakeholders, actuarial teams, underwriting and broking functions, data engineers, and reporting teams to understand business requirements, analyze source systems, define data mappings, and ensure the accuracy and integrity of data used for reporting and decision-making. The ideal candidate will have hands‑on experience in actuarial and insurance environments, strong SQL capabilities, and a proven ability to translate complex business requirements and rules into clear, documented data solutions.

Key Responsibilities

• Advanced SQL, Strong insurance domain knowledge with experience in Actuarial. Hands‑on experience in data analysis and Strong understanding of data warehouses, data lakes, ETL/ELT processes, analytical data models, and Azure/Databricks ecosystem.
• Excellent SQL skills, including: Complex joins and subqueries Common table expressions Window functions Aggregations and reconciliations Data profiling and validation Query optimization
• Proven experience conducting detailed source data analysis across multiple systems.
• Strong capability in preparing and maintaining source‑to‑target mapping documents.
• Experience documenting business rules, transformation logic, calculations, assumptions, and data definitions.
• Hands‑on experience with data reconciliation, data quality analysis, and issue investigation.
• Understanding of data warehouses, data lakes, reporting layers, ETL/ELT processes, and analytical data models.
• Familiarity with Databricks and the Azure data ecosystem.
• Experience working with large, complex, and potentially distributed datasets.
• Exposure to reporting, dashboards, management information, and analytical outputs.
• Ability to interpret technical data structures and explain them in business terms.
• Deep knowledge of the insurance domain, with hands‑on experience in actuarial, underwriting, broking, or insurance data environments.
• Practical understanding of actuarial processes such as: Pricing and rating Reserving Loss ratios and profitability analysis Exposure and premium analysis Claims development Forecasting and portfolio performance
• Strong understanding of underwriting and broker data, including policy, submission, quote, bound, premium, commission, exposure, risk, and claims information.
• Experience interpreting insurance and actuarial metrics, business rules, and reporting requirements.
• Ability to work effectively with actuaries, underwriters, brokers, finance teams, and business leadership.
• Understanding of insurance reporting cycles, data dependencies, and key operational and regulatory considerations.
• Experience working with data governance frameworks, standards, and controls.
• Knowledge of data ownership, stewardship, lineage, metadata, data dictionaries, and critical data elements.
• Experience defining and validating data quality rules and reconciliation controls.
• Exposure to governed reporting environments and consistent KPI or metric definitions.
• Ability to ensure that reporting outputs are complete, accurate, traceable, and aligned with approved business rules.
• Experience supporting reporting requirements, dashboard development, management information, or regulatory reporting.

Required Qualifications

• Minimum 12+ years of experience as a Senior Data Analyst in Insurance, Reinsurance, Actuarial environments.
• Strong experience as a Senior Data Analyst, Business Data Analyst, or similar role in an insurance, actuarial, financial services, or data-intensive environment.

Preferred Qualifications

None mentioned

Certifications

None mentioned