Job DescriptionWe are looking for an expert who can build a Power BI dashboard and train the team on how to maintain it. The existing tables and reports are in Excel using macros, but the front end needs to be developed in Power BI. These reports will be presented to executives on a monthly basis to provide project updates. You will work on a large IT Asset Management (ITAM) project that was implemented in the U.S. and is now being extended to cover all Canadian software and hardware assets. Currently, there are approximately 30,000 line items in Excel, and this number is expected to double in the coming months. The ideal candidate will also have experience with automation to ensure spreadsheets can be published efficiently. This is a 9-month hybrid contract, with on-site work required every Tuesday and the second Friday of each month.Required Skills & ExperienceExperience creating regulatory/compliance-related or currency-related dashboardsPower BI dashboard development (minimum 2 years of experience)Excel automation (3+ years), including macros, VLOOKUPs, and related functionsExperience working with large datasetsStrong business acumen to translate technical outputs into business requirements Nice to Have Skills & ExperienceSQL scripting experience
Job Title
Reporting & Analytics Lead