Financial Data & BI Analyst
Posted Updated 7
views
Summary
Builds and manages Power BI solutions for the FP&A team at a restaurant company — maintaining interactive financial dashboards and KPIs, streamlining reporting with finance/accounting, and supporting budgeting, forecasting, and ad hoc analysis. Core tools: Power BI, SQL, Microsoft Excel, ERP (SAP).
POSITION SUMMARY:
We are seeking an eager, curious, and passionate data and finance professional that will be responsible for building and managing Power BI solutions that support the FP&A team in analyzing business trends that drive company profitability. The individual will report to the Sr. VP of FP&A and work closely with other functional leaders. This role is part of the global MTY FP&A team.
PRIMARY ACCOUNTABILITIES:
* Manage existing Power BI solutions that support the organization
* Educate and collaborate with the FP&A team on Power BI current and future solutions
* Build and maintain interactive financial dashboards and KPI's with Power BI
* Partner with finance and accounting teams to streamline reporting processes
* Provide support for financial analysis for Company leaders
* Provide support for annual planning and budgeting process
* Present data-driven recommendations to the finance and operational teams
* Assist with financial modeling and forecasting
* Ad hoc reporting as needed (sales trends, menu analysis, financial trends, etc.)
KNOWLEDGE, SKILLS, & ABILITIES:
Education:
* Bachelor's Degree in Data Analytics, Computer Science, Finance, Accounting, or related quantitative field
* Bachelor's Degree in Data Analytics, Computer Science, Finance, Accounting, or related quantitative field
Experience:
* 2 to 5 years of experience in business intelligence or data analytics
* 2 to 5 years of experience in business intelligence or data analytics
Skills/Competencies/Certifications:
* Bilingual-French and English an asset
* Proficiency in BI and data visualization tools (Power BI, etc.)
* Advanced SQL and Microsoft Excel
* Familiarity with ERP systems (eg. SAP knowledge an asset) and general ledger data
* Understanding of financial modeling (P&L, budgeting)
* Strong analytical, research and problem-solving skills
* Intellectually curious
* Creative thinker with the ability to translate new ideas into practical application
* Excellent communication, interpersonal and presentation skills with the ability to write concisely and cohesively
* Team spirit, while also self-managing, self-motivated, autonomous
* Cross-functional collaboration and ability to achieve business results with Senior Leadership partners and colleagues in a diverse workforce
* Adaptable, resilient, flexible, fast-paced/sense of urgency, and a high level of multitasking ability
* Strong academic record (GPA of 3.0 or higher preferred)
* Bilingual-French and English an asset
* Proficiency in BI and data visualization tools (Power BI, etc.)
* Advanced SQL and Microsoft Excel
* Familiarity with ERP systems (eg. SAP knowledge an asset) and general ledger data
* Understanding of financial modeling (P&L, budgeting)
* Strong analytical, research and problem-solving skills
* Intellectually curious
* Creative thinker with the ability to translate new ideas into practical application
* Excellent communication, interpersonal and presentation skills with the ability to write concisely and cohesively
* Team spirit, while also self-managing, self-motivated, autonomous
* Cross-functional collaboration and ability to achieve business results with Senior Leadership partners and colleagues in a diverse workforce
* Adaptable, resilient, flexible, fast-paced/sense of urgency, and a high level of multitasking ability
* Strong academic record (GPA of 3.0 or higher preferred)