Data Engineer

Insurance Systems; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A boutique software provider in Toronto is seeking a Data Engineer to build and optimize data pipelines that drive insights and decision-making. The successful candidate will work across teams, ensuring data quality and compliance while developing and maintaining reports and dashboards. Ideal candidates have 2-5 years of experience in data engineering with proficiency in Python, SQL, and various data visualization tools.

Benefits

Competitive salary and benefits

$1,250 per year in Professional development funding

Performance-based bonuses

Flexible working arrangements

Wellness Program with exercise incentives

Qualifications

• 2 to 5 years of experience in data engineering or similar role.
• Proficiency in data processing frameworks and programming languages.
• Hands-on experience with relational database systems.

Responsibilities

• Collaborate with cross-functional teams to understand project requirements.
• Design, build, and maintain scalable data pipelines and integrations.
• Troubleshoot and resolve data-related issues, ensuring accuracy.

Skills

Python

SQL

Spark

C#

Data Visualization

Data Modeling

Communication

Tools

PostgreSQL

Power BI

Tableau

Job description

About us:

Founded in 1997, Insurance Systems Inc. (ISI) is a boutique software provider to the Property & Casualty insurance industry. Our insurance software suite, ISI Enterprise, was developed in-house by our dedicated team of software architects, developers, business analysts, and quality assurance analysts, with guidance from our phenomenal leadership team. Today, we have several successful implementations in the USA and Canada, and we are looking to expand our team.

At ISI, we pride ourselves on our strong corporate culture, work ethic, and the ability to find the right fit for our team. Working collaboratively, we consistently strive to exceed customer expectations while fostering an enjoyable and supportive working environment.

About the Role

As a Data Engineer, you will play a key role in building, optimizing, and maintaining data pipelines and systems that power insights and decision-making. You will work across teams to deliver high-quality data solutions and contribute to our data architecture while continuously improving processes and tools.

Your Responsibilities

• Collaborate with cross-functional teams to understand project requirements and deliver effective data solutions.

• Design, build, and maintain scalable data pipelines and integrations using ETL/ELT tools.

• Develop and maintain data models and schemas to support business analytics.

• Ensure data quality, security, and compliance with governance policies.

• Support stakeholders by translating technical data into clear insights.

• Develop and maintain
  diverse types of reports and dashboards using company designated reporting and business intelligence tools.

• Conduct or support end-user training for deployed reports and dashboards.

• Develop and maintain migration toolkits.

• Support our customers with their data migration implementation projects.

• Troubleshoot and resolve data-related issues, ensuring accuracy and completeness.

• Mentor junior team members and contribute to a culture of continuous learning.

Required Skills & Experience

• 2 to 5 years of experience in data engineering or similar role.

• Proficiency in data processing frameworks and programming languages (e.g., Python, SQL, Spark, psql, C#).

• Hands-on experience with relational database systems
  (e.g., PostgreSQL, Microsoft SQL Server).

• Hands-on experience with data integration tools like ETL/ELT.

• Hands-on experience with developing pixel perfect reports using reporting tools (e.g., SAP Crystal Reports, Eclipse BIRT, Easy Reports, CX Reports, Mescius, Jasper Reports)

• Hands-on experience with developing enterprise dashboards using data analytics and visualization tools (e.g., AWS QuickSight, Power BI, Tableau, GoodData, QlikView, Looker)

• Strong knowledge of data modeling techniques and data architecture principles.

• Familiarity with cloud platforms (e.g., AWS, Azure, GCP).

• Experience with data governance, quality, and security practices.

• Experience using agile methodology principles and tools.

• Effective communication and problem-solving skills.

• Comfortable working in a team environment.

Preferred Qualifications

• Experience with data analytics and visualization tools.

• Experience in Insurance/financial services.

• Knowledge of software development lifecycle (SDLC) and version control.

What We Offer:

• Competitive salary and benefits package

• Opportunities for professional growth and development, $1,250 per year in Professional development funding

• Performance-based bonuses

• Employee referral program

• Flexible working arrangements

• Summer-flex Fridays

• Early closure before a Long Weekend

• Wellness Program with exercise incentives

• Collaborative and inclusive company culture