ERP Data Analyst designing Excel and SQL reporting solutions for Velixo’s ERP software customers. Demonstrating product capabilities, developing reports, and training clients, partners, and colleagues.
About the role
- 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.
Benefits
- Health insurance
- Retirement plans
- Paid time off
- Flexible work arrangements
- Professional development opportunities
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
LP
Analyst, Data & Analytics
LinkedIn Recruiter Post
Canada Life seeks an Analyst, Data & Analytics to transform data into insights, build dashboards, and support business decisions in a hybrid Toronto or London, Ontario role.
LP
FinOps Data Analyst
LinkedIn Recruiter Post
Hiring FinOps Data Analyst for 1 - year contract in Toronto. Requires SQL, Excel, cloud cost analytics, and experience with AWS/Azure/GCP.
LP
Data Analyst
LinkedIn Recruiter Post
Hiring a Data Analyst for a hybrid contract role in Toronto. Requires 5+ years in data migration, strong SQL and Power BI, and experience with data quality and governance.
Data Analyst building AWS data platforms and pipelines for Sun Life, a financial services and insurance company. Delivering governed analytics, reporting, and insights across business functions.
People Analytics Data Analyst helping Dropbox improve hiring through Talent Acquisition metrics and workforce insights. Partnering with People teams and leaders to analyze complex data, improve efficiency, quality, and equity.
LP
Fraud Data Analyst
LinkedIn Recruiter Post
Hiring a Fraud Data Analyst for a 12 - month contract in Toronto, ON. Requires 5+ years in data/analytics with fraud, AML, and threat detection experience.
LP
Data Entry Specialist
LinkedIn Recruiter Post
Hiring Data Entry Specialists for a 3 - month contract in GTA. Onsite, $19.45/hour, with paid training and no customer calls.
Senior Data Analyst building financial models and Looker dashboards for Jane’s healthcare practice management platform. Supporting Finance and Payments with trusted revenue, billing, and transaction insights.
Senior Data Analyst building AI - enabled Tableau analytics for Sun Life, a global financial services company. Developing trusted metrics, data models, dashboards, and sales insights.