Job Description

Pay Rate: $25 - $27/hour

Location: Ontario, Canada

Job Type: 100% Remote

Job Review:

We are seeking a skilled Data Analyst who will be responsible for developing analytics and reporting solutions for the Agent Review team, enabling the identification and assessment of patterns, tracking key findings, and detecting and mitigating potential risks.

Responsibilities:

• Participate in the development of reporting metrics and dashboards in collaboration with the Agent Review and Compliance teams.
• Use analytics technologies, including MSBI, Excel, SQL, SSIS, and Power BI, to develop and maintain data, data extracts, and reporting.
• Initiate, review, track, and provide reporting for client and agent file reviews performed by the Agent Review team.
• Build automations using Excel, SQL, and Power BI.
• Assist in the development of reporting that identifies statistics, trends, and training opportunities for the sales field.
• Document processes related to data warehousing, extraction, automation, analysis, and reporting.
• Extract, transform, and load data using data management tools and T-SQL.
• Administer and maintain the BI Portal, data warehouse, and existing BI solutions.
• Assist management in conducting and facilitating internal testing and user acceptance testing.

Qualifications:

• Post-secondary education in finance, computer science, information technology, or equivalent experience.
• Two years of experience in the insurance and/or securities industry.
• Good understanding and experience with MSBI, Excel, SQL, SSIS, Power BI, and MS Office.
• Strong analytical, decision-making, and problem-solving skills.
• Excellent attention to detail and accuracy.
• Strong communication and relationship-building skills.
• Effective organizational and prioritization skills.
• Bilingual (French/English).
• Candidates must be Located in Ontario or Montreal - Canada

Job Tags

Similar Jobs