Share this Job

Toronto, ON, CA

Actuarial Data Engineer


About Swiss Re Corporate Solutions

Swiss Re is one of the world’s leading providers of reinsurance, insurance and other forms of insurance-based risk transfer. We anticipate and manage risks, from natural catastrophes and climate change to cybercrime.

Swiss Re Corporate Solutions is the commercial insurance arm of the Swiss Re Group. We offer innovative insurance solutions to large and midsized multinational corporations from our approximately 50 locations worldwide. We help clients mitigate their risk exposure, whilst our industry-leading claims service provides them with additional peace of mind.

Swiss Re Corporate Solutions offers a flexible working environment where curious and adaptable people thrive. Are you interested in joining us?


About the Role

To lead / assist in the creation and management of data pipelines to enable Actuarial Services / Data Science in the development of visualizations and advanced analysis that support business operations and decision-making processes.


Responsibilities will include:


  • Gain trust and working relationship with business stakeholders and internal partners
  • Conduct interviews with the Swiss Re Accident & Health clients to assess pain points, define visions of future products, and implement solutions that deliver value across people, process, data, and technology
  • Review and analyze business workflows and user data needs
  • Design and implement business performance dashboards
  • Write customized queries/programs to generate automatic periodical reports highlighting all the Key Performance Indicators (KPIs)
  • Visualize the correct metrics in the dashboard and use appropriate data forecasting models in order to aid the teams to make better business decisions and control risk more efficiently
  • Analytics Engineering in close collaboration with Data Engineers, Data Scientists, Business Users and Technical experts to provide high quality deliverables and timely submissions
  • Improve systems by evaluating current practices and designing modifications.
  • Support the modernization of the existing tools by replacing and rebuilding systems and overall move towards more predictive analytics
  • Utilize knowledge of database management system software, object oriented programming development, system architecture and components and various programming languages
  • Build applications using SQL and/or Python scripts to manipulate data, monitor and help to improve data quality
  • Design, build and maintain end-to-end data solutions supporting our processes with the right data architecture
  • Handle data pipelines while testing for data curation, parsing, cleaning, transformation and enrichment of data
  • Development and support of data pipelines.
  • Have working knowledge of Apache Spark, big data processing and building products on distributed cluster-computing framework
  • Work with fundamentals of data processing, data pipeline, data lineage and ETL (Extract-Transform-Load) methodologies
  • Implement the project according to the Software Development Life Cycle (SDLC) and programming by using fast paced agile methodology, involving task completion, user stories
  • Ensure compliance with internal group controls and guidelines
  • Shape and contribute to appropriate data governance along the whole data lifecycle
  • Construct workflow charts and diagrams and writing specifications
  • Documentation of end-to-end data pipeline process
  • Documentation of data assets for information management purposes
  • Develop cost estimate models to support ROI metrics
  • Ad hoc team / business support as needed
  • Exploration and evaluation of new technologies and platforms.


About You

  • Bachelors or equivalent degree Computer Science, Data Science, Statistics or another relevant quantitative field
  • 5+ years of insurance industry experience
  • SQL Stack – SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)
  • Microsoft MSBI Stack – Power Query, PowerPivot, PowerBI
  • Microsoft Access
  • Familiarity with relational database concepts
  • Detail-oriented, analytical and inquisitive
  • Highly organized with strong time-management skills
  • Ability to work independently and collaborate well with others
  • Ability to affect smooth organizational transformations.



Other Details

Position Type: Permanent; Full-time36.5 hours per week

Rate of Pay: 113,500.00 to $120,000 CAD per year

Benefits: Group insurance benefits, defined contribution retirement plan, employee savings plan, global share (stock) plan, paid time off

Location: Westport Insurance Corporation, 150 King Street West, Suite 1000, Toronto, Ontario, Canada M5H 1J9. Teleworking (remote work) is allowed during the pandemic.


Swiss Re is an equal opportunity employer. It is our practice to recruit, hire and promote without regard to race, religion, color, national origin, sex, disability, age, pregnancy, sexual orientations, marital status, military status, or any other characteristic protected by law. Decisions on employment are solely based on an individual's qualifications for the position being filled.

During the recruitment process, reasonable accommodations for disabilities are available upon request. If contacted for an interview, please inform the Recruiter/HR Professional of the accommodation needed.


Reference Code: 100967 



Job Segment: Claims, Actuarial, Accounting, Data Architect, Compliance, Insurance, Finance, Data, Legal