BSA/ Tech Lead

About

This is a 12-month contract role for a BSA/Tech Lead in Toronto.

Responsibilities

• Lead business and systems analysis for enterprise?scale data warehousing and analytics initiatives.
• Partner with business stakeholders to gather, analyze, and document requirements for data and reporting solutions.
• Translate business needs into functional and technical specifications, including BRDs, FRDs, and data mappings.
• Serve as a technical lead, guiding data warehouse design decisions and best practices.
• Design, review, and optimize dimensional data models (facts, dimensions, star/snowflake schemas).
• Write, optimize, and review complex SQL queries for analysis, validation, and performance tuning.
• Collaborate with Data Engineers, BI Developers, and Architects to deliver scalable, high?quality solutions.
• Support ETL/ELT pipeline design, data integration, reconciliation, quality, and lineage.
• Act as a liaison between business, engineering, and analytics teams; support UAT and agile ceremonies.

Qualifications

• 8+ years of experience with strong SQL, data warehousing expertise, and excellent communication and documentation skills.