Data Engineer at Tokio Marine Canada Ltd

Toronto, Ontario, Canada -

Full Time

Start Date

Immediate

Expiry Date

24 Aug, 26

Salary

100000.0

Posted On

26 May, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Snowflake, Python, SQL, Alteryx, ELT Pipelines, Medallion Architecture, Microsoft SQL Server, PostgreSQL, Data Validation, Azure Data Factory, Apache Airflow, Git, CI/CD, Data Modeling, JSON Ingestion, Data Reconciliation

Industry

Insurance

Description

Join Us as a Data Engineer 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. We support Canadian businesses in taking smart risks by delivering practical insurance solutions and exceptional service through trusted broker partnerships. 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 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. * 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 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 (ELT) * 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. Life at Tokio Marine Canada At TMCan, we’re a relationship company. We value collaboration, innovation, and inclusion, where every voice matters and every team member makes an impact. We believe in flexibility, authenticity, and growth: because when our people thrive, so does our business. TMCan offers the unique opportunity to work side by side with senior leaders, gaining direct exposure to strategic decision-making and business planning. Our CARE values guide everything we do: Collaborative: We communicate openly, support one another, and work as one team. Achieving Excellence: We challenge the status quo and exceed expectations. Responsive: We anticipate needs and deliver timely, exceptional service. Ethical & Respectful: We act with integrity and empower our people to do the right thing. Our Commitment to an Inclusive and Respectful Workplace At TMCan, we are deeply committed to fostering a culture of equity, diversity, and inclusion. We strive to create a workplace where every individual is welcomed, respected, and valued for their unique identity and perspective. By embracing our differences and learning from one another, we aim to build a positive and empowering environment for all. Tokio Marine Canada was proudly recognized as one of the Best Places to Work in Canada by Canadian HR Reporter in 2024. 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.

Responsibilities

Design, build, and maintain robust ELT pipelines using a medallion architecture to power business insights. Ensure data integrity through automated validation, reconciliation, and the optimization of SQL transformations.