Senior Analyst, Business Intelligence
Senior Analyst, Business Intelligence
Posted on :
07-06-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Description
Metrolinx is connecting communities across the Greater Golden Horseshoe. Metrolinx operates GO Transit and UP Express as well as the PRESTO fare payment system. We are also building new and improved rapid transit including GO Expansion Light Rail Transit routes and major expansions to Torontos subway system to get people where they need to go better faster and easier. Metrolinx is an agency of the Government of Ontario.
At Metrolinx equity diversity and inclusion are essential to living our values of serving with passion thinking forward and playing as a team.
CPGs workforce is made up of driven and dedicated professionals who care deeply about working together to deliver infrastructure and make a positive impact in our communities. Join us as we build a knowledgeable and collaborative team that courageously changes how transit projects will be delivered.
This role is accountable for the end-to-end design and development of Business Intelligence (BI) solution and data analytics that support CPGs strategic goals and promote a data-driven culture. Combining strong application development skillsparticularly within the Microsoft Power Platformwith advanced capabilities in dashboard design complex visual storytelling and data modeling this role translates business needs into scalable user-centric BI tools. A customer-focused and consultative approach is essential to ensure solutions are aligned with business needs continuously improved based on feedback and support informed decision-making at all levels of the organization. This position reports to the Manager BI Performance & Analytics.
What will I be doing
- Partner with business units to gather understand and translate complex business requirements into actionable and scalable architectural solution designs.
- Develop and test BI prototypes proof of concepts pilots and production builds for business improvement plans and business cases that aim to understand and improve on the performance and success metrics through the analysis processing and reporting of data that is collected through business processes and systems.
- Lead the design development and continuous enhancement of Business Intelligence (BI) solutions using Microsoft Power Platform (Power BI Power Apps Power Automate) Microsoft Fabric and other BI tools to support strategic and operational goals through scalable cloud-based analytics solutions.
- Optimize BI solution design through data profiling and architecture review. Perform data preparation including cleansing transformation staging and aggregation to ensure data accuracy consistency and readiness for reporting. Design and deliver insightful visualizations and interactive reports tailored to business needs.
- Identify and resolve BI product performance bottlenecks such as slow load times inefficient queries and inaccurate insights. Apply best practices in DAX code optimization Power Query performance tuning and semantic model design to streamline calculations and improve responsiveness and efficiency.
- Develop and maintain comprehensive technical design documentation for BI solutions. Maintain clean and well-organized workspaces proactively addressing technical debt and ensuring alignment with governance standards. Apply best practices for report storage retention and cataloging including version control and archival strategies.
- Explore and apply advanced analytics techniques including forecasting predictive modeling and machine learning to support data-driven innovation and operational intelligence.
- Proactively stay current with evolving trends in Business Intelligence data platforms and analytics technologies to continuously advance the teams technical capabilities. Evaluate and implement emerging tools methodologies and best practices to drive innovation scalability and efficiency in BI solution delivery.
What Skills and Qualifications Do I Need
- Completion of a degree in Computer Science Computer Engineering Information Technology Data Science or a related STEM discipline or an equivalent combination of education training and professional experience.
- Demonstrated experience in Business Intelligence data analytics data engineering or data science. Demonstrated expertise in end-to-end enterprise-level BI solution design and development.
- Proficiency in applying BI data orchestration to support CPGs centralized data repository a strong understanding of data platform architecture principles and familiarity with cloud infrastructure (e.g. MS Fabric Power Platform)
- In-depth understanding of database management systems data modeling cloud data storage/retention analytical processing and ETL/ELT (Extract transform load/Extract load transform) framework
- Demonstrated ability to troubleshoot complex BI issues analyze root causes and optimize performance across data models reports and queries.
- Strong Agile delivery skills with the ability to manage multiple initiatives concurrently while maintaining a high standard of quality and collaboration.
- Excellent problem-solving and critical thinking capabilities combined with a proactive mindset and continuous improvement orientation.
- Strong communication skills with the ability to craft and deliver high-impact presentations to diverse audiences including senior leadership.
Dont Meet Every Requirement
If youre excited about working with Metrolinx but your past experience doesnt quite align with every qualification of this posting we encourage you to apply. You just might be the right candidate for this or other roles. We are always looking for great talent to join our team.
We invite all interested individuals to apply and encourage applications from members of equity-deserving communities including those who identify as Indigenous Black racialized women people with disabilities and people with diverse gender identities expressions and sexual orientations.
Accommodation:
We value the unique skills and experiences each person brings to Metrolinx and are committed to creating and maintaining an inclusive and accessible environment. We are committed to the requirements of the Accessibility for Ontarians with Disabilities Act so if you require accommodation during the hiring process please let our Recruitment team know by contacting us at: or email.
Application Process:
All applicants must be legally entitled to work in Canada. Metrolinx will be using email to communicate with you for all job competitions. It is your responsibility to include an updated email address that is checked daily and accepts emails from unknown users. As we send time-sensitive correspondence we recommend that you check your email regularly. If no response is received we will assume you are no longer interested in pursuing the opportunity. Please be advised that a Criminal Record Check may be required of the successful candidate.
For Internal applicants with the recent implementation of the Internal Mobility Policy the internal recruitment process has changed for non-union roles. Candidates must be in their current role for 12 months prior to applying for another role and each applicant must be in good standing (not participating in a Performance Improvement Plan). Please review all provisions of thepolicybefore submitting your application.
Should it be determined that any background information provided is misleading inaccurate or incorrect Metrolinx reserves the right to discontinue with the consideration of your application.
We thank all applicants for their interest however only those selected for further consideration will be contacted.
WE ARE AN EQUITABLE AND INCLUSIVE EMPLOYER.
Required Experience:
Senior IC
Employment Type
Full-Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
