Senior Data Analyst role developing Power BI dashboards and reports for financial client. Automate manual reports, transform data, collaborate with teams, and troubleshoot issues.
Responsibilities
Build and enhance Power BI dashboards and reports to support executive and team-level decision-making. Automate manual spreadsheet reports into scalable, efficient Power BI solutions for dynamic weekly and monthly reporting. Gather, document, and analyze reporting requirements with stakeholders. Transform and validate data, ensuring accuracy for compliance, audits, and lifecycle management. Collaborate with cross-functional teams to understand data context and support remediation efforts. Perform advanced data preparation using Excel (pivot tables, VLOOKUP/XLOOKUP, macros) before ingestion into Power BI. Identify workflow inefficiencies, recommend process improvements, and support automation initiatives. Troubleshoot data discrepancies, perform root-cause analysis, and ensure reliable dashboard refreshes. Develop training materials, operational guides, and provide user training on Power BI tools. Support data reconciliation and ensure quality standards are met in all reporting outputs.
Requirements
Strong expertise in Power BI dashboard development and maintenance, including financial or cost/benefit reporting. Advanced Excel skills (pivot tables, VLOOKUP/XLOOKUP, macros, automation). Proven experience automating manual spreadsheets into scalable Power BI solutions. Experience in banking or regulated financial services environments. Solid understanding of business analysis, data quality, and reconciliation with imperfect data. Ability to troubleshoot and perform root-cause analysis for data issues. Strong collaboration skills with technical and non-technical teams. Proficiency with PowerPoint, JIRA, and SharePoint. Bachelor’s degree or equivalent diploma. Highly motivated, proactive, and comfortable working in fast-paced, ambiguous environments.
Business Analyst contract role in Toronto requiring 3+ years BSA experience and 2+ years SQL/Python. Capital markets/credit risk background preferred with 2 - 3 days onsite.
Data Analyst supporting the Territorial Data Warehouse, managing IT and business relationships. Analyzing data requirements and ensuring quality and alignment with business needs.
Data Analyst strengthening HR technology and analytics at The Salvation Army for informed workforce planning. Focusing on data integrity and reporting capabilities to empower HR leaders.
Data Analyst supporting automated ETL processes and maintaining data integrity at Cars Commerce. Collaborating with teams to ensure the accuracy and consistency of automotive data.
Business Data Analyst collaborating to enhance S&C Electric Canada's business processes through data analysis and strategic initiatives. Utilizing advanced statistics and data modeling for decision - making and reporting.
Sustainability Data Analyst managing the collection of sustainability data and assisting corporate real estate sustainability initiatives. Contributing to innovative data - driven solutions for sustainability objectives at Sun Life.
Data Analytics Lead for NPX managing analytics solutions and client relationships in the nuclear industry. Leading a team to drive outcomes through data - driven strategies.
Senior Data Analyst at Instacart driving innovation through financial data analytics. Collaborating across teams to deliver trusted insights and optimize performance in data management.