ES
Business Analyst and Data Analyst
Epsilon Solutions LTD
🇨🇦 Canada
On-site
Manager or above
4 days ago
- Power BI
- Excel
- SQL
- Regulatory Compliance
- Pivot Tables
- Power Query
- VBA
- Data Modeling
- DAX
- Data Visualization
- ETL
4 days ago
Location: Toronto, ON (Hybrid- 4 days/week)
Employment Type: Contract
F2F interview required
Job Summary
We are seeking a highly analytical and detail oriented 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 analyzing data developing insightful dashboards and generating regulatory and management reports to support business decision-making 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 executive level 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 hands-on 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 problem-solving skills
- Ability to translate business requirements into technical solutions
Business Analyst and Data Analyst · Epsilon Solutions LTD