Data Analyst and BI Developer – Toronto (Insurance)

At Trisura, we expect more because we believe it can be done better.

We are a young, growth oriented team with a commitment to exceptional talent and have been named one of Canada’s Top Small and Medium Employers since 2017. Our growth and our entrepreneurial style, niche market position and development opportunities ensure that our people see the results of their commitment reflected in the company’s success.

We are currently seeking a qualified individual to join the dedicated, forward thinking information systems team in our downtown Toronto office.

DATA ANALYST AND BI DEVELOPER – TORONTO

Position Overview:
As a Data Analyst within our Data & Analytics Team, you will play a pivotal role in harnessing the power of data to drive actionable insights and support our strategic goals. You will work closely with data engineers and business stakeholders to ensure the availability, accuracy, and usability of data assets critical to our operations.

As an integral member of the team, you will bring:

• Strong data-driven mindset, demonstrating a passion for extracting actionable insights from complex datasets.
• Demonstrated track record in quality assurance, ensuring data accuracy and reliability
• Knowledge of data processes and database architecture
• Effective communication enabling you to convey technical concepts to non-technical stakeholders and collaborate across teams effectively.
• Ability to thrive in a fast-paced environment with multiple priorities.
• An innovative mindset, passion for excellence and detail orientation.

Responsibilities include:

• Data Analysis: Conduct in-depth analysis of data to identify trends, anomalies, and patterns that can inform business decisions.
• Data Preparation and Cleaning: Collaborate with data engineers to collect, clean, and transform raw data into structured datasets suitable for analysis.
• Data Governance: Contribute to the establishment and enforcement of data governance policies and best practices.
• Data Quality Assurance: Develop and implement data quality checks and validations to ensure data accuracy and reliability.
• Reporting and Visualization: Create informative and visually appealing dashboards and reports to communicate key insights to stakeholders.
• Collaboration: Work closely with cross-functional teams, including application teams, finance and accounting, operational teams, actuaries, business analysts, and product managers, to address data-related challenges and support data-driven initiatives.
• Continuous Improvement: Stay up-to-date with industry best practices and emerging technologies to enhance data analysis capabilities within the team.

Programming experience with the following:
Must have:

• Excellent T-SQL skills.
• Ability to write readable and well-documented code for ease of maintenance.
• PowerBI and/or SSRS report design and report-side scripting.

Nice to have:

• MS Power Platform (PowerBI, PowerApps, PowerAutomate)
• DAX

Qualifications:

• Bachelor’s degree or college diploma in Business Administration, Computer Science, Mathematics , Statistics or relevant courses and certifications.
• 5+ years of experience as a data analyst, preferably in the insurance or financial services sector.
• Knowledge of data warehousing concepts and ETL processes.
• Strong analytical and problem-solving skills with a keen eye for detail.
• Experience with data modeling and database design is an advantage.
• Prior work experience in commercial insurance or financial industry an asset.

If you are looking for a career in an exciting and rewarding company, are driven to excel, thrive in a team environment and want to contribute to the success of an organization that values your contribution, we would like to hear from you!

We are committed to an inclusive and barrier-free workplace that reflects the diversity in each of our offices across Canada. Accommodations will be provided on request for candidates taking part in all aspects of our recruitment and selection process.

We thank all candidates for their interest however only those selected for an interview will be contacted.

Trisura Guarantee Insurance Company, headquartered in the heart of Canada’s financial district, is a specialty lines insurer with a focus on Surety, Specialty Insurance, Property & Casualty, and Warranty products.

As a Canadian owned and operated company, Trisura brings innovative solutions and expertise through a select network of both national and regional brokerage firms.

The company, founded in 2006, and operating across Canada with offices in Toronto, Halifax, Montréal, Calgary and Vancouver, is uniquely positioned to satisfy all varieties of risk in Contract, Commercial and Developer Surety, Directors' and Officers' Liability, Fidelity, and Professional Liability including Media Liability, as well as Warranty products.

trisura.com/careers