Data Analyst

3 days ago

Ottawa ON, Ottawa Census Division, ON; Ontario, Canada Spait Infotech Full-time
  • 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.