Data Analyst
- Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Posting language
- English
- Posted
Original job description
Key Responsibilities
- Collect, clean, validate, and transform data from multiple sources.
- Write SQL queries to extract, filter, join, and aggregate data from databases.
- Analyze datasets to identify trends, patterns, anomalies, and business opportunities.
- Develop interactive dashboards and reports using Power BI or Tableau.
- Use Microsoft Excel for data analysis, reporting, PivotTables, and lookup functions.
- Track key performance indicators (KPIs) and prepare periodic business reports.
- Perform data quality checks to ensure accuracy and consistency.
- Collaborate with business stakeholders to understand reporting and analytical requirements.
- Present findings and recommendations to support data-driven decision-making.
- Maintain documentation and follow data governance and confidentiality standards.
Required Technical Skills
- SQL: Joins, subqueries, aggregate functions, CTEs, and basic window functions.
- Microsoft Excel: PivotTables, XLOOKUP/VLOOKUP, IF functions, charts, and data cleaning.
- Power BI or Tableau: Dashboard development, data visualization, and reporting.
- Data Analysis: Data cleaning, exploratory data analysis, trend analysis, and KPI reporting.
- Statistics: Basic descriptive statistics, averages, percentages, and correlation concepts.
- Communication: Ability to explain analytical findings clearly to technical and non-technical stakeholders.
Preferred Skills
- Basic Python knowledge using Pandas and NumPy.
- Experience with relational databases such as MySQL, SQL Server, or PostgreSQL.
- Understanding of data modeling, ETL concepts, and data warehousing.
- Familiarity with business intelligence and reporting processes.
- Academic projects, internships, or practical experience in data analytics.
More about this job
Responsibilities
Collect, clean, validate, transform, and analyze data from multiple sources, using SQL, Excel, and business intelligence tools to create dashboards and reports. Track KPIs, ensure data quality, collaborate with stakeholders, and present findings and recommendations to support data-driven decisions.
Requirements
Requires SQL, Excel, Power BI or Tableau, data analysis, basic statistics, and the ability to communicate findings to technical and non-technical stakeholders. Preferred qualifications include basic Python with Pandas and NumPy, relational database experience, knowledge of data modeling, ETL and data warehousing, and practical analytics experience.
Skills
- SQL
- Microsoft Excel
- Power BI
- Tableau
- Data Cleaning
- Data Analysis
- Data Visualization
- Dashboard Development
- KPI Reporting
- Exploratory Data Analysis
- Basic Statistics
- Python
- Pandas
- NumPy
- Communication
- Data Quality
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
Keywords
- SQL
- Microsoft Excel
- Power BI
- Tableau
- Python
- Pandas
- NumPy
- MySQL
- SQL Server
- PostgreSQL
- Data Cleaning
- Data Validation
- Data Transformation
- Data Analysis
- Exploratory Data Analysis
- Trend Analysis
- KPI Reporting
- Dashboard Development
- Data Visualization
- PivotTables
- XLOOKUP
- VLOOKUP
- Data Quality
- Descriptive Statistics
- Data Modeling
- ETL
- Data Warehousing
- Business Intelligence
- Data Governance
- Relational Databases