Data Analyst at Tucows analyzing data to generate insights for the Finance team. Collaborating across teams for analytics and reporting.
Responsibilities
Translate ambiguous business questions into precise SQL queries against our Snowflake warehouse.
Own and deliver recurring financial reporting, reconciliation, and operational analytics with an eye for improving efficiency over time.
Go beyond dashboards to explain why metrics move. Conduct root cause analyses, build forecasting models, and support decision-making through churn analysis, customer segmentation, CLV, A/B testing, and similar techniques.
Build, maintain, and optimize Looker dashboards, Explores, and LookML definitions that provide governed, reliable, self-service analytics. Govern the semantic layer — metrics, dimensions, and business logic — that powers trusted reporting and AI-enabled analytics. Train business users to leverage these tools confidently.
Serve as the primary analytical partner to the Finance team. Own financial reporting, reconciliation, and forecasting workflows. Support SOX audits and ITAC testing, ensuring financial data is accurate, auditable, and well-documented.
Monitor and improve data quality across analytical pipelines, especially for finance-critical datasets. Gather requirements from stakeholders, translate business needs into technical specs, and collaborate with Data and Analytics Engineers to resolve upstream issues.
Requirements
3+ years in a Data Analyst, Analytics Engineer, or BI Analyst role in a modern cloud data stack environment.
Advanced SQL including CTEs, window functions, joins, and performance-aware querying in Snowflake or a comparable cloud warehouse.
Hands-on experience with Looker: dashboard development, Explores, LookML, governed metrics, and enabling self-service analytics for business users.
Ability to read, maintain, test, and document dbt models. Familiarity with sources, tests, macros, lineage, and dbt development workflows.
Solid understanding of GL, journal entries, trial balance, financial statements, reconciliations, and period-close processes. SOX/ITAC experience is highly valued.
Working knowledge of dimensional modeling — fact/dimension tables, star schemas, slowly changing dimensions.
Applied experience with regression, classification, A/B testing, segmentation, and forecasting using SQL, Python, or similar tools.
Ability to explain complex analysis clearly to both Finance leadership and technical peers. Strong written and verbal skills.
Comfortable with Git/GitHub: branching, PRs, and collaborative development in a terminal environment.
Experience with LLMs or AI-assisted analytics tools (Claude, Gemini, GPT, Looker Conversational Analytics). Exposure to Cortex Analyst, Cortex Search, or AISQL capabilities. Understanding of MCP integration patterns is a plus.
Senior Manager leading Medline Canada’s Microsoft Fabric data platform and BI strategy. Delivering governed data products and analytics for healthcare operations.
Analyste des données clients chez EDC, société d’État aidant les entreprises canadiennes à réussir à l’étranger. Modernisation des pipelines, tableaux de bord et solutions analytiques marketing.
Customer Data Analyst modernizing EDC’s customer data ecosystem at Canada’s export - finance Crown corporation. Building Microsoft Fabric pipelines, Power BI assets, and marketing analytics solutions.
Senior Data Analyst building trusted financial metrics, dbt models, and Looker dashboards for Jane’s clinic - management SaaS platform. Partnering with Finance and Payments to guide critical decisions.
Digital media specialist improving campaign tracking, reporting and analytics at a Toronto marketing technology lab. Automating insights with AI while maintaining data quality and measurement accuracy.
Data Analytics Intern analyzing new features and updates for Montreal - based mobile gaming studio Ludia. Building data modules, dashboards, and insights to optimize game operations.
Senior Data Analyst transforming Sun Life insurance and financial - services data into actionable marketing insights. Building SQL, Python, AWS, Adobe Analytics, reporting, and dashboard solutions.
Student Data Analyst supporting Sun Life’s financial security mission through stakeholder insights and Tableau KPI reporting. Building data analysis skills during a four - month hybrid campus placement.
Analyste de données principal modernisant les plateformes et pipelines de données d’EDC, société financière publique canadienne. Traduction des besoins opérationnels en modèles, règles de transformation et récits utilisateurs.
Senior Data Analyst modernizing enterprise data capabilities at Export Development Canada. Translating business requirements into data models, mappings, pipelines and Agile delivery artifacts.