RQ00223 - Systems Analyst - Senior

RQ00223 - Systems Analyst - Senior  Duration: 6 Months (130 Business Days)  Location: hybrid, 3 days in office (with the possibility for 5 days on-site) at 277 Front Street West, 4th floor  Must Haves: Demonstrated knowledge and experience with the Systems Development Life Cycle (SDLC), including requirements gathering, solution design, development, testing, implementation, and post-deployment support. Ability to quickly understand existing applications, data structures, reporting ecosystems and business processes. Advanced Power BI development including DAX, Power Query/M, data modelling, semantic models and Power BI Service. Strong SQL and data modelling knowledge, including relational databases, dimensional modelling, facts, dimensions and star-schema concepts, with the ability to understand and work with SQL-based data sources when required. Experience integrating and modelling data from multiple systems and data sources, including enterprise and third-party applications. Demonstrated experience gathering requirements and translating business needs into technical and reporting solutions. Experience supporting and troubleshooting existing Power BI solutions in production. Strong analytical and problem-solving skills, with the ability to identify data, process and performance gaps and recommend improvements. Experience with Power BI RLS, workspace management, and security. Experience with Power Apps, Power Automate. Advanced Excel skills, including Power Query, Power Pivot and VBA/macros where applicable. Strong communication and stakeholder management skills, with the ability to work effectively across business and technical teams. Knowledge and experience in rapid application development (RAD) methodologies Public Sector Experience: Preferred Nice to Haves: Experience integrating data from APIs, cloud-based data services, enterprise applications and third-party systems. Experience with project and portfolio management platforms such as Asana, Microsoft Project, or similar enterprise PM systems is preferred. Experience with PMO, project portfolio, financial or operational performance reporting, with an understanding of project status, risks, financials, milestones and resource reporting. Experience working in environments where multiple BI, data or development teams collaborate on shared reporting models, datasets, workspaces or enterprise data sources. Python or other scripting experience for data analysis, automation or data processing Job Summary We are looking for a Performance Analyst to join our team. The successful candidate will be a self-starter that has strong Power BI development, Excel, data modelling and analytical skills, with the ability to build intuitive, dynamic and engaging dashboards that enable leadership and business users to self-serve and understand their data. The role will also involve optimizing the performance of existing reports and data solutions, developing new…