Data Engineer

Tokio Marine Canada Ltd.; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

Tokio Marine Canada is seeking a hands-on Data Engineer in Toronto to design, build, and maintain robust data pipelines powering underwriting, claims, and policy analytics. You’ll work with Snowflake, SQL Server, PostgreSQL, Python, and Alteryx to create reliable, query-ready datasets and automate validation and reconciliation.

You will implement a medallion architecture and partner with analysts and IT to ensure data lineage, governance, and scalable data delivery across the analytics stack.

Qualifications

• Bachelor’s degree or equivalent in a relevant field.
• 3–5+ years of professional data engineering experience building production-grade pipelines on cloud data warehouses.
• Strong SQL, Python, and Snowflake expertise; data governance is a plus.

Responsibilities

• Design & develop scalable ELT pipelines using Snowpipe, Snowflake Openflow, Python scripts, and Alteryx workflows to ingest data from SQL Server, PostgreSQL, Excel, JSON, and APIs.
• Implement medallion architecture (Bronze/Silver/Gold) with schema evolution, partitioning, and retention policies in Snowflake.
• Develop automated validation rules, reconciliation, and anomaly detection to ensure data integrity across source systems and the data lake/warehouse.
• Collaborate with data analysts, data scientists, product owners, and IT to gather requirements and document data lineage; evaluate new tools and promote CI/CD best practices.

Skills

SQL proficiency

Python programming

Data modeling

Education

Bachelor's degree in Computer Science / Information Systems / Engineering

Tools

Snowflake

Microsoft SQL Server

PostgreSQL

Python (pandas, sqlalchemy, pyarrow)

Alteryx Designer & Server

Airflow

Azure Data Factory

Job description

Who We Are

Tokio Marine Canada (TMCan) is a Canadian early-stage entrepreneurial commercial P&C insurer based in Toronto. We partner with select brokers to deliver tailored business insurance solutions across Canada. As part of the Tokio Marine Group, we are able to collaborate under a shared framework while maintaining autonomy and local decision making.

The Opportunity

We are seeking a technically savvy Data Engineer to join our fast-growing analytics team. You will design, build, and maintain robust data pipelines that power business insights across underwriting, claims, and policy administration. The role is hands‑on with Snowflake (including Openflow & Snowpipe), Microsoft SQL Server, PostgreSQL, Python, and Alteryx, and you’ll be instrumental in implementing a modern medallion architecture to ensure clean, trusted data for downstream analytics and reporting.

If you enjoy turning messy source files, Excel spreadsheets, JSON payloads, or legacy system extracts into reliable, query‑ready datasets while automating validation and reconciliation, this is the perfect opportunity. Insurance domain knowledge is a plus but not required; we value strong data engineering fundamentals and a passion for continuous improvement.

What You’ll Be Doing

• Design & develop scalable ELT pipelines using Snowpipe, Snowflake Openflow, Python scripts, and Alteryx workflows to ingest data from on premise SQL Server, PostgreSQL, Excel, JSON, and third party APIs.
• Implement medallion architecture—create Bronze (raw), Silver (cleaned/standardized), and Gold (business‑ready) layers in Snowflake; enforce schema evolution, partitioning, clustering, and data retention policies.
• Develop automated validation rules, record-level reconciliation, and anomaly detection to guarantee data integrity across source systems and the data lake/warehouse.
• Use Snowflake Tasks, Streams, and external orchestration tools (e.g., Airflow, Azure Data Factory) to schedule, monitor, and recover pipelines without manual intervention.
• Write performant T‑SQL, PostgreSQL/Redshift SQL, and Python‑based transformations; tune queries for large‑scale workloads.
• Partner with data analysts, data scientists, product owners, and IT to gather requirements, document data lineage, and produce technical specifications.
• Evaluate emerging tools (e.g., dbt, Fivetran), propose enhancements, and champion best practices for CI/CD, testing, and version control of data assets.
• Provide tier‑2 support for production issues, perform root‑cause analysis, and implement preventive fixes.

Who You Are

You are a hands‑on Data Engineer with strong experience in SQL, Python, and Snowflake, and a passion for building efficient, reliable data pipelines. You take ownership of data quality and performance, and enjoy turning complex data into clean, usable insights. Adaptable and collaborative, you work well across teams and continuously look for ways to improve processes and technology.

You Bring

• Prior work in the insurance industry (underwriting, policy administration, claims)
• Exposure to a binder management system, such as VIPR or similar platforms
• Knowledge of data governance tools (e.g., Collibra, Alation)
• Experience with cloud orchestration / workflow tools (Azure Data Factory, Apache Airflow, Prefect)

Core Competencies & Soft Skills

• Ability to dissect complex data problems and propose elegant solutions.
• Translate technical concepts for business stakeholders; write clear documentation.
• Take end-to-end responsibility for pipeline reliability and data quality.
• Collaborate in an agile environment with cross‑functional teams.
• Continuous learner.
• Stay current on cloud data platforms, open source tools, and industry trends.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, Mathematics, or a related field (or equivalent practical experience).
• 3–5+ years of professional data engineering experience building production‑grade pipelines on cloud data warehouses (Snowflake preferred).

Technical Skills

• Snowflake (core platform, Snowpipe, Openflow)
• Microsoft SQL Server
• PostgreSQL
• Python (pandas, sqlalchemy, pyarrow, etc.)
• Alteryx Designer & Server
• Data Extraction / Loading / Transformation (ELT)
• Medallion Architecture (Bronze/Silver/Gold)
• Data Reconciliation & Validation techniques
• Automation of Excel & JSON ingestion to RDBMS
• Git version control, CI/CD concepts

Salary

The anticipated base salary range for this position is (80,000-100,000). Compensation may vary for roles in other regions to reflect local market conditions and currency differences.