Lighthouse Technology Services is partnering with our client to fill their Analytics Engineer position! This is a 3 month contract-to-hire opportunity and will be hybrid 4 days on site in Toronto, Canada.

This role will be a W2 employee of Lighthouse Technology Services. No C2C or subcontracting arrangements will be considered.

What You'll Be Doing:

- Lead financial closure initiatives with POS data, partnering with Finance teams to onboard new payment vendors
- Design, build, and maintain scalable data transformation pipelines using dbt to support analytics, reporting, and data science initiatives
- Develop and implement data models in Snowflake that improve data consistency, accuracy, and performance across business domains
- Orchestrate data workflows in Airflow, ensuring data lands accurately for operational teams to make timely decisions
- Establish and maintain data quality checks, testing frameworks, and validation processes to ensure reliable data across the organization
- Collaborate with cross-functional teams including data engineering, product managers, and QA to resolve data issues and deliver trusted solutions
- Monitor and troubleshoot data pipeline failures, performance issues, and discrepancies to maintain system reliability
- Proactively push back on stakeholders regarding unrealistic timelines,



helping teams align on achievable delivery schedules
- Develop clear technical documentation including data models, lineage, transformation logic, and pipeline processes
- Promote analytics engineering best practices through daily standups, code reviews, and knowledge sharing sessions

What You'll Need to Have:

- 3+ years of analytics engineering, data engineering, or business intelligence engineering experience
- Strong SQL skills with hands-on experience building and maintaining complex data models
- Demonstrated expertise with dbt (Data Build Tool) for managing data transformations
- Experience working with Snowflake or similar enterprise cloud data warehouses
- Proficiency with Git/GitHub for version control and peer code reviews
- Solid understanding of dimensional data modeling, ELT workflows, and modern analytics architectures
- Experience with AI-assisted development tools (Cursor or similar AI agents)
- Excellent attention to detail when working with multiple payment vendors and complex data domains
- Proven ability to communicate effectively with stakeholders and confidently challenge timelines when needed

Pay Range: $35-37/hr CAD Questions about any of our jobs? Email us at [email protected]

View all of our open jobs here: jobs.lhtservices.com

📌 Analytics Engineer (Toronto)
🏢 Lighthouse Technology Services
📍 Toronto