88640

Toronto, Ontario

Contract

10 hours ago

Sr Business Analyst
Hybrid, Toronto, 2-3 days on site
Estimated Duration: 12 Months

1.0 Description of Assignment

The client ITS are looking for a strategic and technically proficient Senior Business Analyst to lead the development of a roadmap for migrating our existing SQL Server databases to Microsoft Azure Cloud as part of Database SOGR project. This role will be instrumental in shaping the future of our data infrastructure and ensuring a seamless transition to a scalable, secure, and cost-effective cloud environment.

The Digital Enablement Pilot Project as part of CLIENT’s corporate mandate to transform and modernized for a changing environment and attracting new riders and retaining customer royalty. The Stations Customer Service Agents (CSAs) to transform customer engagement and to build a future ready workforce in readiness for FIFA World Cup in 2026. If the pilot is pilot is successful a wider rollout for system wide rollout in 2027.

The Digital Evidence Management Solution (DEMS) project aims to implement a cloud-based, Software-as-a-Service platform to centralize video storage, management, and dissemination for the CLIENT’s Video Services Unit (VSU) and stakeholders. The scope includes deploying a system with automated retention and auditing capabilities, metadata-based search, native video redaction, and a self-service portal for secure access and request management. The solution will integrate with Active Directory for access control and the CLIENT records management system for video records. DEMS will ensure compliance with organizational and City of Toronto data retention mandates. It will consolidate existing tools and manual workflows into a single platform, establishing a repository for new video data.

The Business Analyst will be required to work on site 2-3 days per week at Union Station 61 Front St W or other locations in the GTA as required.

2.0 Skills and Certifications

Key Responsibilities

Assess current SQL Server environments and define business and technical objectives for Azure migration.
Collaborate with stakeholders to gather requirements and align migration goals with business strategy.
Develop a comprehensive migration roadmap including architecture, timelines, resource planning, risk mitigation, and success metrics.
Conduct gap analysis and recommend Azure-based solutions such as Azure SQL Database, Azure SQL Managed Instance, or SQL Server on Azure VMs.
Work closely with cloud architects, DBAs, application portfolio and data engineers to ensure technical feasibility and alignment.
Facilitate workshops, document business and technical requirements, and present findings to leadership.
Support change management and training initiatives related to the migration.

Manadatory Skills & Experience

10+ years of experience as a Business Analyst in IT or data-centric environments.
Proven experience with SQL Server and cloud migration projects, specifically to Microsoft Azure.
Strong understanding of Azure database services, including Azure SQL Database, Azure SQL Managed Instance, and Azure Data Factory.
Experience with data modeling, ETL processes, and performance tuning in cloud environments.
Excellent communication, stakeholder engagement, and documentation skills.
Ability to translate complex technical concepts into actionable business strategies.
Familiarity with Agile and Waterfall methodologies.
Bachelor’s degree in Computer Science, Information Systems, Business, or related field.

Preferred Qualifications

Microsoft Azure certifications (e.g., Azure Fundamentals, Azure Data Engineer Associate, Azure Solutions Architect).
Experience with data governance, security, and compliance in Azure.
Background in enterprise-level data transformation and modernization initiatives.

3.0 Assignment Duties

Assigned Duties

Conduct Current State Analysis
Evaluate existing SQL Server infrastructure, data models, and dependencies to understand the current environment.
Gather and Document Requirements
Work with business and technical stakeholders to capture functional and non-functional requirements for the Azure migration.
Develop Migration Roadmap
Create a detailed plan outlining phases, timelines, resource allocation, risk mitigation strategies, and success metrics.
Recommend Azure Solutions
Identify appropriate Azure services (e.g., Azure SQL Database, Azure SQL Managed Instance, Azure Data Factory) based on business needs and technical feasibility.
Facilitate Stakeholder Engagement
Lead workshops, meetings, and presentations to ensure alignment across business units and technical teams.
Support Technical Teams
Collaborate with cloud architects, DBAs, and data engineers to ensure the migration plan is technically sound and executable.
Monitor and Report Progress
Track milestones, identify issues, and provide regular updates to leadership and project sponsors.
Ensure Compliance and Governance
Incorporate data security, privacy, and compliance requirements into the migration strategy.

4.0 Deliverables

Expected Deliverables

Current State Assessment Report – Detailed analysis of existing SQL Server infrastructure and dependencies.
Business Requirements Document (BRD) – Capturing functional and non-functional requirements for Azure migration.
Migration Roadmap – A phased plan outlining timelines, resource needs, and key milestones.
Solution Recommendation Report – Evaluation of Azure services with proposed architecture and rationale.
Gap Analysis Report – Identification of gaps between current capabilities and future-state requirements.
Risk Register – Documented risks with mitigation strategies.
Stakeholder Communication Plan – Strategy for ongoing engagement and reporting.
Final Presentation Deck – Executive summary of findings, recommendations, and roadmap and migration plan

The pay range that the employer reasonably expects to pay for this position is between CA$75.00 and CA$85.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!