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 analyze structured data from multiple sources.
- Write SQL queries to extract, manipulate, and analyze data from databases.
- Develop and maintain dashboards, reports, and visualizations using Power BI or Tableau.
- Perform data validation, identify inconsistencies, and ensure data accuracy.
- Analyze trends, patterns, and key performance indicators (KPIs) to support business objectives.
- Prepare periodic, ad hoc, and management reports.
- Use Excel functions, PivotTables, lookups, and other analytical tools for data analysis.
- Collaborate with business stakeholders to understand reporting requirements and translate them into analytical solutions.
- Identify opportunities for process improvement through data analysis.
- Document data definitions, reporting processes, and analytical findings.
- Present insights and recommendations to technical and non-technical stakeholders.
- Support data-driven decision-making through accurate and timely reporting.
Required Skills and Qualifications
- Strong proficiency in SQL, including joins, subqueries, aggregations, and CTEs.
- Advanced Microsoft Excel skills, including PivotTables, lookup functions, and data cleansing.
- Hands-on experience with Power BI or Tableau for dashboard development and data visualization.
- Strong understanding of data cleaning, data validation, and exploratory data analysis.
- Knowledge of KPIs, business metrics, trend analysis, and statistical concepts.
- Ability to interpret complex data and communicate actionable insights.
- Excellent analytical thinking, attention to detail, and problem-solving skills.
- Good communication and stakeholder management skills.
Preferred Skills
- Knowledge of Python for data analysis using Pandas and NumPy.
- Familiarity with statistical analysis and hypothesis testing.
- Experience with data warehousing, ETL processes, and data integration.
- Exposure to cloud data platforms such as Azure, AWS, or Google Cloud.
- Knowledge of automation and reporting optimization.
More about this job
Responsibilities
Collect, clean, validate, and analyze data from multiple sources, using SQL, Excel, and visualization tools to create dashboards and reports. Identify trends and process improvements, document analytical work, and communicate actionable insights to stakeholders to support business decisions.
Requirements
Requires strong SQL and advanced Excel skills, experience with Power BI or Tableau, and knowledge of data cleaning, validation, exploratory analysis, KPIs, and business metrics. Candidates should be analytical, detail-oriented communicators; Python, statistical testing, data warehousing, ETL, cloud platforms, and reporting automation are preferred.
Skills
- SQL
- Microsoft Excel
- Power BI
- Tableau
- Data Cleaning
- Data Validation
- Exploratory Data Analysis
- KPI Analysis
- Trend Analysis
- Data Visualization
- Dashboard Development
- Python
- Pandas
- NumPy
- Statistical Analysis
- Stakeholder Communication
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
Keywords
- SQL
- Microsoft Excel
- Power BI
- Tableau
- Python
- Pandas
- NumPy
- Data Cleaning
- Data Validation
- Exploratory Data Analysis
- Dashboards
- Data Visualization
- KPIs
- Business Metrics
- Trend Analysis
- Statistical Analysis
- Hypothesis Testing
- Data Warehousing
- ETL
- Data Integration
- Azure
- AWS
- Google Cloud
- Reporting Automation
- Stakeholder Management