Business Intelligence & Data Analyst – Power Platform
MTY Food Group
Turn this role into an interview — a resume and cover letter built around what this employer wants.
Benefits offered by this job
Job summary
MTY Group, including Thai Express, seeks a Business Intelligence & Data Analyst – Power Platform to evolve our BI, data and automation ecosystem. You will focus on BI, data modeling, and automating processes with Power Automate, partnering with Operations, Finance and Marketing to improve decisions and efficiency.
The role requires hands-on expertise with Power BI, Power Automate, Power Apps and SQL, across Databricks and SharePoint integrations.
Qualifications
- Strong professional experience in Business Intelligence and data analytics.
- Strong hands-on experience with Microsoft Power BI, including Power Query, DAX and data modelling.
- Strong hands-on experience with Microsoft Power Automate.
- Demonstrated experience designing, building and troubleshooting automated workflows.
- Hands-on experience developing business applications with Microsoft Power Apps.
- Experience developing end-to-end solutions within the Microsoft Power Platform.
- Experience connecting Power BI, Power Automate and Power Apps with SharePoint, SQL and other data sources.
- Experience working with Databricks or a comparable modern data platform.
Responsibilities
- Develop, maintain and optimize Power BI dashboards, reports and semantic models.
- Build robust data models and measures using DAX and Power Query.
- Write and maintain SQL queries, views and data transformations.
- Work with Databricks and other data sources to access, transform and structure data.
- Integrate data from multiple internal and external systems.
- Monitor and troubleshoot data pipelines, dataset refreshes and reporting issues.
- Perform ad hoc analyses to identify trends, opportunities and operational issues.
- Translate complex datasets into clear and actionable business insights.
- Improve the performance, reliability and scalability of BI solutions.
- Maintain strong standards for data quality, documentation and governance.
- Design, build and maintain solutions using Power Automate and Power Apps.
- Build and manage Power Automate workflows to automate recurring processes.
- Proactively identify manual, repetitive or inefficient processes to automate.
- Integrate Power Automate, Power Apps, Power BI, SharePoint, Microsoft 365, SQL and other systems.
- Design and develop Power Apps to replace spreadsheets and forms.
- Build user-friendly applications connected to data sources.
- Design data structures to support applications and automated workflows.
- Troubleshoot and optimize existing Power Automate flows and Power Apps.
- Monitor automated processes and applications for reliability.
- Act as a data partner to Operations, Finance and Marketing teams.
- Translate business requirements into BI, data and Power Platform solutions.
- Develop dashboards, analyses and automated workflows.
Skills
Tools
Job description
Business Intelligence & Data Analyst – Power Platform
Thai Express | MTY Group
Over the past 40 years, EXCELLENCE, ENTHUSIASM and INNOVATION have led us to success.
Today, we continue to look for talented professionals who want to work for a company that will offer them opportunities for growth and many rewarding experiences.
MTY offers its employees dynamic, unique and valuable professional experience.
- 3 weeks of vacation
- 5 days of flexible sick leaves
- $2000 reimbursement for professional certifications and continuing education requirements
- Company health and dental plans, with an additional $300 personal wellness expense account
- Employee assistance program with access to mental health, legal, and financial counseling services
- Employee profit-sharing plan with employer contribution
- Monthly company-wide recognition awards
- Company social events, including webinars, town halls, and team activities
- Casual dress code
- Free parking at the office
Thai Express is seeking a Business Intelligence & Data Analyst – Power Platform to support and further develop our business intelligence, data and automation ecosystem.
This is a hands‑on technical and business‑facing role with two primary areas of focus: Business Intelligence & Data and Microsoft Power Platform, with a strong emphasis on process automation through Power Automate.
The successful candidate will work closely with our Operations, Finance and Marketing teams, helping them leverage data and technology to improve decision‑making, automate processes and increase efficiency.
We are looking for someone who can understand a business need, recommend the appropriate solution and take ownership from initial requirements through development, deployment and ongoing support.
1. Business Intelligence & Data
- Develop, maintain and optimize Power BI dashboards, reports and semantic models
- Build robust data models and measures using DAX and Power Query
- Write and maintain SQL queries, views and data transformations
- Work with Databricks and other data sources to access, transform and structure data
- Integrate data from multiple internal and external systems
- Monitor and troubleshoot data pipelines, dataset refreshes and reporting issues
- Perform ad hoc analyses to identify trends, opportunities and operational issues
- Translate complex datasets into clear and actionable business insights
- Improve the performance, reliability and scalability of BI solutions
- Maintain strong standards for data quality, documentation and governance
2. Power Platform – Automation & Applications
- Design, build and maintain solutions using Microsoft Power Automate and Power Apps
- Build and manage Power Automate workflows to automate recurring business processes, approvals, notifications, reporting and data collection
- Proactively identify manual, repetitive or inefficient processes that can be automated or digitized
- Integrate Power Automate, Power Apps, Power BI, SharePoint, Microsoft 365, SQL and other business systems
- Design and develop Power Apps to replace spreadsheets, forms and manual processes with efficient business applications
- Build user‑friendly applications connected to SharePoint, SQL and other data sources
- Design appropriate data structures and back‑end solutions to support applications and automated workflows
- Troubleshoot, maintain and optimize existing Power Automate flows and Power Apps
- Monitor automated processes and applications to ensure reliability and performance
- Support user adoption, documentation and continuous improvement of developed solutions
3. Business Partnership & Decision Support
Act as a key data, analytics and technology partner to our Operations, Finance and Marketing teams, helping each function make better use of data, automation and technology.
- Work directly with business teams to understand their objectives, challenges and day‑to‑day needs
- Translate business requirements into practical BI, data and Power Platform solutions
- Develop dashboards, analyses, automated workflows and applications that improve efficiency and decision‑making
- Support Operations with performance monitoring, operational KPIs, restaurant‑level insights, process improvement and automation
- Support Finance with reporting, financial analysis, reconciliations, data validation and process automation
- Support Marketing with campaign performance, customer and loyalty analytics, digital performance, sales analysis and marketing reporting
- Provide ad hoc analyses to answer emerging business questions
- Proactively identify opportunities where data, automation or technology can improve existing processes
- Communicate insights and recommendations clearly to technical and non‑technical stakeholders
- Support and train users on newly developed dashboards, applications and automated solutions
- Strong professional experience in Business Intelligence and data analytics
- Strong hands‑on experience with Microsoft Power BI, including Power Query, DAX and data modelling
- Strong hands‑on experience with Microsoft Power Automate
- Demonstrated experience designing, building and troubleshooting automated workflows
- Hands‑on experience developing business applications with Microsoft Power Apps
- Experience developing end‑to‑end solutions within the Microsoft Power Platform
- Experience connecting Power BI, Power Automate and Power Apps with SharePoint, SQL and other data sources
- Experience working with Databricks or a comparable modern data platform
- Strong understanding of relational data models and BI concepts
- Strong analytical, troubleshooting and problem‑solving skills
- Ability to translate business requirements into effective technical solutions
- Ability to communicate effectively with both technical and non‑technical stakeholders
- Ability to independently manage solutions from requirements gathering through deployment and ongoing support
- Microsoft Fabric
- Dataverse
- Power Platform governance and environment management
- API integrations
- Python
- Experience with POS, restaurant, retail or franchise data
- Experience with CRM, loyalty, digital ordering or third‑party delivery platforms
- Experience working within a multi‑location or franchise organization
We are looking for someone who combines strong business intelligence and data expertise with an automation mindset and a genuine understanding of business needs.
The ideal candidate doesn’t simply build reports or wait for technical specifications. They work with the business to understand the underlying problem, ask the right questions and determine the most effective solution.
When the business has a question, they determine how data and analytics can provide the answer. When they encounter a repetitive or manual process, they look for opportunities to automate it with Power Automate. When a process would benefit from a dedicated application, they can develop a Power App to support it.
Most importantly, this person will be a partner to our Operations, Finance and Marketing teams, helping them turn business challenges into practical solutions using data, analytics and technology.
This position offers significant ownership of the Business Intelligence, Data and Power Platform ecosystem supporting Thai Express and the opportunity to directly influence how data and technology are used across the organization.
Please note that any offer of employment will be conditional upon a background check, including a criminal record check.
*The majority of our clients and a large proportion of our employees are outside Quebec*.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
