Closed listing
Business Data Analyst
- Toronto, ON, Canada
$40 to $45 CAD / hour · Contract
This opening has closed.
The original listing is kept below for reference.
Job details
- Pay
- $40 to $45 CAD / hour
- Job type
- Contract
- Closing date
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
🎯 Interview: Final round – In Person
We are looking for a Business Analyst / Data Analyst with strong experience in Power BI, SQL, Excel, dashboard development, and regulatory/compliance reporting.
🔹 Key Responsibilities
- Gather and document business requirements from stakeholders.
- Analyze data and identify trends, patterns, and discrepancies.
- Develop interactive Power BI dashboards and reports.
- Write complex SQL queries and work with multiple data sources.
- Prepare KPI, management, executive, and regulatory reports.
- Use Excel, Pivot Tables, XLOOKUP/VLOOKUP, Power Query, and VBA/Macros.
- Perform data quality checks and root-cause analysis.
- Support UAT and translate business requirements into reporting solutions.
- Create BRDs, process documentation, and reporting guidelines.
🔹 Required Skills
- Strong hands-on experience with Power BI, DAX, Power Query, and Data Modeling.
- Advanced SQL skills – Joins, Views, Stored Procedures, Query Optimization.
- Advanced Microsoft Excel skills.
- Experience with dashboard development and KPI reporting.
- Knowledge of data warehousing and ETL concepts.
- Experience with regulatory/compliance reporting.
- Strong business analysis, requirements gathering, and stakeholder management skills.
- Excellent analytical and problem-solving abilities.
More about this job
Responsibilities
Gather and document stakeholder requirements, analyze data, and develop interactive Power BI dashboards and reports using SQL and multiple data sources. Prepare KPI, management, executive, and regulatory reports; perform data quality and root-cause analysis; support UAT; and create business requirements and process documentation.
Requirements
Requires strong hands-on experience with Power BI, DAX, Power Query, data modeling, advanced SQL, and advanced Excel, along with dashboard development and KPI reporting. Candidates should also have knowledge of data warehousing and ETL, regulatory or compliance reporting experience, and strong business analysis, stakeholder management, and problem-solving skills.
Skills
- Power BI
- DAX
- Power Query
- Data Modeling
- SQL
- Microsoft Excel
- Dashboard Development
- KPI Reporting
- Regulatory Reporting
- Compliance Reporting
- Data Analysis
- Requirements Gathering
- Stakeholder Management
- Data Quality
- Root-Cause Analysis
- UAT
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Finance & Accounting
- Technology
- Consulting
Keywords
- Power BI
- DAX
- Power Query
- Data Modeling
- SQL
- Joins
- Views
- Stored Procedures
- Query Optimization
- Microsoft Excel
- Pivot Tables
- XLOOKUP
- VLOOKUP
- VBA
- Macros
- Dashboard Development
- KPI Reporting
- Regulatory Reporting
- Compliance Reporting
- Data Warehousing
- ETL
- Data Quality
- Root-Cause Analysis
- UAT
- Stakeholder Management
- Banking
- Investment Banking