Data & Reporting Analyst - SQL (Power BI and Tableau)

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Toronto; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

Astra-North Infoteck Inc. is looking for a Data & Reporting Analyst in Toronto to support data-driven decision-making. The ideal candidate will possess strong SQL skills and experience with reporting tools like Tableau and Power BI.

This hybrid role (4 days work from office) entails developing dashboards, optimizing reporting processes, and collaborating with cross-functional teams to deliver actionable insights.

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.

Responsibilities

• Write complex and optimized SQL queries to extract, transform, and analyze data.
• Design, develop, and maintain interactive dashboards and reports.
• Gather business requirements and translate them into analytical solutions.

Skills

SQL

Power BI

Tableau

Data modeling

Database migration

Job description

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, PostgreSQL, Snowflake, or BigQuery.
• 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.