Data Lead (Canada)

Role overview

Responsibilities

• Write, review, and debug SQL and Python, including AI-generated code, to build and maintain analytical data models.
• Design semantic layers and reusable models in BI tools such as Looker, Tableau, or Power BI.
• Integrate and reconcile data across systems and business units, aligning metric definitions and customer and product master data.
• Validate data and investigate discrepancies across ERP, web analytics, and other sources.
• Scope requests and assess feasibility, effort, and trade-offs; set realistic delivery expectations.
• Define KPIs and translate business questions into actionable analytical recommendations.
• Use AI tools such as Claude Code or Codex for analysis, coding, and documentation, while validating outputs.
• Partner with data engineering, business stakeholders, and vendors to deliver insights and maintain data quality.

Required qualifications

• Strong SQL and Python skills, including writing, reviewing, and debugging AI-generated code.
• Experience with cloud data warehouses such as BigQuery, Snowflake, or Redshift, and data modeling.
• Familiarity with ERP and web analytics sources, such as NetSuite and Google Analytics.
• Understanding of ETL/ELT, data warehousing, and orchestration tools such as Airflow.
• Experience integrating and reconciling data, with strong validation and governance practices.
• Proficiency in at least one of Looker, Tableau, or Power BI, including semantic layers or reusable models.
• Fluency with AI coding and analysis tools and the judgment to validate outputs.
• Business acumen, KPI definition experience, and ability to work with stakeholders and external vendors.
• Statistics and experimentation, AI-assisted analytics workflow, and e-commerce, retail, or marketing analytics experience are preferred.

Workplace

• Hybrid role in Canada; Toronto is preferred.
• The interview process includes a mandatory in-person interview at a hub office in Salt Lake City, Austin, or Toronto.

About CSC Generation

Hiring notes

• This is an existing vacancy and cannot be filled by a B.C. resident.
• Employment is contingent on a background check, including verification of prior employment dates.
• Candidates must provide a LinkedIn profile URL or an explanation and alternative professional-background evidence.