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 data from multiple sources.
- Identify trends, patterns, and insights to support business decisions.
- Develop interactive dashboards and reports using Power BI or Tableau.
- Write and optimize SQL queries to extract and manipulate data.
- Perform data cleaning, transformation, and validation.
- Analyze large datasets to identify business opportunities and challenges.
- Prepare regular reports and present findings to stakeholders.
- Monitor key performance indicators (KPIs) and business metrics.
- Collaborate with business teams, data engineers, and management.
- Ensure data accuracy, consistency, and integrity.
- Automate routine reporting and data analysis tasks.
- Maintain documentation of reports, dashboards, and analytical processes.
Required Technical Skills
- Strong knowledge of Microsoft Excel, including Pivot Tables and VLOOKUP/XLOOKUP.
- Good understanding of SQL and database management.
- Knowledge of Python or R for data analysis.
- Experience with Power BI or Tableau.
- Understanding of data visualization and dashboard development.
- Knowledge of statistics and analytical techniques.
- Familiarity with data cleaning and data preprocessing.
- Understanding of databases such as MySQL, SQL Server, or PostgreSQL.
- Knowledge of data modeling and reporting techniques.
- Familiarity with business intelligence concepts.
Required Soft Skills
- Strong analytical and problem-solving abilities.
- Excellent attention to detail.
- Good verbal and written communication skills.
- Ability to interpret and present complex data clearly.
- Strong teamwork and collaboration skills.
- Ability to manage multiple tasks and meet deadlines.
Preferred Qualifications
- Experience working with real-world datasets.
- Knowledge of advanced Excel and statistical analysis.
- Familiarity with cloud-based data platforms.
- Understanding of ETL processes and data warehousing.
- Experience with dashboard automation and reporting.
- Knowledge of Agile methodologies.
More about this job
Responsibilities
Collect, clean, validate, and analyze data from multiple sources to identify trends and insights that support business decisions. Develop dashboards and reports, monitor KPIs, present findings to stakeholders, automate routine analysis, and collaborate with business and data teams.
Requirements
Requires strong Excel skills, SQL and database knowledge, and familiarity with Python or R, Power BI or Tableau, statistics, data visualization, and data preprocessing. Strong analytical, communication, teamwork, and organizational abilities are expected; preferred qualifications include experience with real-world datasets, cloud platforms, ETL, data warehousing, and Agile.
Skills
- Data Analysis
- Microsoft Excel
- SQL
- Python
- R
- Power BI
- Tableau
- Data Visualization
- Statistics
- Data Cleaning
- Data Preprocessing
- Database Management
- Data Modeling
- Dashboard Development
- Communication
- Problem-Solving
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
Keywords
- Microsoft Excel
- Pivot Tables
- VLOOKUP
- XLOOKUP
- SQL
- Python
- R
- Power BI
- Tableau
- Data Analysis
- Data Cleaning
- Data Validation
- Data Transformation
- Data Visualization
- Dashboard Development
- Statistics
- Analytical Techniques
- MySQL
- SQL Server
- PostgreSQL
- Data Modeling
- Business Intelligence
- KPI Monitoring
- Reporting Automation
- Cloud-Based Data Platforms
- ETL
- Data Warehousing
- Agile Methodologies