Job Title: Systems Analyst – Senior
Location: Toronto, ON (Hybrid)
Estimated Duration: 6 Months

Job Title
Systems Analyst – Senior
Description
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.
The candidate should be comfortable working with data from multiple enterprise and third-party systems and collaborating with Finance, I&IT as well as data and application teams to bring together the information required for effective performance reporting.
The ideal candidate is a business-minded data specialist and problem solver who can bridge the gap between business requirements and technical implementation. They can take an ambiguous reporting or performance challenge, understand the underlying process and data, and turn it into a practical, scalable and decision-ready solution.
This role is an in?office position based at our 277 Front Street West, Toronto location. Our team is highly collaborative, and much of our work benefits from in?person co?creation, relationship?building, and hands?on partnership with leaders across the organization.

Responsibilities
Business Analysis & Performance Reporting

  • Create and maintain end-user documentation, technical documentation, and developer guides for both existing and newly developed solutions.
  • Establishing reporting standards, KPI definitions, and data governance practices.
  • Gather and translate business requirements into reporting and technical specifications.
  • Understand business processes and identify opportunities for process improvement, automation and reporting optimization.
  • Design and maintain intuitive Power BI dashboards, KPIs and trend analysis for leadership and business users.
  • Develop both ad-hoc analysis and structured recurring reports to support decision-making.
  • Partner with PMO, Finance, I&IT and other stakeholders to understand and integrate their data requirements.

Power BI & Data Development

  • Design, develop and maintain Power BI reports using DAX, Power Query/M, data modelling, and semantic models.
  • Build efficient reporting models using dimensional modelling / star-schema principles.
  • Optimize existing reports, datasets and models for performance, usability and scalability.
  • Implement appropriate RLS, workspace security and access controls.
  • Troubleshoot data refresh, model, DAX and reporting issues.

Data Integration & Solution Development

  • Work with data from multiple enterprise and third-party applications (such as ServiceNow, EcoSys, Jira,etc).
  • Analyze source systems and design appropriate data structures and integration approaches for reporting.
  • Collaborate with data engineers, application developers and other BI teams to source and exchange data.
  • Work with technologies such as SQL, Azure Data Lake, Dataverse and APIs as required.
  • Identifying data quality issues and implementing appropriate controls.

Existing Solution Support & Continuous Improvement

  • Quickly understand and support existing applications, reports, data models and business processes.
  • Investigate production issues, identify root causes and implement sustainable solutions.
  • Evaluate existing solutions and identify opportunities to automate manual processes, improve data quality, and enhance performance.
  • Provide ongoing maintenance and enhancement of reporting solutions.

Data Migration & Platform Transition

  • Analyze source and target data structures and develop data mapping, migration strategies and templates.
  • Support migration of reporting data and processes when applications or platforms change.
  • Validate migrated data and ensure business reporting requirements are maintained during transition.

Testing, Deployment & Documentation

  • Develop and execute UAT, regression and production validation scenarios.
  • Support reporting releases and post-production validation.
  • Maintain business, technical and data documentation.
  • Collaborate with developers and business users throughout the solution lifecycle.

Must-Have Skills & Experience

  • 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

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

The pay range that the employer reasonably expects to pay for this position is between CA$74.00 and CA$84.00

Our voluntary benefits offering includes medical, dental, vision and retirement benefits.

This posting is for an existing vacancy.

If you believe this post to be fraudulent, please report by clicking here

Tundra Technical Solutions is a global workforce and technology delivery firm, ranked by Staffing Industry Analysts as one of the largest in North America. At Tundra, we aren't just hiring top talent at the world's most recognizable brands; we are pioneers of social recruitment. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other legally protected characteristics. We welcome and encourage diversity in the workplace.

We use artificial intelligence tools to help our recruiters screen and assess talent. These tools do not replace human decision making in the process.

Not interested in this position, but know somebody who might be? Check out our Referral Reward Program, referrals are a big secret behind our success. As always, we’re on the lookout for great people. And we know that you know great people!