Analytics Engineer

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 Youll 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 Youll 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
• Strong 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

View all of our open jobs here: