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, and validate data from multiple sources.
- Analyze large datasets to identify trends, patterns, and business insights.
- Write SQL queries to extract and manipulate data.
- Create dashboards and reports using Power BI or Tableau.
- Perform data cleaning, transformation, and validation.
- Prepare daily, weekly, and monthly MIS reports.
- Identify business performance trends and key metrics (KPIs).
- Collaborate with business teams to understand data requirements.
- Present analytical findings to stakeholders.
- Ensure data accuracy, consistency, and integrity.
Required Skills
- Advanced Microsoft Excel (VLOOKUP, XLOOKUP, Pivot Tables).
- SQL (Joins, Subqueries, CTEs, Aggregate Functions).
- Power BI / Tableau.
- Basic Python (Pandas, NumPy) – preferred.
- Data visualization and reporting.
- Statistical analysis and problem-solving.
- Strong communication and presentation skills.
More about this job
Responsibilities
Collect, clean, validate, and analyze data from multiple sources to identify trends, patterns, business insights, and KPIs. Create dashboards and reports, prepare recurring MIS reports, collaborate with business teams, and present findings to stakeholders while ensuring data accuracy and integrity.
Requirements
Requires advanced Excel skills, SQL proficiency, and experience with Power BI or Tableau, along with data visualization, reporting, statistical analysis, and problem-solving abilities. Basic Python with Pandas and NumPy is preferred, as are strong communication and presentation skills.
Skills
- Microsoft Excel
- VLOOKUP
- XLOOKUP
- Pivot Tables
- SQL
- Joins
- Subqueries
- CTEs
- Aggregate Functions
- Power BI
- Tableau
- Python
- Pandas
- NumPy
- Data Visualization
- Statistical Analysis
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
Keywords
- Data Analysis
- Data Collection
- Data Cleaning
- Data Validation
- Data Transformation
- Large Datasets
- Business Insights
- SQL
- Microsoft Excel
- VLOOKUP
- XLOOKUP
- Pivot Tables
- Power BI
- Tableau
- Python
- Pandas
- NumPy
- Dashboards
- Data Visualization
- MIS Reports
- KPIs
- Statistical Analysis
- Problem-Solving
- Data Accuracy
- Data Integrity
- Stakeholder Presentations
- Software Development