onsite
Financial Data Analyst - Business Intelligence - The Guthrie Clinic
Data Analyst
Financial Data Analyst focused on Business Intelligence, driving actionable insights for finance stakeholders using SQL, Power BI, Excel and advanced financial modeling to create dashboards, reports and analytics that support strategic financial decisions.
About the role
Key Responsibilities
- Design, develop and maintain interactive Power BI dashboards and reports that translate complex financial data into clear, actionable insights for senior finance leaders.
- Extract, transform and load (ETL) financial data from multiple internal systems using SQL, ensuring data integrity and accuracy.
- Collaborate with finance and business units to define key performance indicators (KPIs), metrics and reporting requirements, translating business needs into technical solutions.
- Perform ad‑hoc financial analysis, trend analysis and variance explanations to support budgeting, forecasting and strategic initiatives.
- Document data models, data dictionaries and reporting logic to enable knowledge transfer and maintain governance standards.
Requirements
- 3+ years of experience in financial analysis or business intelligence roles within a corporate finance environment.
- Proficiency in SQL for data extraction and manipulation, and advanced Excel skills (pivot tables, VLOOKUP, macros).
- Hands‑on experience building Power BI reports and dashboards, including data modeling and DAX.
- Strong analytical mindset with the ability to translate complex data into clear business recommendations.
- Excellent communication skills, capable of presenting findings to non‑technical stakeholders.
Skills
sqlpower biexceldata analysis