Senior Data Engineer
$90,000–$110,000 year
HybridMarkham, Ontario, Canada
Job Summary
Design, develop, and optimize scalable data pipelines and analytical datasets using Snowflake and Qlik. Own end-to-end delivery of data solutions from requirements through implementation and support, while defining best practices for data modeling, performance optimization, and cost-efficient architecture. Automate data ingestion and transformation workflows, integrating data from multiple source systems. Monitor, troubleshoot, and resolve data pipeline and reporting issues to ensure reliability, performance, and availability. Collaborate with claims operations, analytics, and actuarial teams to translate business needs into robust data solutions. This role supports the modernization of the Claims Data ecosystem and migration to Snowflake within the Claims Data and Insights team at Aviva Canada.
Required Qualifications
- Minimum 3 years of experience in data engineering, analytics, or a related technical role
- Strong communication skills, with the ability to clearly explain complex technical concepts to non-technical audience
- A collaborative approach, balanced with the ability to work independently and take ownership of deliverables
- A strong sense of accountability and ownership, with a consistent focus on delivering results
- Strong analytic and problem-solving skills with the ability to work through the technical implementation details while appreciating the big picture
- Proficiency in Python and SQL, with experience working with complex data models
- Hands-on experience with cloud data warehouses (Snowflake preferred)
- Experience building, maintaining, and debugging ETL/ELT data pipelines
- Familiarity with P&C insurance and claims data
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.