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.
Senior Manager leading Medline Canada’s Microsoft Fabric data platform and BI strategy. Delivering governed data products and analytics for healthcare operations.
Analyste des données clients chez EDC, société d’État aidant les entreprises canadiennes à réussir à l’étranger. Modernisation des pipelines, tableaux de bord et solutions analytiques marketing.
Customer Data Analyst modernizing EDC’s customer data ecosystem at Canada’s export - finance Crown corporation. Building Microsoft Fabric pipelines, Power BI assets, and marketing analytics solutions.
Senior Data Analyst building trusted financial metrics, dbt models, and Looker dashboards for Jane’s clinic - management SaaS platform. Partnering with Finance and Payments to guide critical decisions.
Digital media specialist improving campaign tracking, reporting and analytics at a Toronto marketing technology lab. Automating insights with AI while maintaining data quality and measurement accuracy.
Data Analytics Intern analyzing new features and updates for Montreal - based mobile gaming studio Ludia. Building data modules, dashboards, and insights to optimize game operations.
Senior Data Analyst transforming Sun Life insurance and financial - services data into actionable marketing insights. Building SQL, Python, AWS, Adobe Analytics, reporting, and dashboard solutions.
Student Data Analyst supporting Sun Life’s financial security mission through stakeholder insights and Tableau KPI reporting. Building data analysis skills during a four - month hybrid campus placement.
Analyste de données principal modernisant les plateformes et pipelines de données d’EDC, société financière publique canadienne. Traduction des besoins opérationnels en modèles, règles de transformation et récits utilisateurs.
Senior Data Analyst modernizing enterprise data capabilities at Export Development Canada. Translating business requirements into data models, mappings, pipelines and Agile delivery artifacts.