Sr. Data Analyst

Synechron; Mississauga; On-site; CAD 145,000 - 150,000; Full time

Benefits offered by this job

Competitive compensation package

Laptop and mobile phone

10 days paid annual leave

Flexible hybrid policy

Comprehensive insurance plan

Job summary

Synechron is seeking an experienced Senior Data Analyst with deep insurance and actuarial domain knowledge to support data analysis, reporting, governance, and business intelligence initiatives.

You will work closely with stakeholders, actuarial teams, underwriting and broking functions, data engineers, and reporting teams to translate requirements into robust data mappings and governed reporting solutions.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Mathematics, Actuarial Science, Statistics, Finance, or related field.
• 12+ years of experience as a Data Analyst, Business Data Analyst, or similar role in insurance, actuarial, financial services, or data-intensive environments.
• Strong hands-on expertise in SQL, including complex joins, CTEs, window functions, aggregations, reconciliation, data profiling, and query optimization.
• Proven experience performing source system analysis, data mapping, data validation, and business rule documentation.
• Strong understanding of insurance and actuarial concepts, including pricing, reserving, claims, premiums, exposures, profitability, and portfolio performance.
• Experience working with underwriting, broker, policy, claims, premium, commission, exposure, risk, and related datasets.
• Knowledge of data warehousing, ETL/ELT processes, reporting layers, analytical data models, and data governance frameworks.
• Familiarity with Databricks and the Azure data ecosystem.
• Experience supporting reporting, analytics, or regulatory reporting initiatives.

Responsibilities

• Analyze source systems and map data for reporting and governance needs.
• Translate complex business requirements and rules into clear, documented data solutions.
• Collaborate with actuaries, underwriters, brokers, finance teams, and leadership to drive insights.
• Ensure data quality, reconciliation, and governance across reporting outputs.

Skills

Senior Data Analyst

Insurance domain

SQL

Source data analysis

Data mapping

Data governance

Databricks

Azure data ecosystem

Data quality analysis

Education

Bachelor's degree in Computer Science, Information Systems, Mathematics, Actuarial Science, Statistics, Finance

Tools

Databricks

Azure Data ecosystem

Job description

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 16,400+, and has 60 offices in 20 countries within key global markets.

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, analyse 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 or insurance environments, strong SQL capabilities, and a proven ability to translate complex business requirements and rules into clear, documented data solutions.

We are seeking a Senior Data Analyst with deep insurance and actuarial domain expertise to drive complex data analysis, reporting, and governance initiatives across underwriting, broking, and actuarial functions. The ideal candidate will bridge business and technology teams by translating complex insurance data requirements into actionable insights, robust data mappings, and governed reporting solutions. This role requires strong SQL and analytical skills to investigate data, improve data quality, and ensure accurate, trusted information for business decision-making. Success will depend on the ability to navigate large, complex datasets while collaborating effectively with actuaries, underwriters, and business stakeholders.

Additional Information*

The base salary for this position will vary based on geography and other factors. In accordance with law, the base salary for this role if filled within Mississauga, ON is $145k - $150k/year & benefits (see below).

Key Skills and Experience

Data Analysis and Technical Skills

• Strong experience as a Senior Data Analyst, Business Data Analyst, or similar role in an insurance, actuarial, financial services, or data-intensive environment.
• 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.

Actuarial and Insurance Domain Experience

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

Data Governance and Reporting

• 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

• Bachelor's degree in Computer Science, Information Systems, Mathematics, Actuarial Science, Statistics, Finance, or a related field.
• 12+ years of experience as a Data Analyst, Business Data Analyst, or similar role in insurance, actuarial, financial services, or data-intensive environments.
• Strong hands-on expertise in SQL, including complex joins, CTEs, window functions, aggregations, reconciliation, data profiling, and query optimization.
• Proven experience performing source system analysis, data mapping, data validation, and business rule documentation.
• Strong understanding of insurance and actuarial concepts, including pricing, reserving, claims, premiums, exposures, profitability, and portfolio performance.
• Experience working with underwriting, broker, policy, claims, premium, commission, and risk-related datasets.
• Knowledge of data warehousing, ETL/ELT processes, reporting layers, analytical data models, and data governance frameworks.
• Experience working with large and complex datasets and supporting reporting, analytics, or regulatory reporting initiatives.
• Strong stakeholder management skills with the ability to work closely with actuarial, underwriting, finance, reporting, and technology teams.
• Familiarity with Databricks and the Azure data ecosystem.

Preferred / Good-to-Have Skills

• ASA, ACAS, FSA, or FCAS credential (completed or in progress).
• Experience in Property & Casualty (P&C), Reinsurance, Employee Benefits, Group Benefits, or Voluntary Benefits domains.
• Exposure to insurance broker-dealer, underwriting, or actuarial data platforms.
• Experience with Power BI, Tableau, or other business intelligence and visualization tools.
• Understanding of data lineage, metadata management, master data management, and data cataloging solutions.
• Exposure to cloud-based data platforms, including Azure Data Lake, Azure Synapse, and Databricks.
• Experience supporting data governance, data quality, and regulatory reporting initiatives.
• Knowledge of Agile delivery methodologies and Jira-based project environments.
• Strong analytical and problem-solving skills with the ability to communicate complex technical concepts to business audiences.
• Banking or broader financial services experience is considered an asset.

We Offer:

• A highly competitive compensation and benefits package
• A multinational organization with 58 offices in 21 countries and the possibility to work abroad
• Laptop and a mobile phone
• 10 days of paid annual leave (plus sick leave and national holidays)
• Maternity & Paternity leave plans
• Flexible hybrid policy
• A comprehensive insurance plan including: medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region)
• Retirement savings plans
• A higher education certification policy
• Commuter benefits (varies by region)
• Extensive training opportunities, focused on skills, substantive knowledge, and personal development.
• On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses
• Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups
• Cutting edge projects at the world’s leading tier-one banks, financial institutions and insurance firms
• A flat and approachable organization
• A truly diverse, fun-loving and global work culture

SYNECHRON’S DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.