Join Us as a Data Engineer

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 Pipelines - Build scalable EL T 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.
• Data Quality & Reconciliation - Develop automated validation rules, record level reconciliation, and anomaly detection to guarantee data integrity across source systems and the data lake/warehouse.
• Automation & Orchestration - Use Snowflake Tasks, Streams, and external orchestration tools (e.g., Airflow, Azure Data Factory) to schedule, monitor, and recover pipelines without manual intervention.
• SQL Development & Optimization - Write performant T SQL, PostgreSQL/Redshift SQL, and Python based transformations; tune queries for large scale workloads.
• Collaboration & Documentation - Partner with data analysts, data scientists, product owners, and IT to gather requirements, document data lineage, and produce technical specifications.
• Continuous Improvement - Evaluate emerging tools (e.g., dbt, Fivetran), propose enhancements, and champion best practices for CI/CD, testing, and version control of data assets.
• Support & Incident Management - 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 (EL T)
• Medallion Architecture (Bronze/Silver/Gold)
• Data Reconciliation & Validation techniques
• Automation of Excel & JSON ingestion to RDBMS
• Git version control, CI/CD concepts

This posting is for an existing vacancy at Tokio Marine Canada. We are actively hiring for this position and encourage qualified candidates to apply.

Tokio Marine Canada may use AI tools during the recruitment process to assist with screening, assessment or selection of applicants for a position.

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. At Tokio Marine Canada, our salary ranges are designed to reflect the skills, experience, and responsibilities required for each role while providing room for growth. For experienced professionals, offers are typically positioned near the midpoint of the range. The upper end of the range is reserved for individuals who consistently deliver exceptional performance and impact. Candidates who are newer to the role may start below the midpoint, with opportunities to progress as they develop. Final offer decisions take into account factors such as location, relevant experience, and individual skill set.

We work in a hybrid model, and you should expect to split your time between working in the office and working remotely, with flexibility based on the role and the business needs. We currently have an office in downtown Toronto and will eventually be establishing offices in other provinces. Should you currently work in a province where we do not have an office, you will remain remote until such time as we do establish an office.

Tokio Marine Canada is not accepting unsolicited resumes from search firms for this position. If you are a search firm, you will not be compensated in any way for your submission of a candidate, even if TMCan hires that candidate.