RQ00223 – Systems Analyst – Senior

Cyber-Infomax Solutions Inc.; Toronto; Hybrid; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Hybrid work arrangement

Job summary

Metrolinx in Toronto seeks a data and BI specialist to advance reporting solutions across the organization. You will own advanced Power BI development, data modelling and work with IT and business teams to deliver actionable insights.

The role requires SDLC expertise, strong SQL skills, and experience integrating data from multiple systems. This hybrid position offers in-office collaboration in Toronto with flexible days.

Qualifications

• Experience with SDLC including requirements gathering and deployment.
• Ability to understand applications, data structures and reporting ecosystems.
• Advanced Power BI development with DAX, Power Query/M, data modelling and semantic models.
• Strong SQL and data modelling knowledge including star-schema concepts.
• Experience integrating data from multiple systems and sources.
• Gathers requirements and translates business needs into technical solutions.
• Supports Power BI in production environments.
• Analytical and problem-solving skills to identify data/process gaps.
• Experience with Power BI RLS, workspace management and security.
• Experience with Power Apps and Power Automate.
• Advanced Excel skills including Power Query and Power Pivot; VBA where applicable.
• Strong stakeholder communication and management across teams.
• Knowledge of RAD methodologies.

Skills

SDLC

Data modelling

Power BI development

DAX

Power Query/M

Relational databases

Dimensional modelling

Star-schema concepts

SQL

Data integration

Requirements gathering

Production support

Analytical problem solving

Power BI RLS & security

Power Apps

Power Automate

Excel (Power Query, Power Pivot, VBA)

Tools

Power BI

Power Apps

Power Automate

Power Query

Power Pivot

Excel

Job description

Metrolinx

277 Front Street West, Toronto

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

Location: hybrid, 3 days in office (with the possibility for 5 days on-site)