At a Glance
- Tasks: Analyze data and create impactful reports using SQL, Power BI, and Tableau.
- Company: Join a dynamic analytics team in a hybrid work environment.
- Benefits: Enjoy competitive pay, flexible work options, and opportunities for growth.
- Other info: Collaborate with diverse teams and enhance your analytical skills.
- Why this job: Make data-driven decisions that shape the future of the organization.
- Qualifications: Strong SQL skills and experience with reporting tools are essential.
The predicted salary is between 81000 - 99000 $ per year.
Data & Reporting Analyst
Location
Toronto
Work Model
Hybrid (4 Days WFO)
Duration
- 12 Months
- Top 3 Required Skills
- SQL
- Power BI
- Tableau
Job Description
We are seeking a skilled Data & Reporting Analyst to join the analytics team and support data-driven decision-making across the organization.
The ideal candidate will have strong SQL expertise, hands‑on experience with reporting tools such as Tableau and Power BI, and the ability to build scalable reporting and analytics solutions.
The candidate will work closely with business stakeholders, data engineers, and leadership teams to deliver actionable insights, optimize reporting processes, and improve data accessibility across the enterprise.
Key Responsibilities
- SQL Development & Data Analysis
- Write complex and optimized SQL queries to extract, transform, and analyze data from multiple sources.
- Improve query performance and ensure efficient data retrieval.
- Convert repetitive manual queries into reusable stored procedures, functions, and views.
- Reporting & Dashboard Development
- Design, develop, and maintain interactive dashboards and reports using Tableau and Power BI.
- Build scalable and user-friendly reporting solutions for business stakeholders.
- Support self‑service analytics initiatives through structured reporting frameworks.
- Semantic Layer & Data Modeling
- Design semantic layers and logical data models to support consistent reporting and analytics.
- Ensure data consistency, integrity, and usability across reporting assets.
- Database Migration & Optimization
- Support migration of stored procedures and reporting logic across database platforms.
- Validate data accuracy and minimize disruptions during migration activities.
- Stakeholder Collaboration
- Gather business requirements and translate them into analytical and reporting solutions.
- Partner with cross‑functional teams including business users, leadership, and engineering teams.
- Data Quality & Governance
- Maintain data accuracy, consistency, and reliability across dashboards and reporting environments.
- Support data governance and reporting standards.
- Required Qualifications
- Strong hands‑on experience with advanced SQL and query optimization.
- Experience building dashboards and reports using Tableau and/or Power BI.
- Good understanding of semantic layer design and data modeling concepts.
- Experience with stored procedures, functions, and reusable SQL frameworks.
- Knowledge of relational databases and data warehousing principles.
- Experience supporting database migration or reporting migration projects.
- Strong communication, analytical, and documentation skills.
- Preferred Qualifications
- Experience with multiple database platforms such as SQL Server, Oracle, Postgre SQL, Snowflake, or Big Query.
- Familiarity with ETL/ELT processes and data governance practices.
- Exposure to Python or R scripting.
- Knowledge of version control and deployment best practices.
- Experience with advanced analytics or statistical methods.
- #J-18808-Ljbffr
Data & Reporting Analyst - SQL in Toronto employer: Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!
Astra-North Infoteck Inc. is an exceptional employer located in the vibrant city of Toronto, offering a dynamic work culture that fosters innovation and collaboration. Employees benefit from comprehensive growth opportunities, including mentorship programs and access to cutting-edge technology, all while working in a supportive environment that values diversity and creativity. Join us to be part of a forward-thinking team that is shaping the future of cloud-based solutions and AI.
Contact Details:
Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision! Recruitment Team
