Closed listing
Business Data Analyst
- Toronto, ON, Canada
Contract
This opening has closed.
The original listing is kept below for reference.
Job details
- 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.
Role Name : Business Data Analyst
Location : Toronto (Onsite)
Job Summary
We are seeking a highly analytical and detailoriented Business Analyst Data Analyst with strong expertise in Power BI Excel SQL dashboard development and regulatory compliance reporting The ideal candidate will be responsible for gathering business requirements analysing data developing insightful dashboards and generating regulatory and management reports to support business decisionmaking and compliance obligations
Key Responsibilities
Gather analyze and document business requirements from stakeholders
Perform data analysis to identify trends patterns and business insights
Design develop and maintain interactive dashboards and reports using Power BI
Extract transform and analyze data using SQL from multiple data sources
Prepare management reports KPI scorecards and executivelevel dashboards
Develop and automate reporting processes using Excel Pivot Tables Power Query Advanced Formulas VBA preferred
Generate and validate regulatory compliance reports ensuring data accuracy and adherence to regulatory standards
Work closely with business users compliance teams and technology teams to support reporting requirements
Conduct data quality checks and perform root cause analysis for data discrepancies
Translate business requirements into functional specifications and reporting solutions
Support UAT User Acceptance Testing and ensure successful implementation of reporting solutions
Create process documentation business requirement documents BRD and reporting guidelines
Required Skills
Technical Skills
Strong handson experience in Power BI Data Modeling DAX Power Query Dashboard Development
Advanced proficiency in SQL Joins Views Stored Procedures Query Optimization
Expert knowledge of Microsoft Excel Pivot Tables VLOOKUPXLOOKUP Power Query Macros
Experience in dashboard design KPI reporting and data visualization best practices
Knowledge of data warehousing concepts and ETL processes
Experience in preparing and validating regulatory and compliance reports
Business Analysis Skills
Requirement gathering and stakeholder management
Business process analysis and documentation
Strong analytical and problemsolving skills
Ability to translate business requirements into technical solutions
More about this job
Responsibilities
Gather and document business requirements, analyze data, and develop Power BI dashboards, KPI scorecards, and management reports. Prepare and validate regulatory compliance reports, improve reporting processes, investigate data quality issues, and support implementation through documentation and user acceptance testing.
Requirements
The role requires hands-on expertise in Power BI, data modeling, DAX, Power Query, SQL, and advanced Excel, along with experience in dashboard development and regulatory reporting. Candidates should also have strong business analysis, stakeholder management, documentation, data quality, and problem-solving skills.
Skills
- Power BI
- Data Modeling
- DAX
- Power Query
- Dashboard Development
- SQL
- Query Optimization
- Microsoft Excel
- Pivot Tables
- VLOOKUP/XLOOKUP
- Macros
- VBA
- Data Visualization
- Regulatory Compliance Reporting
- Data Analysis
- Requirements Gathering
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Finance & Accounting
- Consulting
Keywords
- Power BI
- Data Modeling
- DAX
- Power Query
- SQL
- Microsoft Excel
- Pivot Tables
- VLOOKUP/XLOOKUP
- Macros
- VBA
- Dashboard Development
- Data Visualization
- KPI Reporting
- Regulatory Reporting
- Compliance Reporting
- Data Analysis
- Business Requirements
- Stakeholder Management
- Data Warehousing
- ETL
- Data Quality
- Root Cause Analysis
- Functional Specifications
- User Acceptance Testing
- Process Documentation
- Reporting Automation
- Stored Procedures
- Query Optimization