Data Analyst
- Toronto, ON, Canada
Salary Range: $50,000–$70,000 annually, depending on experience and qualifications. · Full-time
Applications open in a new tab.
Job details
- Pay
- Salary Range: $50,000–$70,000 annually, depending on experience and qualifications.
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
Junior Data Analyst
Location: Toronto, ON
Employment Type: Full-Time
Experience Level: Junior / Entry Level (0–2 years)
About the Role
We are looking for a curious, detail-oriented Junior Data Analyst to support our growing analytics and reporting needs.You will work closely with the Business Intelligence Lead and cross-functional teams including Field Operations, Client Services, Finance, and leadership. The role combines reporting, data quality, and business analysis, with a strong focus on understanding not only what is happening in the data, but why.
What You’ll Do
- Monitor key performance indicators (KPIs), identify trends and anomalies, and investigate changes in business performance.
- Conduct root-cause analysis by drilling into performance across clients, campaigns, markets, offices, teams, and individual representatives.
- Work with Field Operations and Client Services to validate findings and understand the operational drivers behind performance.
- Support the development and maintenance of dashboards, reports, and analytical tools.
- Write and maintain SQL queries to extract, clean, join, aggregate, and analyze data.
- Prepare, import, clean, transform, and reconcile datasets from multiple sources.
- Perform regular data-quality checks and investigate missing, duplicated, inconsistent, or unexpected records.
- Validate reports and analytical outputs before distribution and support processes that improve data accuracy and reliability.
- Perform ad-hoc analysis to answer business questions and support decision-making.
What We’re Looking For
- Bachelor’s degree or diploma in Data Analytics, Business Analytics, Statistics, Computer Science, Information Systems, Economics, or a related quantitative field.
- 1-2 years of experience in data analysis, business intelligence, reporting, or a related role.
- Working knowledge of SQL and relational databases.
- Strong Excel skills, including formulas, pivot tables, lookups, and data manipulation.
- Experience with a BI/visualization platform such as Power BI, Tableau, or Zoho Analytics.
- Understanding of data cleaning, joins, aggregations, segmentation, and KPI analysis.
- Strong analytical and problem-solving skills with high attention to detail.
- Ability to communicate findings clearly and collaborate with technical and non-technical teams.
Nice to Have: Experience with Zoho Analytics, Python, APIs/workflow automation, or CRM, fundraising, financial, sales, or transaction data.
- Salary Range: $50,000–$70,000 annually, depending on experience and qualifications.
More about this job
Responsibilities
Monitor KPIs, investigate trends and anomalies, and conduct root-cause analysis across clients, campaigns, markets, offices, teams, and representatives. Maintain SQL queries, dashboards, and reports; prepare and validate data from multiple sources; and provide ad hoc analysis to support business decisions.
Requirements
A bachelor's degree or diploma in a quantitative or related field and 1–2 years of experience in data analysis, business intelligence, reporting, or a related role are requested. Candidates should have working knowledge of SQL and relational databases, strong Excel skills, experience with a BI platform, and the ability to analyze data carefully and communicate findings clearly.
Skills
- SQL
- Relational Databases
- Excel
- Power BI
- Tableau
- Zoho Analytics
- Data Cleaning
- Data Quality
- KPI Analysis
- Root-Cause Analysis
- Dashboard Development
- Reporting
- Data Visualization
- Data Reconciliation
- Analytical Problem-Solving
- Cross-Functional Communication
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Finance & Accounting
Keywords
- SQL
- Relational Databases
- Excel
- Power BI
- Tableau
- Zoho Analytics
- Python
- APIs
- Workflow Automation
- CRM Data
- Fundraising Data
- Financial Data
- Sales Data
- Transaction Data
- Business Intelligence
- Data Analytics
- KPI Analysis
- Root-Cause Analysis
- Data Cleaning
- Data Transformation
- Data Reconciliation
- Data Quality Checks
- Dashboard Development
- Reporting
- Data Visualization
- Segmentation
- Ad Hoc Analysis