Overview
The Data BI Reporting Analyst is an expert on Power BI and data visualization, and on digitalization and automation of finance and accounting processes. She/he will develop interactive dashboards and process automation to support FSS business users.
Key Responsibilities
- Define and develop interactive Power BI dashboards for business reporting needs
- Troubleshoot, maintain, and support in-house created BI dashboards for business users
- Develop Power Apps tools and Power Automate workflows for digitalizing and automating FSS processes
- Develop and automate end-user Excel applications and reports (VBA)
- Create user guides for all Power BI reports and Power Apps developed
- Train business users on the use of Power BI desktop and Fabric, Power Apps, VBA Macro, SQL, Power Query, Power Automate, etc.
- Build, test, and deploy RPA bots using appropriate tools to streamline operations
- Identify repetitive, rule-based business processes suitable for automation and design efficient RPA workflows
- Ensure RPA solutions integrate seamlessly with Power BI, Power Apps, Power Automate, and VBA macros
- Oversee bot performance, troubleshoot issues, and implement updates or enhancements as needed
Required Experience
- At least 5 years working experience in IT related to data warehouse and business intelligence support.
- At least two years working experience in Robotics Process Automation (RPA)
- Strong working knowledge in large relational databases and SQL programming.
- Strong working knowledge in developing Power Apps tools, VBA Macro, and Power Automate workflows for digitalizing and automating
- Extensive experience in analytic and interactive dashboards is a must.
- Business Analysis experience an asset.
Qualifications
- University degree or equivalent.
- Strong working knowledge of BI, SQL, statistical packages, Power BI.
