Data & Reporting Analyst
STACK IT Recruitment•Toronto, ON
•CA$70,000 - CA$80,000•Onsite
About The Position
We’re hiring a Data & Reporting Analyst to join a well-established, collaborative organization where data plays a critical role in supporting business operations, reporting, and decision-making across multiple departments. This is an opportunity for someone who thrives in a fast-paced environment and enjoys working across reporting, business intelligence, data warehousing, and analytics. You’ll work closely with business users to understand reporting needs, build scalable reporting solutions, and help improve how data is leveraged across the organization.
Requirements
- 4+ years of experience in data analysis, reporting, business intelligence, or related roles
- Strong experience working within Microsoft SQL Server environments (SQL 2017+)
- Hands-on experience with SSRS, SSAS, and SSIS
- Advanced T-SQL experience including DDL and DML queries
- Strong understanding of data warehousing concepts and BI solution development
- Experience building dashboards and reports for business users
- Knowledge of dimensional modeling and relational database design
- Advanced Microsoft Excel skills including pivot tables, formulas, and VBA
- Strong analytical, troubleshooting, and problem-solving capabilities
- Excellent communication skills with the ability to work directly with end users and stakeholders
- Ability to manage multiple priorities in a fast-paced environment
Nice To Haves
- Experience with Power BI or Jet Reports
- Professional certifications related to Microsoft, BI, or Data Analytics are considered an asset
Responsibilities
- Meet with business users to gather reporting and data requirements
- Build reports and dashboards using SSRS, SQL Server, and Excel
- Develop and maintain cubes and dimensional data models using SSAS and MDX
- Support and enhance SQL-based data warehouse environments
- Assist end users with data analysis, interpretation, and reporting needs
- Troubleshoot reporting, data, and integration issues as they arise
- Support testing activities including unit testing, integration testing, and user acceptance testing
- Create and maintain documentation related to reporting and data processes
- Research and resolve technical issues using available resources and tools
- Contribute to ongoing improvements across reporting, analytics, and BI processes
- Stay current with evolving technologies, tools, and best practices within data and analytics
Benefits
- Competitive vacation and personal days
- Comprehensive health and dental coverage
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
