Data Engineer – Level 3
Position Summary
Do you thrive in solving complex business and technical problems? Are you driven to search for insight though data patterns and models? Are you passionate about surfacing business needs through technical solutions? We are seeking an experienced, detail-oriented and analytical Senior Data Engineer to join our fast-growing Insurtech team and support the development and evolution of our products. Our aim is to continuously enhance our products to enable seamless and frictionless interactions for our clients.
In this role, you will consult and contribute to the development and maintenance of data pipelines and processes. Individuals in the role will use their experience to expand and optimize the current data stack and toolkit to ensure reliable, secure, and efficient data solutions.
You will work cross-functionally with stakeholders, product managers, and engineers to ensure data solutions are well-defined, scalable, and aligned with business goals. This role is ideal for a data professional who thrives on designing, building, and optimizing data systems that drive business insights and product innovation.
Key Responsibilities
Data Ingestion and Processing: Consult, design, develop and implement data integration solutions to enable processing by downstream applications.
Data Lake Management: Build and maintain data lakes on S3, Postgres databases, AWS Glue Catalogues and DuckLake using various file formats such as Parquet, Avro, JSON, and CSV.
Data Validation and Reconciliation: Validate and triage the outputs of data pipelines and processes.
Advanced Data Modeling:
Build and maintain DAGs (Directed Acyclic Graphs) for orchestrating workflows and data processing.
Apply Entity-Relationship (ER) modeling for structured database design.
Develop dimensional models to support analytics and reporting.
Utilize graph data modeling for complex relationships and advanced queries
Workflow development and Automation: Develop, manage and optimize the orchestration of multistage data processing workflows. Identify and automate new data processes. Experience using Apache Airflow, AWS Step Functions or other orchestration tools preferred.
Develop and deploy data pipelines in line with CI/CD best practices
Code Development: Write and review readable, maintainable code aiming to optimize the reliability, scalability and maintainability of our data platform.
Research and perform POCs to continually improve data stack offerings and processes
Collaborate with cross-functional teams to analyze, develop, test, and deploy solutions aiming to enhance product offerings
Ability to understand and translate business requirements to objective development goals and functionality.
Provide operational support with diagnosing and resolution of Sev-1/Sev-2 incidents and provide guidance to resolve product bugs.
Qualifications
Bachelor's degree or equivalent in the field of Computer Science or Engineering, or graduate research experience with a strong emphasis on experimental design and data collection and analysis
5+ years of experience developing data solutions, optimizing or developing automated data workflows and modernizing data stacks.
3+ years of consulting experience working on project-based delivery and/or product development
5+ years of development using Python, PySpark and SQL
3+ years of experience with handling and developing using AWS cloud infrastructure and services including AWS Glue, AWS Lambda, AWS Batch.
Experience with using various data management systems
Experience working with structured, semi-structured, and unstructured data
Experience working with high and low latency data movement (batch and real-time data)
Experience with data modelling, data mart, data lakehouse architecture, SCD, data mesh, and delta lake overall.
Strong written and verbal communication skills.
Nice-To-Haves
Comfortable balancing multiple priorities in a fast-paced environment.
Experience in SaaS, data-intensive products, or within the P&C Insurance industry is a strong asset.
AWS Solutions Architect or AWS Data Engineer Certification is an asset
Why Join Us?
Be part of a purpose-driven company transforming the insurance landscape.
Work on high-impact initiatives with a collaborative, high-performing team.
Opportunity to grow your skills across business systems analysis, data, and operations in a modern tech stack.
Flexible hybrid work model with occasional travel to client sites.
Working Environment
Established company with a great start-up culture
Hybrid work model
Located in the heart of Downtown Toronto, 7-minute walk from Union Station
How to Apply: If you are ready to take on an exciting new challenge and help drive innovation in the insurance industry, we would love to hear from you! Please submit your resume and cover letter to jobs@hubio.com with the subject line "Senior Data Engineer".