Lioness Strategic Solutions
Toronto, ON
Détails de l'emploi :
Avantages :
We are seeking a Senior Data Engineer to join a Data, AI & Analytics team. This role is ideal for someone who has a strong background in building scalable data pipelines, working with modern data warehousing platforms, and supporting production data environments.
The successful candidate will have a deep understanding of database concepts, data pipeline design, and modern ELT/ETL practices. They should also be able to communicate complex technical ideas clearly and deliver scalable data solutions that support business outcomes.
What You Will Do- Design, build, and optimize highly scalable and reliable data pipelines to support ELT/ETL processes across diverse source systems and platforms.
- Develop reusable frameworks and automation to standardize data ingestion, transformation, reconciliation, testing, and monitoring.
- Perform thorough code reviews to ensure solutions meet performance, scalability, security, and maintainability standards.
- Define, document, and enforce data engineering standards for the platform.
- Partner closely with business and analytics stakeholders to translate requirements into scalable technical solutions.
- Maintain and improve CI/CD pipelines for data platforms, including source control, build, test, and deployment workflows.
- Troubleshoot and resolve production issues such as data quality defects, pipeline failures, performance bottlenecks, and dependency breaks.
- Proactively identify opportunities to optimize and improve existing pipelines for reliability, observability, and operational efficiency.
- 8+ years of hands-on experience in data engineering, building and operating scalable ELT/ETL pipelines and data integration solutions.
- 4+ years of experience with data warehousing and Snowflake.
- Strong SQL expertise.
- Solid experience with dbt, including model design and testing.
- Experience with CI/CD pipelines for data platforms, including source control, automated testing, and deployments.
- Experience with tools such as Bitbucket, Jenkins, Git, or similar.
- Strong understanding of data architecture and data modeling.
- Ability to diagnose and solve complex, open-ended problems and deliver production-ready solutions.
- Experience supporting production data platforms, including troubleshooting performance and pipeline reliability issues.
- Experience with Data Vault 2.0.
- Experience in the Financial Services industry.
- Experience working in a highly regulated environment.
- Experience improving data platform reliability, observability, and automation.
This role follows a hybrid/in-office work model and requires onsite presence four days per week to support collaboration and business needs.
Compensation and BenefitsThe anticipated base salary range for this position is $69,500 - $119,500, depending on experience, skills, education, budget, and geographic location. This position may also be eligible for participation in a bonus program.
The company offers a competitive benefits package, which may include health and wellness benefits, life and disability insurance, retirement savings programs, paid leave, vacation time, holidays, education-related programs, professional development support, and other employee programs.
Additional Benefits May Include- Modern office location within walking distance of Union Station
- Training reimbursement
- Paid professional designations
- Employee savings plan
- Corporate discount program
- Enhanced group benefits
- Parental leave top-up program
- Paid time off for volunteering
This opportunity is with a well-established financial services organization that values collaboration, innovation, continuous learning, and employee growth. The team works in a fast-paced environment where employees are encouraged to take ownership of meaningful work, contribute ideas, and support modern data and analytics initiatives.
The organization is committed to building a diverse and inclusive workforce. Candidates who are excited about the role are encouraged to apply, even if they do not meet every qualification listed.