Closed listing
Data Analyst
- Canada
Full-time
This opening has closed.
The original listing is kept below for reference.
Job details
- Job type
- Full-time
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
Key Responsibilities
- Collect, clean, validate, and analyze data from multiple sources.
- Develop and maintain reports, dashboards, and data visualizations.
- Write SQL queries to extract and transform data from databases.
- Analyze business data to identify trends, patterns, and opportunities.
- Prepare regular and ad-hoc reports for management and business teams.
- Track key performance indicators (KPIs) and provide actionable insights.
- Perform data validation and quality checks to ensure accuracy.
- Work with business stakeholders to understand reporting and analytical requirements.
- Automate repetitive reporting and data-processing tasks where possible.
- Collaborate with data engineers, developers, finance, marketing, operations, and other teams.
- Present findings and recommendations to both technical and non-technical stakeholders.
- Maintain documentation for reports, dashboards, data sources, and analytical processes.
Required Skills
- Strong knowledge of SQL.
- Advanced knowledge of Microsoft Excel, including PivotTables, VLOOKUP/XLOOKUP, formulas, and data analysis.
- Experience with data visualization tools such as Power BI or Tableau.
- Understanding of data cleaning, transformation, and validation.
- Basic understanding of statistics and analytical techniques.
- Strong analytical and problem-solving skills.
- Ability to interpret large datasets and communicate meaningful insights.
- Good written and verbal communication skills.
Preferred Skills
- Experience with Python or R for data analysis.
- Knowledge of Power BI DAX and Power Query.
- Experience working with databases such as MySQL, PostgreSQL, or SQL Server.
- Familiarity with ETL/ELT concepts.
- Knowledge of business intelligence and reporting processes.
- Experience with cloud data platforms such as Azure, AWS, or Google Cloud.
- Familiarity with data warehousing concepts.
More about this job
Responsibilities
Collect, clean, validate, and analyze data from multiple sources; create and maintain reports, dashboards, and visualizations; and track KPIs to identify trends and provide actionable insights. Collaborate with stakeholders and cross-functional teams, automate reporting where possible, document analytical processes, and present findings to technical and non-technical audiences.
Requirements
Requires strong SQL skills, advanced Excel knowledge, experience with Power BI or Tableau, and understanding of data cleaning, transformation, validation, and basic statistics. Strong analytical, problem-solving, and communication skills are required; Python or R, DAX, Power Query, database experience, ETL/ELT, cloud platforms, and data warehousing are preferred.
Skills
- SQL
- Microsoft Excel
- Power BI
- Tableau
- Data Cleaning
- Data Transformation
- Data Validation
- Data Visualization
- Statistical Analysis
- Analytical Problem-Solving
- Python
- R
- DAX
- Power Query
- ETL/ELT
- Data Warehousing
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
Keywords
- SQL
- Microsoft Excel
- PivotTables
- VLOOKUP
- XLOOKUP
- Power BI
- Tableau
- Python
- R
- DAX
- Power Query
- MySQL
- PostgreSQL
- SQL Server
- ETL/ELT
- Azure
- AWS
- Google Cloud
- Data Warehousing
- Business Intelligence
- Data Analysis
- Data Cleaning
- Data Transformation
- Data Validation
- Data Visualization
- Dashboards
- Reporting
- KPIs
- Statistics
- Data Quality