Business Data Analyst

1 month ago


Toronto, Canada PartnerRe Full time

**About this job**:
The Business Data Analyst will be responsible for the analysis, development, and support of all outgoing client data files for processing in PartnerRe systems. Data is produced in various file formats and usually includes transaction, in force, valuation and underwriting files, which have process streams that vary by function.
- Support the PartnerRe monthly retro billing process (including account and data reconciliations, exception handling, account booking).
- Update accounting system to track retro premium and commission accounts. Find and correct any discrepancies.
- Identify/present variances, account trending, premium calculations/verifications and draw conclusions from the findings.
- Ensure monthly retro processing 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.
- Create, maintain and test the ETL scripts used for acquiring, transforming and loading into PartnerRe systems/tools.
- Analyze and design management reporting as defined by management. Write VBA code, macros, and SQL queries to extract, manipulate, and distribute data.
- Document all TAI processes and procedures put into production.
- Adhere to all IT controls and security established by IT management.
- Ensure the Team Lead is informed of ongoing work activities and any unusual circumstances to ensure quality and timely deliverables.
- Assist other teams within North American Life Operations when necessary including, claims, assumed and reporting teams.
- Assist Valuation and Pricing with requests for data and data inquiries. Analyzing discrepancies and providing documentation.
- Identify opportunities for process improvement, initiate internal reports and create efficiencies to improve data quality.
- 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.
- Participation in client visits.
- Communicate with clients to facilitate transmission of monthly transaction files and address any questions/clarifications regarding data issues with clients.
- Support client audits (desk and on-site audits).

**Qualifications**

**About you**:
**Qualifications and Experience**
- 3-5 years' BA experience within the Data space
- Proficiency in data analysis tools (Excel, SQL, Python)
- Familiarity with PowerBI
- Undergraduate or Graduate degree in business or STEM disciplines
- Familiarity with Snowflake, AWS, and Matillion.
- Interpersonal skills and relationship management
- Proficient in SQL, MS Office, VBA
- CBAP or PMP a plus
- 1-2 years of TAI Experience is a plus

Pay: $40.00-$45.00 per hour

Expected hours: 37.5 per week

**Benefits**:

- Dental care
- Employee assistance program
- Extended health care
- Paid time off
- Vision care

Flexible language requirement:

- French not required

Ability to commute/relocate:

- Toronto, ON M5J 2N7: reliably commute or plan to relocate before starting work (preferred)

