About Us
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.