Data Integration Analyst

Berkshire Hathaway Group Reinsurance Division

Toronto

Híbrido

CAD 80 000 - 95 000

Tempo integral

Há 4 dias
Torna-te num dos primeiros candidatos

Uma candidatura completa num minuto

Currículo e carta de apresentação personalizados, prontos a enviar.

Ultrapassa os filtros ATS

Resumo da oferta

Berkshire Hathaway Group, Reinsurance Division (BHG Re) is seeking a Data Integration Analyst to ensure accurate and timely processing of electronic client data. You will oversee intake, validation, transformation, reconciliation, and QC across departments in a hybrid Toronto setting.

The role emphasizes data quality, process automation, and data-driven initiatives, collaborating with IT, Operations, and business stakeholders to improve data governance and reporting capabilities.

Qualificações

  • Post-secondary degree or diploma in Business, Information Systems, Computer Science, Data Analytics, Mathematics, Statistics, or a related discipline.
  • 3-7 years of experience developing and supporting data integration solutions, ETL pipelines, data warehouses, and analytical reporting platforms.
  • Experience with data quality management, data validation, or operational data processing functions.

Responsabilidades

  • Manage the intake, validation, transformation, and loading of client insurance and reinsurance data into internal systems.
  • Collaborate with cross-functional teams to gather and analyze requirements for data integration projects.
  • Review and reconcile control reports and validate results to ensure data accuracy before production.
  • Investigate, analyze, and resolve data quality issues and discrepancies promptly.
  • Develop and maintain data quality standards, validation rules, and quality control procedures.

Conhecimentos

Data integration
ETL pipelines
SQL
Python
PowerShell
Data quality
Automation
Data governance

Formação académica

Post-secondary degree or diploma in Business, Information Systems, Computer Science, Data Analytics, Mathematics, Statistics

Ferramentas

SSIS
Azure Data Factory
Informatica
Microsoft Fabric Data Factory

Descrição da oferta de emprego

The Berkshire Hathaway brand is synonymous with trust, integrity, prudent risk taking and doing business the right way. Like all great brands, ours continues to be forged based on the actions of our people – every one of us – who live it day to day and over time. Our financial strength enables us to provide consistent capacity and innovative, tailored solutions. It enables us to underwrite large, complex risks long term – and gives our customers the utmost confidence in the way we do business.

Berkshire Hathaway Group, Reinsurance Division (BHG Re) is a leading provider of life retrocession to Reinsurers from the United States, Canada, Asia and Europe.We are a unique organization, financially strong and diversified, with an appetite for large risks and a long investment horizon, more accepting of volatility.We specialize in individual life and critical illness reinsurance.BHG Re provides a collaborative and supportive culture where you can learn and grow.

About the Role

The Data Integration Analyst is responsible for ensuring the accuracy, completeness, integrity, and timely processing of electronic client data received from our clients and business partners. This role plays a critical part in maintaining high-quality data across the organization by overseeing data intake, validation, transformation, reconciliation, and quality control processes.

Working closely with Client Administration, Operations, Information Technology, and other business stakeholders, the Data Integration Analyst will identify and resolve data issues, support ongoing process improvements, and contribute to data-driven business initiatives. The successful candidate will combine strong analytical and problem-solving skills with a passion for data quality, process automation, and continuous improvement.

Role and Responsibilities:
Data Management & Quality Assurance
  • Manage the intake, validation, transformation, and loading of client insurance and reinsurance data into internal systems.
  • Collaborate with cross-functional teams to gather and analyze requirements for data integration projects.
  • Review and reconcile control reports, exception reports, and validate results to ensure data accuracy and completeness before committing data to production systems.
  • Investigate, analyze, and resolve data quality issues, discrepancies, and exceptions in a timely manner.
  • Ensure all client files are properly tracked, documented, archived, and maintained in accordance with corporate policies and regulatory requirements.
  • Collaborate with internal peers and clients to follow up on missing, incomplete, or inaccurate data submissions.
  • Develop and maintain data quality standards, validation rules, and quality control procedures.
Data Analysis & Reporting
  • Analyze operational and client data to identify trends, anomalies, risks, and improvement opportunities.
  • Create and maintain reports, dashboards, and data quality metrics to support management decision-making.
  • Perform root cause analysis on recurring data issues and recommend corrective actions.
  • Support ad hoc reporting and business analysis requests from internal stakeholders.
