Financial Data & Reporting Analyst — Power BI Dashboards

William & Mary and the Virginia Institute of Marine Science; Barnsley; Hybrid; GBP 44,000 - 54,000; Full time

Job summary

William & Mary’s Raymond A. Mason School of Business seeks a Financial Data & Reporting Analyst to expand financial and operational reporting capabilities. You’ll manage recurring reports, build Power BI dashboards, and perform variance analyses to support data-informed decisions.

You will work with Workday, Banner, and CRM data, translating results for technical and nontechnical stakeholders while maintaining confidentiality and contributing to process improvements and annual cycles.

Qualifications

• Bachelor's degree in a related field or equivalent experience.
• Experience with structured data, spreadsheets, and reporting.
• Proficiency with Microsoft Excel for data analysis and reporting.
• Ability to collect, reconcile, validate, and analyze data from multiple sources.
• Strong communication of findings to technical and nontechnical audiences.
• Excellent organizational, problem-solving, and interpersonal skills.
• Ability to manage multiple priorities and deadlines.
• Commitment to confidentiality and safeguarding sensitive information.

Responsibilities

• Maintain recurring financial, enrollment, and operational reports.
• Extract, cleanse, reconcile data from Workday, Banner, and CRM systems.
• Perform budget-to-actual and variance analyses.
• Develop and maintain Power BI dashboards and Excel tools.
• Investigate discrepancies and coordinate issue resolution.
• Prepare concise summaries and presentations of variances and trends.
• Document report logic and data definitions for consistency.
• Support process improvement and annual reporting cycles.

Skills

Microsoft Excel

Data analysis

Communication

Organization

Attention to detail

Team collaboration

Confidentiality

Education

Bachelor's degree

Tools

Power BI

Tableau

SQL

Power Query

Microsoft Fabric

Workday

Banner

Slate

Salesforce

Qlik

Job description

William & Mary’s Raymond A. Mason School of Business seeks a Financial Data & Reporting Analyst to expand financial and operational reporting capabilities. You’ll manage recurring reports, build Power BI dashboards, and perform variance analyses to support data-informed decisions.

You will work with Workday, Banner, and CRM data, translating results for technical and nontechnical stakeholders while maintaining confidentiality and contributing to process improvements and annual cycles.