Data Analyst

Spait Infotech

Canada

On-site

CAD 65,000 - 90,000

Full time

19 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Spait Infotech in Canada is seeking a Data Analyst to collect, clean, and analyze data from multiple sources, turning raw data into actionable insights. You will identify trends and generate regular reports to support decision-making.

You will build interactive dashboards in Power BI or Tableau, write SQL queries, and help stakeholders understand complex data. Proficiency in Excel and Python, along with strong communication, problem solving, and meticulous attention to detail, is essential.

Qualifications

  • Experience in data collection, cleaning, and analysis.
  • Ability to write SQL queries to retrieve and manipulate data.
  • Experience creating dashboards in Power BI or Tableau.
  • Proficiency in Excel for data manipulation.
  • Knowledge of statistics basics.
  • Strong communication of insights to stakeholders.

Responsibilities

  • Collect and analyze data from multiple sources.
  • Clean, validate, and transform raw datasets.
  • Identify trends and business insights.
  • Write SQL queries to retrieve data.
  • Create interactive dashboards and reports.
  • Prepare daily, weekly, and monthly reports.
  • Monitor KPIs and business metrics.
  • Collaborate with teams to understand requirements.
  • Present findings and recommendations to stakeholders.

Skills

Analytical thinking
Problem solving
Attention to detail
Communication skills
Time management
Teamwork
Willingness to learn

Tools

SQL
Python
Power BI
Tableau
Excel

Job description

  • Collect, extract, and analyze data from multiple sources.
  • Clean, validate, and transform raw datasets.
  • Identify trends, patterns, and business insights from data.
  • Write SQL queries to retrieve and manipulate data.
  • Create interactive dashboards and reports using Power BI or Tableau.
  • Perform data analysis using Microsoft Excel and Python.
  • Prepare daily, weekly, and monthly reports.
  • Monitor key performance indicators (KPIs) and business metrics.
  • Identify data inconsistencies and ensure data accuracy.
  • Collaborate with different teams to understand business requirements.
  • Present analytical findings and recommendations to stakeholders.

Technical Skills Required

  • Microsoft Excel: VLOOKUP, XLOOKUP, Pivot Tables, Conditional Formatting, and Charts.
  • SQL: SELECT, WHERE, GROUP BY, ORDER BY, JOINs, Subqueries, CTEs, and Aggregate Functions.
  • Python: Pandas, NumPy, Matplotlib, and Seaborn.
  • Power BI: Dashboard Creation, DAX, Power Query, and Data Modeling.
  • Tableau: Data Visualization and Dashboard Development.
  • Statistics: Mean, Median, Mode, Standard Deviation, and Probability.
  • Data Cleaning: Handling missing values, duplicate records, and inconsistent data.
  • Data Visualization: Creating charts, graphs, and reports.

Soft Skills

  • Strong analytical and problem-solving skills.
  • Good verbal and written communication skills.
  • Attention to detail and accuracy.
  • Ability to interpret complex data.
  • Time management and organizational skills.
  • Ability to work independently and in a team.
  • Willingness to learn new tools and technologies.

Key Performance Indicators (KPIs)

  • Accuracy and quality of data analysis.
  • Timely delivery of reports and dashboards.
  • Efficiency in data cleaning and processing.
  • Accuracy of business insights and recommendations.
  • Dashboard performance and reporting efficiency.
  • Ability to meet business reporting requirements.

Preferred Skills

  • Knowledge of ETL processes.
  • Understanding of data warehousing concepts.
  • Basic knowledge of cloud platforms such as AWS, Azure, or Google Cloud.
  • Familiarity with business intelligence tools.
  • Experience working with large datasets.
  • Cleaned and structured datasets.
  • SQL queries and data extraction reports.
  • Weekly and monthly analytical reports.
  • Business performance analysis.
  • Data-driven insights and recommendations.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Intelligence Analyst
Business Intelligence Analyst

Spait Infotech • Canada

On-site
CAD 75,000 - 110,000
Data Analyst- Power BI, Tableau, SQL.
Data Analyst- Power BI, Tableau, SQL.

Astra-North Infoteck Inc. • Mississauga

On-site
CAD 70,000 - 90,000
Data Analyst
Data Analyst

Inizio Partners Corp • Toronto

On-site
CAD 90,000 - 130,000
Data Reporting Analyst
Data Reporting Analyst

Compunnel Inc. • Southwestern Ontario

On-site
CAD 55,000 - 65,000
Power BI Developer
Power BI Developer

Precision Technologies • Mississauga

On-site
CAD 110,000 - 140,000
Data Analyst- Power BI, Tableau, SQL
Data Analyst- Power BI, Tableau, SQL

Astra-North Infoteck Inc. • Mississauga

On-site
CAD 65,000 - 90,000
Business Intelligence Analyst
Business Intelligence Analyst

Wandata Tech • Toronto

On-site
CAD 65,000 - 90,000
Junior Data Insights & Power BI Analyst
Junior Data Insights & Power BI Analyst

Compunnel Inc. • Southwestern Ontario

On-site
CAD 55,000 - 65,000
Data Analyst
Data Analyst

Athenix Technologies • Canada

Hybrid
CAD 60,000 - 85,000
Competitive salary and benefits
Flexible work environment
Learning and development opportunities
+2
Data Office Developer (SQL , Python, Data Engineering , Data Warehousing)
Data Office Developer (SQL , Python, Data Engineering , Data Warehousing)

Astra-North Infoteck Inc. • Toronto

On-site
CAD 90,000 - 130,000