Senior Data Analyst and Reporting

Posted via LinkedIn Recruiter (not a company profile)

Posted 2 weeks ago

Apply Now

Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • 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.

Job title

Job type

Contractor

Experience level

Senior

Salary

$57.97/hr – $69.57/hr

Degree requirement

Bachelor’s degree or equivalent diploma

Tech skills

Power BIExcelPowerPointJIRASharePoint

Location requirements

Linkedin Recruiter PostTorontoOntario Toronto

Report this job

Found something wrong with the page? Please let us know by submitting a report below.