Source Code
RQ00223 - Systems Analyst - Senior
6-month senior systems analyst (performance reporting) contract in Toronto, hybrid 3 days/week onsite. Day to day: build and optimize Power BI dashboards and data models, integrate data from enterprise systems, and translate business requirements into decision-ready reporting. Core stack: Power BI (DAX, Power Query/M), SQL, Excel, Power Apps/Automate.
- Compensation
- CA$77–CA$92 / hr
- Location
- Not listed
- Work setup
- Hybrid
- Seniority
- Senior
- Employment
- Not specified
- Experience
- Not specified
- Category
- Business analysis
- Posted
Skills
Must have
- Demonstrated knowledge and experience with 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
- Experience integrating and modelling data from multiple systems and data sources, including enterprise and third-party applications
- 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, able to identify data, process and performance gaps and recommend improvements
- Experience with Power BI RLS, workspace management, and security
- Experience with Power Apps and Power Automate
- Advanced Excel skills, including Power Query, Power Pivot and VBA/macros
- Strong communication and stakeholder management skills across business and technical teams
- Knowledge and experience in rapid application development (RAD) methodologies
Nice to have
- Public sector experience
- 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 or Microsoft Project
- Experience with PMO, project portfolio, financial or operational performance reporting (project status, risks, financials, milestones, 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
Full description
**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 floorMust 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: PreferredNice 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 reporting capabilities, and ensuring that data is accurate, reliable and presented in a meaningful way.