Work Location: Hybrid remote in Toronto, ON M5J 2N7


  • Data Analyst

    1 week ago


    Old Toronto, Ontario, Canada ECF Data, LLC Full time

    About the RoleECF Data, LLC is seeking a highly skilled Data Analyst to join our team. As a Data Analyst, you will play a critical role in providing actionable insights to support business decision-making.Key ResponsibilitiesData Extraction and Analysis: Extract, clean, and manipulate large datasets from various sources to identify trends and opportunities...

  • Data Analyst

    1 week ago


    Old Toronto, Ontario, Canada ECF Data, LLC Full time

    About the RoleECF Data, LLC is seeking a highly skilled Data Analyst to join our team. As a Data Analyst, you will play a critical role in providing actionable insights to support business decision-making.Key ResponsibilitiesData Extraction and Analysis: Extract, clean, and manipulate large datasets from various sources to identify trends and opportunities...

  • Data Analyst

    1 week ago


    Old Toronto, Ontario, Canada ECF Data, LLC Full time

    {"h1": "Data Analyst Role at ECF Data, LLC", "p": "At ECF Data, LLC, we are seeking a skilled Data Analyst to join our team. As a Data Analyst, you will play a crucial role in supporting our business operations by analyzing and interpreting complex data sets.Responsibilities:* Conduct data reviews to identify and resolve issues* Integrate best practices and...

  • Data Analyst

    1 week ago


    Old Toronto, Ontario, Canada ECF Data, LLC Full time

    {"h1": "Data Analyst Role at ECF Data, LLC", "p": "At ECF Data, LLC, we are seeking a skilled Data Analyst to join our team. As a Data Analyst, you will play a crucial role in supporting our business operations by analyzing and interpreting complex data sets.Responsibilities:* Conduct data reviews to identify and resolve issues* Integrate best practices and...

  • Data Analyst

    11 hours ago


    Old Toronto, Ontario, Canada ECF Data, LLC Full time

    Enterprise Architecture Team - Data AnalystCPA Ontario is seeking a highly skilled Data Analyst to join their Enterprise Architecture team. As a key member of the team, you will collaborate with cross-functional departments to provide actionable insights and drive business decisions.Key Responsibilities:Work closely with IT, Business Intelligence, and...

  • Data Analyst

    14 hours ago


    Old Toronto, Ontario, Canada ECF Data, LLC Full time

    Enterprise Architecture Team - Data AnalystCPA Ontario is seeking a highly skilled Data Analyst to join their Enterprise Architecture team. As a key member of the team, you will collaborate with cross-functional departments to provide actionable insights and drive business decisions.Key Responsibilities:Work closely with IT, Business Intelligence, and...

  • Data Analyst

    4 weeks ago


    Old Toronto, Canada ECF Data, LLC Full time

    CPA Ontario is hiring for the Enterprise Architecture team. The Data Analyst will collaborate with cross-functional departments to provide actionable insights, and is responsible for data extraction and analysis, report and dashboard development, and providing performance insights.In this role you can expect to have the responsibilities: Work with IT,...

  • Data Analyst

    4 weeks ago


    Old Toronto, Canada ECF Data, LLC Full time

    CPA Ontario is hiring for the Enterprise Architecture team. The Data Analyst will collaborate with cross-functional departments to provide actionable insights, and is responsible for data extraction and analysis, report and dashboard development, and providing performance insights.In this role you can expect to have the responsibilities: Work with IT,...

  • Research Analyst, Data

    3 months ago


    Toronto, Canada International Data Group, Inc. Full time

    Overview: - Do you want to be part of a dynamic team in a fast-paced exciting industry? You can make an impact by joining IDC Canada._ IDC Canada is looking for a **Research Analyst **to join our Data and Analytics team on a full-time basis for a permanent opportunity. Reporting to the Research Manager of IDC Canada’s Market Insights and Analytics,...


  • Toronto, Canada International Data Group, Inc. Full time

    Overview: IDC Canada is seeking a **Data & Analytics** **Analyst** to join the consumer devices team. In this role, you will have the opportunity to work on several of IDC’s consumer device programs, including wearables, AR/VR, smart home, personal computing devices like PCs and tablets, and mobile phones. Having familiarity with or expertise in the...


  • Toronto, Canada NTT DATA Full time

    Company Overview: Req ID: 268620 We are currently seeking a Salesforce - Business Analyst - Remote Canada role **Job Description**: - Once You Are Here, You Will: - Understand and document customer business requirements through attending and leading requirement workshops. - Assist with the development of requirement specifications according to standard...

  • Business Data Analyst

    2 weeks ago


    Toronto, Ontario, Canada CB Canada Full time

    Business Analyst - ConsultantCB Canada is seeking a highly skilled Business Data Analyst to join our team in a Consultant role. As a Business Data Analyst - Consultant, you will be responsible for providing subject matter expertise to lead and support projects at each stage to ensure successful delivery.Key Responsibilities:Develop and maintain business...

  • Business Data Analyst

    2 weeks ago


    Toronto, Ontario, Canada CB Canada Full time

    Business Analyst - ConsultantCB Canada is seeking a highly skilled Business Data Analyst to join our team in a Consultant role. As a Business Data Analyst - Consultant, you will be responsible for providing subject matter expertise to lead and support projects at each stage to ensure successful delivery.Key Responsibilities:Develop and maintain business...

  • Business Data Analyst

    3 months ago


    Toronto, Canada BSL consulting LLC Full time

    **Job Role: Business Data Analyst** **Location: Toronto, ON (2 days Onsite/Week)** **Job Type: Full Time(Permanent)** **Qualification**: - Based out of Canada, US - required in client office for minimum 2 days a week - Some recent experience in insurance domain/ data is must (Life and health insurance preferred). - Proficient in creating, maintain...


  • Toronto, Ontario, Canada CB Canada Full time

    Business Analyst - ConsultantCB Canada is seeking a highly skilled Business Analyst - Consultant to join our team. As a Business Analyst - Consultant, you will play a critical role in driving business success by providing subject matter expertise and supporting project delivery.Key Responsibilities:Develop and maintain business requirements documents (BRDs)...


  • Toronto, Ontario, Canada CB Canada Full time

    Business Analyst - ConsultantCB Canada is seeking a highly skilled Business Analyst - Consultant to join our team. As a Business Analyst - Consultant, you will play a critical role in driving business success by providing subject matter expertise and supporting project delivery.Key Responsibilities:Develop and maintain business requirements documents (BRDs)...

  • Business Data Analyst

    4 weeks ago


    Toronto, Canada Iris Software Inc. Full time

    Iris's client, the largest bank in the Canada is looking to hire Business Data Analyst (Wealth Management) Please find below the job details and share your resume if interested at Job Description: Title: Business Data Analyst (Wealth Management) Location: Toronto, ON (HYBRID) Duration: Lon

  • Business Data Analyst

    4 weeks ago


    Toronto, Canada Iris Software Inc. Full time

    Hi, Iris's client, the largest bank in the Canada is looking to hire Business Data Analyst (Wealth Management) Please find below the job details below Job Description: Title: Business Data Analyst (Wealth Management) Location: Toronto, ON (Hybrid-3 days) Duration: Long term assignment

  • Business Data Analyst

    4 weeks ago


    Toronto, Canada Iris Software Inc. Full time

    Hi, Iris's client, the largest bank in the Canada is looking to hire Business Data Analyst (Wealth Management) Please find below the job details below Job Description:Title: Business Data Analyst (Wealth Management)Location: Toronto, ON (Hybrid-3 days)Duration: Long term assignmentGood Wealth Management (WM) knowledge, familiar with WM data flow and Trading...


  • Toronto, Canada Apptad Inc Full time

    **Job Title**: Data Business Analyst/Insights Analyst **Job Location**: Toronto Area,Canada (Expected to be in office 2 days a week) **Job Duration**:Long-Term - The Business Insights Analyst is responsible for the holistic identification of Business Analytics, Reporting and Data Management Requirements as part of several Business Banking Programs /...