Process Improvement & Automation
  • Identify opportunities to streamline manual processes through automation, workflow improvements, and data transformation techniques.
  • Participate in the design and implementation of data-related projects and system enhancements.
  • Assist in the development and maintenance of ETL (Extract, Transform, Load) processes and data integration workflows.
  • Recommend improvements to data management practices, operational controls, and reporting capabilities.
Collaboration & Stakeholder Support
  • Build strong working relationships with internal departments, external clients, vendors, and business partners.
  • Collaborate with Business Analysts, IT teams, and operational stakeholders to support strategic initiatives and data governance programs.
  • Participate in testing, validation, and user acceptance activities for system changes and upgrades.
  • Provide subject matter expertise on data quality, data controls, and business processes.
Minimum Requirements :
  • Post-secondary degree or diploma in Business, Information Systems, Computer Science, Data Analytics, Mathematics, Statistics, or a related discipline.
  • 3-7 years of experience developing and supporting data integration solutions, ETL pipelines, data warehouses, and analytical reporting platforms.
  • Experience working with data quality management, data validation, or operational data processing functions.
  • Building and maintain data pipelines using tools such as SSIS, Azure Data Factory, Informatica, or Microsoft Fabric Data Factory.
  • Experience with SQL for data extraction, validation, and analysis.
  • Advanced SQL, stored procedures, query optimization, data modeling, and database performance tuning.
  • Python, PowerShell, and scripting for data transformation, automation, data quality validation, and API integrations.
  • Understanding data governance, data quality frameworks, and information management best practices.
  • Knowledge of Business Intelligence and reporting tool Power BI.
  • Strong analytical, critical thinking, and problem-solving skills.
  • Exceptional attention to detail and commitment to data accuracy.
  • Ability to manage multiple priorities and meet deadlines in a fast-paced environment.
  • Strong verbal and written communication skills.
  • Excellent interpersonal and stakeholder management abilities.
  • Self-motivated with a continuous improvement mindset and a passion for leveraging data to drive business outcomes.
  • Insurance or reinsurance industry experience is considered an asset.

Work Model: Hybrid - Downtown, Toronto

New Role

Salary $80,000 - $95,000

We are committed to creating an inclusive, barrier-free recruitment and selection process. If you require any accommodation at any stage of the application or interview process, please let us know by contacting recruiting@bhlifere.com, and we will work with you to meet your needs.

Obtém a tua avaliação gratuita e confidencial do currículo.

ou arrasta e larga o ficheiro aqui.

Similar jobs

Ofertas semelhantes que vale a pena comparar

Actuarial Analyst
Actuarial Analyst

Berkshire Hathaway Group Reinsurance Division • Toronto

Híbrido
CAD 75 000 - 85 000
Senior Business Intelligence Specialist
Senior Business Intelligence Specialist

Ryan Specialty Canada Limited • Toronto

Presencial
CAD 110 000 - 140 000
Risk Data Scientist
Risk Data Scientist

Manulife John Hancock • Southwestern Ontario

Híbrido
CAD 94 000 - 144 000
Full Stack Developer
Full Stack Developer

Berkshire Hathaway Group Reinsurance Division • Toronto

Híbrido
CAD 86 000 - 105 000
Hybrid work model
Senior Data Reporting Analyst
Senior Data Reporting Analyst

Equitable • Southwestern Ontario

Híbrido
CAD 90 000 - 130 000
Career growth
Total rewards
Time away
+1
Application Developer (Data Specialist)
Application Developer (Data Specialist)

Munich Re Group • Toronto

Híbrido
CAD 143 000 - 157 000
Hybrid work environment
Annual company bonus
Health and dental benefits
+4
Analyst Data & Analytics (12 month contract)
Analyst Data & Analytics (12 month contract)

The Canada Life Assurance Company • Toronto

Presencial
CAD 66 000 - 110 000
Senior Complex Claims Director, Casualty
Senior Complex Claims Director, Casualty

Berkshire Hathaway Specialty Insurance • Toronto

Presencial
CAD 160 000 - 180 000
Health, dental, vision
Disability Insurance
Life Insurance
+5
Business Data Analyst
Business Data Analyst

Sun Life (Experienced) • Montreal

Híbrido
CAD 62 000 - 93 000
Business Solutions Analyst
Business Solutions Analyst

Echelon Insurance • Mississauga

Presencial
CAD 65 000 - 90 000