Business Data Analyst
Toronto, ON, Canada
PartnerRe
We are a leading global reinsurer that helps insurance companies reduce their earnings volatility, strengthen their capital and grow their businesses through reinsurance solutions.Company Description
PartnerRe is a leading, privately owned, multi-line global reinsurer with a reputation of financial stability and strength, and a commitment to rebuilding businesses and communities after risk events around the world.
Our mission is to continue to be a financially stable and predictable business partner, supporting our clients with solutions tailored to their needs, delivering superior returns to our owner, providing rewarding opportunities for our people and making a positive contribution to society. To achieve this, we live by our values of Integrity, Performance, Collaboration, Straightforward Communication and Respect and Care.
Core to The PartnerRe Experience is our global nature. No matter where you sit in the company, you are part of something bigger. Our teams represent our truly international mindset, forging connections across office locations and all levels of the organization and building a network of mutual success. The result is a day-to-day experience that will allow you to:
Grow in a supportive environment
Connect with a community of experts
View The PartnerRe Experience e-book to find out more about what it’s like to work at PartnerRe.
We are always looking for bright, proactive individuals to join our team!
Please follow our Careers page for all updates on new positions. We look forward to receiving your application.
PartnerRe is an equal opportunities employer.
Please join our company LinkedIn Page for all updates on new positions that are coming live.
Job Description
About the role:
The Business Data Analyst will be responsible for the analysis, development, and support of all incoming client data files for processing in PartnerRe systems. Data may come in various file formats but usually includes transaction, in force, valuation and underwriting files, which have process streams that vary by function.
- Ensure monthly data loads continue to meet stated metrics. Responsibilities include data/plan mapping (including entry and verification of manual data loads) for all clients, investigation and resolution of client issues, and accounting loads/verification.
- Keep the Manager, Assumed Admin informed of ongoing work activities and any unusual circumstances to ensure quality and timely deliverables.
- Develop a robust understanding of reinsurance concepts, principles and treaty language.
- Identify opportunities for process improvement, initiate internal reports and create efficiencies to improve data quality.
- Assist other teams within North American Life Operations and Administration when necessary.
- Assist internal stakeholders with requests for data, data inquiries, analyze any data discrepancies with supporting documentation.
- Analyze and design management reporting as defined by management.
- Write VBA code, macros, and SQL queries to extract, manipulate, and distribute data.
- Communicate with clients to facilitate transmission of monthly data files and address any questions/clarifications regarding data issues with clients.
- Verify that premiums, allowances and taxes for client policies being assumed are being calculated and billed correctly.
- Update accounting system with monthly client cashflow accounts vs accounts receivable. Find and correct any discrepancies.
- Create and maintain the ETL scripts used for acquiring, transforming, and loading into PartnerRe systems/tools.
- Adhere to all IT controls and security established by IT management.
- Adhere to all SOX controls as defined by Internal Control Framework
- Create and maintain a rigorous and effective control environment. This includes complying with all existing controls and identifying and remediating gaps in our current controls.
- Follow IT change management process by thoroughly testing all ETL scripts and CRM applications prior to changes to be implemented.
- Liaise with Underwriting for data checking, management reporting, and discussion on results from Audits and for Retro business (including facultative applications).
- Assist with Enhancement Projects including creation of project, testing and preparation for deployment. Defect/bug discovery and acceptance testing for the administration system. Document testing and outcomes and liaise with other departments to ensure tasks and bugs are completed to specifications.
- Participate in client visits or client audits (desk or on-site) as required.
Qualifications
About you:
The successful candidate should be a conscientious individual with exceptional problem-solving skills and a high degree of professional ethics and intellectual curiosity. In addition, the candidate should be a well-rounded individual who possesses the right combination of communication skills, an inquiring mind and creative mindset.
Education and Experience:
- 1-4 years of experience in a financial institution with some data management expertise
- Knowledge of insurance industry is a plus
- Undergraduate or Graduate degree in business or STEM disciplines
- Basic knowledge of audit & quality assurance principles
- Interpersonal skills and relationship management
- Proficient in SQL, MS Office, Alteryx
- Some experience with VBA
- Basic French language skills is a plus
Additional Information
#LI-Hybrid
PartnerRe provides a working environment in which diversity is valued, where all employees feel welcome, respected, and empowered to perform at their best. We invite you to learn more about D&I at PartnerRe.
Thank you,
PartnerRe Hiring Team
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Data management Data quality ETL Security SQL STEM Testing
Perks/benefits: Career development Team events
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Marketing Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open MLOps Engineer jobs
- Open Data Manager jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Sr Data Engineer jobs
- Open Business Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Analyst Intern jobs
- Open Product Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Data Quality Analyst jobs
- Open Manager, Data Engineering jobs
- Open Research Scientist jobs
- Open Azure Data Engineer jobs
- Open Junior Data Engineer jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs